SUMMARY

• Over 7+ years of IT experience in analysis, design and development of data warehousing and SQL Server related applications.
• Experienced in data modeling (Entity - Relationship and Dimensional Model) and logical and physical database design.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio, ER/ Studio Data Architect and ERWIN.
• Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, Data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced in migrating large datasets between two instances of SQL SERVER 2012, and between Oracle and SQL SERVER. Data mapping and ETL were done between OLTP and OLAP.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2012/2008R2/2008/2005
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r 2/2008/2005.
• Experience in Deploying SSIS packages using the Legacy deployment model as well as deploying SSIS packages using the new Deployment model (Project deployment Model) from SQL server 2012 using SSISDB catalog, configuring project parameters and environments.
• Expert in developing Drill through and Drill down reports using MS SQL Server Reporting Services (SSRS)
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Efficient in up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong team player with great verbal, written communication and interpersonal skills.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2/2008/, 0Oracle 11g/10g

T-SQL: MS SQL, SQL*PLUS, DBMS Packages, T-SQL, Oracle database design, table creations, development of Stored Procedures, Functions, Triggers, Complex Packages, Cursors, Materialized views, Indexes, Partitions in TOAD, PL/SQL Developer, SQL*Plus.

BI & Reporting: MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Server Management studio (SSMS).

Languages: SQL, PL/SQL, C, C++, VB, Java, HTML, XML, XSL.

Scripting: Unix Script, Perl Script, VBScript, JavaScript, Dream Weaver CS4, Web Updater II, SSH Tactic.

OS: LINUX, Windows 2000, 2003, XP, 7,8.

Data Modeling Tools: ER/Studio Data Architect 10.0,SQL Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Participated in system analysis and data modeling.
• Interact with Data Modeler, Work Partner and Director to analyze business needs. Provide software product design and develop a technical roadmap for the solution through the project lifecycle and beyond.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints
• Setting up the Staging Environment, Custom Login to capture the execution time, new records, Updated Records, Error Count.
• Setting up Error Tables to handle bad records because of truncation, overflow or primary key constraint errors.
• Develop SSIS packages to pull data from the ERP system to load the data into staging environment using Sequence container, Execute SQL task, Send mail Task, OLEDB source and OLEDB Destination, lookup transformation, Conditional split, Multicast, Row count, Union All, Expression Builder, Script component and Derive Column transformation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1,type 2 and type 6 changes
• Work with DBA’s to deploy SSIS packages into SSISDB database to move the packages into different environments (Dev, Test, and Prod) and setting up the proper accounts to execute the packages from the catalog.
• Created Jobs and scheduled Packages using SQL Server Agent Job for the Daily, Monthly Load.
• Create Scripts for Data Validation in Production after the process has been deployed.
• Involved in performing Unit Test, Regression Test, Functional Test, Integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Testing document.
• Explained and trained the whole design of ETL Process to business users.
• Wrote the whole documentation of packages and applied Naming Standards

Environment: MS SQL Server 2014, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Share point 2010, Team Foundation Server 2013 (TFS), MS Excel, Power Pivot, MS word, Visual Studio 2013, Spot Fire

Confidential

MS Bi Developer - SSIS/ MS SQL developer

Responsibilities:

• Interact with Development Teams and managers to analyze business needs. Provide software product design and develop a technical roadmap for the solution through the project lifecycle and beyond.
• Developed and deployedSSIS packages for ETL fromvarious sourcesto staging and from staging to production usingData Conversion, Derive Column, Script Task, Condition Split, for each loop container, and more. Performed ETL mappings using SSIS and MS SQL Server
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes/key and SSIS Configuration Scripts
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop container to loop over the directory to load inbound files coming daily.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables to check metadata entries in test and prod databases.
• Created SSIS Package configurations for executing in different environments.
• Developed complex T-SQL code such as Stored Procedures, Indexes for the application.
• Enhancing the existing SSIS packages to meet the changes specified by the users.
• Created C# and VB.Net Script for Data Flow using Script component in SSIS.
• Created/Updated database objects like tables, Indexes, and Pk’s to avoid duplicate entries in the table.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Create scripts for SSIS Jobs in test and production to deploy and schedule automated SSIS jobs on off -peak hours.
• Involved in the creation of DLP’s to guide current and future developers for the organization.
• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Preparing the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Create Scripts for Data Validation in Production after the process has been deployed.
• Involved in performing Unit Test, Regression Test, Functional Test, Integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Testing document.

Environment: MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Share point 2010, Visual Source Safe 2005, MS Excel, MS word, Visual Studio 2010, Visual Studio 2012

Confidential

MS BI Developer-SSIS/SSRS/MS SQL Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2012, T-SQL, SSIS 2012, SSRS 2012, TFS 2010, Advanced Server, SSMS, Erwin v7.2, ASP.Net, C#.

Confidential

MS SQL Server/ SSRS/SSIS/BI Developer

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 used (Kimball’s approach)on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Created OLAP cubes and dimensions for the analysis of student’s registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Environment: MS SQL server 2005, MS Server Integration services, SSIS, DTS, SSRS, Profiler and Windows Server 2003.