SUMMARY:

• Advanced in PL/SQL, SQL, Analytic SQL and Dynamic SQL.
• Experienced in Oracle Spatial Geometry, Oracle Change Data Capture (CDC), SQL*Loader and External Table.
• Constructed numerous Triggers, Stored Procedures, Functions & Packages.
• Proven accomplishments in physical/logical modeling using Erwin, data analysis/data profiling.
• Proficient in data cleansing and data conversion.
• Issue solver - solving complicated problems with simple and effective solutions.
• Good knowledge in Unix Korn Shell scripting, Semaphore.
• In depth knowledge in building Data Warehousing and Relational Database Systems.
• Coded ETL using PL/SQL and Informatica.
• Commanded advanced performance tuning knowledge in ETL and SQL.
• Designed ETL Architecture Designed ETL Strategy
• Adopted the best of Kimball and Inmon ETL strategies.
• Efficient Star/Snowflake schema design.
• Maintained data integrity by defining primary and foreign reference keys.
• Developed ETL Do & Don’t standards.
• Setup tracking numbers for each record for the ease of retrieving the problematic rows for debugging.
• Provided robustness - easy to restart a failed session/job.
• Created type I, II & III slow changing dimensions (SCD)
• Identified and tuned performance bottlenecks for sources, targets, mappings and sessions.
• Used parameterized connections with global settings for all source and target databases.
• Tuned sessions using process partitioning, pipe files, external loaders, dropping and recreating indexes.
• Scheduled jobs in Informatica Workflow Manager using commands, event waits, decision trees, emails and timers.
• Forward thinking with strong business sense.
• Created Oracle SDO geometry layers.
• Created Business Objects Universes and canned reports from Web Intelligence.
• Ability to validate the completeness, integrity and accuracy of master, detail and “drill through” reports.
• Advanced understanding and practical experience on large scale IT infrastructure.
• Flexible in working hours and locations.

TECHNICAL SKILLS:

Enterprise System: Insurance Provider Management System, Manufacturing ERP, Field Service Management

Database: Oracle 10g/9i, MS SQL Server 2005/2000, IBM DB2, MySQL 4.1

Language: SQL, PL/SQL, T-SQL, XML, Korn Shell, ASP, PHP

Database Tool: TOAD

ETL Tools: Informatica PowerCenter 8.x/7.x

Data Modeling Tool: CA Erwin 4.0

Reporting Tool: Business Objects XI, Crystal Report 7

Server OS: IBM AIX Unix, MS Windows Server 2003/2000

Other Application: DB Artisan 8.0, Eclipse

Infrastructure: MS Active Directory, MS Exchange Server

PROFESSIONAL EXPERIENCE

Confidential WA

Oracle Developer

Responsibilities:

• Developed Packages, Procedure & SQL code that transform insurance provider data from legacy in-house MDM and transferred to outsourced centralized system.
• Successfully created unusual logic which computes sets of covering provider relationship from Mainframe flat file which contains only one way relationship.
• Rewrote existing codes in more maintainable way.
• Coded T-SQL Procedure on Sybase platform.
• Coded Korn Shell script that split very large flat file at certain content.
• Logic which process raw data by hierarchy & date rule and output in “date based” pattern.
• Added logging mechanism to Packages.
• Performed extensive SAT prior to UAT.
• Production bug fixing.
• Custom reporting for data analysis.

Environments: Oracle 10g, Toad for Oracle, Sybase ASE, Sybase Central, IBM AIX Unix, Microsoft Visual Studio 2010 ASP.NET C#

Confidential OH

Oracle Developer / ETL Developer

Responsibilities:

