Ram Sql Email & Phone Number

Lees Summit, Mo

GEHA is a health insurance company which provides coverage to more than 1 million lives worldwide.

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.• Involved in database Schema design and development.• Migrated Database from SQL Server 2005 to 2008.• Experience in using SQL Server 2012.• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.• Enhancing and deploying the SSIS Packages from development server to production server. • Wrote the ETL scripts to load the data into database from various source files. • Experienced in error handling and troubleshooting the scripts in failure to load the data into database.• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments. • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.• Expert in SSIS Deploying and Scheduling.• Developed modules of the application in ASP.NET, Silverlight and involved in writing C# classes.• Experience in