SUMMARY

• 15+ years of team leadership, technology integration, solution design, strategic planning, training and mentoring team sizes of 7 - 15 consultants (Offshore and Domestic).
• Corporate-wise database design and data integrity maintenance/Oracle 10g and 11g, DB2, Neteeza, Teradata, PL/SQL, XML Schemas, TOAD, SQL Server 2005, DB2, Java, C++, .NET, etc.
• Data Warehouse, Data Mart Design, Relational and Star Schema (Kimball) Data Modeling using Erwin 9.2 and ER-Studio.
• ETL design and development using Informatica 7.1/8.0, DataStage 8.5 and 8.7, 9.1, 11.3 (Info Analyzer, Business Glossary), Ab Initio, DTS.
• BI tools/Cognos 8.0, Framework Manager, Powerplay Transformer.
• Architecture: TOGAF

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, California

Lead ETL/DataStage Consultant

Responsibilities:

• Lead on supporting Indirect Tax Reporting Analytics for Confidential Europe.
• Overseeing overall ETL roadmap and architecture in designing DataStage based ETL infrastructure to populate the data warehouse for reporting needs.
• Overseeing the technical activities and review designs and code of other ETL developers.
• Establishing InfoSphere 11.3 DataStage boarding request with Confidential data services, creating GSA cloud folders, setting up DataStage projects and environment variables.
• Assisting and providing technical guidance to other team members.
• Reviewing and evaluating data repository strategies, data warehouse, Datalake and POC design.
• ER-StudioCollaborate with QA Leads on test strategies and test planning.

Environment: Confidential InfoSphere 11.3, DataStage, QualityStage, DB2 9, 7, QMF 11.2, Cognos 10.1, JCL, COBOL, MAINFRAME, ER-Studio

Confidential, Harford Connecticut

Technical Lead/Solution Architect

Responsibilities:

• Developed enterprise data models that promote reusability and standardization in the enterprise data warehouse.
• Developed pragmatic enterprise data solutions that support project and enterprise level data strategies.
• Collaborated with requirements analyst leads to develop and clarify in-depth technical requirements.
• Participated in all phases of the ETL development lifecycle including unit testing and ongoing support using DataStage 9.1, 11.3.
• Oversaw the technical activities and review designs and code of other ETL developers.
• Collaborated with QA Leads on test strategies and test planning.
• Worked on conceptual and physical modeling using Erwin 9.2 for the new DW and reporting systems.
• Participated in the data stewardship process.

Environment: Erwin 9.2, UNIX, Confidential InfoSphere 9.1, 11.3, DB2 9, 7, SQL*Plus, TOAD, Cognos 10.1, JCL, COBOL, MAINFRAME

Confidential, Livonia Michigan

Data Architect/Data Warehouse and BI

Responsibilities:

• Remodeled current legacy systems and migrated them into new DW and Guideware.
• Data cleansing and conversion for DB2, Supra and Oracle into Teradata.
• Conceptual and physical modeling using Erwin for the new DW and reporting systems.
• Involved in preparing coding standards documentation and data mappings for DataStage development.

Confidential

Solution Architect/Data Warehouse and BI

Responsibilities:

• Lead team of 9 resources in deployment and production support; manage internal communications with end-users and internal clients as well as third party partners.
• Responsible for staging tables, input tables, output tables as well as reporting database,
• Metadata design for Cognos BI reporting for end users (flash reports, metrics, and BI dashboards, ad-hocs, etc.).
• Architectural design using Erwin for logical/physical design and maintenance/enforcement of the integrity of all schemas is the daily work.
• XML schemas for data definitions for ETL data load, data parsing.
• Cognos metadata design in different phases to accommodate incoming data sources and end user requirements.
• Participated in all phases of project cycle including requirement analysis, client interaction, design, coding, testing, production support and documentation.
• Involved in gathering business requirements and providing development and testing estimation, timelines and resource forecasting.
• Involved in preparing the coding standards documentation for DataStage development.
• Involved in designing complex Parallel DataStage jobs, sequencers.
• Used DataStage XML input stage for processing banks hierarchical files.
• Involved in extracting the data from various sources like Flat files, Oracle and Teradata databases.
• Familiar with BTEQ, Fast load, Fast export concepts in Teradata.
• Involved in developing Key Data validation and splitting modules using DataStage in financial data processing project for various sources files coming from different source systems.
• Used multiple invocation techniques for running jobs in various instances so as to reduce the time and expediting the processes.
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Utilized slowly changing dimensions for tracking changes to dimensions over time.
• Used Data stage Administrator for defining environment variables and project level settings.
• Utilized the stages of job sequence such as User Variable Activity, Notification Activity, Routine Activity, and Terminator Activity.
• Responsible for validating the DataStage jobs, sequencers against the pre-defined ETL design standards.
• Involved in developing Connect direct jobs for transferring files to the downstream systems and for pulling files from the source systems as well.
• Involved in DataStage jobs bug fixing and supporting testing team during various stages of testing.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Experience in preparing and reviewing Functional Test Plans and Master Test Plans for various stages of the testing activities.
• Responsible for preparing various test scenarios and validating the data as per the business rules.
• Involved in preparing and executing System Testing and System Integration test cases.
• Provided support during User Acceptance Testing by running jobs and providing fixes.
• Coordinate the offshore development, testing and implementations using implementation plans.
• Responsible for doing the peer reviews, planning and estimating the project requirements and to report the status to business managers.

