OBJECTIVE:

• Over 10 years (overall) and over 4 years (USA) of programming experience as an Oracle PL/SQL, Java and ETL Developer.
• Expertise in Client - Server application development using Oracle R12, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER and JAVA
• Expertise in ETL application development using Informatica, Pentaho and SmartCo/Neoxam DataHub
• Expertise in Automation testing using Java Cucumber and JUnit
• Use state of teh art technologies and methods we delivered high impact business intelligence solutions, data warehousing solutions and Tableau dashboards and data visualizations
• Expertise on logical and physical Data Modeling using normalizing Techniques.
• Work on Tables, Views, Constraints, Index.
• Work on materialized views for data replication in distributed environments.
• Work on data migration and test for production and development environments.
• Excel at technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Work extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Has experience in Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Has experience in Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Work on Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Has good knowledge on Investment Management business concepts (IBOR)
• Possess excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Has good knowledge on Data Analysis during teh time I studied and practiced data analysis at my university.
• Has good knowledge on Big Data during teh time I studied and practiced data analysis at my university.

TECHNICAL SKILLS

ETL Tools: SmartCo/Neoxam, Informatica PowerCenter 9.x, Pentaho Kettle

Languages: SQL, T-SQL, PL/SQL, Java, Shell Script, Junit, Cucumber, R, Python

Web: HTML, CSS, JSP, JavaScript, JQuery, XML, JSON, Apache Tomcat 7.0

Databases: Oracle, Teradata, MS-Server, MySQL

Development Tools: Toad for Oracle, Oracle PL/SQL Developer, SybasePower Designer, SVN, StarUML, Weka, IBM, SPSS, Tableau, SQL Loader, SQL Plus, Eclipse IDE, R Studio

Platform: Windows, Linux

SDLC Methodology: Waterfall, Agile

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Oracle PL/SQL Developer/SmartCo ETL developer/Java developer

Responsibilities:

• Develop SmartCo codes to customize vendor’s product called ETL SmartCo Data Hub where data is flown in and out using Core Java and JDBC.
• Write Oracle SQL to interact with database
• Develop automation tests using Core Java, Spring, JDBC, JUnit and Cucumber. Automation testing includes writing feature files and step definitions.
• Modify import and export connectors in SmartCo to follow teh latest requirements. Teh update can be from business perspective or from technical perspective
• Support team to debug SmartCo codes and cucumber codes as well as provide suggestion to improve process performance and onboarding newest team members.
• Package codes, configurations, software and reference data from a source environment (DEV12 as an example) and elevate to target environments such as INT12, CAT12 and SAT12.
• Cooperate with PM tool team and CRD team to execute performance tests including Holding Service, Start of Day (SOD), ETF orders (Approved and Confirmed), CRD Order Execution and E2E tests
• Work in various SmartCo UIs (Master/Sleeve portfolio structure, Holding Snapshot, Pre prod support, Hedging) and workflow validations, performance testing of corporate actions, order execution, teh FactSet holding rollup, and development of shift-left automation techniques.
• Use JMS Publisher and Listener capabilities to send/receive data via MQ Secure
• Identify implementation/code issues in advance of them materializing in testing and supply solutions when faced with these problems.
• Join scrum meetings every day to get status of my team and get feedback from BSA and other team members
• Join technical decomposition (when necessary) to solve unclear technical issues and come up with solutions

Environment: SmartCo Neoxam DataHub, CRD, PM Tool, SQL, PL/SQL, Linux, Java (Junit, Cucumber), control-M

Confidential, Austin, TX

Oracle PL/SQL Developer/ETL Developer

Responsibilities:

• Worked on Texas Welfare system and performed productions support requests (PSR).
• Created PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic using SQL Navigator.
• Developing workflows with Worklets, event waits, conditional flows, email, and command tasks using Workflow manager and monitored them in Workflow monitor.
• Develop complex ETL mappings using Informatica Power Center and sessions using Informatica workflow manager.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Wrote UNIX shell scripts to process teh files - like renaming teh files, extracting date from teh file, removing junk characters from teh file etc. before loading teh data into base tables.
• Dealt with huge data and resolved issues of slowness and tackled performance issues while loading as well as retrieving.
• Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
• Created materialized views (snapshot) for remote instances.
• Worked as a module lead and managed roles and responsibilities for testing, defect fixing, applying performance tuning methodologies and migrating ETL components to DIT (Development Independent Testing), SIT (System Independent/Integration Testing), UAT (User Acceptance Testing) and production environment.
• Worked on database application development, query optimization, performance tuning in complete SDLC.
• Performed optimization using ROWID pseudo column to speed up data access from teh data warehouse.

