SUMMARY

• Over 8 years of IT industry experience with Microsoft SQL Server 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS and as SQL Developer.
• Extensive experience in using Microsoft BI studio products like SSIS,SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in Developing reports on SSRSonSQL Server ( 2005/2008/2008 R2).Sound Experience and understanding ofSSAS, OLAP cube and Architecture using BIDS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in Data Modelling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MS SQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Expertise in creating indexed tables with Primary, Foreign key constraints to maintain referential integrity.
• Good understanding in implementing different types ofReplicationModels such asTransactional, Snapshot and Merge.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
• Involved in Develop, analyze and execute system test plans and worked closely with QA group.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented Error handling and Roll Back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 95/98/2000/2002/ Vista/Windows 7/Windows 8/Mac OS X

Databases: MS-SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Oracle 9i/10g/11g, DB2, MS Access

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), BIDS, DBCC, BCP, SQL Server Profiler, Microsoft Performance Point Server.

Data Modeling Tools: Erwin, Microsoft Visio 2000/2003 Microsoft Project/Office 2003,2007, 2010, 2013

ETL Tools: Experienced working with BIDS - DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS), Informatica, Talend.

Reporting Tool: SQL Server Reporting Services (SSRS), Tableau

Languages: T-SQL, SQL C, C++, HTML, XML/XSLT/.Net/C#, Core Java

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Server Developer

Responsibilities:

• Created tables, views, indexes based on the requirements.
• Wrote SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created mappings to extract data from SqlServer and to migrate and transform data from Text/Access/Excel Spreadsheet usingSqlServer Integration Service (SSIS)
• Conducted data cleansing to remove unnecessary columns, eliminate redundant and inconsistent data with SSIS transformations.
• CreatedSqlServer Integration Service (SSIS) packages to extract data from Excel File, Flat Files, Text Files and Comma Separated Values (CSV) files
• Designed new database tables and mapping documents used to guide ETL coding to meet business information needs.
• Currently working on analyzing Validation and discovery projects of healthcare insurance.
• Providing analysis on Validating and Discovering member claims.
• Create trackers to identify the member with unique claim in the line level details.
• Track issues via incident and problem resolutions related to the packages.
• Understanding the System management area and impact of the members with latest claims and sending them to vendor.
• Loading files into proper database and maintaining the database.
• Loading weekly catchup files received from client into proper tables.
• Analyzing members with claims in specific time period and proceed with validation checks to pick the right claim.
• Creating automated jobs to load the weekly catchup data received from client.
• Creating files in the required format for the catchup data and sending it to vendor.
• Doing incremental validation and discovery once we receive files from vendor.
• Reconciling the incremental file with the incremental file we received from vendor. Comparing the results and testing to minimize the differences and finalize the report.
• Scheduling automated jobs to run as specified by using SQL Server Job Scheduling Agent
• Compose clear documentation and reports, assess Operational impacts, provide estimates, ensure operational acceptance, develop and improve support processes and solutions and be involved in projects to supply applications with solutions to their issues.
• Work closely with Vendors and internal resources. This support could expand to other pieces of project depending on the business need.
• Review Groups Incident Problem Change Request queue to identify Problems, Requests and Upcoming Changes within Remedy.

Environment: SQL Server 2008, SQL Server 2008R2, SSIS, SSRS.

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Created ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Responsible for transferring the data using SSIS packages from excel/flat file sources to database.
• Responsible for creating, scheduling Jobs in Talend and SSIS.
• Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.
• Published migrated data using SSIS (SQL Server Integration Services) through data flow tasks, look up transformations and script tasks.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2012.
• Performed Data integrity, validation and testing on the data migrated into the data warehouse.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Involved in extensiveDATA validation by writing several complex SQL queriesand Involved in back-end testing and worked with data quality issues.
• Created SSIS packages, cleaning data and loading data from various sources.
• Worked on various tasks and transformations likeExecute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination.
• Involved in populating data, generating reports using Reporting Services (SSRS) and deploying them on the server.
• Troubleshooting, supporting, monitoring production and test environments.
• Migrating jobs from Talend to SSIS.
• Designed SSIS packages to load data from source to Data Warehouse.
• Worked on Talend ETL tool, developed jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data.

Environment: MS SQL Server 2008/2008R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, Talend, SharePoint.

Confidential, Chicago, IL

Sr. BI Developer

Responsibilities:

• Actively involved in business rule analysis; gathered user requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that don’t have primary key.
• Used Joins, correlated and Non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Experience working in Waterfall and agile software development environments.
• Migration of data from Legacy table to target tables and handling errors.
• Test applications inAgileand Waterfall development process.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and Linked reports using SSRS.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Worked onVB.Net(Windows App) andC#.Net(Web Application) for developing the utilities such asServer Manager, Patient Merger, Visit Re open, Open DoorandHide Visit.
• Migration of data from staging table to target tables and Handling Errors.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple Transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all and Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Developed Reports out of the Consolidated Data Warehouse for the Business Users using MS SQL Server Business Intelligence Development Studio (BIDS) 2008 (SSRS).
• Using Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Security management, Notification and Trigger, Data Tier, Proxy.
• Writing Customized Deployment Process templates for deploying source bits to Dev/QA/UAT/PROD Environments using PowerShell, Microsoft Octopus, MS deploy & TFS.
• Involved in Creating PowerShell scripts for deploying components in SharePoint.
• As part of PowerShell scripting, we use hash table and array to run a script against remote computers.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server and scheduled the monthly/weekly/daily reports to run automatically and send the reports via email.

Environment: SQL Server 2005/2008/2012/2014 , SSIS, SSRS, Visual Studio, MS DOS Batch scripting and COBOL.

Confidential

MS SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation missing values, formatting, transformations using SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Data Warehouse.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Worked with various SSIS control flow tasks and data transformation tasks like Data Conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL.
• Data migration (import & export - BCP) from Text to SQL Server.
• Error handling using Try-Catch Block.
• Normalization and De-Normalization of tables.
• Developed Backup and Restore scripts for SQL Server 2005.
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Prepared daily and weekly status reports and collaborated with other team members.
• Involved in migration of catalogs, Reports from Impromptu to Cognos8 & Report Net using Migration Utility. Used Cognos Scheduler to schedule the Reports.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R, Tableau, Cognos Report Net 1.1, SPSS.

Confidential

MS SQL Server Developer

Responsibilities:

• Created tables, views, indexes based on the requirements.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.

Environment: SQL Server 2000/2005, Visual Basic, .NET