SUMMARY

• Bachelors of Science in CIS
• Over 18 years database development, maintenance and support
• Experience with Data warehouse design
• Knowledgeable in Program Management methodologies
• Extensive knowledge and experience with ETL tools Informatica (Powercenter 8.x, 9.x, 10.x)
• Ad - hoc query support
• Organized and detail oriented
• Excellent oral and written communication skills
• Has held a Public Trust Clearance
• Currently holding a Secret Clearance
• Contract work for Army National Guard, Department Of Homeland Security/ICE
• Walter Reed, Office Of Personnel Management(OPM), DCMA, Confidential, DHA

PROFESSIONAL EXPERIENCE

Confidential, VA

Lead Informatica SME (Contract)

Responsibilities:

• Import/Export Production modules via Repository Manager
• Import Unix scripts on production server
• Review, Execute Unix scripts via su
• Review production logs for problem resolution
• Restart production applications after failure
• Shutdown/restart Infa services
• Monitor production applications
• Resolve/escalate production data issues
• Administrate/Upgrade Informatica Applications
• Install and configure Informatica
• Create repository backups
• STIG checklist compliance
• LDAP connectivity
• 24x7 on-call support
• User crontab as scheduler

Confidential, Va

Sr. ETL Developer/Administrator (Contract)

Responsibilities:

• Creating ETL mapping using Informatica 9.6/10.1
• Performed Unit testing
• Analyze source/target details for data consistency
• Create user in Informatica Administrator console
• Recycle Integration service
• Shutdown/restart Infa services
• Install client/server hotfixes
• STIG cchecklist compliance
• Develop mappings, sessions workflows etc.
• Create shell scripts for file manipulation and workflow execution
• User crontab as scheduler

Confidential, Md

ETL Developer (Contract)

Responsibilities:

• Created ETL mapping using Pervasive
• Created Process flow for ETL mapping execution
• Applied business rules for data manipulation/calculation
• Used SQL Server 2008 to create temporary staging tables
• Performed Unit testing
• Performed Code reviews
• Analyze source details for data consistency

Confidential, DC

ETL Developer/IT Consultant (Contract)

Responsibilities:

• Create mappings in Informatica for fact and dimension builds
• Successfully executed ETL loading procedures
• Created sessions and workflows
• Executed existing Q/A checks to ensure Oracle database was prepared for loading
• Monitored workflow execution and assisted in problem resolution
• Use Trillium for new source data profiling
• Analyze new source details for consistency
• Write design documentation for process explanation

Confidential, Va

Senior Principal Database Engineer (Contract)

Responsibilities:

• Gathering source data via MSAccess and MS SQL Server
• Creating new fact tables
• Creating ETL fact builds for source data population in to data warehouse using Cognos 8
• Performance tuning T-SQL code into SQL
• Create Impromptu Query Definition(IQD) for reporting Using Cognos Framework Manager
• Model table relationships using Cognos Framework Manager

Confidential, DC

Lead Programmer/Analyst (Contract)

Responsibilities:

• Write SQL(Oracle/TOAD) to simulate ETL and to regression test system.
• Perform Informatica unit, system and acceptance testing of all workflows for the AMSA Data Warehouse.
• Create and maintain Informatica workflows, worklets, sessions and tasks for the AMSA Data Warehouse.
• Process files in Unix for initial data integrity testing
• Update system documentation for any maintenance or new development
• Assist in creating system documentation for government approval.
• Run Informatica ETL workflows for file processing and Data Warehouse population.
• Define programming timelines for management and project leaders.
• Create software connections for database connection.
• Present problems and long term solutions during system analysis meetings.
• Work with junior programmers and Project Manager providing specs and testing criteria

Confidential, Va

Systems Consultant; ETL Programmer Analyst (Contract)

Responsibilities:

