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.
• 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.
• 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, Chicago, IL

SQL Server Developer

Responsibilities:

• Wrote SQL queries to retrieve information from the databases depending on the requirement.
• Evaluated actual and estimated execution plans for queries with performance issues to alter queries for better optimal query performance.
• 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.
• Wrote complex stored procedures that utilized dynamic SQLfor reusability purposes such as index monitoring and defragmentation.
• Created SSIS packages that implemented business logic in the transformation stage by utilizing different transformations in SSIS toolbox such as aggregate, Merge, and Merge join.
• Performed unit testing of ETL SSIS packages that performed ETL (Extract, Transform and Load) processes and data cleansing.
• Utilized transformations in SSIS dataflow, SSIS tasks in control flow such as for loop containers and fuzzy lookup.
• Implemented loggings with in SSIS packages such as custom logging with the help of Script Task.
• Designed Power View reports utilizing Power Pivot models in Power BI.
• Involved in designing dashboards utilizing calculations, parameters in Tableau.
• Designed dashboard reports for the key performance indicators for upper level management utilizing tableau Desktop.
• Providing analysis on Validating and Discovering member claims.
• Track issues via incident and problem resolutions related to the packages.
• 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.

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

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.
• Coordinated with front-end for implementing logic in stored procedures and functions. Performed front line code reviews for other development teams.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Excellent in high level design of ETS DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
• Involved in designing interactive dashboards and scorecards utilizing Power Pivot and Tableau.
• 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.
• 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.
• Worked on Talend ETL tool, developed jobs and scheduled jobs in Talend integration suite.
• Developed dashboards and scorecards with SharePoint along with multiple charts and KPIs utilizing Excel power pivot.

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:

• 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.
• Migration of data from Legacy table to target tables and handling errors.
• Access SQL Server using front end applications like VB.
• Test applications inAgileand Waterfall development process.
• 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.
• 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.
• 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:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Data Warehouse.
• Performed extensive data extraction from web and other sources and handled data preparation missing values, formatting, transformations using SSIS.
• 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.
• Implemented error handling techniques in SSIS packages with the help of event handlers, error row redirections and precedence constraints.
• Utilized data viewers and break points as a troubleshooting technique within SSIS packages.
• 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.
• Designed user defined functions to support front end team for data search related requirements.
• 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.

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.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Transformed frequently used queries into views and stored procedures per requirement.
• Improved query performance by Normalizing and De-normalizing tables as required.
• 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