SUMMARY

• Over 7+ years of experience as SQL Developer using Microsoft SQL Server 2012/2008R2/2005, Business intelligence - SSIS, SSRS and experience in all phases of a product development, requirements gathering, analysis, implementation, testing, deployment and maintenance.
• Extremely efficient in Software Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
• Expertise working with Microsoft SQL Server 2012/2008/2005.
• Expertise working on SQL server integration services packages and reporting services using SQL server data tools with Visual Studio 2010/ 2012 IDE.
• In-depth knowledge ofT-SQL(DDL, DML, DCL, TCL)andXQUERY (XML).
• Implemented business logic and developed teh structured database using tables, stored procedures, views, user defined functions, cursors, triggers and indexes using T-SQL.
• Good exposure to relational database management systems.
• Experienced in supporting very large database and troubleshooting teh problems.
• Expertise in performance tuning and troubleshooting teh queries, procedures using SQL profiler, estimated and actual execution plans.
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Integration Services with MS SQL 2012/2008/2005.
• Experienced in migrating and testing DTS packages to SQL Server integration services.
• Involved in creating SSIS packages by using different transformations like conditional spilt, Aggregate, Lookup, SCD, Multicast, Catch connection, Derived column, sort, Merge Join etc.
• Scheduling and maintaining SSIS Packages and batch jobs thruSQL Server Agenton a timely basis.
• Strong knowledge and expertise in data transformations, data loading, and performance tuning.
• Expertise in event/error handling and Data logging using SSIS logging by text/xml files.
• Created and deployed SSRS reports and managed security for reports.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Designed and created database ER diagrams and models using MS Visio.
• Good experience working in scrum and agile project planning methodology.
• Extensively involved in Unit, System, Integration, and functional testing.
• Expertise in using ticketing system, responsible and provided for Production support.
• Excellent communication, interpersonal skills and TEMPhas a strong ability to work as part of a team and as well as handle independent responsibilities.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

SQL Developer

Responsibilities:

• Works on gathering teh requirements from end User.
• Involved in designing teh database using SQL server 2012/2008 R2 database.
• Extensively worked on data mapping and database modeling concepts with UML and ERWIN tools.
• Work within and across Agile teams to design, develop, test, implement, and support technical solutions across a full-stack of development tools and technologies.
• Identified teh tables with no primary keys and added teh primary keys to teh tables to increase teh performances of teh queries.
• Working on creating teh database object like tables, stored procedures, views and function.
• Using SQL Server Data tools, Creates teh SSIS, SSRS reports.
• Working on designing teh SSIS package to extract/transform/load data from various heterogeneous data sources and load into various destinations like SQL tables, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS. Creating teh tables using ETL process. Uses tables, stored procedure in SSIS package to pull teh required data into tables.
• Design teh SSIS package to load teh PNL Source table from one SQL Server database to other SQL server database. Using teh source table created teh SP to populate teh new table and updates teh related PNL columns in teh tables. These tables are used in teh Tableau dashboard reports.
• Load teh crosswalk data from Excel, which comes from user to SQL Database table using SSIS Package, Where teh data is viewed in tableau reporting.
• Creating and developing teh financial SSRS reports.
• Design and Developed teh SSRS reports by extracting teh data from table, stored procedure. Developed various types of reports like Tabular, Matrix, cross tab, bar and pie charts, Gauge, Sparkline, sub reports, drill down, drill through, and parameterized reports using SQL server Reporting Services (SSRS).
• Developed teh Tableau reports. Tableau Dashboard reports which give teh financial detail reports for all teh LOB’s, Divisions, LOB Segment as per teh requirement.
• Tableau Workbooks are created in teh Tableau Desktop and then workbooks are published to Tableau test server then verified across teh data, then exported to tableau production server, where reports are accessed through URL.
• Working on resolves teh SQL database issues/errors by modify teh Stored Procedure with calculation as per necessary modifications or structural changes on tables, views.
• Analyzing and compare teh data with teh user file and teh database.
• Compare and tests teh PNL data on source table to teh user files, if teh data doesn’t match, changes are made to teh SP, which executes to populate teh PNL table.
• Developed reports based on a Power Pivot workbook and Power View reports using SSRS 2012 and integrated with SharePoint 2013.
• Involved in Preparing teh Documentation for load process.
• Highly Experiences in working with Excel, Microsoft Office, Access, PowerPoint and Word.
• Creates teh database objects using TFS. Save and move teh scripts to production using TFS.
• Tests teh tableau reporting before moving it production tableau server.
• Working with Visual Studio 2013 for automation process.
• Knowledge on .Net framework.
• Involved in unit and system test. Works on creating CO and gather teh required document to move teh code to production.
• Involved in deploy teh SSIS package and reports to test and Prod server.
• Good expose and works on using HPSM, CAServicedesk for ticketing system.
• Handles teh production support.
• Ability to work under pressure and involves in teh teamwork.

Environment: MS SQL Server Management Studio 2012/2008R2/2008/2005, MS Access, T-SQL, Teradata SQL Assistant, SQL server Business Intelligence Development studio - SSIS, SSRS, Tableau, Performance Point Server, Crystal reports, Enterprise manager, Query Analyzer, Application Tools.

Confidential

SQL ETL Developer

Responsibilities:

• Worked on requirement gathering, business analysis, development, testing and deployments.
• Involved in designing teh database using SQL server 2012, DB2 and MS access database.
• Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers and referential Integrity.
• Worked extensively on complex queries, debugging and its performances tuning.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created recursive and non-recursive queries using Common Table Expression (CTE).
• Created teh indexes to improve teh performances and also rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Experience with optimization tools for monitoring and tuning using Index tuning wizard SQL profiler and windows performance monitor.
• Worked with teh DBA team to fix teh performances issues of teh ETL code.
• Expertise in designing teh packages using various transformations available in SSIS.
• Involved in ETL process to extracting/transforming/loading data from different data sources using SSIS packages.
• Experienced in migrating teh data using SSIS Packages, Import/Export and Copy database wizard.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Worked on Design, develop, validate and deploy teh Talend ETL processes using Talend Open Studio for data integration.
• Extraction, transformation and loading of data from various file formats like .csv, .xls, .txt and various delimited formats using Talend open studio and sql loader.
• Work with teh data warehouse team to design and develop teh ETL process.
• Extensive experience in developing, designing and handling reports using SSR 2012.
• Involved in developing teh various types of SSRS reports like tabular, matrix, bar charts, pie charts, spark lines, sub reports, drill down, drill through, cascading, parameterized.
• Involved in enhancements, performance tuning and created ad-hoc reports using Report builder.
• Creating different types of reports by extracting data from tables, stored procedures into reports and customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created, deployed and managed security for reports using SSRS.
• Responsible for analysing requirements and developing teh SSRS reports by using Teradata, SQL queries, views and macros.
• Worked and experiences in scheduling teh reports weekly, monthly as per teh business needs.
• Proficient in designing layouts, sorting data and implementing calculation fields for teh reports.

Environment: MS SQL Server Management Studio 2012, MS Access, T-SQL, SQL Assistant, SQL server Business Intelligence Development studio - SSIS, SSRS, Enterprise manager, Client Configuration Utility, Server Configuration Utility, Query Analyze, Application Tools.

Confidential, Redmond WA

SQL ETL Developer

Responsibilities:

• Worked on requirement gathering, business analysis, development, and testing.
• Involved in designing teh database using SQL server 2008 R2.
• Extensively worked on data mapping and data modeling concepts.
• Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers and referential Integrity.
• Worked extensively on complex queries, debugging and its performances tuning.
• Created recursive and non-recursive queries using Common Table Expression (CTE).
• Created teh indexes to improve teh performances and also rebuilt indexes on tables.
• Experience with optimization queries monitoring/tuning using actual/estimated execution plan, SQL profiler.
• Expertise in designing teh packages using various transformations available in SSIS.
• Involved in extracting/transforming/loading data from different data sources using SSIS packages.
• Worked on migrating teh data using SSIS Packages, Import/Export and Copy database wizard.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Extensive experience in developing, designing and handling reports using SSRS 2008R2.
• Involved in Developed teh various types of SSRS reports like tabular, matrix, bar charts, pie charts, spark lines, sub reports, drill down, drill through, cascading, parameterized.
• Involved in enhancements, performance tuning and created ad-hoc reports using Report builder.
• Creating different types of reports by extracting data from tables, stored procedures into reports and customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Knowledge and Extensively used VB script for customizing data to display in reporting service.

Environment: MS SQL Server 2008R2, T-SQL, Data Tools for integration and reporting services, Visual Studio 2012, SQL Profiler, TFS

Confidential

IT Analyst

Responsibilities:

• Requirement gathering, business analysis, development, and unit testing from business analyst.
• In-depth knowledge ofT-SQL(DDL, DML, DSL, andSQLCMD) andXQUERY (XML).
• Created database schema and database objects like tables, stored procedures, indexes, constraints, triggers, views, cursors and functions.
• Worked extensively on complex queries, performances tuning and Query Optimization
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh Development and Production environments.
• Worked on designing various SSIS packages to Extract/transform/Load teh data using various transformations.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed various types of reports like tabular, matrix, cross tab, bar and pie charts, drill down, drill through, and parameterized reports.
• Designed and developed teh crystal reports and developed ad-hoc reports.
• Involved in migrating SSRS reports from SQL Server 2005 to SQL Server 2008/2008R2.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Configured reporting services and managed reporting security by creating groups and granting access to report folders.
• Involved in scheduling, creating snapshots and subscriptions for teh SSRS reports.
• Worked on unit/system testing, deployment and documentation to promote teh code into production.

Environment: SQL Server 2005/2008R2, MS Access, SQL Server integration and reporting services, Crystal reports, Client Configuration Utility, Server Configuration Utility, Query Analyzer.

Confidential

IT Analyst

Responsibilities:

• Experience in all phases of SDLC. Gathering, design, Data Modeling and Implementation.
• Expertise in creating teh database objects like tables, views, indexes, stored procedure, etc.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Worked on designing teh SSIS packages to extract/transform/load data from sources and load into destination SQL tables using connectors, tasks and transformations provided by SSIS.
• Worked on SSRS reports to pull teh analytics data of teh vendors using reporting tool.
• Designed and Developed different kinds of SSRS reports like sub reports, matrix reports, chart reports, drill down, drill through, and corporate dashboard reports.
• Experienced in writing parameterized queries for generating reports, formatting report, layout, sub reports using global variables, expressions and functions in SSRS.
• Developed Ad Hoc reports using Report builder.
• Involved in scheduling teh reports daily, weekly and monthly.
• Worked on migrating teh SSRS reports from SQL server 2005.
• Worked on enhancement reports to redesign, recode with new requirements.
• Worked on unit and system Testing.
• Worked and Involved in promoting teh code to production.
• Worked on solving issues by doing data recovery in existing database.

Environment: MS SQL Server 2005, Business Intelligence integration and reporting services, MS Access, SQL Server Profiler