• Write SQL(Oracle/TOAD) to simulate ETL and to regression test system.
• Perform Informatica unit, system and acceptance testing of all workflows for the Human Resources/Payroll Data Warehouse.
• Create and maintain Informatica workflows, worklets, sessions and tasks for the Human Resources/Payroll Data Warehouse.
• Process files in Unix for initial data integrity testing
• Update system documentation for any maintenance or new development
• Run Unix scripts for file extraction
• Assist in creating system documentation for government approval.
• Run Informatica ETL workflows for file processing and Data Warehouse population.
• Define programming timelines for management and project leaders.
• Create software connections for database connection.
• Give programming presentations to discuss ideas and implementation

Confidential, Md

ETL Programmer Analyst

Responsibilities:

• Perform Informatica unit, system and acceptance testing of all workflows for the Consumer Marketing Database.
• Create and maintain Informatica workflows, worklets, sessions and tasks for the Consumer Marketing Database.
• 24 hour primary on-call
• Update system documentation for any maintenance or new development
• Run Unix scripts for file extraction
• Run Informatica ETL workflows for file processing and data warehouse population for the Consumer Marketing Database
• Write SQL(Oracle/TOAD) to validate ETL process.

Confidential, DC

Programmer Analyst

Responsibilities:

• Perform unit, system and acceptance testing of all work orders
• Mentor new team members
• 24 hour primary on-call
• Update documentation per work order
• Ad-hoc reporting
• Made modifications and created new programs using Easytrieve and Cobol
• Wrote COBOL programs to further process Medicare/Medicaid claims.
• Modified COBOL programs to look for standardized medical terminology/HIPPA.

Confidential, Md

Applications Programmer

Responsibilities:

• Create and maintain new CICS screens using DB2 for new Chain Accounts System.
• Create Sales Data warehouse using Oracle 8i and UNIX.
• Create Sql queries for data validation Sales Data warehouse fact table.
• Create and submit UNIX shell scripts for execution of Oracle Warehouse Builder maps to populate data warehousing tables.
• Create, maintain and provide internal customer support for Credit Score system using IMS.
• Used Endeavor to maintain COBOL programs/copybook/JCL integrity. Also, used endeavor to promote COBOL programs/program specific information from testing areas to production and vice versa.
• Maintain CICS and provide internal customer support online motor vehicle reporting system using VSAM files.
• Modify existing SAS programs to manipulate data for reporting purposes.
• Generate morning report for overnight production runs.
• Test and present retention software for the Real Estate and Facilities Management director.
• Attend batch improvement group meeting to discuss ways to improve on the nightly batch cycles and discuss the effects of the new jobs going into production.
• Create, maintain and provide internal customer support new On-Line Pricing Matrix system for Motor Vehicle Reporting using DB2(SQL) and CICS.

Confidential, Ohio

Programmer Analyst II

Responsibilities:

• Perform design, development, documentation, maintenance and implementation of JCL jobs on an OS/390 mainframe system using VSAM files.
• Perform analysis of customer requirements for EDI project to achieve tactical and strategic business goals while meeting established deadlines. Work on project team to merge information from different states to a central location for bank statements.

Confidential

Programmer Analyst

Responsibilities:

• Perform design, development, documentation, maintenance and implementation of COBOL, JCL, and CICS programs on a retail MVS/TSO mainframe system using VSAM files.
• Work on project teams to perform updates that increase the efficiency and productivity of the customer’s system.
• Demonstrate professional oral and written communication skills during presentations of business proposals.
• Create and implement a new Payroll system using CICS.

TECHNICAL SKILLS

• CICS, COBOL, JCL, DB2, SQL Easytrieve SPUFI, AIX
• OWB(Oracle Warehouse Builder), Informatica 7.x/8.x/9.x ETL Process, Oracle 8i/9i/10g/11, Unix, Trillium(Data Profiling), Cognos8 Data Manager, Cognos8 Framework Manager
• TOAD, EDI, SDF II, Omegamon, File-Aid, Endeavor, Xpeditor, SYNCSORT
• Full SDLC Project Management skills
• Database and VSAM skills
• Completed 1 week Informatica PowerCenter 7.x training