SUMMARY

• Highly motivated Microsoft SQL BI developer with strong 8+ Year experience in development and maintenance of OLTP and data warehouse applications using MS SQL Server 2016/ 2014 /2012 /2008 R2 /2008 /2005 over 7 years of experience in Healthcare, Retail, Banking and Finance.
• Extensive knowledge in analyzing, designing and developing Client/Server, BI applications and various segments of software development life cycle (SDLC) involving business process analysis, requirement gathering and development.
• Expertise in Microsoft Suite of products (SSIS, SSRS, SSAS, SSMS) in Development, Test, Production Environments. Even managed large databases.
• Extensively involved in Agile methodology, developing and implementing end to end BI solutions.
• Proficient in data integration, DTS Migration and transfers using utilities including Data Transformation Services (DTS), SSIS, Bulk copy program (BCP) and Bulk Insert.
• Involved in designing ETL data flows, deploying SSIS packages, creating mappings/workflows to extract data from SQL Server and worked extensively on various data sources (Excel, XML, Flat file etc.), Synchronous and Asynchronous transformations using SSIS.
• Experience in job scheduling, SQL mail Alerts using SQL Server Agent.
• Expert in Debugging, Logging, Error handling and Event handling for SSIS Packages.
• Highly experienced in Designing, Developing and Deploying various reports like Tabular, Matrix, Chart, Drill down, List, Ad - hoc, Parameterized, Cascading and other reports using SSRS (Relational and multi-dimensional data).
• Worked on Subscriptions, scheduling snapshots, managing snapshot history and managing the report server.
• Designed and created OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence and populating/maintaining data marts in SSAS.
• Used multi-dimensional expressions (MDX) queries for calculated members of OLAP cube, KPIs, partitions, aggregation, and measures in SSAS.
• Thorough knowledge in data ware house concepts, Relational Database Management Systems (RDBMS), Normalization, Data Modeling and Documentation.
• Strong experience in creating tables, writing complex SQL Queries using functions, stored procedures, cursors, Indexes, joins, triggers, views in T-SQL for optimum performance.
• Extensive knowledge of addressing performing issues and involved in performance tuning, index tuning, Data Profiling and query optimization.
• Highly involved in automation processes.
• Involved in unit testing and helped Quality Assurance Team to generate Test Plans and Test Executions.
• Enjoys working in collaborative team environment and produced qualitative results independently with minimal supervision.
• A well-organized, Flexible, enthusiastic and project oriented team player with excellent Interpersonal, communication, management and analytical skills to develop creative solution for challenging client requirements.

TECHNICAL SKILLS

RDBMS: MS SQL Server, Oracle, MS access, DB2, \ SQL Alerts, SQL jobs, Erwin, ER studio.

Tools: Teradata\ Service Now, TFS, Tidal

BI and SQL Tools: SSIS, SSAS, SSRS, Business Intelligence

Operating Systems: MS Windows 2010/07/03/P, Windows

Scripting and Query Languages: MS office 2013/2010/2007, Agile, Scrum and \ T-SQL, HTML, VBScript, C, C#

Waterfall methodology: Development Studio (BIDS), SSMS, Visual \ Server 2012/2008, MS-DOS, Unix-Ubuntu Studio

PROFESSIONAL EXPERIENCE

Confidential, Dayton OH

Sr. SQL / BI Developer

Responsibilities:

• Subject matter expert for Adjusted Clinical Group process. Created all new lines of business products using SSIS and working on migration of existing products from SAS to SSIS.
• Received Certificate of appreciation for moving Ga MDCD product into production within the tough deadline.
• Involved in the complete SDLC including requirement specifications, Analysis, Design, Development, Testing and worked on End-to-End Process (starting from requirements analysis to implementation).
• Expertise in analysis of data to the high level and working in requirements gathering and creating STM’s.
• Identified data issues and worked extensively on bad data to resolve the issues. Also, worked on net iteration to eliminate backout claims, duplicates, calculate cost etc.
• Extensive experience in writing complex queries including stored procedures, temp tables, functions, CTE’s, Joins, Sub queries and more.
• Worked with parameters, variables, error handling, expressions in SQL server and SSIS. Also, worked on RDBMS concepts for creating database objects such as tables, views, functions, indexes etc.
• Performed data cleaning, Data Aggregation, Data Scrubbing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SQL queries.
• Highly experienced in performance tuning and query optimization.
• Experience in HIPPA guidelines, Claims, Member, Provider, HEDIS, Pharmacy, Care Management etc.
• Developed ETL packages using different data sources (SQL server, Excel, Flat files, XML etc.) and loaded the data into the target by performing various kinds of transformations.
• Automated ACG application version, mapping and license files which are received yearly or quarterly to reduce human error and frequent code modification.
• Extensively worked on SVN tortoise and Team Foundation Server to keep track of all changes that are made in the project.
• Worked on deployment process using Team City and Octopus and also using SVN for several lines of business products.
• Provided documentation about database/Tables and Updated functional specification, technical design documents and Unit test cases.
• Excellent Inter-personal, Analytical & Communication Skills with experience in interacting with clients, data admins and multiple groups. Ability to work in a fast-paced environment and under deadlines.

