PROFESSIONAL SUMMARY:

• Having 7+ Years of IT Experiences in Data Modeling, Data Mart Development & Maintenance of Data Warehousing and Client Server Application with Finance, Healthcare, Manufacturing, and Banking domains with expertise MS SQL Server 2008 R2/2012/2014 of products like SSAS, SSIS, SSRS, Multidimensional (MDX), Data Analysis Expressions(DAX), Tabular Model, Power BI, .NET(C#).
• Experienced in Data Extraction, Migrations, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 R2/2012/2014 respectively.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 R2/2012 (SSAS) Cubes, Dimensions, Measures, Deploying & Processing SSAS objects, writing MDX and DAX queries.
• Experienced with Cube Analysis using MS-Excel with excel PowerPivot.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008 R2/2012/2014 (SSRS).
• Expert in database maintenance, monitoring, backups, restores and recoveries.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2008 R2/2012/2014 and strong knowledge of SDLC principles.
• Strong experience in Stored Procedure/TSQL coding, Performance tuning, and Query Optimization.
• Involved in all phases of software development life cycle: design, implementation and unit testing.
• Good communication, analytical and interpersonal skills, self-motivated, quick learner and an active team player and team leader. Very flexible and ready to take new challenges.

TECHNICAL SKILLS:

Reporting: Designed and developed Reports/Dashboards using SSRS. Designed different types of graphical reports like Pie Charts, Column Charts, Map reports, Indicators. Worked on Dashboard reports, Drill Through and Drill down reports, Sub reports, Ad hoc Reports. Worked on Report deployment, Formatting reports, Configuration of Report Server, Subscription of reports in Report Manager.

ETL: Designed complex packages for data processing/migration across various domains using tools such as SSIS. Worked on Configuring connection managers, Logging, Checkpoints, Event Handlers, Performance Tuning, Breakpoints, Transactions and Debugging.

DW: Designed and developed many Data warehouses based on various schemas in SQL. Proficient in Dimensional Modelling techniques.

Databases: MS SQL Server 2005/2008 R2/2012/2014, Teradata.

PROFESSIONAL EXPERIENCE:

Confidential - Jersey City, NJ

Sr. ETL developer/SSIS, SQL Developer

Responsibilities:

• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Developed Physical data models and created DML scripts to create database schema and database objects.
• Employed Server Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Worked closely with the Business Analyst, Data Modeler and Database Architect during the design and development of ETL technical specification document.
• Used SSIS as an ETL to extract data from source like MS SQL Server, Flat files and Teradata and loaded to target.
• Involved in fine-tuning of sources, targets, mappings and sessions for performance optimization.
• Extensively used complex SQL queries to unit test the system and to test the existing project. Also used to validate the data in data warehouse and involved in end-to-end testing of the design
• Worked extensively with variables and parameter files in the mapping and in session level to pass the value and to control the environment, source, target information.
• Designed SSIS packages with audit batch process at detail and header level to track number of rows inserted and updated on the tables affected, added transactions to rollback or commit the transaction based on package execution.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources.
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Responsible for scheduling the packages in terms of data validation and consistency through sql server agent Jobs using Tidal with Job Dependencies and created file event to check the existence of file in a shared location with email notification to Business Distribution list.
• Used Team city and Octopus for deployment of SSIS package to higher stack.
• Use Agile methodology for SDLC and utilize scrum meetings for creative and productive work.

Environment: MS SQL Server 2016/2014/2012 , Windows 10/NT/XP, SSIS 2012/2015, SSRS 2012/2015, T-SQL, C#.net, MS Office 2013, Erwin 10.6, Team Foundation Server (TFS), MS Excel 2013/2010, SSRS, Power BI, Team City, Octopus,Tidal, Informatica Power Center, Share Point.

Confidential - Dayton, OH

Sr. Microsoft BI developer/SSIS, SSRS, Informatica, SQL Developer

Responsibilities:

• Performed as the Functional team leader for SSIS module to integrate data collection from different sources.
• Gathered from the users their home mortgage modification reporting requirements like Referrals, Application, Submittals and Decisions etc. for their Home Equity solutions.
• Performed Dev testing for existing mappings in informatica using Debugger.
• Designing SSIS ETL packages to validate, extract, load from different file formats and a data sources.
• Reviewed incoming data structures and business definitions and usage.
• Used sequence containers, loop containers, execute SQL task and various data flow tasks.
• Created Script tasks to display the messages using C#.
• Generated reports of various types including, drill down, drill through, ad hoc, matrix, and parameterized reports using SSRS with Budget size and cost per dollar raised as parameters.
• Developed many Tabular Reports, Matrix Reports, Sub Reports, Dynamic grouping, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2014) with Equity and Bonds Data
• Performed ETL from transactional source databases to data warehouse with incremental load using SSIS.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Defining relationships between Dimensions and Measure groups with Trades and securities. Involved in the design and development of the SSAS cubes and MDX queries.
• Creating users Role base security (permissions) for cubes, dimensions, measure groups etc.
• Worked on Power BI and prepared dashboards using SSRS to make it more attractive so that operational Margin overhead ratio related to bonds can be shown
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs to avoid loss of transactional data related to shares.
• Wrote complex SQL queries involving multiple tables from different databases using Joins, sub-queries, temp tables.

