SUMAMRY:

• Around 6 Years of wide - ranging experience in Database Design, Development, support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in integration of various data sources like SQL Server, S DB, DB2 and Flat File, Excel File.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc.
• Extensively worked on Control Flow Tasks such as Foreach Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.

TECHNICAL SKILLS:

Server Operating System: Windows 2003, 2008, 2012.

Languages: Pl/SQL, T-SQL

Data bases: MS SQL Server 2005/2008/2012

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Self BI with Excel

Development Tools: Visual Studio.NET 2008/2012/2013/2015

Database Query Tools: SQL Server Management Studio (SSMS), SQL Profiler, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

MS SQL BI Developer (SSIS, SSAS, SSRS)

RESPONSIBILITIES:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used SSIS to move data from text files to SQL Server.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion).
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel, Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
• Extensively created complex formulae and calculations (Interest Rate, Standard Fee) for financial data using SQL and Excel
• Created Tableau reports for different processes on Home Loans Servicing

ENVIRONMENT: MS SQL Server 2014, Excel, SQL, SQL BI Suite (SSIS, SSAS, SSRS), MS Office, Microsoft Visual Studio 2010,2012,2013

Confidential, Parsippany, NJ

MS SQL BI Developer (SSIS/SSRS/SSAS)

RESPONSIBILITIES:

• Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users
• Worked on Data migration project by validating three source data row by row and field by filed
• Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
• Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements
• Created a logic to validate the data before loading data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
• Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
• Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables with high level SSIS package execution.
• Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in SSIS
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Responsible for the issues raised from the production and debugging and deploying the updates.
• Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
• Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

ENVIRONMRNT: Microsoft SQL Server 2012/2008, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Visual Studio

Confidential, New York, NY

BI Developer (SSIS, SSAS, SSRS)

RESPONSIBILITIES:

• Responsible for gathering requirements for the database designing for the middle office with the Data Architect.
• Developed SQL Scripts for data validation, manipulation and reporting services
• Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults. Used multiple join statements to retrieve data from multiple tables using complex SQL queries
• Developed SSIS ETL Packages using multiple data sources (SQL Server, Flat Files, Excel Source files, etc.) and then loaded the data into destination tables by performing different kinds of transformations.
• Extensive experience in usage of SSIS Control Flow items (For Loop, for each loop, execute package/SQL tasks, Script task, and send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion).
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, Transaction, and package configurations and Logging for Complex SSIS Packages.
• Created reports using SQL Server Reporting Services (SSRS) as per user requirements.
• Designed various reports like charts, drilldown, drill through and matrix reports based on the user requirements using SQL Server Reporting Services (SSRS).
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS).

ENVIRONMENT: MS SQL Server 2008 R2, SQL, T-SQL, Microsoft office Suite (Word, Excel, PowerPoint).

Confidential, Chicago, IL

BI Developer (SSIS, SSAS, SSRS)

RESPONSIBILITIES:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements. 
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations
• Developed SQL Scripts for data validation, reporting services
• Created refund calculations using SQL and excel for mid-size data
• 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.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created checkpoints and configuration files in SSIS packages
• Experienced in slowly changing dimension in SSIS packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and dashboards involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Tested all ETL packages, various types of testing like Unit, Regression and System.

ENVIRONMENT: MS SQL Server 2012, SSRS, SQL, T-SQL, Microsoft office Suite (Word, Excel, PowerPoint)