SUMMARY

• Over SEVENTEEN 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: Fast Load, Multi Load, Fast Export, BTEQ.

ETL: MSBI (Analysis - SSAS, Integration - SSIS and Reporting Services - SSRS).

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: Tableau, Crystal Reports, Acutate, Power Pivot, SharePoint and Performance Point Services, Intersystem - Cache database, Speed miner.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer /Technology Specialist

Responsibilities:

• Use independent judgment on requirement. Done an analysis and prepared approach document for a complete DWH solution.
• Design the perfect software coding standards, guidelines, and technology best practices
• Created Stored Procedures, Functions, Views and Triggers.
• Performed optimization for SQL procedures.
• Design and created SSIS packages to load data into DWH.
• Design and created SSAS cubes with hierarchies, aggregations, calculations, KPIs, Actions and Partitions.
• Design and created SSRS reports in different format.
• Created MDX queries to build SSRS reports.
• Responsible for delivery of all technical (non-functional) requirements in the release
• Owns all technology architecture deliverables in the program

Environment: SSIS, SSRS, SSAS 2010 and 2012, SQL Server

Confidential

SQL Developer /Technology Specialist

Responsibilities:

• Use independent judgment on requirement. Done an analysis and prepared approach document for a complete DWH solution.
• Design the perfect software coding standards, guidelines, and technology best practices
• Created Stored Procedures, Functions, Views and Triggers.
• Performed optimization for SQL procedures.
• Design and created SSIS packages to load data into DWH.
• Design and created SSAS cubes with hierarchies, aggregations, calculations, KPIs, Actions and Partitions.
• Design and created SSRS reports in different format.
• Created MDX queries to build SSRS reports.
• Responsible for delivery of all technical (non-functional) requirements in the release
• Owns all technology architecture deliverables in the program

Environment: SSIS, SSRS 2010 and 2012, SQL Server

Confidential

SQL Developer /Technology Specialist

Responsibilities:

• Use independent judgment on requirement. Done an analysis and prepared approach document for a complete DWH solution.
• Design the perfect software coding standards, guidelines, and technology best practices
• Created Stored Procedures, Functions, Views and Triggers.
• Performed optimization for SQL procedures.
• Design and created SSIS packages to load data into DWH.
• Design and created SSAS cubes with hierarchies, aggregations, calculations, KPIs, Actions and Partitions.
• Design and created Tableau reports in different format.
• Responsible for delivery of all technical (non-functional) requirements in the release
• Owns all technology architecture deliverables in the program

Environment: SSIS, SSAS 2008 R2 and 2012, SQL Server, Tableau, Pentahoand SAP - BI

Confidential

SQL Developer /Technology Specialist

Responsibilities:

• 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

Environment: MS SQL Server 2008 R2 and 2012, SSIS, SSAS, SSRS, PPS, Power BI and Teradata

Confidential

Senior Consultant

Responsibilities:

• Involved in database design / preparing SQL scripts to support the larger databases that involves terabytes of data. Involved in design and 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 and views 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 CSE Factbook 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.