Environment: MS SQL Server 2016/2014, Windows 10/NT/XP, SSIS, SSRS, OLAP, OLTP, T-SQL, C#.net, Query Analyzer, MS Office 2013, Oracle 11g, Erwin 10.6, Team Foundation Server (TFS), MS Excel 2013/2010, SSRS, Power BI.

Confidential, New York, NY

SSIS, SSRS, SSAS, SQL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes with data like equity and bonds, gather and documented project requirements and translate them into ETL Design Specifications.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to stage in the data warehouse to perform Aggregate, Audit, Derived Columns, Lookup, Fuzzy Lookup, Merge Join, Conditional Split, OLE DB Command and more. Performed ETL mappings using MS SQL Server Integration Services.
• Used Control Flow elements like for each Loop Container and For Loop Container in SSIS.
• Used Execute SQL task, Execute Process task, execute packages task, File System task and Send Mail task in SSIS to solve the issues with bonds, securities.
• Upgraded SSIS packages for an entire Application from using Project wizard and successfully deployed packages.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and Managers to track the transactions.
• Generated SSRS Reports to hold data related to financial statements, Balance sheet, Income statement with Bonds as .
• Created a sustainable reporting practice and means of storing and sharing/ publishing the information and reports using subscriptions to capture Debt Service, Trends and Securities.
• Created Adhoc Reports and Dashboard to show Revenue Gross Profit, Operating Income related to Equity.
• Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.

Environment: MS SQL Server 2008 MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Microsoft Visual Studio 2010, MS Excel, T-SQL.

Confidential - Dayton, OH

Microsoft BI developer

Responsibilities:

• Creating and analyzing existing high level ETL design documents and data mapping documents
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task.
• Imported data, built scheduling packages, defined integration flow and log data error exceptions using SSIS.
• Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.
• Assisted in building a company specific Data Mart for the Claims related data.
• Optimized the performance of queries with modification in T-SQL queries, removed the unnecessary columns and redundant data, normalized tables, established joins and created index.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• Worked on developing cubes with Derived column, Aggregation, KPI for decision-making, Prospective, measures and hierarchy.
• Designed and developed the reports according to the requirements using SSRS and Power Map.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• T-SQL used for creating various complex objects like Tables, views, functions, store procedure for storing and processing data in required form.

Environment: MS SQL Server 2012 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Management Studio, Data Transformation Services, SQL Server Agent, SQL Profiler, Export/Import Wizard, Visual Studio, MS Access, T-SQL, Query Analyzer, MS-Excel, MS Access 2010, Power BI, SQL Server Agent, Power Map.

Confidential, Exton, PA

Microsoft BI developer/SSIS, SSRS, SSAS, SQL Developer

Responsibilities:

• Designed and developed SSIS Packages to import data and export data from MS Excel, flat files, SQL Server and transform and load data into SQL Server database.
• While importing data from flat files used various Error Output Descriptions which manages error outputs from flat files.
• Merged data from different data sources for example text files, CSV, excel spread sheet and OLE DB source and load data to database.
• Transformed data between different formats (flat files, excel spread sheets) and fixed the defective data.
• Transformed reports from SSAS to Excel and analyzed them by creating charts, matrixes and tables.
• Created reports like tabular, matrix, ad-hoc, drill through reports, drill down reports using SSRS.
• Designed Report Templates, Bar Graphs and Pie Charts based on the sales data.
• Deployed SSRS reports into Report manager and managed reports subscriptions, delivery, generation, rendering.
• Upgraded the server from SQL Server 2008 to SQL Server 2012.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions by writing Queries and Joins.

Environment: MS SQL Server 2008 Enterprise Edition, SQL Server 2012/2008R2 Enterprise Edition, Crystal Reports 2008, ODBC, VBScript, Windows 2000/2003 Server, SSRS, SSAS.

Confidential

Microsoft BI developer/SSIS, SSRS, SSAS, SQL Developer

Responsibilities:

• Migrated data from different sources such as flat file, Excel to SQL Server databases using SQL Server Integration Services (SSIS)
• Expert in creating packages like extract, transform and load data to data warehouse by SSIS, from various sources such as flat files, OLEDB sources.
• Experienced in various data flow tasks and transformations such as merge, union audit and so on
• Experienced in creating various reports such as multilevel group by different format like charts, tables and so on.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Used different T-SQL queries such as views, triggers, user defined functions, stored procedures to retrieve data from various tables, load data.

Environment: MS SQL server 2008 R2, SQL Server Integration Services (SSIS) 2008 R2, SQL Server Reporting Services (SSRS) 2008 R2, MS Excel, MS PowerPoint.