SUMMARY

• 7 years of IT industry experience with expertise in Microsoft SQL Server Development in Insurance and Health care domains.
• Strong experience in Development, Testing, Maintenance and Support of ETL (Extraction, Transform and Load) using Informatica Power Center 9.0.1/9.5
• Strong Applications designing and development experience in Microsoft Visual Studio .Net IDE using ASP.NET and C# Windows Form with back - end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client. windows applications, web applications and web services in Microsoft Visual Studio .Net IDE using C#, ASP.NET
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expert in TSQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Good understanding of Normalization /De-normalization and database design methodology.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Sound knowledge of creating MS Excel Macro/VB Scripting.
• Knowledge of Agile methodology.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.
• High performer and awarded highest performance rating (CRR 1+) for two consecutive years during appraisal cycle.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012, Oracle 9i/10g, DB2, Teradata, MS Access

ETL Tools: SSIS( 2005/2008/2012 ), Informatica Power Center 9.0

Operating Systems: Windows NT/95/98/XP/2000/Server 2003

Programming: T-SQL, PL/SQL, C/C++, Core Java, C#, Teradata SQL, VB Script

Tools: Informatica Power Center 9.0, ClearQuest, DQ Analyzer 8, SAS EG, Informatica MetaData Manager

Framework: ASP.NET, ADO.NET

Web Server: IIS Server 6.0

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

MS SQL Server Developer

Responsibilities:

• Developed migration scripts for conversion of existing systems into new Services CRM solution (MPN membership .Next Project).
• Designed SSIS Packages to extract, transform and load (ETL) existing data into SQL Server 2012.
• Wrote highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Used joins and sub-queries in queries to retrieve data from multiple tables.
• Worked individually on designing technical documents by gathering required logic for the project.
• Wrote Unit test cases for the Build packages, and analyzed various transformation rules.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors on Microsoft SQL Server.
• Created deployment environment for the packages in order to migrate data to CRM.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools.

Environment: MS SQL Server 2012, SSIS 2012, DTS, T-SQL, Visual Studio 2012, .NET, Share point, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), Azure, CRM Web Services, Agile/Scrum, Facets,Microsoft Excel, Microsoft access.

Confidential, Las Vegas, Nevada

.Net & BI Developer(SSIS,SSRS)

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of the application.
• Continuously interacted with Business Analysts and end users to gather business requirements.
• Used WCF services and web services for communicating with other application and components.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Extensive use of dynamic SQL to increase the performance, efficiency and quality of code.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created Tabular, Charts and graphs as per customer requirements Using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.

Environment: MS SQL Server 2008/2012, MS SQL SSRS 2012, SSIS 2012, ASP.NET, jQuery, C#.NET, Visual Studio 2012, Web Services, WCF, Java Script, HTML, CSS

Confidential, Fort Lauderdale, Florida

SQL Server/BI Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Implemented dimensional data warehouse model using Ralph Kimball methodology.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Designed and developed Reports in SQL Server 2005 Reporting Services (SSRS).
• Involved in migration and Conversion of Reports from SSRS .
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• 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.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Environment: SQL Server 2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008

Confidential, Mayfield Village, OH

.Net & BI Developer(SSIS,SSRS)

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) and identified and defining the business requirements.
• Implemented complicated business logic to calculate premiums depending on the changing rate tables and the various conditions provided by users.
• Implemented User Profile Management modules to create user profile and provide functionalities like update profile, payment features and process claims online.
• Understood and analyzed the project requirements and involved in GUI designing of the application.
• Extensively implemented Object Oriented Programming functionalities.
• Implemented the Presentation Layer using the concepts of Master Pages, CSS, AJAX, JavaScript, jQuery and HTML.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Maintenance and provide support to the users for the deployed reports.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created subscription to reports.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.

Environment: MS SQL Server 2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 server, Visual Studio 2005, C#.NET, JavaScript, ADO.NET, HTML, CSS

Confidential, Pittsburgh, PA

.Net & SSIS Developer

Responsibilities:

• Involved in system analysis, design and development.
• Designed and developed effective web application based on technical design and requirement specifications.
• Designed and developed UI for the website with the focus on the user’s experience and interaction using ASP.NET User Controls, HTML Controls and Server Controls.
• Used Cascading Style Sheets and master page for a unified look and feel of the application.
• Developed the Business Layer using C#.
• Developed ETL Packages and Reports.
• Create tables,stored procedureswhen required.
• Gatheird Day to Day files from FTP, Secure FTP servers, decrypt them and deliver tothe respectiveteams thatrequire the file.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly-basis,file-transfersfrom one location to other.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Modified different packages where the issues (likeremoving the duplicaterecords or just updating a record and disable the previous records that had different IDs for one person,) rose after the user interference.
• Worked with Team foundation server (TFS) offeringsource control, data collection,reporting, and project tracking.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry,performingdatabase capacity planning.

Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, BIDS 2005/2008,Visual Studio 2005/2008,CSS, JavaScript, ADO.NET, TFS.