SUMMARY

• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2005 on various business domains like Financial, Insurance and manufacturing.
• Extensive experience in focused on ETL and reporting with MSBI suite(SSIS, SSRS)
• Worked on the following versions of MS SQL Server 2012/2008R2, 2008/2005 as developer.
• Experienced in full life cycle ETL development using SSIS
• Extensive experience in creating many complex SSIS packages using SQL Server Integration Services using SQL server 2012/2008 R2/2005
• Experience in Extraction and Migration of Data from heterogeneous data sources like flat files, CSV, Excel, MS Access, Oracle, XML & MS SQL Server using SSIS.
• Experience in data reporting and data analysis.
• Experience in Creating, Populating and maintaining Data marts.
• Experience in data analyst.
• Develop ETL specifications, source to target mapping and other documentation required for ETL development.
• Expert in designing reports using SQL Server Reporting Services (SSRS).
• Having knowledge on build cubes via SSAS using MDX and DAX.
• Experienced in generating on - demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2012/2008 R2/2008 (SSRS).
• Worked on complete Reporting Life Cycle on Authoring, Management & Delivery.
• Experience in creating Data Driven, Drill Through, Drill Down, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).
• Knowledge in Design and Development of Reports and cubes using SSAS.
• Experience in Designing reports using Report Designer, Report Builder3.1, and Report Manager, creating parameterized reports & managing subscriptions.
• Upgrade of Crystal Server product to current version
• Worked on Report Manager to subscribe reports, Assign roles, user access with respect to security.
• Install and configure Crystal Server v 2013
• Document the process for installing Crystal Reports 2013 developer software for Windows 7 and 8
• Convert all existing Crystal Reports files (v2008) to 2013
• Demonstrated understanding of effective dashboard reporting construction and data visualization.
• Strong in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, Triggers, User Defined Functions, Views, DDL/DML, TSQL Scripts and Batches.
• Team development experience using scrum and agile.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client requirement.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Experience in unit testing and support user acceptance testing and document test results.
• Good knowledge of the Microsoft Server tool BI Stack of SSAS (Analysis Services - OLAP).
• Good knowledge and experience in Data Warehouse design (Kimball Group) of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
• Knowledge of Change Management procedures and source control tools.

TECHNICAL SKILLS

ETL Tools: SQL Server Integration Services 2012/2008 R2/2008/2005

Reporting: SQL Server Reporting Services2012/2008R2/2005, MS Excel.

Development skills: T-SQL, PL/SQL,SSIS/SSRS/SSAS

Databases: SQL Server 2012/2008R2/2005, Oracle11g, MS Access.

Languages: T-SQL, PL/SQL,VB Script, .Net, C#

Other Tools: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

SQL SERVER / MSBI Developer

Responsibilities:

• The client is one of the largest Managed Services providers.
• Was part of a team working on their ETL and complex reporting needs to support their Enterprise Wireless LAN (WLAN) customers.
• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Analyzed the specifications provided by the client and gathered the requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load in order to create and maintain a centralized data warehouse.
• Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures validated and tested all packages on development server
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated customer reports using SQL Server Reporting Services 2012/2008R2from the OLTP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for better performance.

Confidential, New York, NY

MS SQL Server / SSIS/ ETL Developer

Responsibilities:

• Developed SSIS package for transferring the data between MS Excel, Flat Files and SQL Server.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Worked with DBA to perform data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Experience in Error Handling using global variables and logging of the errors into database
• Created various Tables, Views and Indexes.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors for application.
• Used SQL Profiler to trace out problems in slower execution plans.
• Developed several reports with multi-level drill downs and used several Charts to represent the data in the reports using SQL Server 2008 Reporting Services (SSRS).
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created several report subscriptions to deliver reports to the end users via email.

Environment: SIS, SSIS, MS SQL Server 2005/2008, Windows 2003, VSS 2005, MS Office Access 2003, C#, VBScript, .Net, DTS.

Confidential, New York, NY

ETL Developer /SQL Developer

Responsibilities:

• Developed SSIS packages to load data from application database and general ledger into data marts.
• Designed SSIS packages to pull the data from Oracle to SQL Server.
• Responsible for creating SSIS packages, Scheduling packages in SQL Server database.
• Gathered requirements from several Interfacing teams and prepared the Requirements document.
• Implementations of MS SQL Server Management studio to create Complex Stored Procedures and Views using T-SQL.
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors during the execution.
• Scheduled the reports to run on daily and weekly basis in Report Manager and emailing them to director and analyst to be reviewed in Excel Sheets.
• Created several reports for claims handling which had to be exported out to PDF formats.
• Created several Drill down & Drill Through reports using SSRS for the different divisions to see their weekly, monthly and quarterly claims handling data.
• The reports had to have the data broken down in several visualizations using line, bar and column charts.
• These were delivered as subscriptions via email to the groups.

Environment: MS SQL Server 2005, Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).

Confidential 

Data Analyst

Responsibilities:

• Built ad-hoc queries from SQL Server databases based on customer requirements.
• Organized monthly and annual reports to ensure balance statements are accurate.
• Assisted the manager in the analysis of the collected data and interpreting them.
• Verified accuracy of data analysis and coordinated with the branch office.
• Responsible for logical and physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Designed and implemented stylish report layouts.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created users and roles for login authentication and validating permissions.
• Administered MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.

Environment: SQL Server 2005, Transact-SQL, Query Analyzer, DTS Designer, SQL Profiler, and MS-Excel.