SUMMARY

• 7 Yrs of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains like HealthCare, Banking.
• Experience in using Business Intelligence Tools (SSIS, SSAS, SSRS) in MS SQL Server 2014/2012/2008 R2/2005.
• Ability to work in all stages of Software Development Life Cycle (SDLC).
• Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS).
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using SQL Server Integration Services.
• Hands on experience with performing various SSIS data transformation tasks like lookups, Conditional Split, Event handlers etc.
• Good Experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Developing reports on SSRS on SQL Server (2005/2008/2008 R2).
• Proficient experience in different Databases like Oracle, SQL Server and DB2.
• Working Experience on slowly changing dimensions.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Experience in interacting with business users to analyze the business process, performing ETL, reporting the data.
• Good Experience in Cube Development using SSAS.
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Good knowledge on Informatica tool.
• Experience in tuning T - SQL queries in improving the performance of the queries.
• Good Experience of working on SQL Server Data Tools (SSDT) / SQL Server 2014.
• Good knowledge in designing and creating Indexes, develop Queries and T-SQL Scripts in MS SQL 2014/2012/2008 R2.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables’ inner and outer joins, stored procedures.
• Excellent analytical skills, communication skills and understanding of business requirements in various domains.

TECHNICAL SKILLS

Databases Tools: SQL Server Management Studio, Business Intelligence Development Studio.

ETL Tools: Integration Service (SSIS) 2014/2, Informatica 9.5.1

Reporting Tools: SQL Server Reporting Services (SSRS) (2005/2008 R2/2012/2014).

Database: MS SQL Server 2014/2012/2008 R2/2005, DB2, Oracle

Programming: T-SQL, PL-SQL, C.

Operating Systems: Windows NT 2000/2003 Server, Windows XP/7, Unix/Linux, Mac.

Other Tools: MS Office Suite (Microsoft Word, Power Point, Excel), OLAP & OLTP, Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

SQL/SSRS Developer

Responsibilities:

• Currently working on a health insurance project which deals with health care data, to get the members health care data from the State of Connecticut.
• Deals with Claims, Providers, Recipients health care data, Enrollments, Program types, Sub-program types, Age groups, Premium Amounts.
• Participated in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment.
• Involved in gathering business/technical requirements from Business Analysts. Good understanding of business requirements.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Developed and maintained Tabular Reports, Matrix reports, Parameterized reports, Dashboards.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Identified and defined multiple Datasets to generate sub reports based on main parameterized report.
• Used matrix to group based on row & column to find appropriate values i.e. Total members in a particular program, particular sub program, age group, Gender etc.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters using SSRS.
• Involved in developing various Drill-Through and Drill-Down reports based on the business requirements using SSRS 2012.
• Developed and maintains high level Dashboards, Sub-reports, Ad-hoc reports.
• Developed Reports for business end users using Report Builder tool.
• Involved in tracking and fixing Data warehouse issues created in an online tool JIRA.
• Involved in the Data warehouse Defect Triage and Issue Resolution Process.
• Addressed the production tickets in parallel (tickets which are not dependent on Data warehouse Prod data validation activities which are in progress).
• Co-assisted the work stream and also provided the deliverables to the client on time.
• Involved in training the End users on how to use the reporting tool.
• Involved with Query Optimization to increase the performance of the reports.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Used cascaded parameters to generate a report from two different Data Sets.
• Uploaded the reports to the Report Manager and organized them into folders.
• Involved in writing effective queries for improving the performance of the SSRS reports.
• Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of the reports.
• Designed the reports layout for creating tabular and matrix reports.
• Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases and published the reports as PDF, Excel and CSV etc.
• Assisted the DBA’s in deploying the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Involved in Performance testing of the generated reports.
• Assisted the ETL team to created SSIS Packages by performing different Transformations.
• Good understanding of Data warehouse and ETL using Informatica.
• Good knowledge on Informatica Client tools.
• Actively involved in Weekly Status Meetings.

Environment: MS SQL Server 2014/2012/2008 R2, MS SQL Reporting Services, Business Intelligence Development Studio (BIDS), SQL Server Data Tools, Report Builder 3.0, DB2 4.1.0.1 Client, MS Excel 2007, Windows 2007 Server.

Confidential, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements, and translating them into technical specifications.
• Created SQL Server Reports based on the requirements using SSRS 2012/2008.
• Identified and documented all the reports, tables (subject areas) and ETL for each Business units.
• Created efficient SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, Data flow task, file system task.
• Designed and developed efficient SSIS packages using different SSIS transformations.
• Created SSIS packages for getting the data from different sources such as Flat Files, Excel and databases (SQL server).
• Extracted large volumes of data from various data sources and loaded them into target destinations by performing different kinds of SQL Server Integration Services Transformations.
• Developed packages for loading data to data warehouse OLAP using SSIS from various data sources OLTP.
• Created logging at Package level and task level to log the number of records processed by each package and each task in a package using SSIS.
• Created SSIS packages with error handling.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Extensively used all features of MS SQL Server 2012/2008 R2/2008 as a SQL Developer.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using SSAS.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Assisted in creating events and tasks in the work flows using workflow manager.
• Generated different reports using MS SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters using SSRS.
• Developed a Tabular Reports, Parameterized reports ad-hoc reports using SSRS Report Designer.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Used complex queries involving join and union of multiple tables.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.

Environment: SQL Server 2012/2008 R2, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS) T-SQL, PL/SQL, SSRS, Windows Server 2007, Oracle 9i, Informatica 9.5.1, MS Excel.

Confidential, Cincinnati, Ohio

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• As a part of Data warehousing team, involved in developing SSIS Packages to perform ETL from source to destination and creating the SSRS reports to help users analyze the business data.
• Experienced in Extracting, Transforming and Loading the Data from Flat Files, Excel to SQL Server by using SSIS.
• Experience in using different transformations such as Lookup, Merge, Conditional Split, Derived Column etc which did data validation checks during Staging, before loading the data into Data warehouse.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like Files, Databases to SQL using SSIS.
• Involved in writing T-SQL code using complex SQL joins.
• Used some Data Conversion tasks in SSIS to load the data from flat file to SQL Server Database.
• Created SSIS packages to export data from SQL Server to Text and Excel files and configured SQL mail agent for sending mails upon package deployment.
• Implemented Event Handlers and Error handling in SSIS packages.
• Tested, Cleansed and Standardized the data meeting the business standards using Lookup/fuzzy lookups using SSIS.
• Experience in performance tuning of queries by creating Indexes, Query Optimization.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through SQL Served Reporting Services (SSRS).
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005/2008.
• Created subscriptions in SSRS to deliver reports to a shared file and also by sending Emails to the business users.
• Designed and developed report templates, bar graphs, charts on the financial data.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008, Visual Studio 2008, SQL Server Integration Services (SSIS), Reporting Services (SSRS), ETL, T-SQL, MS Excel.

Confidential

SQL Data Analyst/ Trainee

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Extensively used T-SQL to write the code for the reports.
• Involved in writing T- SQL queries using complex joins, DDL/DML functions.
• Extract Transform and Load (ETL) source data into respective target tables using SQL Server Integration Services (SSIS).
• Involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Used different SSIS Transformations in creating packages and loading the data from multiple sources to target destinations.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2005.
• Created SQL Server Reports such as Tabular, Matrix, Drill Through, Drill Down reports based on the requirements using SSRS 2005.
• Involved in generating Dashboards, Sub-reports, parameterized reports based on requirements.

Environment: SQL Server Management Studio, Business Intelligence Tools (SSIS/SSRS) 2005, Windows 2000 Server.