Sql Server Data

Abhinay

*******@*****.***

201-***-**** Sr. SQL BI Developer

Summary

7+ years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server 2014 /2012/2008R2/2008/2005 and Visual studio 2008/2005.

SQL/SQL BI Developer in various industrial domains such as Finance, Insurance, and Health Care.

Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008R2/2012 with expertise on data normalization.

Conversant with all phases of the Software Development Life Cycle (SDLC) specially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.

Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation.

Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Strong expertise in Data modeling using Erwin 9/8/7.2 with good understanding of Relational Database Management Systems (RDBMS).

Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.

Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).

Involved in configuration of FACETS Subscriber/Member application.

Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.

Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008R2/2012 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.

Widely used VB scripts in the script task in SSIS packages.

Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.

Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.

Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

Experienced in creating Jobs, alerts, SQL Mail Agent, scheduling packages using SSRS.

Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

Extensive experience in database activities like Data Modeling, Database Design & Development, Coding, Implementation, Maintenance and Performance Monitoring & Tuning using tools such as Index Tuning Wizard, SQL Profiler and Replication.

Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

Education

Bachelor’s in CSE, Hyderabad, India

Technical Skill

MS SQL Server 2005/2008/2008R2/2012,2014, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), FACETS, BIDS,Reports11/10/9/8.5,Visual Basic 6.0,Visual Basic.NET, HTML, XML, Oracle 7.x/8i/9i, SharePoint Technologies 2007, MS Visio,SVN,DTS, Import/Export Data, Bulk Insert, BCP, SQL Profiler, SQL Query Analyzer, Enterprise Manager, Management Studio, Replication, SQL Agent, Oracle 10g/11g, SQL Developer, Toad, Unix, Linux, MS Visual Source Safe 6.0/8.0/2005, Visual Basic 6.0, T-SQL,PL/SQL,HTML, CSS, XML, VB.Net,ASP.NET, Erwin,JIRA.

Projects Summary

Emblem Health, New York, NY May’15 – Till Date

Sr. SQL BI Developer

Emblem Health is a health maintenance organization (HMO) and Health Insurance Company based in New York City serving over 3 million members. The scope of the project was to analyze the incoming data which were at different frequencies and various sources .Build SSIS Packages to stage data, cleanse and load them into OLTP and finally into the OLAP Database for analysis and reporting services.

Responsibilities:

Interacted with business users and analysts and gathered and documented the technical and business metadata.

Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.

Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.

Designed database, tables and views structure for the new data mart.

Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into MS SQL Server 20012 using SSIS Packages.

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Developed SSIS tasks to download Encrypted files from remote SFTP server, decrypt and stage data in Staging DB.

Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Configured and maintained of Facets and other application software products, such as Claim check, Facets.

Dealt with 834 import members lookup processes and resolving issues with member attributes, enabling multiple rules associated with member lookup process in FACETS.

Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.

Used VB.Net Script for Data Flow and Error Handling using Script component in SSIS.

Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.

Created Views to reduce database complexities for the end users.

Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

Scheduled Jobs for executing the stored SSIS packages/Master Packages which were developed to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.

Involved in design, code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

Built the dimensions and fact tables with star schema using SQL Server Analysis Services (SSAS)

Implemented SSAS Cubes, Fact and Dimension tables to perform analysis.

Deployed Cubes on Development Server and Production Server.

Creating visualizations and dashboards in Power BI

Develop PowerBI, SSIS packages (ETL) to extract and transform data from various financial sources to DataMart and Schedule SSIS jobs.

Design and develop cubes, reports (SSRS 2014), and dashboards (Using PowerBI) for BI and Analytics

Environment: MS SQL server 2012,2014, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, Powerpivot, Visual Studio, SSMS, PowerBI PowerPoint, MS Project, Unix, Facets, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS Server Analysis Services.

JP Morgan Chase, Jersey City, NY May ‘14 – Apr ‘15

MS SQL Server BI Developer SSIS/SSAS/SSRS

JPMorgan Chase & Co. is a leading global financial services firm operating in more than 60 countries. The firm is a leader in investment banking, financial services and financial transaction processing for consumers, small business and commercial banking. The project was to build the Enterprise Reporting database using Business Intelligence Development Studio, enabling the business manager to track and measure significant indicators of their Relationship Manager’s performance over the time Period.

Responsibilities:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.

Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.

Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Oracle and Text files and Excel files and MS word 2007 files) to SQL Server.

Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.

Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.

Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.

Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.

Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.