Environment: Confidential WebSphere DataStage 8.1 Designer, Director, Administrator, and Manager

Confidential

Responsibilities:

• Led Exadata infrastructure upgrades and migrations from Oracle/HPC to Oracle/Exadata, Oracle 10g to 11g2, and UNIX Solaris to Linux.
• ActivePivot, reviewed vendor product ActivePivot to replace Cognos Query Studio.

Environment: ERwin, Oracle 10g, SQL*Plus, TOAD, Cognos 8.0/Framework Manager/Report Studio, SQL Server 2005

Confidential

Technical Systems Analyst

Responsibilities:

• Extensively used DataStage client components like Data Stage Designer, Director, Manager and Administrator in Data Warehouse development.
• Performed system conversion from legacy system to Confidential system (Ingenium, Fineos), logical and physical data modeling for staging databases.
• Architecture design on transactions from Mainframe to DB2 then to SQL Server, multiple platform transitions.
• Created logical and physical data models using ERwin®/ERX, for staging databases and for OLAP or data warehouse databases.
• Identified Primary Key Resolution criteria with multiple data sources from transactional and historical data feeds.
• Established data cleansing / scrub criteria, by defining domains for many data elements.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed the Data Mart defining entities, attributes and relationships between them.
• Defined various facts and dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.

Environment: UNIX, Windows 2000, Confidential DataStage 8.6, Oracle 10g, SQL*Plus, TOAD, Cognos 8.0

Confidential

Solution Architect

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Created mappings to move from Various Systems (CRM, OLTP) to Transaction History database (Reporting Database).
• Developed standard and re-usable mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created, updated and maintained ETL technical documentation.
• Created procedures and packages.
• Used PMCMD command/ Confidential MAESTRO/Control-M for running Informatica from backend.
• Was part of scripting team for shell script to automate and migrate data from ODS to Data Warehouse.
• Responsible for creating business solutions for Incremental and full loads.
• Loaded aggregated fact tables.
• Managed software releases after each stage of the testing and defect removal.
• Requirement gathering and business analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Designed and developed Informatica Mappings to load data from source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like parameter files, variables and dynamic cache.
• Performance tuning using round robin, hash auto key, key range partitioning.
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using UNIX Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Created related schemas, namespace, and query subject to develop cubes in Framework Manager.
• Designed and developed IQD file and cube model utilizing Framework Manager and Transformer respectively.
• Created associated data source/cube in Cognos 8 portal and configured connection to the Power Cube.
• Published packages to the portal to be accessed by Analysis Studio and Report Studio.

Environment: UNIX, Windows 2000, Informatica PowerCenter 7.1.2/8.0, Oracle 10g, SQL*Plus, TOAD, Cognos 8.0

Confidential, Tucson, Arizona

Oracle and Java Developer

Responsibilities:

• Involved technologies included JDBC, Java Servlet, EJB, and J2EE.
• Systems Architect for multiple WebSphere projects. Setup WebSphere Application Server testing, staging and production environment.
• Configured multi-server environments.
• Used Rational Rose for the documentation and design phase of the application.
• Worked on a single sign-on (SS0) Project to facilitate a user's ability to access multiple applications through a single session.

Environment: Java, J2EE, JSP, JDBC, GUI, MS Project, Visio, Oracle, PL/SQL