More than 7 years experience and expertise in SQL Development, Data Warehousing, and Reporting and Business Intelligence solutions using SQL Server 2014,2012/2008R2/2008. Excellent Experience working with T-SQL and building OLTP/OLAP databases through conceptual Entity Relationship Diagrams and Erwin. Experience in Microsoft SQL Server BI Studio, SSIS and SSRS.
Experience in working Scrum/Agile Methodologies for gathering requirement and analysis using different meetings.
Experienced in Enterprise Data Modeling (Dimensional & Relational) with a solid understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, and fact and dimension tables modeling of data. Created data models for relational schema (OLTP) and dimensional schema (OLAP) with proper normalization and De-normalization techniques.
Involved in relational & dimensional data modeling and Forward/Reverse Engineered Data Models to SQL Server using Erwin.
Microsoft SQL Server 2014, 2012, 2008R2, 2008, Oracle 9i, 10g, 11g
DATABASE TOOLS: Management Studio, SQL Profiler
DATABASE LANGUAGES: SQL, T-SQL, Oracle DB Forge Studio
BUSINESS INTELLIGENCE: SharePoint, TFS, Power Pivot, Tableau, Visual Studo, BIML
DATABASE MODELING:Erwin, Visio
SQL / ETL Developer09/2015 to 08/2016Piedmont Natural GasCharlotte, North Carolina
Highly Proficient in T-SQL programming and vast experience in creating complex stored procedures, triggers, views and user defined functions on SQL 2012/2008 R2/2008 servers to meet the requirement of the applications.
Performed Partitioning and Index Tuning by taking into consideration Internal and External Fragmentation levels according to the Microsoft's best practices.
Understanding of SQL, PL/SQL and Relational Database queries in ORACLE.
Advanced SQL and PL/SQL programming Automated the administrative tasks using SQL Server Agent, event notifications, and scheduled maintenance plans according to Microsoft best practices.
Supported the migration of data from Heterogeneous Sources and different formats to relational data warehouses, staging databases using complex Stored Procedures, SSIS packages as well as command prompt scripts.
Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Restricted data for particular users using Row level security and User filters.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Provided 24/7-production support for Tableau users.
Expertise in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert and BCP for Enterprise Data Warehouse.
EDW) Skilled in creating SSIS packages providing specific functionality like Data Profiling and Data Cleansing for a clean ETL process and populating Data Warehouse and Data-Marts.
Well versed in configuring Master-Child packages for Dynamic execution using proper SSIS Package Configurations.
Designed Reports using SQL Server Reporting Services (SSRS).
Included graphical structures using charts, tables, matrices, parameters and conditional formatting.
Created Parameterized Reports, Sub Reports, Drill Through, Drill down Reports in SSRS and Ad-hoc Reports using Report Builder.
Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
Utilized Report Manager to secure the reports with windows user groups and roles for individual reports and also reports folders.
Administered Report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.
SQL/BI Developer07/2014 to 08/2015Elliot Hospital Elliot Health System EHSManchester, New Hampshire
The cornerstone of EHS is Elliot Hospital, 296-bed acute care facility located in Manchester (New Hampshire's largest city).
Established in 1890, Elliot Hospital offers Southern New Hampshire communities caring, compassionate and professional patient service.
Responsibilities: Worked with the Business users and Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
Designed the 'Dimensional Model' of the Datamart and used Erwin 9.0 to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
Created complex stored procedures to perform Index maintenance, data profiling, critical staging procedures for loading data marts and reporting database.
Optimized and restructured the Approval Workflow Stored Procedure for the application by evaluating Execution Plans, indexing and Partitioning large tables.
Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
Enhanced the functionality and performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage SQL Profiler and DTA.
Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Flat Files, Excel Files and dumped it into a centralized Data mart.
Deployed various types of SSIS Transforms in packages including slowly changing dimension, aggregate, fuzzy lookup, conditional split, row count, derived column etc.
and handled erroneous output using event handlers.
Developed master child package technique to manage big ETL projects efficiently.
Made use of Event Handlers, Loggings, Breakpoints and Data Viewers for effective debugging of packages.
Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.
Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
Successfully performed and documented unit testing and system testing of the entire ETL Process.
Created Drill Down, Drill Through, Sub and Linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
Managed very large reports that return a huge volume of records and optimized their performance using techniques like cascading parameters and filters.
Designed dash boards and score cards using Power Pivot for better analysis of business.
Implemented security to restrict the access to users and to allow them to use only certain reports.
Effectively handled data errors during the modification of existing reports and creation of new reports.
Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports.
Improved the performance of reports by optimizing data sets, making use of report caching and snapshots along with taking into consideration networking aspects.
Tools and Technology: SQL Server 2012/2008 R2, SSIS, SSAS, SSRS, Erwin 9.0, Share Point 2010, Tableau Server.
ETL/BI Developer12/2013 to 06/2014American International Group American International Group, IncWilton, Connecticut
also known as AIG - is an American multinational insurance corporation with more than 88 million customers in 130 countries.
AIG companies employ over 64,000 people in 90 countries.
The company operates through three core businesses: AIG Property Casualty, AIG Life and Retirement and United Guaranty Corporation(UGC).
AIG Property Casualty provides insurance products for commercial, institutional and individual customers.
Responsibilities: Functioned as an ETL designer and SSIS package developer for the new project.
Involved in the design of data marts using star schema and Kimball Methodology.
Created T-SQL scripts and complex stored procedures for data validation and data process tables.
Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes.
Worked with the Senior Architect and DBA to develop Data validation procedures and implement logic the required Business rules.
Developed ETL Packages included the use and implementation of stored procedures, data conversions, error logging, dynamic variable expressions, sequence containers, conditional precedent constraints, and conditional data flow and email notification.
Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and excel.
Implemented various types of SSIS Transformations in Packages including Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
Written procedures to implement Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
Responsible for the management and migration of SSIS packages in the staging and pre-production environments.
Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
Designed different types of reports Managed Reports such as Drill Down, drill through, sub and linked reports using the SSRS.
Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded reports in SSRS by linking aggregate data to support summarized view as well as detailed view.
Used different layout such as Matrix, tabular, chart, Tablix to display data in a grid format, with layout possibilities ranging from simple tables to advanced matrices.
Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
Used Report Manager for setting up roles and security on the reports.
Tools and Technology: SQL Server 2008 R2, SSIS, SSAS, SSRS, T-SQL, BIDS, Erwin 9.0, Windows Server, Tableau Server.
SQL/SSIS Developer05/2012 to 09/2013Deutsche BankCary, North Carolina
Backed by a global network spanning over 70 countries, Deutsche Bank is a leading provider of financial services to agencies, corporations, governments, private individuals and institutions in the Americas.
Having first established a presence in the Americas in the 19th century, the Bank began independent operations in the U.S.
in 1978, opening its first North American branch in New York City.
Responsibilities: Responsible for collaborating with the end users and SMEs to gather Functional Requirements.
Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
Involve in documenting all the changes that take place throughout the development of the database and create a repository for further analysis and future reference.
Created complex stored procedures and functions to support efficient data storage and manipulation.
Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
Created cover indexes and applied various work around methods to help improve processing time of ETL.
Involved in designing and developing efficient ETL strategy to integrate existing and new data into newly created Data Warehouse.
Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from various heterogeneous sources such as SQL Server, Oracle, Excel, CSV etc.
on to SQL server 2008R2.
Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
Created new SSIS packages and modified existing SSIS packages implementing auditing and error handling.
Responsible for monitoring all the packages which ran, were scheduled, completed or failed.
Created Package Configurations to test packages on different servers.
Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
Involved in periodic presentation of requirements for review with stakeholders Employed SQL Profiler and Database Engine Tuning Advisor (DTA) to analyze the performance effects of workloads and implemented its recommendations wherever appropriate.
Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
Installed, Configured and managed Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS.
Tools and Technology: SQL Server 2008R2/08, SSIS, SSRS, Visual Studio, SQL, Oracle, Excel, Windows Server.
SQL/SSIS Developer01/2011 to 04/2012JP Morgan Chase & CoNew York City, New York
The lines of business include the Investment Bank, the Global Corporate Bank, Private Equity, Asset Management, Treasury Services and Investor Services.
Morgan offers clients an integrated range of services that combine specialist local knowledge with leadership positions across these lines of business.
Responsibilities: Involved in Database designing (physical and logical) to meet new product requirement using ERWIN.
Created data-related documentation like file descriptions and definitions, entity relationships and attributes.
Designed new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment.
Created Stored Procedures for Reporting on Audit Information and Error Information during each ETL Process.
Handling Query Optimization and Performance Tuning using SQL profiler and Database Tuning Advisor (DTA).
Completely involved in creation of Data Mart from scratch by taking into various business process by identifying different dimensions and facts from existing Data Warehouse.
Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.
Promoted database objects from test/development to production servers by coordinating and communicating with production schedules within development team.
Created different types of reports like drill down reports, drill through reports, sub-reports, and parameterized reports.
Designed reports to include charts and logos that complies with the organizations culture and polices of reporting and documentation.
Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.
Tools and Technology: Microsoft SQL Server 2008/R2, Widows Server, BIDS, SSIS, SSAS, SSRS, Erwin, T-SQL.
SQL Developer02/2009 to 11/2010Omnicare Health ServicesNew Hampshire
Omnicare is a Fortune 500 company based in Cincinnati, Ohio.
Omnicare functions primarily as a provider of pharmaceuticals, related consulting and data management services.
As of December 31, 2009 the company provided its pharmacy services to skilled nursing, assisted living, and other healthcare facilities comprising approximately 1.4 million beds in 47 U.S.
states, the District of Columbia and Canada.
Responsibilities: Gathered system requirements through end-user collaboration.
Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2005 for faster execution and developed database structures.
Developed and created various backup and recovery plans depending upon OLTP load, server down time, percentage of data loss and budget issues and automated all the things using SQL Server Agent.
Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server.
Implemented the developed database into SQL Server 2005 using T-SQL.
Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
Imported data from MS Access, MS Excel and Text Files to SQL server using SSIS.
Provided back-end support for functional testing and performance testing Drafted all system documentation along with user manual, flowcharts, and source code.
Data Migration with MS Access, Excel and Text files and scheduling tasks using SSIS.
Tools and Technology: SQL Server 2005/2008, SSIS, SSAS, SSRS, BIDS, Erwin, Windows Server.
Polaris Software Lab LtdMumbai, India
Polaris Software Lab LtdMumbai, India
Polaris Software Lab LtdMumbai, India
Masters Of Science: Computer ScienceComputer Science
acute care, administrative, Ad, Architect, Asset Management, assisted living, auditing, backup, budget, business analysis, Business Intelligence, business process, charts, consulting, encryption, clients, data management, Data Migration, Data validation, data warehouse, data warehouses, DATABASES, DBA, DATABASE, DATABASE MODELING, debugging, delivery, designing, Dimensions, documentation, email, Equity, Erwin 9.0, ERWIN, ETL, executive management, features, financial, Functional, Hub, DB2, indexing, insurance, layout, leadership, logging, logic, logos, access, MS Access, MS Excel, Excel, SharePoint, Share Point, windows, migration, Natural Gas, Enterprise, network, networking, nursing, Optimization, Oracle 9, ORACLE, Oracle DB, developer, PL/SQL, PDF, PeopleSoft, People Soft, programming, project coordination, quality, Relational Database, reporting, requirement, requirements gathering, scheduling, servers, scripts, Microsoft SQL Server, SQL, SQL Server, strategy, system documentation, Tableau, tables, T-SQL, Treasury, type, Type 1, Type 2, view, Visio, Visual Studio, Windows Server, Workflow, Written