SUMMARY

• Over 8 years of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2014/2012/2008/2005.
• Proficient in business process modeling, documentation, and testing using MS
• In - depth knowledge in creating use cases, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and QA teams in understanding the requirements.
• Experience in ETL development and deployment of DTS, SSIS packages from MS access, Excel, Oracle.
• Extensive Experience and in-depth working knowledge in various SQL Server tools and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, Data base Engine tuning Advisor, Query Analyzer.
• Extensive experience in all aspects such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects.
• Active participation in Software Development Life Cycle (SDLC) specially waterfall and agile methodology.
• Experience with database migration from SQL server 2005 to SQL Server 2008 / SQL server 2008 to SQL server 2012 / SQL server 2012 to SQL server 2014.
• Experience with full life cycle from large data set migration to data warehouse loading production, data analysis, cleaning, scrubbing, manipulation, data extraction for reporting, and data management.
• Solid understanding of RDBMS database concepts including Normalization and solid experience in creating database objects such as tables, views, stored procedures, triggers, cursors, functions, indexes and other T-SQL (DDL, DML) statements for various applications.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Experience in developing different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports, linked reports, sub reports and creating stylish report layouts in SQL Server Reporting Services (SSRS).
• Hands on experience in Master Data Management (using Microsoft’s MDS)
• Solid experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS, BCP and Bulk Insert between different homogeneous/heterogeneous systems.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012, MS Access

ETL Tools: SQL Server Integration Services (SSIS)

Analysis Services: SQL Server Analysis Services (SSAS)

Reporting Services: SQL Server Reporting Services (SSRS)

SQL Languages: T-SQL, pL/SQL

UI Coding: VB, VBA

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

MS SSIS/SSRS/ SQL Server Developer

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Experience in strategy development process for data cleansing and data migration, creation of source to target mappings, data profiling and data validation jobs using DataStage, and also involved in the creation of ETL jobs in DataStage.
• Developed processes and procedures for governing data movement, data integrity, metadata and various other components of data management.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indexes and functions for databases.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Experience with database migration from SAP to SQL server 2014. Experience in the automation process of data extraction from SAP source system to SQL server 2014
• Developed complex stored procedures and functions on SQL SERVER 2014.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports using SQL Server Reporting Services (SSRS).
• Developing a MDM solution for domains, building the models in Microsoft Data Services (MDS) and creating the SSIS packages to pull data from numerous sources into MDS.
• Involved in Report Design and Coding for Standard Tabular type reports, parameterized reports, cascading reports, linked reports including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Experience in Creation of DTS Packages for data migration between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Used SSIS to migrate databases such as access databases, flat files to centralized IT destinations.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Integrated SQL Server reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal (SSRS).
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated tableau dashboard with combination charts for clear understanding.
• Prepared test Plans for each release, written Test Cases and executed them as part of Functional testing.
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Developed complex SSIS packages using control and data flow components with error handling, error emailing.
• Created SSIS packages which download files daily from web and load in to databases using FTP Component, For Each Loop.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.

Environment: MS SQL Server 2005/2008/2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows XP, Microsoft Office 2010, Microsoft Outlook, Quality Center, AJACS, Microsoft SharePoint 2003, Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access) Master Data Management (using Microsoft’s MDS).

Confidential, Tampa, FL

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the public data collected.
• Creating Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Also used DTS packages for creating job on the SQL Server 2000.
• Creating and integrating User Defined Functions and Stored Procedures for reporting purpose.
• Developed Ad-Hoc reports, sub reports, drill down reports, parameterized reports and dirty reports.
• Designing and testing (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Designing 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.
• Moving the entire phase from the Staging to the Production.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS packages which download files daily from web and load in to databases using FTP Component, For Each Loop.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Used Team Foundation Server (TFS) for version control, source control and Reporting to keep track historical changes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Windows XP, IBM DB2, Crystal Reports, XP2, Microsoft Office 2003, Microsoft Outlook

Confidential, Chicago, IL

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Planned and Designed SSIS packages based on the business requirements.
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Created a process to programmatically create ODBC System DSNs within an MS Access database
• Developed MS Access Data Analysis reports
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Performed error handling using script task and event handlers.
• Used various SSIS tasks such as Conditional Split, Merge Join, Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Created sub-reports, drill down reports, summary reports, parameterized reports and ad-hoc reports using SSRS.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Windows XP, Microsoft Word 2003, Visual Source Safe.

Confidential, Atlanta, GA

MS SQL Server/BI/ETL Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Provided and managed QA task estimations within a scrum/agile team.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.

Environment: MS SQL Server 2005/2008, Business Intelligence Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PL/SQL, SQL Profiler, Windows XP/ NT / 2000/2003, SQL Query Analyzer, SQL Profiler.