We provide IT Staff Augmentation Services!

Enterprise Etl/data Architect Resume

NY

SUMMARY

  • Results - driven IT executive offering a strong balance between business savvy and technical capabilities.
  • Possess a proven track record of 20+ years of lT leadership experience in the financial services, technology consulting and Pharma industries.
  • Serve as an organizational change agent, starting up, turning around and developing IT organizations into key drivers of business and revenue growth.
  • Skillfully manage the entire lifecycle of global software development and data integration projects to ensure the on time and within budget delivery of high-quality solutions.
  • Leverage expertise in technology roadmapping, budgeting, product development, process improvement and service quality optimization to align all aspects of IT operations with business goals and customer objectives.
  • Capitalize on superior communication and interpersonal skills to develop valuable relationships with clients, vendors and all members of an organization.
  • Build and spearhead top-performing virtual teams, providing the strategic direction, guidance and support needed to meet and exceed both client and business expectations.

TECHNICAL SKILLS

INFORMATICA: PowerCenter, IDQ, Designer, Repository Manager, Administrator, MDM

Business Reporting: Business Objects

TRILLIUM: Name and address standardization

CASE TOOLS: ERWIN, PROVISION, VISIO and System Architect for Conceptual, Physical, Logical Modelling and Dimensional Modelling using Star Schema, COBOLII, CICS, JCL, VSAM, SQL, PL/SQL, SQL*Plus, TOAD, MS-PROJECT, XML, UNIX,LINUX, SHELL SCRIPT, JAVA, HTML, JSP, SERVLETS, .NET

VERSIONING TOOLS: Star Team, Source Integrity, PVCS, Changeman, Librarian

Data Warehousing: Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x,MDM

CRM: Extensive training on Siebel with workshop experience conducted by Confidential and approved by Siebel System. This included configuration, design of data model, gap analysis, and EIM manager.

Databases: Oracle 10g/9i/8i, MS SQL Server, DB2 (ver 5)

Software & Languages: Informatica, Certified Workshop and Training in Siebel Tools and Administration Organized by Confidential and Siebel Inc., Oracle PL/SQL, COBOL, CICS, DB2, SQL, DBA TOOLS, MVS, VS-COBOL, QMF, FILE AID, XPEDITER, Test Director, Dimensions, Business Object.

Hardware & Operating Systems: Linux, Windows, ES-9000 series of Confidential with operating system of MVS (Multiple virtual storage). OS2 operating system

PROFESSIONAL EXPERIENCE

Confidential

ENTERPRISE ETL/Data Architect

Responsibilities:

  • Obtained Business buy in by demonstrating the need for the re-architecture, explaining the short term and long term benefits and presenting a cost vs. benefit analysis
  • Involved in creation of complete ETL/MDM framework for the enterprise using Informatica PC,PowerExch,B2B(ver 9.x), IDQ
  • Architected the Audit Balance & Control process, Designed and Developed the components and Integrated with all ongoing projects.
  • Created a Standard development Framework to reduce development time and put an automated regression process in place to improve QA efficiencies
  • Managed the Project in an iterative process using a combination of Agile and SDLC, designed to deliver results every few weeks
  • Design the whole ETL/MDM architecture
  • Worked closely with the Middleware group
  • Built Database/Data Mart /Match Merge Rules
  • Introduce best practice methodologies involving the Data Warehouse/MDM
  • Identify user requirements, hardware sizing information, training requirements,

Confidential

Technical Lead/Solution Architect

