SUMMARY

• Over 8 +years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on various projects through all phases of Data Warehouse Development Life Cycle, including, requirement gathering and analysis, design, development, testing, performance tuning, and production support.
• Experienced with Logical and Physical Data Model design process in Star and Snowflake Schema, 3NF.
• Good Experience on Managing, Scheduling, and Monitoring of Informatica workflows.
• Designed and developed complex mappings, from varied transformation logic like Unconnected Connected and dynamic lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Design and Maintain Informatica PowerCenter mappings for extraction, transformation and loading between Oracle, Teradata and Sybase databases.
• Hands on experience in Teradata database with extensive knowledge & scripting skills in BTEQ, MLOAD & FLOAD Utilities.
• Extensively followed Ralph Kimball and Bill Inman Methodologies. Design the Data Mart model with Erwin using Star Schema methodology. Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin. Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved to working in slowly Changing Dimensions type 1, type2 and type 3 based on the requirement. Understanding the Star Schema and Snowflake Schema, relationship between Fact and Dimension tables. Understanding of primary, foreign, compound, and surrogate keys relationship
• 2008/2005/2000 , MS Access 2000, SQL (DQL, DML, DDL, TCL), PL/SQL (Stored Procedure, Function, Package, Trigger, Bulk Load, Autonomous Transaction, Exception Handling), XML and SQL editor (SQL*Plus, TOAD).
• Extensively worked on data migration, data cleansing and data staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Proficient in applying performance tuning concepts to Informatica mappings, session properties, and database.
• Able to provide end - to-end solution architecture for DW / BI solutions in a Teradata MPP environment.
• Leadership in the creation and implementation of data warehouse architecture and systems architecture.
• Teradata architecture/Teradata data modeling/Teradata DBA providing expertise in ETL, Reporting, Performance Tuning and database structures.
• DBA Experience - Roles, Profiles, Query Tuning, TASM, PMON, Hardware Upgrades, etc.
• Experience in generating reports using (reporting tools) COGNOS and BO.
• Possess excellent communication skills both written and verbal, and confident working with stakeholders at all levels.
• Has the ability to build strong professional relationships and a temperament suited to helping others.
• Possess a keen sense of strategic goals and objectives in addition to good business acumen, I'm self-motivated with a delivery focused 'can do' mentality.
• Good Analytical & Problem Solving Skills.
• Good teamwork capabilities.

TECHNICAL SKILLS

ETL: Informatica 9/8.6.1, Ab Initio 2.13/2.12/2.10/2.8 Business Intelligence Business Objects, Cognos

RDBMS: Oracle 7.x/8.x/9i, MS Access 2000, SQL Server 2000/7.0/6.5 , Teradata

Languages: SQL, PL/SQL, Transact-SQL, Java, C, C++, PERL.

Web: HTML, ASP, and JSP.

UNIX Editors: UltraEdit, vi.

Database Tools: Teradata SQL Assistant 6.1, Tpump, FastLoad, MultiLoad, Developer2000 Forms 4.5/5.0/6i, Reports 6i, SQL Loader, TOAD, Quest

Data Modeling Tools: Erwin 3.0/3.5/4.0/4.1 , Visio, Sybase Power Designer

PROFESSIONAL EXPERIENCE

Confidential, Parsippany NJ

ETL Informatica Developer

Responsibilities:

• Prepared functional requirements and detail design specifications for ETL Process and data base designs
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Power Center of Informatica.
• Update Informatica mappings & specs & guide offshore team to do so.
• Involved in analyzing scope of application, defining relationship within & between Groups of data, Star schema and Snowflake schema.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used Informatica mappings to load flat files, oracle to flat files, flat files to oracle, oracle to oracle.
• Created and Monitored Batches and Sessions using Informatica Power Mart Server.
• Performance tuning of Informatica mappings.
• Develops methods to efficiently reuse existing components. Participates in ETL process design and maintenance sessions and using Control-M job scheduler.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Prepare development strategy summary for each data domain, for the proposed changes to that domain, for analytics, reports, and data quality routines.
• Collaborates with team members to resolve issues to assure the successful delivery processes.
• Worked on Power Exchange helping organization unlock mission-critical operational data and deliver it, on demand. Data models with experience in performing gap analysis to identify potential data set modifications and enhancements.
• Successfully moved the Sessions and Batches from the Development environment to Production environment.
• Monitored workflows and session using Power Center and Power Exchange workflows monitor. Used Informatica Scheduler for scheduling the workflows.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Handled release tickets for defects, enhancements, maintenance & system upgrades, and process optimization activities. Reversed engineer and documented existing ETL program codes.
• Performed data quality and integrity testing within EDW and Star Dimensional Model Data Mart
• Products providing high-performance Exchange access to the wide variety of mission-critical data used.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the Data marts (Load Data, Analyze using OLAP tools).
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Implement continuous improvement initiatives within team.

