SUMMARY

• Consolidated IT experience of 15+ years across all phases of SDLC including Consulting, Requirement Study, Design, Development, Customization, Implementation & Support
• Understanding and exposure to the Software Development Life Cycle (SDLC) methodologies including Waterfall, Agile Methodologies.
• Understanding & working knowledge on multiple functional & industry domains including Insurance, Utilities, Manufacturing and State of Education
• Experience working with Oracle, Informatica Power Center, SQL Server, Oracle APEX, Oracle e - Business Suite
• Experience working with HP- ALM, Jira and Confluence
• Good experience on Database Design & development in SQL Server 2000/2005/2008/2012 . Worked extensively with Stored Procedures, Views, Constraints, Indexes and triggers
• Experience in documenting, preparing and executing test plans
• Excellent programming skills in Oracle PL/SQL in coding complex data conversions and interfaces and skills using tools including APEX, SQL Reports, BI Publisher
• Strong technical expertise on ERP project implementations, and has worked with the Oracle E-Business Suite package for a number of years in both developer and analyst roles.
• Technical expertise in integration of Oracle e-Business Suite (R12) and with multiple Oracle e-Business Suite modules including Oracle Financials (GL, AP) and Oracle HRMS Suite (Core HR, SSHR, Payroll)
• Experience with Oracle WAM (Work Asset Management).

TECHNICAL SKILLS

Oracle Technologies: Informatica Power Center 9.6.0, SQL, PL/SQL, APEX 5.0, FNDLOAD, XML Publisher, BI Publisher, SQL Server

Other Technologies: Exposure to .Net, Netezza, SSIS

Applications: Oracle WAM, Oracle Financial Modules (AR, AP, GL), Oracle HR, Oracle Transportation management, Oralce Customer Care and Billing, WMSDocs, Noetix Web Query, Workbench

Agile Tools: JIRA, Confluence, HP ALM

Industries: Insurance, Manufacturing, Utilities, Education, Joint Family Services, Restaurants

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

Noetix Report Developer

Responsibilities:

• Working on report development using Noetix Views based on Oracle EBS.
• Agile Sprint implementation with JIRA/Confluence
• Designed and implemented reporting solutions, delivering combined time savings of 350+ hours per year.
• Provided technical support to end users, increasing productivity by quickly and effectively resolving issues.
• Delivered about 1000 critical financial and non-financial Noetix reports within stringent Sprint timelines, with all the chart of account changes in place along with UAT testing

Environment: Lotus Notes 8.5.3, Noetix Web Query 6.0, Noetix Search 2.2.2, Noetix Enterprise Manager 2.2.2, Noetix Views Workbench 2.2.2, Windows Server 2012 R2 Standard, Oracle 11g Enterprise Edition 11.2.0.4.0 , Oracle SQL Developer 3.2.20.09, Oracle EBS 12.1.3

Confidential, Columbus, OH

Consultant

Responsibilities:

• Designed conversion packages using Oracle APIs for Work Structures like Grades, Jobs, Organizations and converted about Confidential ’ 30,000 employees from old to new Business Group
• Implemented employee deployment creation, initiation and conversion of Addresses, phones, contacts, person extra information and Payroll

Environment: Oracle EBS 12.1.3, Oracle 11g Enterprise Edition 11.2.0.4.0 , Oracle SQL Developer 3.2.20.09

Confidential, Columbus, OH

Informatica, APEX Developer

Responsibilities:

• Led client team for project planning and business requirement analysis
• Developed proof of concept - Informatica workflows
• Provided recommendation for design optimization
• Designed and developed front-end screens and backend PL/SQL scripts.
• Developed application that interfaced with Oracle databases and generate email notifications
• Designed several Apex reports, Data Input pages with Validations and JavaScript coding.

Environment: APEX 5.0, Informatica 9.6, Oracle 11g Enterprise Edition 11.2.0.4.0 , Oracle SQL Developer 3.2.20.09

Confidential, Columbus OH

Developer and Tester

Responsibilities:

• Created manual test scripts in HP Application Lifecycle Management (ALM) for UAT
• Created automated regression tests using C# in Visual Studio.
• Conducted System regression testing and UAT Development
• Designed and developed WMSDocs UI
• Worked on C# code to refactor the backend processes, according to the customer needs, send messages on integrity checks
• Conducted Unit testing for WMSDocs

Environment: WMSDocs, Lotus Notes 8.5.3, HP-ALM 12.53, Microsoft Windows, Microsoft IIS, Team Foundation Server, VSTS, Windows Installer, ASP, .Net, C#

Confidential

Consultant

Responsibilities:

• Designed and developed Accounts Receivable queries to extract R12 data for Sweden, Finland and Norway.
• Production support in data load to intermediate APEX tool MVT, validate and fixed data issues.

Environment: Oracle EBS 12.1.3, Oracle 11g Enterprise Edition 11.2.0.4.0 , Oracle SQL Developer 3.2.20.09, Micorsoft Excel 2010

Confidential, Pittsburg, PA

Sr Business Analyst/Consultant

Responsibilities:

• Developed several PL/SQL packages for checking the accuracy of the converted data.
• Developed Bill Compare tool on APEX platform to compare the Bills of Discus system to CC&B tables.
• Developed on few Audit reports to compare and audit the converted data from Discus to CC&B systems.
• Designed and developed Manual Entry forms on APEX 4.2, which are used to enter CC&B data like Accounts, Field Activity, Start and Stop Service etc.
• Worked on ODI (Oracle Data Integrator) packages in conversion of data to CC&B system.
• Implemented Mock runs to convert the data to CC&B.

Environment: Oracle CC&B 2.3.1, Oracle 11g Enterprise Edition 11.2.0.4.0 , Oracle SQL Developer 3.2.20.09, APEX 4.2