Anuradha D.

Anuradha D.

C# developer with SQL and SSIS

Kolkata , India

Experience: 8 Years

Anuradha

Kolkata , India

C# developer with SQL and SSIS

40036.8 USD / Year

  • Notice Period: 28 Days

8 Years

Now you can Instantly Chat with Anuradha!

About Me

 

  • 8+ years of experience assql server Developer and Data Analyst in Production, Development and Staging Environments and .net development.
  • An experience of total software life cycle working with Different vert...
  • An experience of total software life cycle working with Different vertical projects i.eHealthcare ,Banking and Insurance.
  • Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
  • Ability to learn and apply new skills to existing problems.
  • Have worked in the team from development to support phases being part of different modules at a time.
  • Have worked on Agile and scrum methodologies.
  • An experience of total software life cycle working with Different vertical projects i.e Healthcare ,Banking and Insurance
  • Ability to learn and apply new skills to existing problems.

Show More

Portfolio Projects

MS CRM DataMigration

Company

MS CRM DataMigration

Description

  • Its a CRM based project for the sales,services and campaigns.The data is huge and needed to be maintained as well as regular campaign data needed to be migrated to CRM DB.
  • Created mapping tables to find out the missing attributes for the ETL process, for CRM 365 application.
  • Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
  •  Participate on or lead technical implementation team
  • Lead development of technical specifications based on functional specifications
  • Lead and develop components of the customer solution that include application enhancements, system integrations, data conversions and migrations.
  • Oracle 11g/10g/9i/8i/8.0/7.3, PL/SQL, SQL *Loader, Physical database design, Logical database design, Data Modeling (PowerBuilder), Data Mapping, Cleansing, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
  • creation and scheduling of    T-SQL  jobs  to run daily

Show More Show Less

Healthcare Med mantra

Company

Healthcare Med mantra

Role

Web Developer

Description

Hospital automation to enable transformation in patient care, resource management and information management

  • Designing page according to client reqirements.
  • Writing code behind and stored procedures according to new requirements
  • Fully aware of standard templates being followed for the preparation of relevant document useful for the project.
  • Responsible for unit testing and some part of integration testing.
  • Providing proper validations in the page .
  • Worked in all production issues involving in my pages.
  • Have worked in different modules like billing,wards,lab and nurses

Involved in the product team to stabilise the product server and got experience in services relating issues

  • Designing page according to client reqirements.
  • Writing code behind and stored procedures according to new requirements
  • Fully aware of standard templates being followed for the preparation of relevant document useful for the project.
  • Responsible for unit testing and some part of integration testing.
  • Providing proper validations in the page .
  • Worked in all production issues involving in my pages.
  • Have worked in different modules like billing,wards,lab and nurses

Involved in the product team to stabilise the product server and got experience in services relating issues

Show More Show Less

Wellsfargo : development and support project

Company

Wellsfargo : development and support project

Description

  •  Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers.
  • Implemented Template Columns for Custom Nested GridViews
  • Worked on exporting reports to Excel from Gridviews and Ultrawebgrids.
  • Offshore SPOC
  • Attending daily scrum meetings with Scrum Master and Product Owner.
  • Web page analysis for dividing into levels and components
  • Writing Template Building Blocks for the new pages
  • Issues related to content mismatch and customization
  • Components and page creation
  • Unit testing and Automation testing
  • Making sure the published pages have passed the automation testing.

Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks

Show More Show Less

Humana Healthcare

Company

Humana Healthcare

Description

  • Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
  • Optimized the Oracle PL/SQL queries by Performance Tuning.
  • Working in data analysis & data cleansing.
  • Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C# and vb.
  • Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
  • Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
  • In production support (L2 and L3) in rotational shifts for all the application that has been gone live from the team while continue development for new projects

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 usingSSIS/DTS, and exe applications.

Show More Show Less

Carecentrix Healthcare

Company

Carecentrix Healthcare

Description

 It’s a Production Support and enhancement Project.There are many applications with UI as c# and Winforms and backend of oracle and sql.There are Tidal jobs and reports those are in SSIS and SSRS.Most of the Jobs are ETL process where as applications are used to create and update claims.

 

  • Get requirement from client and created HLD/ LLD for the same, get it approved and start working on the same.
  • PL/SQL, SQL, Database Design (both Physical and Logical), Data Exports & Imports, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities
  • Giving L2 and L3 production support for claims team.
  • Development of EXE application for claims processing usingc# and web services.
  • Using MVC architecture for front end design of application and supporting the same for production live.

Show More Show Less