SUMMARY

• 9 years of IT experience in Design and Development of Data Warehousing projects with involvement in all phases of Software Development Life Cycle as senior Microsoft BI Developer in Banking and Finance industries
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL server database management studio 2005/2008/R2 and SQL Server Data Tools (2012) with strong knowledge on SQL and TSQL concepts.
• Expertise in creating SSAS Tabular Models for multidimensional data analysis and Power views for performance reporting.
• Expertise in Power BI suite like creating Excel Power Pivot Models and Power Pivot Reports with 2012 version of SQL Server Data Tools.
• Expertise in deploying Excel Power Pivot Models and views on SharePoint site and refreshing them using Power Pivot Gallery.
• Expertise in handling various database activities like Data Modeling, Database Design and Development, Maintenance and Performance Monitoring and Tuning using tools such as SQL Profiler.
• Technical expertise in OLTP/OLAP/ODS System Study, Analysis and E - R modeling, developing OLTP database schemas using 3NF, OLAP database schemas using Star Schema and Snow flake Schema (dimensional modeling)
• Expertise in design and development of Operational Data Store (ODS) with implementation of Change Data Capture (CDC) Concept.
• Expertise in Design and Development of ETL mappings for Data Extraction, Transforming and Loading (ETL) using DTS and SSIS (2005, 2008, 2012) packages.
• Expertise in creating job schedules to automate the ETL process using batch files to execute the SSIS packages.
• Expertise in design and development of complex dashboards and reports using SQL Server Reporting Services (SSRS) and Dundas charts with OLAP and SQL Server data sources.
• Expertise in turning the business requirements into Analytical Solution offerings using SQL Server Analysis Services (SSAS).
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Developed and deployed OLAP cubes using SSAS.
• Developed MDX Scripts and created datasets to perform reporting like interactive drill down reports and dashboard reports.
• Implementation of performance dashboards to analyze and measure performance of applications supporting large banking and financial functions
• Expertise in using Team foundation server for version controlling.
• Created test plans, test cases for Unit, System and Integration testing
• Extensive knowledge on Process control and documentation of the artifacts of design and maintenance by TFS systems.
• Performance & Tuning achieved through Utilizing Alert Logs & Trace Files

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/2003

Database: SQL Server 2005/ 2008/ R2/ 2012

Reporting: SSRS, Dundas Charts, PPS 2007

ETL Tools: SSIS

Analysis Services: SSAS, SSAS Tabular Models

PROFESSIONAL EXPERIENCE

Confidential, GA

Sr. SSIS, SSRS Developer

Responsibilities:

• Designed and developed a concrete Operational Data Store (ODS) with implementation of Change Data Capture (CDC).
• Developed Enterprise Data Warehouse using Kimball’s methodologies to extract the data from excel source files and loaded to EDW using SSIS packages.
• Implemented email notification, notifying the support team on the status of the scheduled jobs.
• Dynamic configuration of SSIS packages through XML files and SQL server configurations.
• Deployed the SSIS packages and created job schedules to execute the packages with strategic audit and control mechanism to track data load and alert the users with email notifications.
• Designed and developed SSAS OLAP cube with a rich set of KPIs and aggregations defined to represent the data in strategic dashboards and reports.
• 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 the earned revenue and accounts receivables over a period of times.
• Dynamic report formatting with color coding and on demand hide/show of columns in the reports during runtime.
• Performed various query optimization techniques and improved the execution times of the queries used in the report dataset.
• Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.
• Involved in all phases of the project and provided required support manuals and test cases that helped the smooth execution of the project.

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

Confidential, Springfield, Illinois

Sr. MSBI Developer

Responsibilities:

• Involved in collecting business requirements and Preparing ETL Design Documents.
• Designed and developed a concrete Enterprise Data Warehouse having the 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 the dimensional and fact tables.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with the development team
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need
• Deployed the packages using package configuration and deployment wizard with batch files calling the SSIS packages using SQL Agent jobs.
• Implemented email notification, notifying the support team on the status of the 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 the report manager.
• Created subscriptions and assigned roles, permissions to the users using report manager.
• Supported the project in UAT and production support phases with quick turnaround time in resolving the issues and created user manuals and design documents that help the team for future enhancements.

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

Confidential, Birmingham, Alabama

Sr. MSBI Developer

Responsibilities:

• Involved in interactive discussions with the 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 the 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 the same using SQL Query Analyzer to optimize application and system performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating with the development team
• Assisted the 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 the server for users to access them across the 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 the Report Builder and Report Model.
• Involved in delivering KT sessions to the client.
• Involved in Production Support of the application at client location during the transition period.

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

Confidential, Glastonbury, Connecticut

MSBI Developer

Responsibilities:

• Involved in Requirements gathering and analysis.
• Involved in the 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 the reports using web link and set security levels to various users to access the 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 the whole process.

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

Confidential

Software Engineer

Responsibilities:

• Involved in interactive discussions with the 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 the dirty data using MS SQL Server Integration Services 2005 (SSIS).
• Worked with the 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 the 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
• Have developed queries in ITSM
• Automated reports using SSRS.

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