SUMMARY

• 7+ years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server /2008 R2/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, MDM, Data Profiling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/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).
• Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onFACETSbusiness rules.
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R2/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.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2/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
• MSBI
• 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.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. SQL BI Developer

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.
• As part of this Developer,SQLServer SSIS,SSRSand MDS are used to implement all loading, data quality and data quality reporting and scorecard requirements plusMDMworkflows.
• 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.
• Designed aSQLServer Enterprise Meta data crawler, client,data profiling, cross database and object analyzer andmaster data managementsystem integrated with.Net.
• 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.
• 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.
• SQLServerMDM, In-Memory, Indexed Views, SMO API Data Management Services, Dynamic DDL, DML, Open Data Framework (OData) WCF Data Services for ESB Integration Services.
• Involved in design, code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Some of the data transformation and standardization rules were achieved by effective utilization ofmaster data management(MDM) systems.
• 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.

Confidential, Dallas, TX

MS SQL Server BI Developer SSIS/SSAS/SSRS

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.
• Dealt with834importmembers lookup processes and resolving issues with member attributes, enabling multiple rules associated with member lookup process inFACETS.
• 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).

Confidential, New Brunswick, NJ

MS SQL BI Developer

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.
• Involved in configuration of FACETSSubscriber/Memberapplication.
• 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.

Confidential, Parsippany, NJ

MS SQL Server Developer/SSIS/SSAS/SSRS Developer

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

Confidential, West Chester, PA

MS SQL Server/SSIS/SSRS/SSAS Developer RDBMS

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#, .NETWindows 2000/2003

Confidential

MS SQL Developer

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.