SUMMARY

• Over 7 years of experience in software development, designing and implementing Stand alone software application with major focus on Data warehouse and Database Technologies.
• Hands on Experience on Microsoft BI skills T - SQL, SSIS, SSRS and SSAS.
• Experience on use and development of MS SQL Server 2000/ 2005/2008/2012 databases Technologies including DTS, SSIS, SSRS, SQL Server Profiler, SQL Server Agents.
• Solid Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing decision Support Systems.
• Strong experience in logical and physical database design and development using Erwin and MS Visio.
• Experience in MS SQL Server Configuration, Performance Tuning, Query Optimization, Creating complex SSIS packages using appropriatecontrol and data flow elementswithSSIS standards likeerror handling, loggingand working withpackage configuration files.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data, Crystal Reports and MS Excel spreadsheets.
• Experience in generating Drill down reports, Drill through reports, Parameterized reports, Tabular reports, Matrix reports, Sub reports, Cascaded parameterized reports and Graphical reports in SSRS 2005/2008R2.
• Experience working across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, unit testing, data validation, systems integration and user acceptance testing.
• Strong analytical and communication skills and ability to effectively communicate with all levels of management and staff.
• Proven knowledge and experience with all aspects of data management, including reporting, data analysis, analytics, and data modeling concepts and techniques.

TECHNICAL SKILLS

RDBMS: DB2, Microsoft Access, Oracle 10g, SQL Server 2012/2008 R2/2005

ETL/Reporting: SSIS, SSRS, SSAS 2005/2008/2012 , Informatica

Operating Systems: Windows 2008/2003/2000/98 , Linux Red Hat 7.x, 8.x

Languages: COBOL, C, C++, Java, Python, T-SQL, XML

Microsoft: Word,Excel,Access,PowerPoint

Web Technologies: ASP.NET, VB.NET, C#.NET, JavaScript, HTML.

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr. MS SQL Server BI Developer

Responsibilities:

• Analyzing and understanding the existing reporting environment.
• Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow for report
• Implementing the new reporting requirements for the business by making use of the new database and schema changes.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse
• Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow.
• Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime.
• Participated in identifying data migration issues and resolved them.
• 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 variables, break point, check point, logging, package configuration and event handler in SSIS packages to meet the business needs.
• Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs.
• Implemented security for the SSAS cubes by creating new roles and modifying existing roles based on the new hierarchies for the cube.
• Built MDX queries for Analysis Services & Reporting Services.
• Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes.
• Created multiple partitions and aggregations for the different measure groups for improving performance of the cubes.
• Resolving the SSAS cube connectivity and data issues as and when needed.
• Interacted with Business Users to help them understand to generate reports/look at the business data with various drill down options with Excel via connecting to SQL Server Analysis Services (SSAS).
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Supported the production environment for any Data or Logic related Issues, Test and Debug the use case scenarios and migrate the code as needed by coordinating with the DBA Team.

Environment: SQL Server 2012,SQL Server 2008 R2, SQL Server Integration Services (SSIS), Reporting Services(SSRS), TFS, PowerShell, Pivot Tables, MS Visual Studio.Net, C#, SQL Profiler, MS Office Suite 2010,Windows 2003/2007 Server OS.

Confidential, RI

Sr. SSIS ETL Developer

Responsibilities:

• Design and maintain MS SQL SSIS Packages, T-SQL Stored Procedures, scripts and code for high performance.
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2008.
• Defined parameters, variables and run time parameters within the SSIS package Execute SQL task and executed stored procedures within the packages by passing parameters and loaded the data into the tables.
• Interact with the implementation MS SQL Server T-SQL scripts for ETL to enhance delivery of existing and future reporting solutions.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.
• Extensively used Package Configurations while deploying the SSIS packages from DEV - Stage, Stage - Prod environments.
• Developed ETL programs using Informatica to implement the business requirements.
• Analyzed the Informatica mappings for Source to Target for Data Analysis.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Identified the Data Source and defining them to build the Data Source Views.
• Created report Model onSSASCubes as well as changing default configuration on existing Cubes.
• Designed, coded and implemented ad hoc reports in SSRS.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Heavily worked on SSRS report performance, stored procedure tuning, table partitions.
• Performing intensive data analysis on large data volumes, testing for quality assurance, and migrating releases into stage and production environments.
• Supported the End User community for any Issues or Clarifications.

Environment: MS SQL Server 2008 R2, TFS, SharePoint 2010, T-SQL, SSIS, SSRS, Excel, Visual Studio 2008/2010, Informatica 8.1.1 Power Center, Windows Server 2008.

Confidential, Los Angeles, CA

SQL BI Developer

Responsibilities:

• Analyzing the transactional data in DB2 and other source systems using Data Profiler.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
• Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per the business requirements to improve the productivity of the claims processing system.
• Connected to the FTP Server and pull the group of Excel sheets into the SSIS from thefolder located on FTP Server.
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent.
• Coordinating the production deployment activities.
• Responsible for Performance Tuning of SQL commands and trouble shooting of Technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor.
• Documented all kinds of Reports and SSIS ETL Packages.
• Testing the new SSRS reports developed based on different filters and validating the outcome with the database.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users.
• Ensure all code and versions are properly maintained in TFS while migration is in progress.

Environment: MS SQL Server 2008 R2, TFS, T-SQL, SSIS, SSRS, Excel, Visual Studio 2008/2010, Windows Server 2008

Confidential

MS SQL Developer

Responsibilities:

• Involved in Creation of tables, indexes, sequences, constraints, triggers and stored procedures.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Created indexes for the quick retrieval of the data from the database.
• Created SSIS packages for data importing, cleansing and parsing of normalized data.
• Created SSIS Packages using fuzzy lookup, derived columns, conditional split, term extraction, aggregate, execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text File, MS Access and CSV files.
• Deployed the packages on staging and production.
• Monitored jobs and supported production environment.
• Reduced the T-SQL overhead and responsible for developing processes, automation of maintenance jobs, tuning SQL Server and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Created drill down reports, Parameterized reports using SQL Server 2005 Reporting Services and deployed the generated reports on to the server.
• Replication of data using Transactional method.

Environment: Microsoft SQL Server 2008/2005, T-SQL, SQL Integration Service (SSIS), SQL Reporting Services (SSRS), SQL Profiler, Query Analyzer, MSIIS 7.0, MS Office.