SUMMARY

• Over 14 years of extensive experience in data migration, data warehousing database design and development.
• Extensive experience with ETL/Data warehousing tools in Accounting & Inventory, Finance & Mutual fund areas, Automobiles, Manufacturing, Health care, Betting, Telecom Industry and Logistics.
• Involved in various stages of Software development life cycle.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment.
• Skilled in Data Warehousing Data Modeling using Star Schema and Snowflake Schema.
• Good knowledge of SQL Server and Teradata RDBMS Architecture, Tools & Utilities
• Well versed with MSBI Analysis, Integration and Reporting Services
• Expertise in various Analysis components like Cube, Dimension, Measures, KPI and Aggregation.
• Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, IBM DB2, Oracle and loaded into SQL Server and Teradata DW.
• Strong Teradata SQL, ANSI SQL coding skills.
• Expertise in Report formatting, Batch processing and Data Loading and Export using BTEQ.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes
• Used BTEQ, FastLoad, Multiload, and Fast Export utilities extensively to load to target database.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the BTEQ scripts.
• Involved in designing and building stored procedures and macros for the module.
• Expertise in SQL Server 2008 and 2012
• SQL Server R2 and 2012 Procedures, Functions, Views and Triggers. And experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.

TECHNICAL SKILLS

Operating Systems: MS Windows 2008/7/XP/2000/NT/9x

Database: Teradata 13.10, SQL Server 2008 R2 and 2012, Oracle (8i/9i/10g)

Teradata tools & Utilities query facilities: SQL Assistant, BTEQ

Load & Export: FastLoad, MultiLoad, FastExport, BTEQ

ETL: MSBI (Analysis, Integration and Reporting Services)

Languages: C, C++, Visual Basic, VB.Net

Scripting languages: VB Script

Version Control Tools: Team Foundation Server (TFS), Visual Source Safe, SVN Tortoise, Composite

Others: Crystal Reports, Acutate, PowerPivot, SharePoint and Performance Point Services, InterSystem - Cache database, Sppedminer

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

Technology Specialist

Responsibilities:

• Worked on loading of data from several flat files sources using Teradata FastLoad and MultiLoad.
• Writing Teradata sql queries to join or any modifications in the table.
• Transfer of large volumes of data using Teradata FastLoad, MultiLoad and T-Pump.
• Database-to-Database transfer of data (Minimum transformations) using ETL (MSBI).
• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance.
• Developed SSIS packages for the ETL processes using SQL Task, Script Task, Derived Task, Conditional Split Task and Lookup Tasks.
• Use independent judgment to design and developed software architecture for a project, software proof of concepts or prototypes in emerging technologies based on inputs from customer or project team
• Design the perfect software coding standards, guidelines and technology best practices
• Responsible for delivery of all technical (non-functional) requirements in the release
• Owns all technology architecture deliverables in the program
• Mentor System Analysts / Senior Developers
• Individually contributed to development
• Analyze, identify and integrate software tool sets for projects

Environment: Windows 2008, Teradata V13.10 (BTEQ, FastLoad, MultiLoad, Teradata SQL, FastExport), MS SQL Server 2012, 2008 R2, SSIS, SSAS, SSRS and Performance Point Services (PPS)

Confidential, San Francisco, CA

Technology Specialist

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Involved in designand development.
• Developed SSIS packages for stage I and II using business and transformation rules.
• Handled the exceptions and moved the data into exception tables.
• Performed the performance tuning SQL which used in Cognos
• Responsible to compile high level design document.
• Involved in analysis of data source which is Kenan1 and Kenan2.
• Created stored procedures andviews for the Business logic.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services, SQL Server Analysis Services

Confidential

Senior Consultant

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Involved in designand development.
• Developed SSIS packages for stage I and II using business and transformation rules.
• Handled the exceptions and moved the data into exception tables.
• Performed the performance tuning SQL which used in Cognos
• Responsible to compile high level design document.
• Involved in analysis of data source which is Kenan1 and Kenan2.
• Created stored procedures andviews for the Business logic.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services, SQL Server Analysis Services

