SUMMARY:

• 8+ Years of experience in Information Technology as SQL Server Developer (2005, 2008R2, 2012) in Production, Development and Test Environments. Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
• Excellent experience in SQL Server Programming (T - SQL), Integration services (SSIS), Analysis Services, Notification Services and Reporting services (SSRS) in SQL 2005/2008 R2/2012.
• Experience in Data Warehouse Development environment using Microsoft SSIS, SSAS and SSRS.
• Extensive experience in Creation and Maintained of Stored Procedures, Triggers and Functions.
• Strong knowledge of Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization.
• Proficient knowledge of Creating Feeds from OLTP to OLAP systems.
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
• Expertise in SQL Query Performance Analysis skills and Ability to Redesign for Optimal Efficiency.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using SSIS.
• Very good experience in designing, development and deployment of SSIS packages.
• Designed SSIS Packages to Extract, Transform and Load data into Database, Archive data file from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Experience in MS SQL Reporting Services (SSRS) and Crystal Reports. Generated tabular, matrix, drilldown, drillthrough, summary Reports, sub reports, detailed reports, Parameterized and linked reports using SSRS.
• Developed several ad-hoc reports for one time purpose according to the customer requirement.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Developed Cubes using SQL Analysis Services (SSAS).
• Very good exposure to Data Modeling including Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Visio.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts.
• Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and /Supporting end users.

TECHNICAL SKILLS:

Database: MS Access, Oracle, Sybase, SQL Server 2005, 2008, 2012

O/S: Linux, HP-UX, AIX, Windows 2000, 2003, 2005, XP and Window NT

Languages: SQL, PL/SQL, T-SQL, ASP, HTML, JAVA, VB, VB Script and .Net.

Tools: OLAP, OLTP, SSRS, SSIS, SSAS, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

SQL Server Developer /ETL Developer

Responsibilities:

• Regular interaction with business users for documenting business requirements, data analysis, data mapping, gap analysis and review the documents with business users
• Analyze source data files with users, document business rules and data elements
• Work with Data Architect in designing Data Warehouse and the OLAP Model
• Mapping of Source Data elements to the Fact and Dimension tables
• Responsible for creating database objects like tables, Views, Store Procedures, Triggers, Indexes, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for the Performance tuning of the SQL statements in stored procedures with the use of the SQL Profiler, execution plans and Database Engine Tuning Wizard.
• Designedand developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed documentation and provided scripts to move table structures/views and stored procedures from Development environment to Testing and Production environments.
• Developed and deployed data transfers packages using SSIS, also scheduled jobs on Servers using JAMS.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to Staging area. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for managing BI environment, which includes Data Model, Data sources, ETL tools, target data warehouse, Facts, Dimensions and Reporting tools.
• Designed, deployed, and maintained various SSRS Reports in SQL Server 2008. Defined report layouts and developed complex reports using multiple data providers / sources.
• Wrote Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

Environment: MS SQL Server 2008 R2 / 2012, T-SQL, SSRS, SSIS, SSAS, ERWIN, .NET Framework

Confidential, Fort Lee, NJ

SQL Server Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved with the users in gathering requirements, source data files, data mapping for ETL and Reporting
• Worked with users for data analysis, defined business rules, updated functional specification documents and prepared gap analysis documents.
• Written Stored Procedures, complex queries, Views, Functions, Triggers and Indexes in SQL Server 2008R2 environment.
• Used “SQL Profiler T SQL Duration” template for tracking execution time of T-SQL Statements.
• Modified existing stored procedures and some functions.
• Good understanding of indexes and Performance tuning to optimize SQL and Stored Procedures.
• Monitoring the event logs, Server error logs and blocked processes for troubleshooting purposes.
• Generated tabular, matrix, drilldown, drill through, Summary, detailed, sub reports, Parameterized and linked reports using reports in MS SQL Reporting Services (SSRS)
• Developer several ad-hoc reports for one time purpose according to the customer requirement.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Involved in the development Cubes using SSAS and MDX
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Implemented SSIS with SQL Server stored procedures for data manipulations.
• Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
• Created mappings using row count transformations, Aggregate transformations, business intelligence transformations, split and join transformations and some other transformations like Lookup, Data Conversion, Derived Column, MultiCast and SCD transformations etc.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Created logical and physical data models using Erwin.
• Created Entity Relationship (ER) diagrams based on requirements.
• Involved in component and integration testing of stored procedures. Wrote test conditions and test scripts for all the stored procedures that I have created.
• Done the code reviews, maintained the version control and documentation.

Environment: MS SQL Server 2008 R2 / 2012, T-SQL, SSRS, Crystal Reports, SSIS, SSAS, ERWIN, .NET Framework

Confidential, Virginia Beach, VA

SQL / ETL Developer

Responsibilities:

• Regular interaction with business users for documenting business requirements, data analysis, data mapping, gap analysis and review the documents with business users
• Analyze source data files with users, document business rules and data elements
• Responsible for creating database objects like tables, Views, Store Procedures, Triggers, Indexes, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for the Performance tuning of the SQL statements an stored procedures with the use of the SQL Profiler, execution plans and Database Engine Tuning Wizard.
• Designedand developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also scheduled jobs on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to Staging area. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for managing BI environment, which includes Data Model, Data sources, ETL tools, target data warehouse, Facts, Dimensions and Reporting tools.
• Designed, deployed, and maintained various SSRS Reports in SQL Server 2008. Defined report layouts and developed complex reports using multiple data providers / sources, user defined objects, aggregate aware objects, and synchronized queries.
• Wrote Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment: MS SQL Server R2, T-SQL, SSRS, SSIS, SSAS, ERWIN, .NET Framework

Confidential, Atlanta, GA

SQL / ETL Developer

Responsibilities:

• Interacted with users in analyzing requirements, developing mapping specifications and updating functional requirement documents (FRD’s)
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designated error table.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Generated various reports with Drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery Mechanisms of Reports including Email /PDF/Schedules
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: MS SQL Server 2008, T-SQL, VS2008, SSRS 2008, Crystal Reports, SSAS, SSIS, Business Intelligence Development Studio (BIDS)

Confidential, Jacksonville, FL

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Interacting with users, business requirements gathering, documentation and user .
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Involved in designing Logical and Physical Data Models.
• Written Stored Procedures, complex queries, Views and Functions, Triggers in SQL Server 2005/2008 environment.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa
• Involved in fine Tuning and Performance and Query optimization as required by the application
• Conducted data import and export operations.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked on SSIS Packages to pull the data from different Sources and load to Data mart.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP.

Confidential . Columbus, OH

SQL / BI Developer

Responsibilities:

• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
• Used MS Excel, CSV files as data source and copied data to the target.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated Reports in SSRS using Expressions and Functions for the reports.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling the subscription reports with the subscription report wizard.

Environment: MS SQL Server 2005, SQL Server Reporting Services, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP.

Confidential, Secacus, NJ

Developer

Responsibilities:

• Involved in Analysis of the existing system and prepared the documentation
• Designed and developed enhancements to Wholesale Distribution and Marketing System, a Client/Server based system using Visual Basic 6.0 and SQL Server 2005.
• Application involved a customized user-interface with many windows, customized menus. Retrieval, manipulation and updating of data at runtime.
• Developed several display, weekly, and monthly reports. Generated detailed and summary reports.
• Extensively used stored procedures, functions and cursors
• Used query optimization techniques.