• Enhance application functionalities by creating new and modifying existing database triggers, procedures, functions & packages.
• Accomplishment: Developed and implemented data cleansing & data migration strategies to process bulk data. Identified problematic records and assigned error flags. Improved the overall cleansed data rate from 80% to 97%.
• Gather reporting requirements, business rules/processes and logic and design the logical model.
• Analyze source systems and derive the data model.
• Perform extensive data quality analysis and classify bad data.
• Design and implement Data Warehouse Star and Snowflake schemas with input from Business team. Carry out ETL workflows analysis.
• Code ETL for Facts and Dimensions tables and apply incremental loading techniques.
• Optimize ETL & reporting performances.
• Write SQL to generate ad-hoc detail and summarize analysis reports for business. Reports include Analysis of service calls, Procurement, Stock Transactions, Part Usages, Workforce efficiency, Refrigerant usage, etc. Majority of reports to be coded into Business Objects.
• Create varieties of canned reports in Business Objects.
• Geographically display all Kroger stores on Google Earth by generating KML / KMZ files using PL/SQL procedures.
• Customize inventory barcode labels.
• Develop batch processing jobs in Unix Korn Shell and PL/SQL as well as job management scheduling in IBM Tivoli and Crontab.
• Fix application bugs and bad data. Apply workaround solutions when needed.
• Key go-to person for technical matters. Mentor new team members.
• Work with software vendors in resolving application issues.

Environments: Oracle 10g on RAC, Toad for Oracle, IBM AIX Unix, Business Objects, IBM Tivoli Scheduler, Eclipse.

Confidential Dublin OH

ETL Developer

Responsibilities:

• Involved with the design of data model and development of the physical & logical architecture using Erwin 4.0.
• Analysis and review of source data structures from the Vantive CRM system and Peoplesoft CRM to integrate customer support data and developed specifications of our target data mart and Informatica mappings.
• Designed and developed mappings to perform delta load against high volume CRM data sources without any timestamps.
• Integrated existing reports from Excel spreadsheets and web-based Dashboards to Cognos cubes and reports delivered from the data mart.
• Developed test plans for Integration testing, system testing and acceptance testing
• Enhanced the existing financial DW to integrate data from the Peoplesoft Billing, Contracts, PO, AP and AR modules.
• Worked with business analysts to review and assess business requirements relating to data loads and publications.
• Performed in-depth review of source data quality.
• Developed specifications for transformation and cleansing.
• Involved in creating the physical & logical architecture using Erwin 4.0.
• Performance tuning of Informatica mappings and database tables to manage data loads from Peoplesoft.
• Developed test plans for Integration testing, system testing and acceptance testing.

Environment: Oracle 10g, DB2, MS SQL Server 2000, Informatica 7.1, Toad for Oracle, DB Artisan 8.0, UNIX.

Confidential

System Engineer

Responsibilities:

• Carried out installations, configurations, management of Domain Controllers (MS Active Directory, DNS, Group Policy, LDAP)
• Deployed and maintained DHCP, FTP, MS ISA Server and MS IIS Server.
• Managed the Email MS Exchange Server.
• Set up Citrix Sever farm, published applications, managed load and licensing.
• Handled deployment and configurations for physical servers (types included tower, rack mount and blade) and virtual servers.
• Liaised with Microsoft in fine tuning performance of MS SQL Server 2000 servers.
• Performed rapid network deployment of operating system images to servers and PCs.
• Set up Symantec Antivirus Sever and deployed its clients to PCs.
• 3rd level technical support person for Data Center related issues.
• Configured basic firewall routing policies and rules as well as network load balancer.
• Assisted branch technicians in resolving technical issues.
• Handled backup and restore of MS SQL Server databases.
• Acted as 1st level support for email filtering device Mirapoint.
• Developed and enhanced variety of reports using Crystal Report 7
• Coded reports library application with MS Visual Basic 6.
• Performed system acceptant test on enhancements and bug fixes.
• Maintained documents of flow process and standard operating procedures for ERP system and in-house developed systems.
• Customized inventory barcode labels.
• Being a technical support person for ERP system, NT/Unix file servers, software and hardware issues.
• Investigated and fixed bad data.
• Conducted ERP system training for end users.
• Maintained Domain Controller (MS Active Directory) and Email Server (MS Exchange Server).
• Carried out month / year end closing’s data compilation, backup & restore.
• Composed IT disaster recovery plans and performed tests.
• Mentored new team members.

Environments: Crystal Report 7, MS Visual Basic 6, Syspro Manufacturing ERP, MS SQL Server 2000, MS Windows Server 2000/03, Citrix Metaframe XP.