Summary

• Over 8+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2014/2012/2008R2/2008/2005 in a high transaction and multi - server production environment with excellent knowledge of Software Development Life Cycle (SDLC), RDBMS, Data Warehouse & Data Modeling concepts.
• Strong experience in creating T-SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Handled huge financial data, expert level query optimization and performance tuning experience.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Strong Experience in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Strong SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Experience in Guidewire Billing Center web-based billing system to test different test case scenarios

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008r2/2008//2005
• MS Access 2010/2007/2003
• Oracle
• SSIS
• SSAS
• SSRS
• INORMATICA 9.1 Power Centre(ETL)
• Tableau
• Crystal Report
• TFS
• T-SQL
• PL SQL
• Guidewire
• DOS
• Erwin
• DTS
• Windows Server 2003/2005/2008
• C#
• .NET
• Sharp
• HTML
• ISS
• and XML
• XSLT
• MS Office
• Visual Source Safe

PROFESSIONAL EXPERIENCE

ETL/SSRS Developer

Confidential

Roles & Responsibilities:

• Responsible for converting business requirement into functional and technical document.
• Rewrite the existing code, queries, stored procedures for long running queries by replacing cursors with various joins, common table expression (CTE), indexing and applied MS best practices for query tuning
• Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling in the packages.
• Coding, testing, performance tuning in developing Informatica mappings and workflows.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers
• Worked with end users to analyze data flow process and understand requirement for the finance reporting
• Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report using Database Performance monitoring tools
• Created monthly and quarterly sales reports in tabular and matrix form using SSRS, maintained and enhanced the existing data warehouse reports
• Combined Dundas chart control with .NET Grid view control and bind both of those controls to a common data source.
• Enhanced and developed UI functionality using .NET and HTML.
• Interacted with testing team to fix the defects raised during the testing period.
• Responsible for creating data mapping and data dictionary and ETL documentation.

Environment: SQL Server 2008 R2, SSMS, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, .NET Frame work, TFS, XML, Informatica 9.5, DB2, SQL, UNIX Scripting, Excel, T-SQL, SSIS, SSRS.

ETL/SSRS Developer

Confidential

Responsibilities:

• Participated in brain storming technical solution with the team
• Participated in validation and review data model- Designing (Technical Design) ETL interfaces.
• Designed and maintained data warehousing artifacts and data dictionary and mapping design.
• Created Complex Stored Procedures, Triggers, Functions (UDF), Indexes, Views, Scripts and other T-SQL code for the SQL applications following SQL code standards
• Carried out mapping and created the database for the reporting team.
• Wrote various complex SQL queries for data profiling for data validation and data quality critical for data warehouse.
• Optimized SQL queries, and long running Stored Procedures for improved performance and availability, and for effective data retrieval.
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
• Responsible for implementing error handling in ETL using C# in script component/Task.
• Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
• Responsible for Coding, testing, performance tuning in developing Informatica mappings and workflows.
• Created SSIS package using for each loop, sequence container to load multiple files from same source folder on different FTP location and to perform group task
• Wrote VB .NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Build & implement drill through drill down, parameterized and real time BI reports using SSRS.
• Using C#, .NET in the process of reporting.
• Responsible for Deployment of the report using SSRS and used Report subscription (Email) to publish reports

Environment: SQL Server 2012/2008, Windows Server, Enterprise Manager, SSMS, SQL Server Business Intelligence Studio, SQL Server Profiler, .NET, C#, Sharp, TFS, Excel, T-SQL, SSIS, SSRS, Informatica power center.

BI DEVELOPER - MS SQL Server /SSIS/SSRS Developer

Confidential, Charlotte, NC

Responsibilities:

• Worked with application developers and production team across functional units to identify business needs and discuss solution option.
• Successfully installed and configured MS SQL Server 2008r 2 on the production server.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Generated Assessment Report to Analyze the Scope and Complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2008r2 objects like Tables, Views and Stored Procedure.
• Designed a new schema for the Data Warehouse using Dimensional Modeling and developed it using the Erwin tool.
• Migrated entire schema as well as Data into MS SQL Server 2008r2 and validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load the data from OLTP system to Data Mart for analyzing the data.
• Performed transformation conditional split, sorting and included data about the environment using Audit Transformation.
• Developed and optimized database structure, Stored Procedure, Indexes, Trigger, Cursor and user defined Functions.
• Perform weekly database checkup, shrink database according to instructions, and documents weekly database activities.
• Experienced in generating reports and deploying it in to the server using SSRS (SQL Server Reporting Services).
• Developed and rendered monthly, weekly and daily reports and per requirement and gave roles, user access with respect to security report manager.
• Created simple query filters, prompted filters and simple filters to restrict data in reports.
• Documented the developed work and production release for future reference.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster recovery.

Environment: MS SQL Server 2008r2, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, DTS, Data Analyzer, SQL Profiler, Windows XP, Erwin 4.2, VSS, Visual Studio 2008, MS Access and Excel

BI Developer

Confidential

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Extensively used ETL/Informatica power center for loading the data from various sources involving flat files and oracle tables to Data warehouse.
• Strong Data Warehousing ETL experience of using Informatica 8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Extensively used ETL transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Wrote T-SQL queries, Store Procedures and used them to build packages
• Created/Updated database objects like tables, views, stored procedures, function, packages
• Handled slowly changing dimensions to maintain the history of the data
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Created reports to retrieve data using Stored Procedures that accept parameters
• Supported production operation activities, with focus on integration and development of new and existing products and services

Environment: MS SQL Server 2008, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), DTS, DB2, Visual Studio, SQL, UNIX Scripting, MS Access and Excel.

BI Developer

Confidential

Responsibilities:

• Responsible for requirement gathering and converting business requirement into functional and technical document.
• Involved in preparation of High Level Design Document (HLD), Low Level Design Documents (LLD).
• Extensively used ETL/Informatica for loading the data from various sources involving flat files and oracle tables to Data warehouse.
• Developed and deployed ETL packages to load data from various sources to staging and staging to Data warehouse.
• Worked with various ETL/Informatica transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Wrote T-SQL queries, Store Procedures and used them to build packages
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Developed and maintained ETL and data mapping documentation.
• Environment: Java, JSP, Servlets, Spring AOP, Spring IOC, Spring ORM, Spring MVC, Hibernate, DAO, DTO, XML, JDBC, Transactions, JavaScript, JQuery, JSON, Apache Tomcat, WebLogic Application Server, SOAP, WSDL, JMS, Eclipse, Oracle, CVS, JUnit, log4j

Environment: MS SQL Server 2005, ETL Informatica, Erwin, Windows 2000 Server, MS Office 2000 and Excel.