SUMMARY:

• Over 12 Years of experience in IT involving development, testing and production support. Including around 8 years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server DTS/SQL Server Integration, Reporting & Analysis Services.
• Experience in the development and testing of Windows/Microsoft and web - based software applications. And Strong experience in Agile Methodology.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical and troubleshooting.
• Strong experience with SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)
• ETL implementation using SQL Server Integration Services (SSIS). Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS). Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2012.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

TECHNICAL SKILLS:

Database: SQL Server 2005/2008/2012/2014, MS Access 03/07, Oracle9i, 10g

Operating Systems: Windows XP/2000/2003/Win XP/Win 7

Programming Languages: T-SQL, HTML, C#, VB.Net

BI Suite: SSIS, SSAS, SSRS

Database Tools: SSMS, MS Visual Studio, Toad, Ankhs 2.5, BIDS Helper 2008 v1.5.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior SQL Server BI Consultant (SSIS, SSRS)

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Worked extensively on creating Complex T-SQL Queries, Stored Procedures, User Defined functions and implementing Error Handling using Try & Catch Block
• Created SSIS packages to clean and load data to data warehouse and populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, QA, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Strong experience in data modeling (Star Schema/dimensional modeling), data marts
• Created the deployment scripts after the development is done for every project.
• Generated Reports using SQL Server Reporting Services.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.

Environment: SQL Server 2012 and 2014, SQL Server Data Tools for Visual Studio 2013, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt.

SQL Developer (SSIS, SSRS)

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooter the SSIS/SQL job Agent whenever necessary.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports and SSIS packages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt.

SQL Server BI Developer

Responsibilities:

• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided.
• Production support responsibilities.
• Created and modified stored procedures, triggers and cursors.

Environment: Environment: SQL Server 2008, SQL Server Business Intelligence Development Studio 2008, SSIS, SSRS and T-SQL.

Jr. SQL Server Developer

Responsibilities:

• Worked with SQL to create Tables, Views, and Triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Application support for ETL, Data transformation and Data Analysis
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Extensive use of T-SQL DDL and DML commands for various applications.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.

Environment: T-SQL, SQL Server … Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003 and Erwin Data Modeler.

Quality Analyst / Sr. QA Test Engineer

Responsibilities:

• Overall accountability for planning, developing, maintaining and executing the project Test Estimates, Test Strategy and Test Plans (including Master Test Plan)
• Prepare Test Plans, Test Scripts (Manual and Automation scripts using Selenium Web driver)
• Execute Test Cases (Manual and Automation scripts using Selenium Web driver)
• Extensive experience in Device (Mobile Testing)
• Set up test results recording structure in HPQC
• Written SQL queries to access modify and create test data in the database for Back-end testing.

Environment: and Tools: SQL Server, TOAD, Oracle, Win Runner, HP Quality Center, Windows NT, SQL, Visual Basic, Oracle, MS Office, Visual Basic, HTML, JavaScript, Windows, UNIX, and Test Director.