Environment: Informatica 9/8.6,ERWIN (Data Model), Teradata 14.0, Teradata SQL Assistant, TOAD, Sql & Pl/Sql, SSH Secure Shell (FTP tool),Data Marts, IBM DB2 (database), Oracle 10g, CVS (version controlling),UNIX (O/S), XML spy (to generate XML Schema) and Edit plus (IDE).

Confidential, NJ

ETL Informatica Developer/Analyst

Responsibilities:

• Responsible for Business Analysis and Requirements Collection. Gather and analyze business requirements by interacting with business clients and end-users.
• Developed Informatica ETL mappings, sessions, worklets, and workflows.
• Implemented performance tuning of mappings, sources, targets, and sessions and had experience identifying the bottlenecks.
• Extensively used Erwin for Logical / Physical data modeling and Dimensional Data Modeling, and designed Star Schemas.
• Designed and developed Informatica Data Quality (IDQ) for data analysis, data cleansing, data matching and exception handling.
• Extensively worked on transformations like Expression, Router, Dynamic Lookup, Update Strategy, Sorter, Aggregator, Union, Source Qualifier transformations.
• Created reusable mapplets and transformations to maintain row level security across the clients
• Develop Functional requirements (use case modeling), system requirements and design by analyzing the existing Legacy system, other heterogeneous source systems and impact analysis.
• Loaded data into Teradata using Informatica, FastLoad, BTEQ, and FastExport, MultiLoad, and Korn shell scripts.
• Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer. Used Informatica Workflow Manager, Workflow Monitor to create sessions and batches.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues. Enhanced SQLs for performance tuning. Rolled out documentation for the ETL Process.
• Supported the production implementation of the data warehouse, monitored jobs & fixed failed scripts
• Worked on Power Exchange honors the security requirements of all sources, targets, and architectures, and employs industry-standard encryption to maintain security across the chosen architecture.
• Responsible for ETL process under development, test and production environments
• Supporting all the multiple Platforms through high performance environment provided by Power Center, Power Exchange.
• Involved in preparation of the detail level design documents and involved physical Database for development and Designing the ETL architecture.
• Developing Informatica mappings using all transformations and used Informatica Workflow manager to create Session, Workflows to run with the logic embedded in the mappings.
• Guide technical resources of project through design, construction, testing and implementation and Develop and manage BI methodology.
• Provide support and technical guidance to resolve support issues as needed.
• Defining test case scenarios and performing manually executed unit testing. Experience using Load runner to test reports and software batch processes desirable.
• Responsible for the overlap of business requirements with the application and technical architecture.
• Track new trends and directions in technology, and determines potential impact to our Team in the Project.

Environment: Informatica 8.6.1, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert), ERwin Data Modeler, Control-M, Teradata Warehouse Miner, UNIX (o/s), Use cases, RUP, Legacy Systems, Oracle 10g/9i, Autosys, Shell Programming, SQL * Loader, IBM DB2 8.0, Toad, Excel and Unix scripting, Sun Solaris, Windows NT

Confidential, Parsippany NJ

Informatica/Teradata Developer

Responsibilities:

• Documenting various ETL standards to be followed including Informatica and Oracle Design standards.
• Enhancement of codes/Informatica Mappings/Stored Procedures.
• Involved in Data warehouse design to load data in Staging and Datamart
• Creating various Informatica mappings to load data from Staging to Datamart(dimension and fact tables)
• Working on Informatica PowerCenter to create various Type 1 and Type 2 mappings using transformations like Joiner, Lookup, Router, Filter, Union, Sequence Generator, Aggregator and Expression
• Created reusable lookup transformation for mappings which use static tables like Geography and Time dimension tables.
• Worked on different utilities of Teradata like Fast load and M-load.
• Created Worklets and grouped the sessions under the worklet based on the requirements.
• Developed reusable sessions for source reconciliation and target reconciliation.
• Creating workflows and sessions to execute mappings using Workflow manager.
• Extensively worked in using mappings variables, session variables and workflow variables
• Using UNIX parameter files at session and workflow level.
• Worked with various Teradata utilities as external loaders in informatica instead of Relational Connections.
• Working on sessions to be executed in parallel or series based on requirement.
• Working on pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX.
• Walking through each Informatica module and implementing performance tuning logic on sources, targets and sessions.
• Implemented Error handling and Exception handling in Informatica Mapping Designer
• Understanding data quality scenarios from business and implement the same in Staging.
• Creating Design Document, Unit Test Plan and Test case documents for all ETL changes.
• Migrating ETL changes from DEV to QA. Also involved in taking Repository backup to avoid any loss of code being developed.
• Working with QA team providing Developer support and resolving any issues in test environment.
• Executing data loads in DEV and QA and collected statistics for all ETL jobs.

