Data Architect/Analyst - ETL Architect - Developer Designer

An Enterprise Data Warehouse professional with 15 years track record of success completing projects timely and on budget. Remarkable Data Warehousing experience serving in different capacities: Dimensional and relational modeling ETL architecting and development, as well as designing Business Intelligence cube. Possess ability to tackle and deliver desired results in enterprise data integration of discrete sources. A well respected team-player with attributes that enable to rise to the challenges of the Information Technology.

TECHNICAL EXPERTISE

Technologies: Databases: SQL Server 2012/ 2008/2005/2000, Oracle 11g/10g/9i/8i/7.3, Teradata, DB2 UDB, MS Access

Design Tools: ERwin, Business Objects Designer

Development Tools: Informatica PowerCenter, SSIS, MSDTS, DataStage

Reporting Tools: Tableau, Business Objects, SQL Server Reporting Services SSRS

Languages: SQL, PL/SQL, T-SQL, UNIX shell script, Visual Basic, Macros with VBA

Frameworks: SQL Assistant, SecureCRT, RefelectionX, Aquo Data Studio, Toad, QMF for Windows, Exceed, Maestro, Autosys, PL/SQL Developer, Tidal, OEM, Visual SourceSafe

Platforms: Windows 7/vista/XP/2000/98 , UNIX Sun Solaris, AIX, HPUX

Methods: Relational and Dimensional Modeling, ETL Design, DW Lifecycle, Software Development Lifecycle, Object-Oriented Design

Training courses: Informatica, ERwin, SAP BI / BW, SAP / FICO, ScrumMaster

Industries: Airlines, Public Health, Insurance, Aerospace, Banking, Telecommunications, Finance, Manufacturing

PROFESSIONAL EMPLOYMENT HISTORY

Confidential

Senior Informatica Developer/Architect

• Architect new and reverse engineer existing ETL processes. Design, develop, and unit test ETL processes involving data from differing RDBMSs of diverse sources. Profiling, cleansing, and analyzing data.
• Re-architected existing ETL processes that in return streamlined data warehousing
• Architected, developed and unit tested efficient Informatica mappings and mappletes that propel big volume of data into data mart.
• Modified existing mappings, mappletes, and Sessions reducing processing time thereby increasing output.
• Conducted extensive data profiling to cleansing, conforming and transforming massive data that is critical to the business.
• Performed Peer Review, conducted Unit and System Integrated Testing SIT and provided technical advice to other Developers

Confidential

Senior Data Warehouse Developer

Design and develop data conversion and Integration ETL solutions for complex functional and technical requirements. Assist in the installation/upgrade of Informatica-SAP Connector/Adaptor. Design and develop data models. Implement best practices and methodologies in data analysis, design and modeling.

• Enhanced existing ETL architecture by re-structuring and re-grouping numerous Informatica objects
• Streamlined error handling process that enabled to segregate records based on severity levels of error.
• Designed, developed and deployed ETL process that captures cleanses and standardizes various data feeds collected from different data providers.

Confidential

• Designed, and developed re-usable INFA mappings and mapplets using various transformations
• Using Informatica 9.1.0 version, developed, tested and implemented numerous ETL processes
• Architected and modeled relational and dimensional data structures.
• Devised ETL strategy for converting and loading legacy data to SAP BW.
• Performed data analysis, architected, and created database objects.
• Developed software migration strategies and procedures for production deployment.
• Involved in business analysis sessions to put together achievable technical solutions to convert, and integrate various data sources.

Confidential

Senior Data Warehouse Developer

• Designed, developed and maintained numerous Informatica mappings /sessions / workflows
• Identified performance bottlenecks and tuned Informatica sessions creating efficient ETL process
• Utilizing complex Informatica objects, captured data error records, corrected the errors and loaded into target system
• Assisted Informatica Administrator responding to developers' requests and fixing system errors
• Conducted extensive analysis of numerous data sources Oracle, SQL Server, and SAP
• Created / revised data models and re-architected data flow for efficiency
• Using the Designer, created several Business Objects Universes
• Developed Web Intelligence reports making use of several queries
• Created Process Flow, RunBook, and reference documents for future use

Confidential

Translate business requirements into database objects responsible for the design, structure, organization, development and deployment of databases. Provide on-going support and maintenance of data. Assist in addressing reporting requests.Created conceptual, logical and physical data models to capture, store and publish critical data elements. Worked extensively on reverse engineering processes and created DDL scripts for implementing data model changes. Generated ERwin reports in HTML, RTF, and PDF format depending upon the requirement, published Data model in model mart, co-coordinated with DBAs to apply the data model changes. Created / maintained / modified database design document with detailed description of logical entities and physical tables. Worked on data profiling and data validation to ensure the accuracy of the dataAuthored a database reference document and contributed to the internal DA knowledge repository for use across the team

Confidential

Senior DW/BI Application Developer

