SUMMARY:

• IT professional with over 15 years experience in a database production environment specializing in project management, Analysis, BI Reporting, HADOOP, Hive with a focus on data warehousing in financial, telecommunication, and insurance.
• Designed technical processes by working with analytical team to gather requirements and create specification.
• Coded programs in DB2, Oracle databases, HIVE, Informatica and HADOOP. I Have a Bachelor of Science Degree in Management Information Systems from Confidential .

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.1, Informatica Developer, Informatica Administrator, SQL*Loader

BI & Reporting: Business Objects 6.5 Crystal Reports xi/6.x, working knowledge of Cognos 8.4, Hyperion, Microstrategy

Data Modeling: Erwin 7.3, Logical, Physical, Relational, ER Diagrams and Dimensional Data Modeling

Big Data: Apache HADOOP, Apache HIVE

Databases: Oracle 10g/9i, MS SQL Server 2008, Teradata, DB2.

Others: Unix Shell Scripting, SQL, PL/SQL,ANSI SQL, SQL*Plus, HTML 4.0,ODBC,SSIS, Quest TOAD, Tivoli scheduler, Autosys, Appworx.

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Senior ETL HADOOP Developer

Responsibilities:

• Design and develop new ETL Informatica processes to from Confidential ’s source systems to HADOOP.
• Coordinate with outsource developers for new coding requirements.
• Mentoring employees on Confidential Big Data environment mentor program.
• Successfully completed SAS project to connect to Hive tables for reporting.
• Write UNIX scripts to manipulate files and data in UNIX and HADOOP.
• Create Oracle SQL adhoc used to audit the system.
• Coordinate consulting developers and Confidential resources on a daily schedule to insure production implementation schedule will be met.
• Position requires research of root cause and design solutions of production issues.
• Research and design performance improvements.
• Contribute ideas in weekly design sessions.
• Create production morning report.

Environment: Informatica Administrator, Informatica Power center 9.6, Informatica Developer, Oracle SQL, HADOOP File System, Hive, UNIX/LINUX, Oracle, HP Service Manager (Incident Manager), Administrator.

Confidential, Saint Louis, MO

BI Consultant

Responsibilities:

• Design and Developed ETL process from legacy system to new Teradata tables.
• Created Informatica power center workflows and SQL scripts.
• Design and develop reports for business users.
• Develop new database tables and views.

Environment: Teradata, Informatica, SQL scripts, Microstrategy, Appworx

Confidential, Troy, MO

Database Administrator/ETL/Reporting

Responsibilities:

• Developed ETL process from legacy system to new TruckMate transportation and Logistics system.
• Evaluate and redesign the refrigerated warehouse management system.
• Design and develop reports for transportation, warehouse, and shop systems..
• Design and develop new PaperWise electric document system which allowed truck drivers to submit documents using a smart phone App so the documents are sent directly to electric document processing.

Environment: SQL Server 2005, DB2 i, DB2 LUW, Qua Data Studio, TruckMate, Paperwise

Confidential, St. Louis, MO

Senior Programmer Analyst, Business Intelligence - Data Warehouse

Responsibilities:

• Designed and developed new ETL processes to move data from Lord & Taylor and Confidential databases into the Data Warehouse.
• Model and analyze data from a computing technical and specific business process viewpoint; integrated the data into a computing system and application architecture.
• Participated in the design of the technical and architecture for the data warehouse.
• Worked closely with business intelligent group to develop reports.
• Created project and technical documentation including procedures and standards.
• Developed and maintain Teradata Views, Tables, SQL script for EDW.
• Created Data Mappings of ETL process and wrote specifications.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well a performance turning of mappings and sessions.
• Coordinate with off shore developers.

Environment: Oracle 10g, Teradata 13, Informatica PowerCenter 9.1, Designer (ETL), Workflow Manager (ETL), Workflow Monitor, Unix, PuTTY, MS Office 2007, WinSCP 4.1

Confidential, St. Louis, MO

Data Warehouse Developer/Analyst

Responsibilities:

• Analyzed user request and developed a solution.
• Extracted source data from variety of sources.
• Gathered, defined and communicated project requirements and functional specifications to business and development staff in a clear, comprehensive manner.
• ETL design, development, testing, and promotion tasks.
• Designed and developed new data warehouse tables.
• Created SQL scripts to analyze data in data warehouse.
• Informatica mappings and database performance tuning.
• Performance tuning.
• Created deployment and source to target documentation.
• Wrote test scripts unit and user acceptance testing.
• Unit and parallel test Informatica Mappings and workflows.
• Conducted peer walk-throughs.