Environment: Informatica Power Center 8.1, MDM, SQL, PL/SQL, Teradata V13, Teradata SQL Assistant, UltraEdit Professional, Windows 2000 Professional, Unix, SVN, Flat files

Confidential, Boston MA

Teradata Developer/DBA

Responsibilities:

• Analyzed the existing Teradata applications for complexity and Enhancement.
• Participated in Joint Analysis Design with user community and Business users
• Creating Teradata objects like Databases, Users, Profiles, Roles, Tables, Views & Macros.
• Used Teradata Manager and Teradata Administrator to Monitor and Manage Teradata Database.
• Performance Analysis of all DW databases was done with appropriate recommendations.
• Physical database design and implementation using logical database model.
• Design, develop and test process for loading cyclical data into a data warehouse
• Working with the users and testing teams to implement the business logic as expected.
• Created tables, access views and update views in the development database for unit and system test.
• Developed FastExport, FastLoad and Multi Load scripts to simulate the environment in development database
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Performed unit and system test for the modified code and loaded shadow data marts for testing prior to production implementation.
• Investigating Space Usage & Monitoring the growth of the databases.
• Executing change requests for DDL & DML statements from the ETL and BI users
• Collecting Statistics using statistics wizard and recollecting the stats by finding the stale statistics.
• Restricted Teradata Manager Users to limited Menus & Options access with manager Profiles.
• Used Teradata Explain to analyze and improve query performance.

Environment: Teradata 12.0, Teradata Manager, Teradata Administrator, SQL Assistant (Queryman), BTEQ, FastLoad, MultiLoad, FastExport, Data Dictionary.

Confidential, Bentonville, Arkansas

Teradata Developer

Responsibilities:

• Extracted data from MySQL database transformed and loaded into Teradata warehouse according to the specifications.
• Developed various mappings and corresponding workflows as specified by the design document.
• Developed the concept of a single, central Last Update Session Table that is used to capture the latest timestamp the data was extracted from MySQL source systems for various target table loads performed on a daily and weekly basis.
• Created multiple complex views that involve a join of about 10 tables with elaborate use of various Teradata SQL functions like CAST, COALESCE etc.
• Developed the Data model primarily in Star Schema design functionality.
• Data is selected as well as updates are performed on the tables in the Sales force application through Teradata Utilities like BTEQ, MLOAD and FEXPORT.
• Participated frequently in the design review discussions and any needed data model changes.
• Involved in Business Analysis meetings.
• Performed extensive Unit and Integration testing of the mappings and integrity of the data loaded into the target tables.

Environment: Teradata 12.0, SQL Assistant (Queryman), BTEQ, FastLoad, MultiLoad, FastExport, UNIX Sun Solaris, WINDOWS 2000

Confidential, Hartford CT

Teradata Developer & DBA

Responsibilities:

• Onshore co-coordinator & lead for APLF project from a development perspective for 3 releases
• Performance tuning of APLF application front end queries generated from SAS & Teradata macros.
• Develop BTEQ/SQL Scripts for APLF and implementation plans and co-ordinate team efforts
• Help in architecture of the new semantic layer summary tables of APLF
• Suggestions to implement PPI/AJIs for performance tuning for Prof & APLF from a developer stand point
• Open up tickets for change control for DDL migrations from DBA perspective.
• In charge of maintaining & setting up environments ( Dev / Test / Model Office / Production)
• Help setup & maintain TASM settings and work with other Teradata consultants to fine tune TASM settings.
• Generate weekly CPPT reports to submit to management.
• Use Atanasoft for DDL validation & compares
• Use Atanasoft for data migrations across environments
• Help in setting up Atanasoft Server settings
• DDL Implementation & Tracking in all environments.
• Worked on hardware upgrade plan of TD13.10
• Performance tuning of front end application queries.
• Making PI, PPI, SI, AJIS changes for performance enhancements.
• User Management ( Roles + Profile Management)
• Review Data Model & provide inputs to the data architect.

Environment: Teradata 12.0/Upgrade 13.0, Ab Initio 2.14, Cognos 8.0, UNIX

Confidential

Teradata Developer

Responsibilities:

• Involved in the Data warehouse Data modeling based on the client requirements.
• Created Data Warehouse Data Modeling used by Erwin.
• Coordinated with the client and gathering the User requirements.
• Involved in Preparing Detailed design and technical documents from the functional specifications
• Prepared low level design documentation for implementing new data elements to EDW.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Managed and administered a Teradata Production and Development Systems
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test.
• Involved in writing views based on user and/or reporting requirements
• Involved in Design, develop and Test process for validation and conditioning data prior to loading into the EDW
• Procedural SQL to troubleshoot the database objects like tables, triggers and procedures.
• Worked extensively on complex Teradata SQL statements
• To validate data on both systems by writing custom BTEQ and oracle SQLs.
• Involved in Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Analyzed data processing functions, methods and procedures
• Worked on enhancements on existing Teradata Data warehouse according to business changes.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Developed whole framework for ETL using PL/SQL to move data from legacy systems
• Modified or enhanced existing ETL processes to include additional client migration requirements

Environment: Teradata V2R6, Teradata Manager, Teradata Administrator, Queryman, BTEQ, FastLoad, FastExport, Informatica, Oracle 10g, SQL, PL/SQL, UNIX.

Confidential

Teradata Developer/Analyst

Responsibilities:

• Creating Logical Model & extended logical model and converting logical model to Physical Model
• Involved in the Database entities and attributes identification and wrote creation scripts for the database objects like Tables, Views and designing PI and secondary indexes.
• Extensively Involved in Preparing Detailed technical documents from the functional specifications
• Involved in the Optimization of Teradata loading scripts which resulted in substantial performance improvement for the conversion processes.
• Data modeling, database design and creation of data mart using data modeling tools and Creation of Data Flow diagrams and Entity Relation Diagrams using Erwin
• Developed different algorithms for data synchronization, migration, cleaning and insertion
• Defined UNIX shell scripts for file comparisons & file manipulations
• Extensively used FastExport, FastLoad, MultiLoad and Tpump based on data requirements and table structures
• Performance tuning of Report queries using explain results
• Performed Data validation and Data integrity checks on the data mart
• Working with QC and UAT teams for respect team approvals
• Working with offshore team for development and administrative activities
• Working with Teradata DBAs on automated scripts for stats collections on tables, indexes and columns
• Developed the end-user documentation and performed periodic updates of the design documents.
• Involved in Application Maintenance and Production Support

Environment: Teradata V2R6, Informatica Power Center, Unix Shell Scripts, SQL Assistant (Queryman), BTEQ, FastLoad, MultiLoad, FastExport, Data Dictionary, AIX 5.3, FTP, Putty, Word, Excel, PowerPoint, Visio, JIRA, Erwin, Clearcase, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Provided estimates for the ETL requirements.
• Interacted with client to understand the business requirements by conference calls and teleconference meetings
• Reviewed the designed document with designer and resolved the queries and issues found in design documents
• Design, Develop, & Implement ETL processes.
• Unit Testing Of ETL Process
• Analyze & document performance characteristics of the ETL processes to support the development of production job schedule
• Help testing team to create appropriate test cases based on business requirements to ensure good quality data load processing
• Provide detailed status reporting on development cycle
• Develop ETL mappings in Informatica to load EDW
• Analyze SQL associated with database Views to improve performance characteristics
• Recommended an implementation strategy (including criteria for use) for deployment of database Views
• Assisted new team members to understand the basic knowledge of the project and provide knowledge transfer sessions.

Environment: Teradata V2R5, Informatica 7.1, Siebel, Business Objects 6.5

Confidential, Columbus Ohio

Teradata Developer

Responsibilities:

• Collaborate with data architects to instantiate EDW 3NF (third normal form) physical data model
• Design, Develop, & Implement ETL processes.
• Unit Testing Of ETL Process
• Provide detailed status reporting on development cycle
• Create test cases to ensure good quality data load processing
• Tuning the SQL Queries and Unit and Integration Testing of the tables, views n macros developed

Environment: Teradata V2R4, Teradata SQL Assistant, BTEQ, MLoad, FLoad, Business Objects 6.5, Informatica 7.1, UNIX

Confidential

ETL Developer & Tester

Responsibilities:

• Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer, Transformations Developer, workflow designer, worklets designer and task developer.
• Worked with various Informatica Power Center objects like Mappings, Reusable transformations, Mapplets, Workflows, and Session Tasks.
• Developed various complex mappings that contain the business rules for the server during the extract, transform and load process by using various Active and passive transformations
• Worked with different task like sessions, email and command.
• Extensively used mapping parameters, mapping variables and parameter files for implementation of Incremental Loading.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Involved in performance tuning in different levels.
• ETL process is scheduled depends on business requirements.

Environment: Informatica Power Center 5.1, Oracle 8i, PL/SQL, Toad, UNIX