Professional Summary

• Extensive 8 years of experience in Database development for both OLTP Batch Processing, Online Processing OLAP Systems SSRS, SSIS, SSAS using MSSQL Server 2005/2008/R2/2012.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard and SSIS,.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed OLAP cubes using SSAS SQL Server Analysis Services .and calculate the metrics that were revealed in the functional analysis.
• Experience in creating datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks can take initiative to handle responsibilities independently as well as a proactive member of a team.

Technical Skills

MS SQL Server Integration Services 2012/R2/2008/2005, SQL, SSIS, C ,VB.net T-SQL, Crystal Reports9.0, Data Modeling, Visual Basic, ASP.Net, Microsoft Visio, Scripting tuning HTML, XHTML, XML, CSS, JavaScript, AJAX, IBM, UNIX scripts, MS SQL Server 2005/2008/2008R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.

Projects Summary

Confidential

MS SQL Server Developer/ SSRS Developer

JP Morgan Investment is a global provider of asset management, investment processing, and investment operations solutions. JP Morgan provides products and services to institutions, private banks, investment advisors, investment managers, and affluent individuals. My primary scope was to modify and create new reporting portfolio on Reporting Service SSRS. We generate different sorts of reports including static, ad-hoc, and drill-down and drill-through.

Responsibilities:

• Created ETL packages using Heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Control Flows, which include tasks and containers that execute when the package runs. Organized tasks in sequences and in loops during creation of package in SSIS.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events On warning, On Pre and Post Execution, On Task Failed etc.
• Developed SSAS Cubes and export them out as pivot tables in Excel for data analysis
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
• Used PowerShell to monitor database information and made modifications.
• Used SharePoint-PerformancePoint Services to create rich dashboards, aggregating content from multiple sources and displaying it in a web browser.
• Implemented perspectives and KPI using calculated measures based on requirements.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.
• Supported ASP.NET team to build a credit card payment system prototype for a private bank.

Environment:

MS SQL Server 2008R2/2012, T-SQL, SSIS, C ,VB.net, SQL Server Integration Services SSIS , SQL Server Data Tools, SQL Server Reporting Services SSRS 2008 , SQL Server Analysis Services SSAS , SharePoint 2013, Business Intelligence Development Studio BIDS , MS Excel.

Confidential

SQL Server/SSIS/SSAS/SSRS Developer

GMac was founded 1939, it is now called National General Insurance., and it's is a subsidiary of Ally Financial. The GMAC Insurance is the 15th largest underwriting company in the United States. The project focused on maintaining, and optimizing the existing databases monitoring database performance and growth, performance tuning, to Create Reports according to the business requirement using SQL Server Reporting Services SSRS and populate data warehouse using SQL Server Analysis Services SSAS .

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008 R2/2012. Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet. Created complicated reports like parameter based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS2008 R2/2012.
• Continuously interacted with users to gather the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published ad-hoc reports through Report Manager.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data Driven Subscription both Email And Windows File Sharing.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes
• Provided database technical support to ASP.NET application developing team to optimize existing Auto Insurance Query System. Troubleshot slow issues and optimized data access in SQL server.
• Involved to build Customer Information Management System with application developing team, provided supports on connection between front end and database data access .
• Designed and Created databases, tables, views, stored procedures and triggers.
• Modified existing database by adding tables and relationships.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables
• Primary keys, foreign keys .
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2008R2/2012.
• Created notifications, alerts to let support team know in case there are any failures.
• Migrated database from SQL server 2008 R2 to SQL Server 2012 using both Copy Database Wizard and Detach Attach method.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points,Logging, TRY and CATCH Blocks.

Environment: MS SQL Server 2008R2/2012, Management Studio SSMS , ETL, ASP.NET, Crystal Reports9.0, Data Modeling, OLAP, Data warehousingSSIS, C ,VB.net T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012, ASP.NET. IBM, UNIX scripts, MS SQL Server 2005/2008/2008R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.

Confidential

MS SQL Developer/ETL Developer

Nationwide Mutual Insurance Company Affiliated Companies is a group of large U.S. insurance and financial services companies based in Columbus. Nationwide is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Nationwide Insurance is a group of large U.S. insurance and financial services companies that offers a variety of insurance products as well as financial services. The goal of this project was to design and construct Enterprise Data warehouse for Nationwide Insurance. The objective was to achieve single point of reference to get the customer data from various databases.

Responsibilities:

• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Optimized Query Performance, Session Performance and Reliability.
• Designed Extract Transform Load ETL process to populate the data warehouse using SSIS
• Loaded Data to the Interface tables from multiple data sources such as MS Access, Oracle, Text files and Excel Spreadsheets using SSIS.
• Applied various data transformations such as SCD Slowly Changing Dimension to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Generated Reports using Expressions and Functions for the reports using SSRS 2008.
• Generated Snapshot, Drill Down, and parameterized reports using SSRS
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 SSAS .
• Enhanced the functionality in database and data warehousing concepts OLAP, OLTP Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008 SSAS .

Environment:

MS SQL Server 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , , C ,VB.net ,SQL Profiler/Analyzer, Management Studio, Import/Export Wizard, Excel,Arc-GIS 10.0, Map Point 2010 .

Confidential

SQL Server/BI Developer

Pepsico is an American multinational food and beverage corporation headquartered in Purchase, New York, United States, with interests in the manufacturing, marketing and distribution of grain-based snack foods, beverages, and other products. The main objective of the project was to build a system by extracting the data and loading into mart Developed business intelligence system to quickly identify customer needs and better target services. With SSIS packages a large amount of customer-related data from diverse sources was consolidated, including customer billing, ordering, shipping .Involved in ELT and Business Intelligence processes. The idea is to build a Decision Support System for executives

Responsibilities:

• Involved in installation and configuration of SQL Server 2005/2008 with latest Service Packs.
• Created and executed SQL Server Integration Service SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting SSRS Reporting Services based on specifications and business needs and modified existing reports as needed.
• Developed ETL's using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Designed, administrated and developed Star Schema Data marts
• Experience in creating multiple reports SSRS in Drill mode using tables, crosses tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.

Environment:

SQL Server 2005/08, SSRS, SSIS, C ,VB.net, SSAS, Oracle 10g, Visual Studio, MsVisio2003/2007, MS Project. IBM, UNIX scripts, MS SQL Server 2005/2008/2008R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.

Confidential

SQL Server Developer

Tyson foods is an American multinational corporation based in Springdale, Arkansas, that operates in the food industry. The company is the world's second largest processor and marketer of chicken, beef, and pork. In this project I worked as a developer and I was actively involved in designing database and developing packages for extraction/loading.

Responsibilities:

• Involved in ER diagrams and mapping the data into database objects.
• Design of the Database and the Tables.
• Build table relationships and wrote Stored Procedure's to clean the existing data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery,
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Involved in Job scheduling and alerts.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Designed and implemented user log in and security.
• Involved in hard Coding and data analysis of Complex Queries, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Involved in requirement gathering, analysis, design, development, change management, deployment and User Training.

Environment: IBM, UNIX scripts, MS SQL Server 2005/2008/2008R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin. SQL Server 2005 Enterprise Edition, .NET Framework-SQL, SQL Server 2005, SSIS 2005, SSRS, C ,VB.net, SSAS, Windows 2003 Advance Server, MS Excel, MS Access, Visual Studio 2005