TECHNICAL SKILLS:

Operating Systems: HP - UX, Linux, Windows

Databases: Oracle, DB/2, PostgreSQL, SQL Server

Languages: Python, SQL*PLUS, PL/SQL, SQL*Loader, UNIX/Linux Shell Scripting, Perl

Scheduling Tools: Control-M, Crontab

Applications: Informatica PowerCenter, Informatica PowerExchange, Informatica Developer

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

INFORMATICA DEVELOPER

• Responsible to meet with business stakeholders and other technical team members to gather and analyze application requirements.
• Designed and customized data models for data warehouse supporting data from multiple sources on real time. Involved in building the ETL architecture and source to target mapping to load data into data warehouse.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experienced at creating effective test data and development thorough unit test cases to ensure successful execution of the data.
• Advanced problem determination and resolution of complex scenarios with our ETL developers related to Informatica, scripting, security, database query development, performance, issuance, etc .
• Work with peers at State Farm from various areas, Informatica user group community, and the vendor to define system processes like coding standards, documentation, knowledge sharing sessions, best practices, etc.
• Accountable for t eaching new and keeping existing developers up to date on the Informatica tool suite, best practices, and techniques used in the industry to provide an effective and efficient Informatica solutions.
• Create Python, Perl, and Linux scripts to perform operations that are not suited will for Informatica to perform. This includes things like a Perl script to convert tabs in an Excel document to CSV flat files, a Python script to extract data out of LDAP to meet security requirements, a Linux script to use a database loader program, etc.
• Work with ETL developers on creating data maps in PowerExchange to interact with GDGs, PDS, and VSAM files on the IBM Mainframe.
• Responsible for business analysis, requirements gathering, and build ing ETL source to target specification documents based on the business data collected for various projects. Then, breaking down the design specification into simple ETL Workflows and Mappings that perform extraction, transformation, and loads of source data into a desired target. This involves the use of any of the many Informatica transformations like aggregator, filter, router, joiners, expressions, etc. to meet business logic and create robust mappings in Informatica.
• Involved in dimensional modeling (Star Schema) of the Data warehouse to design the business process, dimensions, and measured facts. This involves interacting with Data Modelers and Business Analysts.
• Extensive use of SQL and database performance knowledge to extract or load data from or into relational databases such as, Oracle, DB/2, PostgreSQL, and SQL Server.
• Use of various SQL* loaders from Oracle, DB/2, PostgreSQL, and SQL Server to load or unload data.
• Create and maintain, mainly Type 1, and 2 slow changing dimensions mappings used in the data warehouse.
• Tune Informatica mappings to identify bottlenecks on targets, sources, and session to optimize performance to achieve maximum efficiency.
• Prepared and implement issuance documents and process to move the Informatica Workflows and Linux scripts from development to testing, and then through to production.

Confidential, Anderson, IN

ASSISTANT DIRECTOR

• Oversee all IT functions including data center management, integrity of data, system security, vendor relationships, technical support, application development, and disaster recovery while managing the operating budget and directing activities of 30+ staff and student workers.
• Accountable for developing strategic initiatives concerning information technology, implementation, and support of IT systems, architecture, application development, and hardware acquisitions.
• As a strategic business partner working with business unit heads to create a business strategy and discover how to best leverage technologies, applications, and new techniques while minimizing risk. In order to accomplish this, I consult with and advise clients concerning specific data processing procedures and feasibility of using information-processing tools. I performed comprehensive studies and analysis of data processing functions, methods, and procedures and makes recommendations concerning the feasibility of revising existing operations or adapting new applications or technologies for data processing solutions.
• Challenged to improve productivity and reduce costs through enhanced use of technology I collaborate with department managers to analyze and document process and system workflows. I authored a plan to improve software development process, consolidate and upgrade servers, and establish consistent hardware and software standards to eliminate unstable, highly mixed operating environment. This resulted in:
• Increased server’s uptime from 80% to 98%.
• Reduced software downtime to less than 2% by decreasing defects though new development methods and testing processes.
• Decreased manual processed by the use of workflow and creating efficiencies through merging IT teams while improving services 30% which resulted in lower overhead costs and the eventual reduction in operational cost.
• Altered staffing model to include a third shift operation to improve delivery time of data. This lighted the workload and stress on the other two shifts while allowing for better prioritizing of the processing workload.
• Implemented the use of several shareware software products including Linux operating system to reduce cost.
• Designed a new technology platform to support the student administrative system incorporating key components including imaging, automated workflow, redesigned client interfaces and databases.

Confidential, Round Rock, TX

PROGRAM MANAGER

• In charge of the worldwide management of the Dell storage software development and delivery.
• Managed the planning, scope, budget, timeframe, and execution of the cross-functional teams involved in the integrated software and SAN solutions.
• Served as a focal point and provided the communication link between the core teams and upper management.
• Worked closely with the engineering development managers and extended teams to meet the requirements set forth in the Business Contract for each project and each product.
• Facilitating program meetings, created and maintained cross-functional schedules and plans, managing program risks, and ensuring all project documentation kept up to date, archived, and communicated to all the teams on a timely basis.
• Represented the team during internal and external audits.