SUMMARY:

• Over 12+ Years of strong IT experience in Data Warehousing, Databases & Decision Support Systems.
• Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center 8.6./9.5.1, Teradata, Oracle 9i & 10g, SQL Server 2000/2005, SSIS,SSRS,SSAS and Salesforce.
• Presently working as DW BI architect in Accenture.
• Took lead Solution architect role in dealing with clients, program managers and IT team
• Translate business requirements into detailed architectures and designs
• Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
• Solid experience translating business requirements into conceptual, logical, and physical data models.
• Implement best practices and methodologies in data analysis, design and modeling.
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms.
• Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
• Design standards for using normalized data structures, de - normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.
• Analyze software & configuration requirements & articulate specifications.
• Create use case strategies, and when necessary, help to create test strategies.
• Producing technical feasibility studies. Providing security consultancy & best practices for securing Microsoft platforms.
• Conducting product overview presentations. complex systems on client site.
• Solution development and technical consultancy across a broad technology spectrum.
• Involved in all phases of Software Development Life Cycle in Data warehousing and Date Integration projects.
• Exclusive experience of SQL and BTEQ in Teradata, Oracle, PL/SQL, SQL server, DB2 as RDBMS with Procedures, Functions and SQL * Plus
• Good Experience on Salesforce objects and their creation.
• Extensively worked on BTEQ, MULTILOAD and FASTLOAD, FAST EXPORT, PDO utilities in Teradata.
• Extensively worked on BTEQ scripts in Teradata using UNIX to override the Informatica code that causes performance issues.
• Have good hands on experience in tuning Teradata scripts by using explain plans.
• Optimized the Oracle queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, and constraints.
• Good understanding of warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Heavily interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts. Dealt with Type1/Type2/Type3 loads.
• Possess good understanding of Conceptual, Logical and Physical designs and familiar with ER diagrams.
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 4.x/3.x.
• Experience in Integration of various data sources like Teradata, Oracle, DB2, Sybase, SQL Server and Flat Files.
• Resolved product issues. Used features like Pre-Session/Post-Session commands/sql for fine-tuning of Databases/Data marts, Mappings, Sessions, Various Parameters in oracle and Informatica to get optimal performance.
• Followed a high level of quality processes and documentation in compliance with CMM Level 5 for all the projects with Detailed design doc, code review, Traceability matrix, defect tracker, EWS,Unit test cases documents, Assembly test cases etc..
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Have good hands on Clear Case as a Configuration management tools, for maintaining the project related documents and their versioning system.
• Hands on experience in scheduling UNIX scripts, Teradata BTEQ scripts and Informtica workflows.
• Good knowledge on Teradata Macros, BTEQ scripts & Utilities like Multi load, Fast load…etc.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.

TECHNICAL SKILLS:

Data Warehouse Tools: Informatica Power Center 9.5, SSIS, ERWIN Data Modeler

Business Intelligence Tools: SSRS,SSAS

RDBMS: Oracle8i, DB2, SQL Server, Teradata

Design Tools: ERWIN Data Modeler

Programming Languages: UNIX Shell Scripting,.NET

CRM: Salesforce, Siebel 7

Scheduling Tool: Control M, ESP

Operating Systems: Sun Solaris UNIX, Linux, DOS, Windows 95/98/NT/2000/XP/Win-7

PROFESSIONAL EXPERIENCE:

Confidential - Fort Worth, TX

DWH Architect

Responsibilities:

• Performed Solution Architecture Design for various Business-to-Business and System-to-System Data Integration and Transformation, business process translation, implementation and maintenance, technical leadership.
• Performed Data modeling and Enterprise data architecture design for data warehouse and business intelligence solution for Alcon - including all phases of Data modeling - Conceptual, Logical and Physical using both relational and dimensional approaches as well as design and implementation of ETL Architectures across various product suites.
• Performed design of data interface and implementation of data integration between Salesforce.com, Siebel and SAP.
• Designed and Developed Data Integration and Reporting Module for this project
• Translate business requirements into detailed architectures and designs
• Designed and implemented Data Foundation Layer and Business Layer modelling for Scheduled, on-demand and dashboard reporting as well as ad-hoc reporting structures using SSRS
• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations
• Develop solution cost structure by identifying all cost points including labor, software and hardware
• Implement architectural designs while building solid relationships with stakeholders at all levels
• Work with functional analysts, developers and development managers to ensure that all solutions are deployed within agreed timelines and supported after delivery
• Identify where exceptions to the enterprise architecture standards are required.
• Architecting & implementing enterprise & business segment BI solutions.
• Architecting & implementing enterprise & business segment OLTP solutions.
• Provided IP management leadership and oversight of the software development process
• Oversaw design of applications from functional and technical specifications
• Recommended and assisted with development of standards and project frameworks and provided guidance to vendors
• Ensured on-time, quality release of systems and components.
• Design the database using ERWIN
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including SQL server.
• Involved in Database deign to normalized the data in 1 N,2 N and 3 N form.
• Worked with Solutions Architect to ensure smooth translation of requirements into applications
• Worked closely with business stakeholders to determine product prototypes
• Mentor junior developers

Environment: Informatica Power Center 9.5.1, SalesForce.com, SSIS, SSRS Teradata, SQL server UNIX Shell Scripting, Control M Scheduling Tool and Windows XP, Seibel

Confidential - Milwaukee, WI

DWH Architect

Responsibilities:

• Take lead architecture role in dealing with clients, program managers and IT team
• Translate business requirements into detailed architectures and designs
• Performed Solution Architecture Design for various Business-to-Business and System-to-System Data Integration and Transformation, business process translation, implementation and maintenance, technical leadership.
• Performed Data modeling and Enterprise data architecture design for data warehouse and business intelligence solution for Alcon - including all phases of Data modeling - Conceptual, Logical and Physical using both relational and dimensional approaches as well as design and implementation of ETL Architectures across various product suites.
• Performed design of data interface and implementation of data integration between Salesforce.com, Siebel and SAP.
• Designed and Developed Data Integration and Reporting Module for this project
• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations
• Develop solution cost structure by identifying all cost points including labor, software and hardware
• I was given Lead architect role by the client, which includes, involving in Business requirement discussion, understanding the requirements from Business team, pass on the requirements to offshore dev team and lead the project from Design, Dev, Unit testing and Deployment. I am Single point of contact for all the project I drive.
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Understand the business parameters that could influence performance (data sizes, complexity, concurrent executions .. etc)
• Responsible for implementing the Informatica/Teradata CDC logic to Process the delta data.
• Involved in the creation of Informatica mappings to extracting data from oracle, Sql server, Flat Files to load in to Stage area. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like TPT, MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Owning all the code migrations/reviews includes Informatica, UNIX shell scripts, DB objects and ESP migrations.
• Carry out Defect Analysis and fixing of bugs raised by the Users
• Highly motivated with the ability to work effectively in teams as well as independently
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle,DB2 andTeradata.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including SQL server.
• Involved in Database deign to normalized the data in 1 N,2 N and 3 N form
• Design the database using ERWIN

Environment: Informatica Power Center 8.6.1/9.5.1, Teradata, UNIX Shell Scripting, ESP Scheduling Tool and Windows XP

Confidential

Senior Technical lead

Responsibilities:

• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations
• Develop solution cost structure by identifying all cost points including labor, software and hardware
• I was given Lead architect role by the client, which includes, involving in Business requirement discussion, understanding the requirements from Business team, pass on the requirements to offshore dev team and lead the project from Design, Dev, Unit testing and Deployment. I am Single point of contact for all the project I drive.
• Provide first level production support, inclusive of incident & problem ticket management
• Performance tuning and preventative maintenance of MetaSolv application
• Implementing Enhancements to the current MetaSolv application
• Design, Develop and Implement the Work Requests (WRs).
• Responsible for utilizing technological analysis and design principles to formulate detailed application plans and processes in order to implement clients' requests for new or modified functionalities.
• Analyze clients' requests for new or modified applications through interviews and design sessions.
• Plan, develop and test proposed enhancements with client interaction for verification.
• Monitor performance and functionality throughout the implementation process by testing applications to ensure optimum user benefits, design and configure application modifications and enhancements as necessary.
• Implement the integration and customization of customer-specific system packages.
• Development of SSIS packages.
• Development of Reports using Webfocus and SSRS
• Code Development & bug fixing
• Monitoring the data refresh process and maintaining a Production
• Migrating the data form one database to another database (Ex Oracel to SQL server)
• Determine the data quality standards for the organization and ensure adherence of the processes data to these standards
• Conduct research as required to judge the authenticity of the data. Make corrections, wherever required
• Recommend modifications in the data management process, policies and standards, to improve cost effectiveness and time effectiveness of the processes
• Make certain the errors or inefficiencies detected within the data are corrected immediately to ensure timely completion of projects
• Helping the team members to complete their deliverables on time.

Environment: SSIS, SSRS, SSAS, SQL server 2005 and Metasolv

Confidential

Team Lead

Responsibilities:

• Code Development & bug fixing of Front-End with all the features to interact with the user.
• Development of ETLs using SSIS packages.
• Monitoing the data referesh process and maintaining a Production and Mirror database.
• Development of Cubes using SSAS.
• Development of Reports using SSRS.
• Provided daily based status updates to Immediate Supervisor onshore/ offshore.
• Analysis of the data flow in the project and providing the knowledge transfer to the team members.
• Helping the team members to complete their deliverables on time.
• Technologies Used: SQL Server 2008 - SSIS, SSRS, SSAS, Visual Studio 2008 C#.net and experience in Web Designing
• Report Development - Component Art and Dundas

Environment: SSIS, SSRS, SSAS, SQL server 2005

Confidential

Senior Developer

Responsibilities:

• Development & bug fixing of Front-End with all the features to interact with the user.
• Coordinating with the On-site for the project requirements.
• Participate in planning & task delegation.
• Provided daily based status updates to Immediate Supervisor onshore/ offshore.
• Analysis of the data flow in the project and providing the knowledge transfer to the team members.

Environment: C#.NET, ASP.NET with 2.0 Net Framework, Commerce Server 2007, SQL Server 2005

Confidential

Senior Developer

Responsibilities:

• Involved in the development of 20 sites which related to the Manufacturing / Distribution domain. This involved development in a team of 30 people. The technologies involved were C#, ASP.Net, Content Management Server and Commerce Server.
• Process Implementation: Involved in the project-wide implementation of a code analysis tool (FxCop).
• Deployment: Deploying the latest builds to different servers in different environments after testing.
• Knowledge Sharing: Handling sessions on Content Management Server and Commerce Server for the new joiners.
• Ensure web-based application is compatible with IE and Mozilla, develop page layout, generate code, and debug code.
• Handled total site along with some other resources.
• Had experience in developing DTS Packages in MS Sqlserver 2005

Environment: CMS, SharePoint,C#.nert, VB.net and SQL server

Confidential

Developer

Responsibilities:

• E-Commerce Application.
• Mainly intended for shopping cart users.
• Unique feature of layout changing dynamically upon selection is incorporated.
• Integration with Payment Gateway Interface (Version) for credit card payment is incorporated.
• Component based approach for reusability.
• Third party components like file upload and mail components implemented successfully.
• Both admin Module and User Module developed and separated.
• Categories and Subcategories can be added dynamically through admin side.
• User Roles and Privileges given.
• In homepage the content and Images are developed dynamically using database.
• Involved in defining architecture of the application and interacting with client and involved in analysis

Environment: ASP. Net, 2000, IIS, SQL Server 2000, IIS 6.0,Windows 2000 Server