Responsibilities:

  • Lead a team of 16 developers
  • Involved in building the whole ETL/MDM architecture using Informatica PC (ver 9.x), IDQ
  • Involved in coordination, process control, active participation with the MDM hub team
  • Loading data to the MDM Hub Landing and Staging tables from various sources . Like Web services, Databases, Xl, Third party tools etc
  • Designed and developed source, target and the transformation rules (business rules to generate the consolidated (Star schema, Dimensional, Fact, and Summary) data using Informatica ETLMDM(Syperian) (Power Mart/ Center) tool.
  • Worked very closely with the data modelling team

Confidential

Data Architect/Technical Lead

Responsibilities:

  • Obtained Business buy in by demonstrating the need for the re-architecture, explaining the short term and long term benefits and presenting a cost vs. benefit analysis
  • Evaluated external vendors against home grown products to provide a MDM solution for centralizing product Information and reference data
  • Managed a team of Onshore developers to convert two Asset Classes to Informatica and provided Production support using an Offshore Team
  • Designed the High level Architecture for the project and laid out the conversion strategy
  • Created a Standard development Framework to reduce development time and put an automated regression process in place to improve QA efficiencies
  • Managed the Project in an iterative process using a combination of Agile and SDLC, designed to deliver results every few weeks
  • Managed direct reports, and reviewed their annual performance
  • Lead Vendor Negotiations to obtain Informatica Licenses within budget
  • Integrated with Actuate and .Net front ends to provide UI and dashboard features
  • Managed project Finances and funding.
  • Design the ETL architecture using Informatica PowerCenter (ver 9.x)
  • Introduce best practice methodologies involving the Data Warehouse
  • Identify user requirements, hardware sizing information, training requirements.
  • Design a POC for the Mortgage Asset class involving the latest BI tools(Informatica)
  • Actively participate in the hiring process for ETL developers, BA, Data Modellers and Report writers
  • Create a concrete and detailed project plan indicating the finishing date for the data warehousing project.

Confidential

Technical Architect

Responsibilities:

  • Lead a team of 19 developers
  • Involved in building the whole ETL architecture
  • Involved in coordination, process control, quality assurance(SOX) and delivery . Active participation and presentation for making the product SOX compliant
  • Loading data to the Oracle Staging tables from multiple data sources: Oracle 9i and Text files using Informatica Powercenter 7, parameterising the Informatica environment
  • Designed and developed source, target and the transformation rules (business rules to generate the consolidated (Star schema, Dimensional, Fact, and Summary) data using Informatica ETL (Power Mart/Center) tool.
  • Wrote Oracle Stored Procedures, Functions, and Packages, to meet the needs for the ETL process, and the generation of dynamic SQL.
  • Wrote shell scripts for validating the records and creating “header and trailer” records for validation and statistical purposes.
  • Maintained the Informatica shared folder for the sources and targets, and created shortcuts from the shared folder.
  • Writing test scripts .
  • Working with Business Analysts to define functional areas and creating Gap analysis documents.
  • Creating and modifying existing Technical Specification document and other client deliverables for different releases
  • Development of Informatica mappings with the use of the various Informatica transformations - Look up, Stored Procedure, Router, Update Strategy, Joiner, Sorter, Normalizer, Filter, Expression, Aggregator, Rank, Source Qualifier, Source definitions, Target Definitions
  • Creating Workflows and system documentation.
  • Created Corporate Metadata repository for ETL jobs using the Informatica Repository tables
  • Running, scheduling and monitoring workflow through work flow manager and Workflow Monitor.

Confidential - NY

Technical Architect

Responsibilities:

  • Lead a team of 4 developers
  • Prepare timelines for ETL project
  • Successful extraction of data from ARISg (or an ARISg standby database) to the Global Safety Data Warehouse, with the potential to expand to other source databases in future phases
  • Successful, daily feed of data from the Global Safety Data Warehouse to the PfAST Data Mart,
  • A central administrative dashboard, containing data such as business metadata, technical metadata, error logs and ETL process information, and front-end usage audit information.
  • A reporting and querying application, populated by the PfAST Data Mart, that allows the end-user to easily run standard reports and queries with optimal performance,
  • A reporting and querying application, populated by the PfAST Data Mart, that allows the end-user to easily run ad-hoc reports and queries with optimal performance,
  • Data visualizations, advanced statistical analysis and text search tools (future phases), and
  • Data to be provided to the Signal Detection application
  • Used business requirements and functional specifications to generate logical data models and Data Integration objects using star schema approach for the data warehouse and data mart..
  • Analyzed source system data and designed different transformations and Gap Analysis documents.
  • Performed Internal and external data source Identification, Data Analysis, and meta-data specification, data integrity (i.e., quality) assessment and data extraction design created multi-dimensional logical models and designed and implemented physical databases
  • Designed, developed and unit-tested mappings and used transformations- Lookup, Join, Aggregator, Sequence Generator, Mapplet, Router, Rank, Filter, Source Qualifier and Update Strategy using Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation designer.
  • Developed Stored Procedures, Functions and Packages using Oracle PL/SQL for complex business logic and called them in Informatica mappings.
  • Developed Post and Pre SQL Stored Procedures using Oracle PL/SQL in Informatica for building and dropping Indexes.
  • Developed Stored Procedures using Oracle PL/SQL for Checksum Regression functionality for the test team.
  • Writing test scripts using Test Director for Unit/System/Integration/UAT testing
  • Working with Business Analysts to define functional areas and creating Gap analysis documents.
  • Creating and modifying existing Technical Specification document and other client deliverables for different releases
  • Created Corporate Metadata repository for ETL jobs using the Informatica Repository tables
  • Using Dimensions for configuration management
  • Assisted in fine-tuning transformations for increased performance and efficiency.
  • Assisted the Quality Assurance team in developing test-scripts for end-to-end process testing.
  • Post production maintenance and support.
  • Used Business Object as an OLAP tool for reporting. Performance tuning SQL used by BO

Confidential

Technical Architect

Responsibilities:

  • Loaded data to the Oracle Staging tables from multiple data sources (Legacy) Oracle 8i.
  • Designed and developed source, target and the transformation rules (business rules to generate the consolidated (Dimensional, Fact, and Summary) data using the Informatica, ETL (Power Mart/ Power Center) tool.
  • Involved in the development of Informatica mappings with the use of the various Informatica transformations - Look up, Stored Procedure, Router, Update Strategy, Joiner, Sorter, Normalizer, Filter, Expression, Aggregator, Rank, Source Qualifier, Source definitions, Target Definitions
  • Creating Workflows and system documentation.

Confidential - Bridgewater, NJ

Technical Architect

Responsibilities:

  • Lead a team of 5 developers (ETL, TIBCO & Siebel)
  • Prepared project timelines
  • Involved in the end-to-end design of the ETL and Siebel application for Samples interfaces.
  • Used Siebel Tools and Siebel Applications (E pharma) for building the interface design for Samples.
  • Created multi-dimensional logical models and designed and implemented physical databases
  • Loading data to the Oracle Staging tables from multiple data sources: Oracle 8i, Text files and Excel Spreadsheets using Informatica.
  • Designed and developed source, target and the transformation rules (business rules to generate the consolidated (Star schema, Dimensional, Fact, and Summary) data using Informatica ETL (Power Mart/Center) tool.
  • Loaded the EIM tables for Siebel data source through Informatica.
  • Wrote Oracle Stored Procedures, Functions, and Packages, to meet the needs for the ETL process, and the generation of dynamic SQL.
  • Wrote shell scripts for validating the records and creating “header and trailer” records for validation and statistical purposes.
  • Maintained the Informatica shared folder for the sources and targets, and created shortcuts from the shared folder.
  • Writing test scripts using Test Director for Unit/System/Integration/UAT testing
  • Working with Business Analysts to define functional areas and creating Gap analysis documents.
  • Creating and modifying existing Technical Specification document and other client deliverables for different releases
  • Development of Informatica mappings with the use of the various Informatica transformations - Look up, Stored Procedure, Router, Update Strategy, Joiner, Sorter, Normalizer, Filter, Expression, Aggregator, Rank, Source Qualifier, Source definitions, Target Definitions
  • Creating Workflows and system documentation.
  • Created Corporate Metadata repository for ETL jobs using the Informatica Repository tables
  • Running, scheduling and monitoring workflow through work flow manager and Workflow Monitor.
  • Used Informatica repository manager for backup, and Informatica designer to export the Informatica mappings as a backup for the mappings.
Technical Architect

Confidential - Morristown, NJ

Responsibilities:

  • Used business requirements and functional specifications to generate logical data models and Data Integration objects.
  • Analyzed source system data and designed different transformations and Gap Analysis documents .
  • Designed, developed and unit-tested mappings and used transformations- Lookup, Join, Aggregator, Sequence Generator, Mapplet, Router, Rank, Filter, Source Qualifier and Update Strategy using Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation designer.
  • Assisted in fine-tuning transformations for increased performance and efficiency.
  • Assisted the Quality Assurance team in developing test-scripts for end-to-end process testing.
  • Post production maintenance and support.

Confidential

Systems Analyst

Responsibilities:

  • Developed ETL Mappings with Business Critical validations.
  • Worked with the senior DBA in creating test and development environments for ETL development.
  • Loaded the data into test and development environments using SQL server as the database.
  • Designed, developed and unit-tested mappings and used transformations - Lookup, Join, Aggregator, Sequence Generator, Mapplet, Router, Rank, Filter, Source Qualifier and Update Strategy using Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation designer.
  • Created test cases to test the data in target the data warehouse with the source systems postproduction maintenance and support.

Confidential

Systems Analyst

Responsibilities:

  • Involved in a project of IT systems in CICS/COBOL for a major insurance firm ( Confidential Cross Confidential Shield).
  • Keeps track of all the claims registered through this system, throughout the state. It has interfaces with systems in other states as well.

Confidential

Application Manager/Team Lead/Sr Architect/Sr Developer

Responsibilities:

  • As a key person in the Application support group for a payroll system, was involved in development of payroll processing for all levels of employees ensuring accurate monthly production runs. This job also involved fine-tuning of existing DB2 and non-DB2 applications, simplifying the existing procedures, assessing new requirements with user interaction and development of MIS report. Involved in the development of online batch programs in CICS/COBOL, VS-COBOL II and CSP in program development group, which is the central pool of programmers. The main objective of the group is to develop quality applications as per specifications provided by the different ISP teams.
  • Worked on a Wage revision module during a wage revision carried out in 1995 from 1992. This resulted in arrears payment to the employees that were to be done by the organization. This module covered the DA arrears computation not only for the normal employees but even for the superannuated and discharged employees. This module involved massive computation of various types for over 50,000 employees of a major steel company. My responsibility was that of a developer and also for testing and implementation of DA Arrears system.
  • Recruited to develop a single, authoritative source of high-quality information that would enable business leaders to easily access and analyze data related to product, portfolio, HR, supply chain and general ledger management.
  • Worked on an Income tax module that was envisaged to streamline income tax related activities and brings tax calculation for all types of employees under one umbrella. Excellent querying and entry facilities, on-line batch submission and tax calculation for any category of employees and certificate printing activities are provided in this module. Security blanket on category and group to control unauthorized access to data and aforesaid activities is available. Involved in analysis, design and development of applications and design of security system.

Hire Now