SUMMARY:

• 15+ years of experience in the design, development and management of systems using Oracle database, SQL and PL/SQL with in - depth understanding of data modeling and ER design.
• Oracle E-Business Suite R12 Financial Management Certified Implementation Specialist: Oracle Payables.
• Proficient in Informatica Power Center using Source and Target analyzer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manger, Workflow Monitor with Performance Tuning.
• Strong Knowledge of Tableau Desktop 10 data visualization using Dashboards, Reports and Storytelling.
• Interest in Data Science and using data to drive business decisions.
• Strong knowledge of Excel (Pivot Tables, Vlookups,functions)
• Oracle PL/SQL and SQL Programming
• Informatica Power Center 9.6, 10
• Tableau Desktop Reports and Dashboard
• Oracle E-Business Suite R12 Order to Cash and Procure to Pay cycle.
• Data Modelling and ER design
• Data warehousing
• Python, Core Java, JavaScript.
• Software Development Lifecycle (SDLC)
• Having good exposure on Data Warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies.
• Individual Contributor - can work with least guidance, willing to learn new technologies and a Team Player - can mentor and guide individuals with passion for data.Expert data harmonization skills - questions every data point before relying on it.
• Self-starter, results-driven and effective at prioritizing and managing multiple initiatives concurrently.
• Excellent verbal and written communication, presentation and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6, 10 | SAP BODS Data Services Designer | Tableau Desktop 10

Databases and Applications: Oracle RDBMS | MySql | Oracle E- Business Suite R12 - GL, AR, PA, PO etc, MS Office(Word, Excel, PowerPoint, Access), SQL Developer, TOAD, Jupyter Notebook

Programming: Oracle PL/SQL | SQL l SQL Loader | Oracle BI Publisher | Oracle Workflows | Oracle D2K (Forms and Reports) | Python | PHP | JavaScript | Core Java | Bash/Shell

Operating Systems: Linux operating system | Microsoft Windows Server | Microsoft Windows

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Responsibilities:

• Tableau Desktop 10 Certified Associate: covering visual analytics, charts, mapping, dashboards, stories etc.
• Informatica Power Center 10 Certified Expert: in depth Extract - Transform - Load process with performance tuning
• SAP BODS 4.2 Data Services Designer, Data Flows, Workflow, Data Integration, Data Quality and Platform Transforms.
• Data Warehousing Professional Certified.

Confidential

Responsibilities:

• Completed Landmark Forum, Advanced Course, Evening Seminars and Self Expression and Leadership Program from Confidential, San Francisco,USA.
• I became Introduction Leader and took Landmark Introduction sessions.
• Designated as Emotional Intelligence Coach with six months training at Confidential.

Confidential

Project Manager

Responsibilities:

• Managed and lead multiple project teams of software engineers on daily basis in all areas of software engineering and technical project management life cycles including requirements gathering, analysis, data modelling, ER diagrams design, development and implementation.

Confidential, Foster City, CA

Oracle Software Consultant

Responsibilities:

• Oracle Financials Software Consultant for Oracle Order Entry analysis, design and implementation.
• Consulted as Oracle Software Consultant with Prism Group Consulting.
• Oracle Consultant developed forms and reports using Pl/Sql, Forms and reports at Mills College, Oakland, CA through Executive Systems Group, Santa Clara, CA
• Consulted as Oracle Software Consultant with Core Technology group, Los Gatos, CA for their various clients.

Confidential, Berkley, CA

Oracle Applications Instructor

Responsibilities:

• Taught Classes for Oracle application development teaching Oracle database, SQL, PL/SQL, Sql Forms

Confidential, San Francisco, CA

Oracle Software Consultant

Responsibilities:

• Developed Job Accounting Database (JADB) and integrated with Oracle General Ledger, Oracle Payables, Oracle Assests and Receivables.
• Designed and developed Oracle Financials Cost and Revenue distribution (CARDS) non - Labor and integrated with Oracle apps.

Confidential, Redwood Shores, CA

Systems Engineer

Responsibilities:

• Responsibilities involved conversion and development of Accounts Payable reports from RPT/RPF reports to Oracle*Reports 2.5. Development of reports for GSA test using Oracle*Reports 2.5 which was difficult to develop using FSG at Oracle Payables Department.
• Analysis, Design and Development of Reports, Forms with testing at Oracle Govt Financial - General Ledger department.
• Provided consulting services to clients specific to the implementation of Oracle Financial Application software and related technologies at Confidential.

Confidential, Santa Clara, CA

Programmer Analyst

Responsibilities:

• Consultant at Oracle Govt. Financial - General Ledger department. Responsibilities involved conversion and development of Funds available analysis report etc
• Consultant for OASIS - a property information and tax assessment system, supporting Geography information (Mapping), office automation and data analysis for Confidential, Stockton, CA.

Confidential

Programmer Analyst

Responsibilities:

• Real Estate Appraisal System designed to get up to date information on the status of applicants for property appraisal at Confidential, Newark, NJ.