• Review existing business processes, identify shortfall and create new or modify existing processes Responsible to install and utilize the newly purchased Informatica software
• Re-designed Sales Commission process by consolidating and/or eliminating steps which reduced processing time by up to 75
• Designed and created database objects that houses Internap Sales, Revenue, and Commission data helping the company migrate to a single RDBMS that is easily manageable and cost effective
• Designed and created numerous Informatica mappings and workflows enabling Internap utilize its newly purchased Informatica software
• Created several source to target mappings
• Trained and mentored Internap's Developers on how to utilize Informatica efficiently.

Confidential

IT Staff Consultant

Architect and develop Informatica objects. Responsible for analyzing, cleansing, conforming, transforming and loading data expected to provide support in database design, development, and data management

• Designed, created and developed numerous ETL Informatica mappings and workflows that helped achieve goal by reducing load time by at least 30
• Thoroughly analyzed data sources, applied required business logics loading data to its target in an effort to consolidate data to a single environment
• Developed efficient executable scripts enabling automation of the ETL processes
• Streamlined and tuned credit card transaction ETL process
• Redesigned the mappings and workflows of Call Center Data Capture ETL process to conform to changing business rules.
• Modified Oracle SQL scripts significantly improving performance
• Updated massive Call Center historical data to comply with the new business rule
• Developed strategy to capture, store, correct and reprocess bad data

Confidential

ETL Architect

Create a standard ETL process monitor and review ETL processes prior to deployment. Assist in the purchase of new software. Responsible for installation and upgrade of ETL tool manage migration of existing ETL applications.

• Created a stable, timely, maintainable and extensible ETL framework introducing uniformity across the board
• Conducted peer code reviews to help utilize efficient Informatica objects that adhere to a standard and consistent format
• Performed data architect and data analysis tasks thereby modeling the logical and physical Enterprise Data
• Provided mentoring and guidance to ETL developers on Data Warehousing methodologies
• Researched, selected, and tested software to provide pros and cons of data warehouse tools to management
• Worked collaboratively with Business Objects administrator on designing effective Universe dramatically decreasing query return time.
• Successfully upgraded Informatica Repositories during two separate upgrades Version 6.1 to 7.1.3 and from Version 7.1.3 to 8.1.1.

ETL Developer

• Played a major role in launching the first Enterprise Data Warehouse in American Cancer Society
• Designed, developed and implemented ETL processes using Informatica that extract from diverse data sources and load organized dimensions and massive fact data into Oracle Database that reduced costs by about 18 .
• Delivered cleansed and conformed data for various Oracle data marts reducing Business Objects processing time while enabling users retrieve data easily and quickly.
• Performed detail data analysis to integrating data and to tuning SQL scripts.
• Provided regular and periodic production support for Data Warehouse load processes.
• Worked closely with the Data Architect: Modeling data, analyzing source and target databases, gathering business requirements, evaluating system and hardware resources.
• Created and maintained Data Flow Diagrams, Process RunBook, and Unit Acceptance Testing documents.

Confidential

IT Professional

Develop, implement, and support applications that support Cargill's business. Gathering requirements and business rules and interpret them to technical solutions

• Identified strategies for scaling applications based on business requirements, software functionality, database expansion and optimization
• Created array of processes using VB, Excel Macros, and Unix Shell Scripts to capturing row data from different sources thereby providing traders with variety of information that enabled them conduct power and gas trades effectively in the market place.
• Designed, developed and integrated processes that pull internal data to extrapolate and measure the financial risk of Cargill's electric business at a specific point in time.
• Reduced failures in live applications by implementing new development and staging environments and setting policies for scheduled deployments
• Worked in Collaboration with external data providers to identifying necessary business attributes required.

Confidential

Programmer Analyst II

Create new applications or modify existing applications. Analyze internal and external data to determine impact on application process. When/if data related issues arise identify the problem, work with data owner to solve business problem.

• Designed, developed and tested applications for business information analysis.
• Created and implemented DataStage jobs which extracted data from Relational Database sources, and external FTP sites ultimately loading it into the Oracle Database after cleaning and conforming the data.
• Integrated multiple software to automate data load: Programmed by UNIX shell script using DataStage ETL tool loaded to Oracle database scheduled to run via Tidal software.
• Developed new VB application that allowed users to key in different values of attributes returning projected sales that enabled Market Analysts broaden their strategic planning capability.

Programmer Analyst I

• Created interface for data entry and modified existing applications
• Built front-end VBA macros that assign unique code for every product in each product category that standardized data across different divisions enabling Enterprise Data Management team serve its customers better than prior to the invention of these macros.
• Enhanced performance of existing Visual Basic application by modifying the source code and adding more procedures and functions.

Information Systems Intern

• Maintained intranet website, monitored and documented activities of UNIX servers
• Worked on Enterprise Data Warehouse information board website by uploading metadata and other necessary information.
• Assisted DBAs by monitoring and documenting activities of Oracle database on multiple servers as measured by Patrol software. Documentation used as reference by all Programmers, System Analysts and DBAs.