SUMMARY

• 5 years of experience in design and development with MS SQL SERVER & excellent hands on working with SSIS/SSRS OLTP and OLAP environment.
• Interact closely with both IT and the business members
• Perform code reviews, support operations teams with necessary documentation
• Excellent knowledge on T - SQL Query Language.
• Optimization of T-SQL code/query and its performance tuning
• Experience using various transforms in SSIS while transferring the data from various sources into the destinations
• Experience in creating complex SSIS packages.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS
• Well versed of using Partition, Fragmentation, cursors, stored procedures, Triggers.
• Strong in troubleshooting SSIS package
• Experience understanding and analyzing various data sources.
• Responsible for ETL design and development.
• Excellent verbal & oral communication

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Load daily load data from Flat file to Oracle using software Tidle
• Debugging error on daily load if there is any error.
• Validating daily data load is correct comparing source and destination.
• Exporting data in flat files
• Identify root causes in case of ETL failures.
• Creating table and loading data in oracle for some data analyze
• Creating workflow in Informatica to load data
• Generated weekly and monthly reports in Excel sheets using complex SQL queries.
• Research and Response customer service request all day
• Data cleaning for consistency in database
• Write integrity Query for data consistency
• Analyzing data
• Immediate fix high priorities issues in production database.
• Worked in Agile methodology.

Confidential, Plano, TX

SQL Server Developer / ETL Developer

Responsibilities:

• Experience creating relationship models, schemas, views, store procedures, Views, Triggers, cursors, and other database artifacts
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008
• Involved in Incremental Data Load from various sources into SQL Server Database Engine using transformations like derived columns, lookups, data conversions, Slowly Changing Dimensions (SCD) and conditional splits.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Identify the causes of slow running of T-SQL queries.
• Worked on developing SSIS packages with scalable ETL components and complex business logic that involves data extraction from different heterogeneous sources like text, CSV, Excel, SQL Server.
• Once package is completed successfully, perform unit test.
• Identify root causes in case of ETL failures.
• Gather requirement with clients and communicate with project manager for user story and defect
• Interact closely with Project manager, Reporting, and QA team and the business as per their requirement.
• De-identify Data before demo to customer.
• Deploy SQL Code in Team City and Deploy package in Dev, QA, and Production Server
• Analyze client data.
• Clean and reload data in QA (Testing) environment for testing purpose
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Built cubes in SSAS.
• Worked in Agile methodology.

Environment: SQL Server 2008R2, Business Intelligence Development Studio (SSIS, SSAS, SSRS), OLTP, OLAP, SVN, RoundHouse, SVN

Confidential, TX

SQL Server Developer / ETL Developer

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS and SSRS to develop a solution.
• Hands on experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors.
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2012 / 2014.
• Unit testing after successfully run of packages.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine using transformations like derived columns, lookups, data conversions, Slowly Changing Dimensions (SCD) and conditional splits.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers, lookups with Execute SQL Tasks.
• Implementing major Event Handlers like OnError, OnProgress and OnTaskFailed for SSIS Packages.
• Worked on developing SSIS packages with scalable ETL components and complex business logic that involves data extraction from different heterogeneous sources like text, CSV, Excel, SQL Server, and Postgres.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Analyze, design, and develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Worked in Agile methodology.

Environment: SQL Server 2008R2 / 2012 / 2014 Enterprise, PostgreSQL Database, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Microsoft Office Share Point Server, OLTP, OLAP, TFS

Confidential, Richardson, TX

SQL Server Developer / ETL Developer

Responsibilities:

• Actively participated in interactions between users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Created logical and physical database design, data structures and maintained it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Designed SQL SSIS Packages to extract data from heterogeneous data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008/R2 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS and SSRS to develop a solution.
• Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
• Worked on Data Model and good knowledge of Relational Database.
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Working with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Data load to and from MSAccess to MS-SQL Server
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Used of Pivot table in Excel to analyze the data and detect patterns.
• Analyze, design, and develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Worked in Waterfall methodology.

Environment: SQL Server 2008R2 Enterprise, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Erwin, Microsoft Office Share Point Server, OLTP, OLAP, Red Gate SQL Compare, HTML, JavaScript, CSS

Confidential, Plano, TX

SQL Server Developer / ETL Developer

Responsibilities:

• Analyzing the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS and SSRS to develop a solution.
• Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
• Administering SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Working with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Implementing major Event Handlers like OnError, OnProgress and OnTaskFailed for SSIS Packages.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Analyze, design, and develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involve in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Used VLOOKUP in Excel to retrieves Information from Database
• Used of Pivot table in Excel to Extracts, Organizes, and summarizes huge data.
• Worked on macros in Excel to analyze the data, which is of same pattern and have to do repeatedly.
• Worked with Report Manager to configure Web URLs, E-mail and also Databases for reports.
• Worked in Agile methodology.

Environment: SQL Server 2008R2 Enterprise, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Erwin, Microsoft Office Share Point Server, OLTP, OLAP, Red Gate SQL Compare, Sybase, HTML, JavaScript, CSS