SUMMARY:

• Highly motivated Microsoft SQL BI developer with strong experience in development and maintenance of OLTP and data warehouse applications using MS SQL Server 2 /2008 R over 7 years of experience in Finance, Healthcare and Banking.
• 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.Teradata\ Service Now, TFS, Autosys, Tidal

BI and SQL Tools: SSIS, SSAS, SSRS, Business Intelligence \ MS Windows 2010/07/03/P, Windows Development Studio (BIDS), SSMS, Visual \ Server 2012/2008, MS-DOS, Unix-Ubuntu Studio

Others: MS office 2013/2010/2007 , Agile, Scrum and T-SQL, HTML, VBScript, C, C# Waterfall methodology

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. SQL / BI Developer

Responsibilities:

• Actively involved in complete SDLC including requirement specifications, Analysis, Design, Development, Testing and worked on End-to-End Process (starting from requirements gathering, analysis to implementation).
• Worked with Business users, Business Analyst to discuss the data rules, mappings and involved in grooming of the sprint issues to be expected and solutions to overcome them. Also, worked with Product Managers for prioritization of project work.
• Worked on data modelling to create multiple database objects like views, tables, functions, cursors, indexes, triggers, views, complex SQL Queries using joins, CTEs, temp tables, stored procedures in T-SQL with optimum performance.
• Created SSIS ETL workflows to validate, extract, transform and load the input data to a centralized SQL server and automated all the internal Monthly and Quarterly data loads of Investment Risk which includes Redemption, Share class, SRRI, Investor Concentration data load using Excel data loader and Autosys (Workload Automation Jobs).
• Worked with JP. Morgan’s team to generate redemption data for SICAV and OEIC funds.
• Designed and developed SARL Board reports, Monitoring short position report, MiFID Forward and Backward stress test reports for different account-benchmark-model-currency combinations using multiple capabilities like Tablix, Matrix, Cascading, Drill down, Parameterized, sub-reports etc.
• Developed and deployed multiple parametrized sub reports for Equity Summary & detailed risk report and audit reports for MSCI liquidity data using SSRS.
• Tested the Portfolio, Factor, and Security Analytics modules of MSCI process in test environment. Built and performed user acceptance testing on new and modified reports.
• Automated SSRS report delivery using data driven report subscription, single report subscription, Autosys jobs like, sending CPO summary reports, different Liquidity PM reports for US, ASIA, UK Portfolio managers for the list of Equity, Fixed income and Asset allocation accounts under them etc.
• Followed agile methodology and worked extensively on Adhoc requests, supported and enhanced Investment Risk reports to deliver fast iterations to the users.
• Documented the data mappings, process involved in the workflows and report development.
• 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 Management Studio (SSMS), MS SQL Server 2016/2012, MS Visual Studio 2012, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Service Now, Rally, Jira, Trello, Informatica, Autosys and Microsoft Team Foundation Server.

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.
• 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. 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.
• 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.
• Generated various kinds of reports using SSRS and report builder.
• 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.

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.
• Developed, maintained and executed SQL scripts/queries and validated completeness, integrity and accuracy of data.
• 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 SQL Agent for job scheduling.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of database and ER diagrams using multiple data modeling tools like ERWIN, 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