Environment: MS SQL Server 2016/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS Visual Studio 2012, SVN, Service Now, Octopus and Team City, Tidal and Microsoft Team Foundation Server.

Confidential, Miamisburg, OH

Sr. SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Followed agile methodology and delivering fast iterations to the users.
• Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created SSIS Packages using Execute SQL Task, File System Task, Execute Package Task, Send Mail Task, Execute Process Task, Sequence container and for each Loop container.
• According to client requirements, generated reports like Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and process data from data mart using SSAS.
• Involved in building the dimensions, cubes with star schema and snow flake schema using SSAS.
• Worked with RDBMS concepts for creating database objects such as tables, functions, stored procedures, indexes, views.
• I was involved in performance tuning of the SQL queries.
• Used SQL server agent and Autosys to schedule the packages.
• Worked on SDLC (Software Development Life Cycle) and was involved in all stages of development.

Environment: MS SQL Server 2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS Visual Studio 2010, MS Excel, T-SQL, Autosys

Confidential, New York, NY

Sr. SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• According to the business requirements, Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Worked extensively on bad data using configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
• Created configuration files in order to deploy packages in different environments.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables/parameters to store the data into SQL-Warehouse.
• I have extensive experience on working on production level issues.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Extensive experience inrelational and dimensional data modeling for creating logical and physical design of database and ER diagramsusing multiple data modeling tools likeERWIN, ER Studio.
• Developing reports like tabular, graph, matrix and deployed them on SharePoint server.
• Involved in creation and processing of SSAS Cubes.
• Identified and modified the KPI’s, measures in co-ordinance with the requirement and created calculate members in cube using MDX queries in Business Intelligence Studio using SSAS.
• Worked with RDBMS objects such as tables, views, indexes, stored procedures, functions, and triggers in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Involved in unit testing of the SSIS packages, reports and cube re-conciliation.

Environment: SQL Server 2012, Excel, Access, MS SQL Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Reporting Services (SSRS), Visual Studio 2010, Erwin, ER studio

Confidential, Chicago, IL

MS SQL / BI Developer

Responsibilities:

• Designed and developed SSIS packages to move data from different environments within the organization.
• Created SSIS Package with Variables, Expressions and Transformations.
• Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.
• Experienced in Deploying packages from development server to production server.
• Deployed the packages in catalog method and worked on job scheduling and send mail task.
• Worked on designing reports such as Tabular, Matrix, List using SSRS. Configured and maintained Report Manager and Report Server using SSRS.
• Created the reports based on the requirements and Deployed the Reports in Report Server.
• Created a sustainable reporting practice and means of storing, sharing/ publishing the information and reports using subscriptions.
• With Analysis Services created Cubes, Dimensions, facts, Measures and Aggregates based on the business requirement.
• Involved in defining Referenced Relationships and in Identifying KPIs in SSAS.
• Involved in the performance and database optimization of T-SQL queries.
• Developed User Defined Functions, Stored Procedures, SQL Queries based for Ad hoc process.

Environment: MS SQL Server 2012/2008 R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Integration services (SSIS), T- SQL, Erwin, MS Excel, MS word, Visual Studio 2010

Confidential, Long Island City, NY

MS SQL SSIS/SSAS/SSRS Developer

Responsibilities:

• Experience in extracting the data from OLTP Systems to OLAP (DWH) using SSIS.
• Developed and deployed SSIS packages and also upgrading DTS packages to SSIS. Also involved in Modified the Existing SSIS Packages.
• Frequently used data flow and Control flow Items for Designing ETL Packages.
• Used various transformations such as Derived Colum, Look up, Conditional Split and Multicast while implementing the business logics and load the data to destination using SSIS.
• Migrated 80+ DTS packages from SQL 2000 to 2008R2 using SSIS designer.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using SSRS.
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
• Created Linked reports, Ad-hoc reports (using Report Builder) based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed SSAS cubes for providing business intelligence applications.
• Created various calculations and Named Datasets to implement business Logics.
• Worked on Cube Reconciliation and Unit Testing.
• Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity.

Environment: MS SQL Server Management Studio (SSMS), MS SQL Server 2008R2, T-SQL, Visual Studio 2005, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS)

Confidential

SSIS/SSRS developer/Sr. MS SQL Developer

Responsibilities:

• Developed, maintained and executed SQL scripts/queries and validated completeness, integrity and accuracy of data.
• Designed, developed, and tested stored procedures, views and complex queries for creation of Reports.
• Designed and developed Data Transformation Process (Extraction, Transformation & Loading) using Heterogonous Sources to Destination (SQL Server).
• Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Mail Task Etc.
• Used SQL Agent for job scheduling.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient management.
• Built and performed user acceptance testing on new and modified reports. Generated different types of reports like tabular, matrix, list and more.

Environment: MS SQL Server 2008/2005, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS) and MS Excel, Microsoft office Suite (Word, Excel and PowerPoint)