SUMMARY

• 9 years of work experience in business analysis, reporting and software support
• Hands on experience in MS SQL Server 2005/ 2008/2012/2014 Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS).
• Proficient in Creating, Configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Maintaining teh Log and Audit information in Sql tables, Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Sorting teh data, defining data source and subtotals for teh respective reports using SSRS 2008R2/2008.
• Hands on experience in scheduling and deploying reports on report manger.
• Good Knowledge in creating OLAP cubes defining teh dimensions and relationship between dimensions and measure groups.
• Having noledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Strong investigative and troubleshooting skills.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/2008/2012/14

Reporting Tool: SQL Server Reporting Services 2005/ 2008/2012/2014 (SSRS)

ETL Tool: SQL Server Integration Services 2005/ 2008/2012/2014 (SSIS)

OLAP Tool: SQL Server Analysis Services 2008/2012/2014 (SSAS) with MDX

PROFFESSIONAL EXPIERIENCE

Confidential, GA

Sr. SSIS, SSRS Developer

Responsibilities:

• Involved in collecting business requirements and Preparing ETL Design Documents.
• Developed Enterprise Data Warehouse using Kimball’s methodologies to extract teh data from excel source files and loaded to EDW using SSIS packages.
• Implemented email notification, notifying teh support team on teh status of teh scheduled jobs.
• Dynamic configuration of SSIS packages through XML files and SQL server configurations.
• Deployed teh SSIS packages and created job schedules to execute teh packages with strategic audit and control mechanism to track data load and alert teh users with email notifications.
• Developed critical SSRS reports using T - SQL stored procedures and complex SQL queries with custom coding for dynamic parameter change and formatting.
• Developed various trend reports using matrix reports and cascading prompts with charts and graphs to analyze teh earned revenue and accounts receivables over a period of times.
• Dynamic report formatting with color coding and on demand hide/show of columns in teh reports during runtime.
• Performed various query optimization techniques and improved teh execution times of teh queries used in teh report dataset.
• Deployed and shared teh reports with rules and permissions defined on teh report manager for data driven subscriptions.
• Involved in all phases of teh project and provided required support manuals and test cases that helped teh smooth execution of teh project.

Environment: Microsoft BI Suite (SSIS, SSRS, SSAS, SQL Server) 2012, SharePoint Portal.

Confidential, IL

Sr. MSBI Developer

Responsibilities:

• Involved in collecting business requirements and Preparing ETL Design Documents.
• Designed and developed a concrete Enterprise Data Warehouse having teh data extracted from excel source files, SQL tables and loaded to EDW using SSIS packages.
• Developed complex SSIS packages using transformations and tasks like File System task, script task, For Each Loop Container, Multicast, Merge, Lookup and Slowly Changing transformations to load teh dimensional and fact tables.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with teh development team
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per teh business need
• Deployed teh packages using package configuration and deployment wizard with batch files calling teh SSIS packages using SQL Agent jobs.
• Implemented email notification, notifying teh support team on teh status of teh scheduled jobs.
• Developed complex SSRS reports like Drill through, Drill down, Parameterized, sub reports to represent their data in meaningful information.
• Created report model to help users create Ad hoc reports using report builder.
• Created custom stored procedure to generate complex canned reports and deployed them on teh report manager.
• Created subscriptions and assigned roles, permissions to teh users using report manager.
• Supported teh project in UAT and production support phases with quick turnaround time in resolving teh issues and created user manuals and design documents that help teh team for future enhancements.

Environment: Microsoft BI Suite (SSIS, SSRS, SQL Server) 2008

Confidential, AL

Sr. MSBI Developer

Responsibilities:

• Involved in interactive discussions with teh business users to collect requirements.
• Designed and implemented relational models and data marts to build a concrete repository for various applications.
• Designed and developed a concrete Enterprise Data Warehouse using Kimball’s methodologies and designed teh data models to handle data from different subject areas.
• Responsible for database backups, database replication, encryption and database security
• Maintaining high security to patient records by creating and managing new security accounts and restricting user activity on it.
• Involved in trouble shooting and tuning of databases for its performance and concurrency using Database Tuning Advisor.
• Export/ Import data from other data sources like flat files using Import/Export of Data Transformation Services (DTS)
• Analyzing performance related queries and tune teh same using SQL Query Analyzer to optimize application and system performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per teh business need.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with teh development team
• Assisted teh development team in writing complex SQL scripts and SQL Joins
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Involved in index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created dynamic SQLs to create reports and deployed them on teh server for users to access them across teh globe.
• Designed and developed complex canned reports using SQL Reporting Services.
• Implemented Drill through to reports by passing Multiple Parameters from one report to another and designed various prompts and cascading options to reports.
• Created ad hoc reports using teh Report Builder and Report Model.
• Involved in delivering KT sessions to teh client.
• Involved in Production Support of teh application at client location during teh transition period.

Environment: MS BI (SSIS, SSRS, SSAS, SQL Server) 2008

Confidential, CT

MSBI Developer

Responsibilities:

• Involved in Requirements gathering and analysis.
• Involved in teh design, development and testing phases.
• Development of mapping specifications using SSIS.
• Designed and developed complex canned reports using SQL Reporting Services.
• Implemented Drill through to reports by passing Multiple Parameters from one report to other.
• Designed various prompts and cascading options to reports.
• Involved in deploying teh reports using web link and set security levels to various users to access teh reports.
• Designed and developed filters, look up transformation rules (business rules) to generate data using SSIS.
• Designed and Developed processes to fetch data from different databases placed across different servers using variables.
• Designed and developed jobs using SQL Server Agent for Scheduling of packages and Creation of jobs sequences for automation.
• Sending mail after successful completion of teh whole process.

Environment: MS BI (SSIS, SSRS, SSAS, SQL Server) 2005

Confidential

Software Engineer

Responsibilities:

• Involved in interactive discussions with teh business users to collect requirements.
• Created ETL/SSIS packages to extract data from various sources like SQL Server database, Excel, Flat files to OLAP systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Performed data cleansing by creating tables to eliminate teh dirty data using MS SQL Server Integration Services 2005 (SSIS).
• Worked with teh software development team to design, develop and deploy reports that improve access to financial and operational data using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SQL Server Reporting Services 2005 (SSRS).
• Worked with advanced data regions like Tablix, Matrix, Gauges, Charts, Rectangle, and Textboxes in MS SQL Server Reporting Services (SSRS) 2005.
• Developed Dashboards using PPS 2007 and integrated Scorecards and Reports to teh dashboards.

Environment: MS BI (SSIS, SSRS, SSAS, SQL Server) 2005

Confidential

MSBI Developer

Responsibilities:

• Preparation of ETL Design Documents.
• Creation of SSIS packages to implement ETL process to load fact and Dimensions Tables.
• Reporting and regression of bugs.
• Providing report level securities for end used.
• Resolving Tickets with in SLA
• Sending mails to IM’s regarding SLA SR’s status.
• Played IC responsibilities
• Has developed queries in ITSM
• Automated reports using SSRS.

Environment: MS BI (SSIS, SSRS, SSAS, SQL Server) 2005