Environment: Oracle 9, Informatica PowerCenter 9, Designer (ETL), Workflow Manager (ETL), Workflow Monitor, Oracle SQL Server, Stored Procedures, AppWorx, MS Office 2000

Confidential, St. Louis, MO

ETL-Informatica Developer/Data Analyst

Responsibilities:

• All legacy data was extracted, transformed and loaded to new data warehouse.
• Established. Standards for data warehouse and informatica.
• Performed ETL design, development, testing, and promotion tasks.
• Analyzed Informix Stored Procedures to determine best method to convert Stored Procedures to Informatica Mappings.
• Evaluated Informix Stored Procedures to determine the estimated time required to completed each mapping and workflows.
• Unit and parallel test Informatica mappings and workflows.
• Conducted peer walk-throughs.

Environment: Oracle 10g, Informatica PowerCenter 9, Designer (ETL), Workflow Manager (ETL), Workflow Monitor, Unix, Oracle SQL Developer 2.1, PuTTY, Informix 2.5, Informix Stored Procedures, Informix DB access, MS Office 2007, WinSCP 4.1

Confidential, St. Louis, MO

Data Analyst/Developer

Responsibilities:

• Designed and developed JavaScript front-end with DB2 back-end application.
• Analysis of business requirements and creation of technical specifications, testing plans, testing conditions/expected results, and implementation plans
• Created Ad-Hoc SQL reports.
• Architect of data access layer to DB2 tables.
• Data Modeling of DB2 tables.
• Data Mapping of ETL process.
• Data Migration.

Environment: Oracle 10g, DB2, CA ERwin (data modeling), Unix, SQL, PL/SQL, OLAP, COBOL, IDMS, SQL*Loader, Platinum for DB2, AutoSys.

Confidential, Moscow Mills, MO

Responsibilities:

• Oversaw contracts bids.
• Ordering construction material.
• Planned and Managed project schedule.
• Managed contractors in all phases of construction.

Confidential, St. Louis, MO

Data Warehouse Developer

Responsibilities:

• Developed relational data models and migration strategies for the project.
• Led the Account Activity Data Warehouse project, which entailed determining what tasks were needed to complete project and assigning tasks to developers and users.
• Responsible for update meetings every 2 weeks with department managers to discuss the progress of the project and to develop and manage project scope.
• Account Activity Data Warehouse involved the development of relational data models and migration strategies for the project.
• Oversaw the requirements, design, implementation, and maintenance of the database applications.
• Analyzed, designed, coded, and tested SQL and PL/SQL programs in a Unix environment.
• Created multiple table joins to extract information for users.
• Account activity data warehouse involved development of relational data models and migration strategies for the project; migrated data to data warehouse.
• Developed tables and materialized views in the data warehouse.

Environment: Oracle 10g, DB2, CA ERwin (data modeling), Unix, SQL, PL/SQL, OLAP, COBOL, IDMS, SQL*Loader, Platinum for DB2, AutoSys

Confidential, St. Louis, MO

Programmer Analyst ETL Data Warehouse

Responsibilities:

• Coordinated designed and implemented applications, collaborating with project managers and business stakeholders to ensure completion of project deliverables.
• Managed project schedule, task, milestones, resources and maintained MS Project.
• Managed the design, development and implementation of an ETL process that extracted data from Oracle to enterprise data warehouse.
• Data model to develop new Oracle table structures using ERwin.
• Designed and developed data flows and data interface specifications to ensure data integrity.
• Diagnosed problems, created ad-hoc reports and find solutions to meet user requirements
• Supported data extraction through SQL, Hyperion, Crystal Reports and developed custom reports from the simple to complex table joins.
• Created ad-hoc analysis for review as requested by department and business line management. Resolved report tickets after new claim system was implemented into production data from legacy system to Oracle tables for new claim system.

Environment: Oracle 9g data, DB2, MS SQL 2000, Informatica PowerCenter 8.1.1 Designer (ETL), Workflow Manager (ETL), Workflow Monitor, Workflow Designer, CA ERwin (data modeling), Siebel Tools, Cognos, Crystal Reporting, Unix, PL/SQL, WinSQL, TOAD, OLAP, COBOL, Microsoft Virtual Server, Oracle, Tivoli scheduler.