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 wif Microsoft SQL Server 2012/2008/2005.
• Expertise working on SQL server integration services packages and reporting services using SQL server data tools wif Visual Studio 2010/ 2012 IDE.
• In-depth noledge ofT-SQL(DDL, DML, DCL, TCL)andXQUERY (XML).
• Implemented business logic and developed the 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 the problems.
• Expertise in performance tuning and troubleshooting the 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 wif 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 noledge 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 has 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 the requirements from end User.
• Involved in designing the database using SQL server 2012/2008 R2 database.
• Extensively worked on data mapping and database modeling concepts wif UML and ERWIN tools.
• Work wifin and across Agile teams to design, develop, test, implement, and support technical solutions across a full-stack of development tools and technologies.
• Identified the tables wif no primary keys and added the primary keys to the tables to increase the performances of the queries.
• Working on creating the database object like tables, stored procedures, views and function.
• Using SQL Server Data tools, Creates the SSIS, SSRS reports.
• Working on designing the 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 the tables using ETL process. Uses tables, stored procedure in SSIS package to pull the required data into tables.
• Design the SSIS package to load the PNL Source table from one SQL Server database to other SQL server database. Using the source table created the SP to populate the new table and updates the related PNL columns in the tables. These tables are used in the Tableau dashboard reports.
• Load the crosswalk data from Excel, which comes from user to SQL Database table using SSIS Package, Where the data is viewed in tableau reporting.
• Creating and developing the financial SSRS reports.
• Design and Developed the SSRS reports by extracting the 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 the Tableau reports. Tableau Dashboard reports which give the financial detail reports for all the LOB’s, Divisions, LOB Segment as per the requirement.
• Tableau Workbooks are created in the Tableau Desktop and then workbooks are published to Tableau test server then verified across the data, then exported to tableau production server, where reports are accessed through URL.
• Working on resolves the SQL database issues/errors by modify the Stored Procedure wif calculation as per necessary modifications or structural changes on tables, views.
• Analyzing and compare the data wif the user file and the database.
• Compare and tests the PNL data on source table to the user files, if the data doesn’t match, changes are made to the SP, which executes to populate the PNL table.
• Developed reports based on a Power Pivot workbook and Power View reports using SSRS 2012 and integrated wif SharePoint 2013.
• Involved in Preparing the Documentation for load process.
• Highly Experiences in working wif Excel, Microsoft Office, Access, PowerPoint and Word.
• Creates the database objects using TFS. Save and move the scripts to production using TFS.
• Tests the tableau reporting before moving it production tableau server.
• Working wif Visual Studio 2013 for automation process.
• Knowledge on .Net framework.
• Involved in unit and system test. Works on creating CO and gather the required document to move the code to production.
• Involved in deploy the SSIS package and reports to test and Prod server.
• Good expose and works on using HPSM, CAServicedesk for ticketing system.
• Handles the production support.
• Ability to work under pressure and involves in the 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 the 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 the indexes to improve the performances and also rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Experience wif optimization tools for monitoring and tuning using Index tuning wizard SQL profiler and windows performance monitor.
• Worked wif the DBA team to fix the performances issues of the ETL code.
• Expertise in designing the 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 the 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 the 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 wif the data warehouse team to design and develop the ETL process.
• Extensive experience in developing, designing and handling reports using SSR 2012.
• Involved in developing the 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 the SSRS reports by using Teradata, SQL queries, views and macros.
• Worked and experiences in scheduling the reports weekly, monthly as per the business needs.
• Proficient in designing layouts, sorting data and implementing calculation fields for the 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 the 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 the indexes to improve the performances and also rebuilt indexes on tables.
• Experience wif optimization queries monitoring/tuning using actual/estimated execution plan, SQL profiler.
• Expertise in designing the packages using various transformations available in SSIS.
• Involved in extracting/transforming/loading data from different data sources using SSIS packages.
• Worked on migrating the 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 the 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 noledge 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 the packages in both the Development and Production environments.
• Worked on designing various SSIS packages to Extract/transform/Load the 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 the 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 the SSRS reports.
• Worked on unit/system testing, deployment and documentation to promote the 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 the 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 the 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 the analytics data of the 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 the reports daily, weekly and monthly.
• Worked on migrating the SSRS reports from SQL server 2005.
• Worked on enhancement reports to redesign, recode wif new requirements.
• Worked on unit and system Testing.
• Worked and Involved in promoting the 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