Build packages and handled slowly changing dimensions to maintain the historic data.

Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.

Evaluate business performance with key performance indicators (KPI) using SQL Server Analysis Services.

Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time frame.

Deployed reports on Microsoft Office Sharepoint (Moss).

Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS) and created SSRS reports.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, Power pivot, Visual Studio, SSMS, PowerPoint, MS Project, MS Server Integration services (SSIS), MS Server Reporting services (SSRS).

Johnson &Johnson, New Brunswick, NJ Sep’13 – Apr’14

MS SQL BI Developer

Johnson & Johnson is an American multinational medical devices, pharmaceutical and consumer packaged goods manufacturer founded in 1886. Its common stock is a component of the Dow Jones Industrial Average and the company is listed among the Fortune 500. The scope of the project was to develop sales reports and statistics covering weekly, monthly, quarterly and annual historical information for the Sales department database using SSRS and to implement business analysis over the OLAP cubes of the data warehouse with SSAS. The goal was also to add daily feed to the data warehouse using SSIS.

Responsibilities:

Involved in gathering requirements with team lead for efficient Reporting of the database.

Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.

Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Widely used SSIS transformation such as Derived Column, send mail task, fuzzy lookup, fuzzy grouping, data conversion and aggregate.

Developed auto generated system using SQL Server Agent to schedule the packages.

Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.

Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation.

Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services.

Used various SSRS expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions.

Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.

Integrated MS SSRS with SharePoint Foundation 2010/SharePoint Server 2010 by configuring a report server to run in SharePoint integrated mode

Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services.

Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.

Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.

T-Mobile, Parsippany, NJ Dec’12 – Aug’13

MS SQL Server Developer/SSIS/SSAS/SSRS Developer

T-Mobile is one of the leading cell phone providers in the United States today. U.S. Providing America’s largest Mobile to Mobile calling family of more than 99 million subscribers, the company works hard to offer customers with the highest level of satisfaction by offering quality products and services.

The company has huge database including employee, product and customer information. The Project was Database Management System. In that they want to manage their seasonal promotion, sales information, product details.

Responsibilities:

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.

Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.

Installed SQL Server 2008 and Management tools using SQL Server Setup Program.

Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.

Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel, OLEDB and Access to SQL Server.

Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations.

Handled slowly changing dimensions to maintain the history of the data.

Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.

Created User Defined Functions, Triggers, Indexes Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Environment: MS SQL Server 2005/2008, T-SQL, Windows 2000/2003, Crystal Report 8.5, MS SQL Server Integration Services, MS Share Point, MS Excel, HTML

Teva Pharmaceuticals, West Chester, PA July’10 – Nov’11

MS SQL Server/SSIS/SSRS/SSAS Developer

World leader in generic pharmaceuticals, US generics market leader, with approximately 20% market share .The goal of the project was to build and manage the data warehousing of various business departments like Sales, Inventory management, Budgeting, Production and Forecasting.

Responsibilities:

Involved in the logical and physical design of the Data mart using dimensional modeling and designed the SSIS Package for the transfer of data from OLTP to data mart.

Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.

Created SSIS script tasks, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column

Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.

Unit tested all the reports by running queries against the warehouse using SQL

Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.

Designed Usage summary and Detail reports in SSRS and responsible for the deployment of the reports on the reporting services website

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, MS Server Integration services, C#, .NET,

Windows 2000/2003

Life Insurance Corporation, Hyderabad, India Aug’08– May’10

MS SQL Developer

Life Insurance Corporation of India (LIC) is a Government of India enterprise, and is the largest life insurance company and also the largest investor of the country. The corporation is aimed at providing life insurance services and offers attractive savings features along with various insurance policies. The project was to load the data from various sources (branches of LIC) into a single Data warehouse by the help of BCP.

Responsibilities:

Involved in development phase meetings for Business Analysis and Requirements Gathering.

Interacted with business users and analysts and gathered and documented the technical and business metadata.

Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.

Designed database, tables and views structure for the new data mart.

Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.

Created complex Stored Procedures and Functions for integrity checks of transferred data.

Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures

Helped provide end users with the ability to access and utilize the data stored in the data mart.

Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Worked with SSIS packages to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.

Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Environment: MS SQL Server 2005 Enterprise Edition, MS Access 2003, Erwin v4.0, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, Visual Source Safe, MS SQL Profiler.

Contact this candidate