Confidential

Senior Consultant

Responsibilities:

• Worked as designer to implement the Confidential project.
• Developed design document for SSIS.
• Developed the SQL queries based on data mapping document and created Indexes for the tables.
• Developed SSIS packages for stage I and II using business and transformation rules.
• Handled the exceptions and moved the data into exception tables.
• Performed the performance tuning for SQL SPs.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services, SQL Server Reporting Services

Confidential

Senior Consultant

Responsibilities:

• Involved in the analysis of the issues and proposing the solutions to the client
• Analysis and transformation Data using Business Intelligence
• Developed SSIS packages for stage I and II using business and transformation rules.
• Handled the exceptions and moved the data into exception tables.
• Performed the performance tuning for SSIS packages.
• Developed the SQL queries based on data mapping document and created Indexes for the tables.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services

Confidential

Senior Consultant

Responsibilities:

• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Analyzing the data and requirements from the business and end users.
• Developed data mapping documents for reports.
• Developed report specification documents.
• Design the reports and PPS dashboard.
• Involved in database objects creation like stored procedures, triggers, views and jobs.
• Involved in Report designing, testing and delivery.
• Responsible for timely manner deliverable.
• Wrote unit test cases for Reports.

Environment: Oracle 11g, MS SQL Server 2008 R2, SSAS, SSRS, PPS Dashboard, Composite

Confidential

Senior Consultant

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Analysis and transformation Data using Business Intelligence
• Involved in Report designing, testing and delivery
• Responsible for timely manner deliverable.
• Wrote unit test cases for Reports module.
• Team management activities like task assignments, tasks review, client interaction etc.

Environment: MS SQL Server 2005, SSRS, SSIS, Crystal Report, Vb.NET, PerformancePoint Services

Confidential

Business System Specialist

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Responsible for managing project related to reports.
• Providing online support to clients.
• Involved in Database design, database creation, database objects creation like stored procedures, triggers and views.
• Analysis and transformation Data using Business Intelligence
• Client interaction for system study, requirements gathering and analysis, system design.
• Responsible for timely manner deliverable.
• Wrote unit test cases for Reports module.
• Team management activities like task assignments, tasks review, client interaction etc.

Environment: MS SQL Server 2005, SSRS, SSIS, Crystal Report, Vb.NET

Confidential

Senior Technical Consultant

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Client interaction for system study, requirements gathering and analysis, system design.
• Involved in Database requirements gathering, Database design, database creation, database objects creation like stored procedures, triggers and views. Done the performance tuning.
• Developed Data Migration module using DTS.
• Involved in Report requirements gathering, Report design and delivery
• Responsible for timely manner deliverable.
• Wrote unit test cases for Reports module.

Environment: InterSystem - TrakCare application, InterSystem - Cache database, Sppedminer, SVN Tortoise

Confidential

Report Analyst (Associate Reporting Team Lead)

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Client interaction for system study, requirements gathering and analysis, system design and support.
• Involved in requirements gathering, Database design, database creation, database objects creation i.e. stored procedures, triggers, views
• Involved in Report requirements gathering, Report design and delivery
• Responsible for timely manner deliverable.
• Wrote unit test cases for Reports module.
• Was there at client side for three months for development.

Environment: VB.NET, MS SQL Server 2000/2005, Actuate, MS Reporting Services 2005, Integrated Services (SSIS)

Confidential

Senior Software Engineer

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• One of the members of development team.
• Interaction with client to understand requirements and for delivery.
• Wrote unit test cases for Account module.

Environment: VB.NET, MS SQL Server 2000, DTS, SSIS, Crystal Report 10, MS Reporting Services

Confidential

Senior Software Engineer

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Was one of the members of System Analysis & Design team
• Develop Service Management module.
• Wrote unit test cases for Service Management module.

Environment: VB.NET, MS SQL Server 2000, Navision Attain, C-Front, C/SIDE, MS Reporting Services 2000