SUMMARY

• 10 years of professional IT experience with domain noledge in domain experience in Healthcare, Finance, Insurance, Telecommunication, Retail, Media and E - Ticketing
• Extensive experience in MSBI with SSIS, SSRS and SSAS. Creating SSIS packages, design and supporting reports, dashboards, drill through reports; and MOLAP and HOLAP Cubes
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good experience on SQL Server Analysis Services (SSAS). Hands on experience in Creating Star Schema and Snow Flake Schemas
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS using Expressions
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Extensive experience in writing and supporting developers with stored procedures, SQL queries, UDFs, triggers and etc.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2008/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Excellent noledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Great ability to create and manage various database objects like tables, views.
• Extensive experience in EDW, Database Administration, MSBI and Analytics, Application design and development; and ETL design, implementation plan and test strategies
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Extensive experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery, Running DBCC Commands and Database Mail Configuration
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing with presentations and a good team player.

TECHNICAL SKILLS

DW/ETL Tools: MS SQL Server Integration Services (SSIS)

OLAP Tools: MS SQL Server Reporting Services (SSRS), Analysis Services (SSAS)

Databases/DBA: MS SQL Server 2000, 2005, 2008 R2, 2012, 2014, MS Access & Oracle 9i

Web Application Development: .Net Framework 4, ASP.Net, Workflows, WCF Web Services

Operating Systems: All version of Windows OS

Other Tools/Utilities: Varicent (ICM tool), Infragistics, System Centre Configuration Management.

Programming languages: C#, Visual Basic, HTML5, CSS3, JavaScript, Power shell, TSQL

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Technical Lead

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Experience in creating Parameterized reports and Linked reports with thorough noledge of report serving architecture. (Table, chart and matrix report).
• Generated several drill down and drill through reports using SSRS.

Confidential, Denver, CO

BI Architect

Responsibilities:

• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough noledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports using SSRS.

Confidential

Senior MSBI Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working noledge of ODBC.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Confidential

Team Lead

Responsibilities:

• Developed, deployed and monitored SSIS Packages using various transformation tasks
• Unit Testing the SSIS packages with respect to its flow and performance issues
• Monitored and modified Performance using execution plans and Index tuning
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services

Confidential

Production Support Systems

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough noledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)

Confidential

Senior Developer Technical

Responsibilities:

• Participated in initial noledge transfer activities of the application
• Involved in acquiring the requirements from the customer and consolidating them
• Involved in the upgrading Technical documents of the application
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users
• Developed SSIS packages and SSRS Reports to pull the data from existing database tables to load the display required datasets, parameters for decision making

Confidential

Senior Developer

Responsibilities:

• Participated in initial noledge transfer activities of the application
• Involved in acquiring the requirements from the customer and consolidating them
• Involved in the Technical design of the application
• Write Queries to pull the data from the Existing tables and update the data
• Developed SSIS packages to pull the data from the upstream tables and load the data to the downstream database