SUMMARY

• Over 11 years of overall IT experience in Data Warehousing/Business Intelligence (BI) using technologies TERADATA, SSIS, SSAS, SQL Server, DB2, C#, ASP.NET
• Worked in different roles such as Project Lead, Sr.Software Engineer and Software Engineer roles.
• Hands on experience in different databases such as TERADATA, DB2, and SQL Server
• Having experience in using the ETL tool (SSIS).
• Strong experience building extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables using SSIS.
• Expertise in T - SQL such as writing Stored Procedures, Functions, Cursors and Triggers in SQL Server
• Expertise in query performance using execution plans for complex queries in SQL Server.
• Proficient in QUERY OPTIMIZATION and DBCC COMMANDS and reading EXECUTION PLANS
• Familiar with Logical Data Model and Physical Database design.
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Hands on experience usingTeradata utilities like B-TEQ, Fast Load, MultiLoad and Fast Export.
• Having knowledge on Creating Cubes and MDX queries
• Experience in creating ksh Scripts in UNIX using putty
• Sound Knowledge ofData Warehousing concepts,E-R model&Dimensional modeling(3NF) likeStar Schema, Snowflake Schemaand database architecture
• Good experience in handling multiple projects with Offshore - Onshore model including interviewing, mentoring, training and provide efforts estimation for the DW and BI applications.
• Implemented In-house developed tool (MBT) in the project which resulted in reduction of Man work Hours
• Worked in various domains SUPPLY CHAIN, CRM, SALES and FINANCE domains.
• Complete understanding of Software Testing Life Cycle (STLC), QA Methodology and QA Strategy.
• Strong experience building extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables using SSIS
• Created complex SSIS packages for Data Migration and Transformation.
• Expertise in query performance using execution plans for complex queries in SQL Server.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

Programming Languages: C#,ASP.NET, XML, SQL, PL/SQL, VB, Unix Shell Script.

Web Technologies: HTML, DHTML, CSS, JavaScript

Frameworks: DOT NET

Tools: & Utilities: Quality Center 10.00, ALM, DB Visualizer, T-SQL Assistance, Erwin

RDBMS: MS SQL Server, TERADATA, DB2, MS Access.

Source Control: Microsoft VSS, SVN

ETL Tools: SSIS,SSAS

Operating Systems: Windows 9x/2000/XP, Linux, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Project Lead

Responsibilities:

• Analyze Business Requirement Documents and create Software Design specifications to develop.
• Conducted review meetings and presentation with Architects on Software Design specifications.
• Responsible for environment configurations, data setup and user access to the team members
• Experience in Creating Teradata scripts using Teradata SQL Assistant
• Created Teradata BTEQ scripts to implement the business logic
• Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
• Created SSIS packages for the loading one of source files from SQL SERVER systems into Teradata
• Running the jobs and validating the tables and files after completion of the jobs.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Working with QA team on the Defects assigned and Test Case review.
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Work with DBA on Batch Performance Testing
• Production Support and coordinating with different teams across organizations during post implementation validations.
• Participate in UAT with end users to provide them technical guidance and data set up needs.

Environment: Teradata, SVN,SSIS, SQL Server, Windows and UNIX

Confidential, NJ

Senior Software Engineer

Responsibilities:

• Responsible for creation and maintenance of the supporting SQL stored procedures, tables, views and functions.
• Handled designing and development of DB and ETL process.
• Usage of SSIS variables to define the SQL queries to pull the incremental data from source Error handling
• Usage of Script components across all DFT’s for error handling.
• Implementation of Bad files logic to capture the bad records.
• Implementation of Custom logging to measure the success and failure of the packages.
• Package created for email handling to handle both success and failure emails.
• Involved in writing complex SQL scripts as per the business requirements.
• Performed code review and provide the feedback to peers.
• Develop and load the data from external file systems such as MUREX, INTEX, IDEAS, YIELDBOOK and ALM etc. using SSIS Package
• Usage SSIS variables to define dynamic SQL queries.
• Query performance using execution plans for complex queries.
• Use star team to check in and checkout files. Use labels for deployment of procedures.
• Writing scripts business logic in stored procedures or enhance the existing stored procedure.
• Performed unit testing, system testing and integration testing.

Environment: Visual Studio 2008, C#, SQL Server 2008, SSIS, SSRS, Star Team, Quality Centre and Remedy

Confidential

Senior Software Engineer

Responsibilities:

• Responsible for collecting data from web services and displaying in ASP.NET user controls
• Efficiently created web Part for the controls and added these web parts to the share-point site.
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Performed unit testing, system testing and integration testing.

Environment: Asp.Net, c#, Sqlserver2005, HTML, CSS, Java Script and Share point.

Confidential

Senior Software Engineer

Responsibilities:

• Interacted with the clients to gather & analyze business requirements of the various modules of the project.
• Extensively involved in the design, coding, deployment and maintenance of the project.
• Provided support and enhancement according to the requirements.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Extensively used Object Oriented Programming.
• Developed reusable Business Logic Components used for rating the Policy Coverage’s.
• Handled the process dealt with implementation of application in client place.
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005

Environment: Visual Studio, Asp.Net, C#, SqlServer, HTML, Java Script, CSS and Windows

Confidential

Sr. Software Engineer

Responsibilities:

• Interacted with the clients to gather & analyze business requirements of the various modules of the project.
• Extensively involved in the design, coding, deployment and maintenance of the project.
• Provided support and enhancement according to the requirements.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Develop and load the data from external file systems such using SSIS Package
• Developed reusable Business Logic Components used for rating the Policy Coverage’s.
• Handled the process dealt with implementation of application in client place.
• Writing stored procedures, views, functions and SqlScripts in SQL Server 2005

Environment: Visual Studio, Asp.Net, C#, SqlServer 2005, SSIS, HTML, Java Script, CSS and Windows

Confidential

Software Engineer

Responsibilities:

• Provided support and enhancement according to the requirements.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Extensively used Object Oriented Programming.
• Exceptions are handled and the user is intimated with user friendly messages.
• Developed reusable Business Logic Components used for rating the Policy Coverage’s.
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005.
• Involved in UNIT Testing.

Environment: Visual Studio, Asp.Net, C#, SqlServer 2005, SSIS, HTML, Java Script, CSS and Windows

Confidential

Software Engineer

Responsibilities:

• Implemented 3 tier Architecture using C#.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Extensively used Object Oriented Programming.
• Exceptions are handled and the user is intimated with user friendly messages.
• Wrote stored procedures, views, functions and SqlScripts in SQL Server 2000.
• Handled the deployment process of code, Unit Testing and preparation of Test Cases.

Environment: Visual Studio, Asp.Net, C#, SqlServer 2005, SSIS, HTML, Java Script, CSS and Windows