SUMMARY:

• 6+ years of relevant IT experience in all phases of the software development life cycle such as Requirement Analysis, Design, Development, Testing using SQL Server. Experience in Waterfall and Agile working models.
• Develop Tables, Indexes, Stored Procedures, Functions, Views, Triggers and other objects utilizing latest DML and DDL syntax.
• Building and maintaining SQL scripts in Microsoft SQL Server 2008+, SSIS packages, SQL Jobs, complex SQL queries for data analysis and data extract.
• Design Indexes for existing applications, choosing when to add or remove indexes.
• Proficient in ETL Extract - Transform - Load) using SQL Server Integration Services 2014 (SSIS).
• Expert in Extracting and Transforming data using SSIS in SQL Server 2008, SQL Server Import Export, Bulk Insert and BCP.
• Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Expert in Extracting and Transforming data SSIS in SQL Server, SQL Server Import Export, Bulk Insert.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Experienced in Database Programming - Stored procedures, Functions, Triggers, Cursors using T-SQL.
• Created SSIS Packages to load data into database from various sources.
• Scheduled the jobs to do these tasks periodically. Identify, track, and resolve issues and challenges that arise throughout the SDLC while maintaining schedules, cost and quality.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Good experience in SSIS transformations and delivered many reports by using SSRS MSBI tools

TECHNICAL SKILLS:

Languages: T-SQL, SQL, PL/SQL, Java

RDBMS: SQL Server 2008/2012/2016, MS Access, DB2

Development Tools: Visual Studio

Tools: VSS, Jira

Reporting Tools: SSRS, BIDS,Tableau

Database Tools: MS SQL Server Enterprise Manager, SQL developer, SQL Profiler

SQL Server Tools: Profiler, Query Analyzer

Services Database Engine: SSIS, SSRS, SSAS

Operating Systems: Windows

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Irving TX

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Have used SQL Server 2012 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Performed Data Cleansing and Profiling using Transformations in Packages.
• Designed SSIS Packages to transfer data between servers, load data into database; Scheduled the jobs to do these tasks periodically;
• Generating reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Developed mappings to load the data from various sources into the Data warehouse different transformation
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.
• Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Involved in daily batch loads (Full & Incremental) into Staging, troubleshooting process, issues and errors.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• For all the work done on the WRs there was minimal or no maintenance in Production accomplishing quality deliverables which directly/indirectly contributed to the minimum no. of Prod IRs (bugs/fixes) through quality code and various levels of QA.
• Building and maintaining SQL scripts in Microsoft SQL Server 2012, SSIS packages, SQL Jobs, complex SQL queries for data analysis and data extract.
• Build the code according to the technical specifications, detailed design, maintainability and coding and efficiency standards.
• Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
• Involved in migration from MS SQL Server 2008 to MS SQL Server 2012, DTS to SSIS.
• SQL 2008 DTS as a means of ETL for creation of DTS packages for various operations.
• Converted DTS packages of SQL 2008 to SSIS packages in SQL 2012. Also scheduled DTS packages and SSIS packages as jobs to perform various tasks.
• Reviewed all the code changed/Scripts/Back up scripts for all major Releases to ensure that Re-entrant scripts were added for Bootstraps and Drop and Create for Stored Procs and permissions given appropriately.

Environment: MS SQL Server 2012, Visual Studio 2010, Microsoft TFS 2010.

SQL Developer

Confidential

• Coordinated with EIS (Enterprise Information System ) team to provide them with the necessary stored procedures and packages and necessary insight into the data
• Worked on SQL* loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancement and fixing of production problems. Generated server-side SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed SQL triggers and master tables for automatic creation of primary keys. Created SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance
• Performed SQL tuning and application tuning using various tools like EXPLAIN PLAN
• Extensively involved in using hits to direct the optimizer to choose an optimum query execution plan.
• Created SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance. Extensively use bulk collection in SQL objects for improving the performing.
• Used Pragma autonomous transaction to avoid mutating problem in database trigger
• Extensively used the advanced features of SQL like records, tables, object type and dynamic SQL.
• Handled errors using exception handling extensively for the case of debugging and displaying the error messages in the application.
• Generating reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Handled exceptions using try catch blocks.
• Effectively used Session and Cookies for users to validate and to make a timeout for the connectivity with the database.
• Data Access Layer for the Application was implemented in ADO.NET for data input, queries, retrieval and management.
• SQL Server 2008 was utilized as the data repository.
• Stored Procedures, Triggers and Views for the data access were implemented in SQL Scripts and tested in SQL Server 2008.
• Developed Custom reports using stored procedures.
• Visual Studio 2010 was utilized as the IDE tool for the development of the project.
• Version control of the source code was managed using Team Foundation Server (TFS 2010).

Environment: Visual Studio 2010, XML, MS SQL Server 2008, SSIS, Microsoft TFS 2010.

SQL Developer

Confidential

• Involved in full development cycle of planning, analysis, design, development, testing and implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constrains in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL programs required to retrieve data using cursors and exception handling.
• Designed data modeling design specifications and to analyze dependencies.
• Creating indexes on the table to improve the performance by eliminating the full table scans and views for hiding the actual table and to eliminate the complexity of the large queries.
• Fine-tuned procedures SQL queries for maximum efficiency in various databases using oracle hints, for rule based optimization.
• Create some customer reports and forms for end users to check the details and errors.
• Worked closely with the clients to establish problem specifications and system design.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring sessions as well as performance tuning of mappings and sessions.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Monitor data processing, maintain code and work with Operations Team
• Perform requirements analysis, detail design, troubleshooting, source code construction, system testing, integration testing and implementation for reports/data
• Interact with customers and other team members when developing ETL code, and researching and troubleshooting technical issues
• Data Grids, Data Views, and Datasets were used to display Reports which were generated using stored procedures.
• Stored Procedures, Triggers and Views for the data access were implemented in SQL Scripts and tested in SQL Server 2008.
• Developed Custom reports using stored procedures.
• Involved in analyzing, designing and prototyping the initial design.
• Designed and implemented a three-tier architecture that included Presentation, Business and Data Access Layers.
• Developed various subprograms, procedures, packages, functions, database triggers and DDL, DML complex queries in SQL.
• Create and Manage schema objects, Indexes, sequences & Views.
• Wrote complex SQL queries by using joins.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote many Adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.
• Designed and developed Packages to import and export data from MS Excel, SQL Server and Flat files.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.