Confidential, Columbus, OH

PL/SQL Developer/ETL Developer

Responsibilities:

• Used SQL Loader to load data from flat files received from various facilities every day.
• Created and modified various UNIX shell scripts according to teh changing needs of teh project.
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
• Experience in Dynamic SQL, Collections, and Exception Handling.
• Created shell scripts and scheduled them using Crontab.
• Reported bugs and tracked defects using Jira.
• Worked with teh ETL developers to get data from various data sources (SQL Server, flat files and XML) and loaded teh data into target data sources after performing required transformations.
• Worked with Transformations, Mappings, Mapplets, Workflows, Worklets and debugger to find bottleneck in mappings.
• Partitioned large tables using range partition technique.
• Experience with performance tuning of Oracle database using Explain Plan and Hints to perform cost-based optimization.
• Experience in Dynamic SQL, Collections, and Exception Handling.
• Created shell scripts and scheduled them using Crontab.
• Created stored procedures, functions and packages to move data from teh staging tables to teh data mart.
• Reported bugs and tracked defects using Jira.
• Test, debug and take measures for query optimization.
• Develop a workflow tool to manage internal processes using JSP/Servlet and JavaScript/JQuery.

Confidential, Vietnam

ETL MySQL Developer

Responsibilities:

• Drove full lifecycle delivery of complex project aimed at design, development, rollout, and maintenance of state-of-teh-art billing system. Organized and coordinated project team, and oversaw requirements gathering, database design, systems testing, and deployment. Performed and documented code fixes, developed and refined test scripts, and optimized functionality.
• Completed all phases of project and SDLC on time with good quality.
• Credited with delivering business critical system to automate billing processes; triggered immediate and measurable improvements in productivity, efficiency, and cost savings.
• Migrated data from text files and FoxPro to MySQL server as ETL jobs.
• Developed data modeling (Star Schema and Snowflake) and SQL coding using MySQL Server.
• Developed data schema using MySQL Clustering.
• DevelopedStored Procedures, Functions, Triggers and SQL Scripts.
• Involved in various product quality management activities focusing on defect prevention and tracking mechanism.

Confidential

ETL Pentaho Developer

Responsibilities:

• Charged with maintaining and optimizing CMS system including website and database. Gathered and translated client business requirements into functional specifications and system enhancements. Designed and generated Design key reports for digital voices, account, project, rendering and KPIs. Managed and mentored team members. Interfaced extensively with senior managers, clients, and internal/external stakeholders.
• Acquired and aggregated multi-source data into a centralized data warehouse.
• Provided high level optimization ideas for teh ETL team to improve their code performance.
• Developed data modeling (Star Schema and Snowflake) and SQL coding using MySQL Server.
• Involved in designing ER diagram usingMySQL designer.
• Extracted data, cleaned it and inserted them in teh data warehouse using Pentaho Kettle tool.
• Designed and developed teh complex ETL mapping, session and workflow and scheduled jobs in Pentaho.
• Developed DDL scripts to generate tables, views, indexes.
• Run batch jobs for loading data from flat files using SQL Loader.
• Supported production issues.
• Worked with teh ETL developers to get data from various data sources (SQL Server, flat files and XML) and loaded teh data into target data sources after performing required transformations.

Confidential

ETL Informatica Developer

Responsibilities:

• Supervised, trained, and motivated 8 team members focused on design, development, and administration of world class software, enterprise architectures, and database/data management solutions supporting internal corporate operations and a diverse client base. Collaborated with managers, stakeholders, and users to document business requirements and establish project goals. Defined and documented complex requirements and processes, coordinating with managers, stakeholders, and users to ensure alignment with software configuration and enhancements. Performed troubleshooting, testing, and debugging.
• Recognized as a primary point of contact and liaison between U.S. and Vietnam teams.
• Spearheaded collaborative efforts with Indian and U.S. teams to customize data warehouse of major client, Travelocity. Redesigned database, migrating data and implementing workflow of business process using ETL Informatica tool and SQL.
• Extracted, cleaned and inserted data in teh data warehouse using Informatica PowerCenter tool.
• Hand-picked for 6-month data warehouse project onsite in Minnesota (USA); entrusted with communications with teh foreign client Travelocity and requirements transfer to Vietnamese team.
• Developed data modeling (Star Schema and Snowflake) and SQL coding using Teradata and Oracle.
• DevelopedUNIX Shell scriptsto automate table creation, execute procedures.
• Retrieved booking records and financial records from client’s current database, tan extracted, transformed and loaded them to a new database, finally customized database.