SUMMARY:

• Total 12+ years of experience in Software Development, Data warehouse and ETL Development, EDI Integration, BI Reports, Oracle APEX forms and reports development and implementation for Enterprise Resource Planning (ERP) & Customer Relationship Management (CRM) applications, following - Waterfall, Scrum & Kanban Agile methodologies, adhering to Capability Maturity Model Integration (CMMI) Level 5 quality standards.
• Achieved high level of success as Senior Software Engineer in software development and implementation of over 16 ERP projects spanning numerous markets and diverse corporations.

CORE STRENGTHS:

• Software Development
• Agile methodologies
• Electronic Data Integration
• Account Management
• Requirements Analysis
• Software Lifecycle
• Project Management
• CMMi Level 5 standards
• Subject Matter Expert
• Troubleshooting
• Business Intelligence
• Documentation
• Product Development
• MIS Reports
• Customer / User Support
• User Training
• Delivery Management
• Implementation
• User Acceptance Testing
• Quality Control

TECHNICAL SKILLS:

Database: Oracle 11g, 10g, 9i, 8i, 8, MySQL, MS SQL Server 2008 & 2012

Languages: Oracle SQL, PL/SQL, C, C++, HTML, JavaScript, T-SQL; Apache Hadoop - Cloudera, Hive, Pig

Development Tools: Oracle Forms 11g, 10g, 9i, 6i, 4.5; Reports 11g, 10g, 9i, 6i, 2.5; Toad, SQL ToolsSQL Developer, PLSQL Developer ; Oracle Application Express (APEX) 4.2.3, 5.0, 5.1

Business Intelligence: Oracle Discoverer 10g, 9.0, 4.0, MicroStrategy Desktop, Crystal Reports

Environment: OS: Windows 8, 7, Vista, XP, Linux - Suse, Redhat;

Server: Windows, Linux, JBoss7.1, EAP

Defect Tracking: Bugzilla, OTRS, JIRA, Customer Self Service Portal

Other Tools: MS Project, MS Office, Putty, WinSCP, Tectia, SSH Secure Shell Client, WebEx, SharePointCitrix, VPN, MS Excel, Perfino, Talend, Adobe Photoshop CS4.

ERP MODULE EXPERIENCE:

• Procurement
• Sales
• Supply Chain Management
• Accounts Payable
• Inventory
• Fixed Assets
• Business Intelligence Reports
• Accounts Receivable
• Manufacturing
• Job Contracting
• Electronic Data Transfer (EDI)
• Human Resource Management
• Budget
• General Ledger
• Customer Relationship Mgmt.
• Warehouse Management

WORK EXPERIENCE:

Confidential, Virginia

Programmer Analyst, Business Systems Analyst, Scrum Master

Responsibilities:

• Requirement gathering, creating Functional and Technical Specification documents, conducting Joint Application Design (JAD) discussions with customer and sprint meetings with onsite and offshore teams.
• Designed, developed and maintained: Oracle database schemas, PL/SQL packages, stored procedures, functions, tables, views, indexes, materialized views, synonyms, grants, constraints, triggers etc. using Oracle 11g; Oracle Forms and Reports 10g; and Oracle BI Discoverer Reports 10g for ERP, ETL data warehouse and EDI requirements.
• Developed materialized views for data replication in distributed environment and for creating OLAP BI reports.
• Designed and developed objects using SQL and PL/SQL techniques such as implicit, explicit, reference cursors, for loops, bulk collects, forall, UTL FILE and DBMS SQL package for ETL and EDI integration to outside applications.
• Optimized long slow jobs, queries by analyzing tables, using explain plan, DBMS PROFILER, indexes, bulk collect;
• Created DBMS JOB and DBMS SCHEDULER to execute reports and procedures to send email notifications;
• Provided support for ETL Developments using Talend Data Integration tool.
• Applying ERP war file in JBoss EAP server, reports war file in reports server and Apache SOLR search war files.
• Technical lead for onsite and offshore software development teams.
• Review developments periodically; plan and execute - unit, integration, performance and user acceptance testing.
• Provide day-to-day user support, monitor all issues reported by the customer, troubleshoot and provide root fixes
• Prepare user manuals, help documentation and provide necessary training and support to the end users
• Successfully playing the role of a one stop shop for: user support, training, business functionality advice; deploying .war files, troubleshooting performance and configuration level issues, coordinating developments and reporting issues to offshore team; design, development and review of customizations and enhancements for 2 ERP systems.
• Successful completion of requirement analysis, documentation, ERP Customization Design and Development, Integration Testing, Performance Testing, End User Training and upgraded the existing Oracle front end based ERP system to a Java front end based ERP system in 7 months
• Provided hands on training to the core and end users on using the new Java ERP system, thereby reducing support queries and clarifications by over 50% and increasing productivity.
• Designed, developed and incorporated new dashboards, data warehouse reports and automated jobs in the system to facilitate the users retrieve information faster reducing the delay in shipping orders to the clients end customers.
• Subject Matter Expert (SME) for user experience and usage, familiar with how all customers use the system, functionality used, and common scenarios performed;

Confidential

Programmer Analyst, Business Systems Analyst, Scrum Master

Responsibilities:

• Requirement gathering, creating Software Requirements Specifications, Functional and Technical Specification documents, conducting Joint Application Design (JAD) discussions and sprint meetings with all stakeholders.
• Designed, developed and maintained: PL/SQL packages, procedures, functions, materialized views, indexes, triggers for ERP, Data warehouse & OLAP Oracle 11g schemas; developed APEX interface screens and reports as required.
• Optimized long slow jobs, queries by analyzing tables, using explain plan, DBMS PROFILER, indexes, bulk collect;
• Provide day-to-day user support, monitor all issues reported by the customer, troubleshoot and provide root fixes
• Internal Quality Control including unit, integration testing, performance testing and user acceptance testing
• Managing other software development and implementation projects
• Successful completion of Business Process Study, requirement analysis, documentation, ERP Customization Development, Testing, End User Training and Implementation within 7 months with a team of 6 members.
• Completed software design and development with high quality, resulting in less than 25 post Go-live issues.
• Awarded best project for scoring 86% in software process compliance audit and for on time delivery of solutions.

Confidential

Programmer Analyst, Business Systems Analyst, Product Owner

Responsibilities:

• Requirement gathering, conducting Joint Application Design (JAD) discussions and meetings with customer.
• Provide day-to-day user support, monitor all issues reported by the customer, troubleshoot and provide root fixes
• Designed, developed and maintained: Oracle database schemas, PL/SQL packages, stored procedures, functions, tables, views, indexes, materialized views, synonyms, grants, constraints, triggers etc. using Oracle 11g; Oracle Forms and Reports 10g; and Oracle BI Discoverer Reports 10g for ERP, ETL data warehouse and EDI requirements.
• Designed and developed screens to perform what if analysis on costs, discounts, and sales price; designed and developed Oracle D2k and Oracle Application Express (APEX) reports to provide sales information for 9 countries: by country, location, sales man, middle men commission, logistics, etc., which helped in improving sales and profit.
• Designed and developed EDI integration tables, triggers, procedures, packages and jobs to sync huge amounts of retail data on a daily basis from outside applications to enterprise applications and vice versa; replicate the synced customer, delivery notes, invoices and collection data to 19 different internal companies based on requirements.
• Identified high CPU Utilization queries using ASH (Active Session History), AWR (Automatic Workload Repository) reports, optimized long running jobs and queries by analyzing tables, using explain plan to tune the queries, DBMS PROFILER to tune PL/SQL code, creating indexes, bulk collect and parallel execution methods.
• Performed SQL and PL/SQL tuning and application tuning using Explain Plan, SQL Trace, TKPROF and Auto Trace.
• Created Project Management documents such as: Estimation, Cost Sheet, Project Management Plan, Delivery Schedules etc. and maintained them throughout all the phases of Software Development and Implementation.
• Subject Matter Expert (SME) for user experience and usage, familiar with how all customers use the system, functionality used, and common scenarios performed;
• Prepare user manuals, quick reference guides and help documentation to support end users
• Internal Quality Control including unit, integration testing, performance testing; user training, user acceptance testing and manage project and all deliverables.
• Turned around a failing project that had several high priority complex issues with over a million existing production and more growing transaction data to be corrected - within 3 months, and provided 24/7 flexible support to users.
• Successfully designed, developed and implemented EDI integration to integrate ERP with 3rd party mobile and tablet applications as per schedule and under estimated budget, which increased retail sales and profit for the client and brought in new opportunities for business development for the company.
• Appreciated for effectively executing multiple projects with tight schedules, reducing costs and delivering on time
• Recognized for being the Subject Matter Expert (SME) and effective first point of contact for all users.
• Trained, mentored 14 freshers; monitored all phases of software development and ensured quality in deliverables;
• Commended for successful ERP customization development, training, implementation and support in Thailand, Myanmar, Vietnam, Cambodia; and rollouts in Indonesia, Singapore, Malaysia, Nigeria & Ghana

Confidential, Virginia

Programmer Analyst, Business Systems Analyst

Responsibilities:

• Discuss with clients, analyze and document software requirements, design and technical specifications.
• Designed, developed and maintained: Oracle database schemas, PL/SQL packages, stored procedures, functions, tables, views, indexes, materialized views, synonyms, grants, constraints, triggers etc. using Oracle 11g; Oracle Forms and Reports 10g; and Oracle BI Discoverer Reports 10g for ERP, ETL data warehouse and EDI requirements.
• Designed and developed triggers, stored functions, packages and procedures using Dynamic SQL and Execute Immediate statements to generate data for business reports; used DBMS JOB and DBMS SCHEDULER to execute packages and procedures to email reports from the database.
• Designed and developed database packages and interface screens for EDI integration to outside applications.
• Subject Matter Expert (SME) for user experience and usage, familiar with how all customers use the system, functionality used, and common scenarios performed;
• Technical lead for onsite and offshore team for the design, development and testing software developments
• Internal Quality Control including unit testing, integration testing, performance testing and issue fixing;
• Analyze and maintain the existing system, modify the design and code to optimize its performance;
• Prepare user manuals, quick reference guides and help documentation to support end users
• Increased user productivity, customer satisfaction by troubleshooting and fixing long pending and annoying issues.
• Successfully developed and implemented EDI module for daily integration with 3rd party logistic applications
• Upgraded ERP client server application to Web application facilitating users worldwide to access the application.

Confidential, Virginia

Programmer Analyst, Business Systems Analyst

Responsibilities:

• Discuss with clients, analyze and document software requirements, design and technical specifications.
• Designed, developed and maintained: Oracle database schemas, PL/SQL packages, stored procedures, functions, tables, views, indexes, materialized views, synonyms, grants, constraints, triggers etc. using Oracle 11g; Oracle Forms and Reports 10g; and Oracle BI Discoverer Reports 10g for ERP, ETL, OLAP and EDI requirements.
• Analyzed and improved the performance of slow running reports providing faster access of data to the users and also completed new enhancements to enrich and to provide more details to the reports for better insights
• Internal Quality Control including unit testing, integration testing, performance testing and issue fixing;
• Optimized long running jobs and queries by using explain plan, creating new indexes and rewriting queries.
• Prepare user manuals, quick reference guides and help documentation to support end users
• Launched new module for budget planning and tracking providing more budget control to the management.
• Created new and enriched existing Management Information System (MIS) reports to track the flow of transactions and validate the correctness of data entered by users which increased efficiency, quality of data and improved the performance of supply chain operations by 20%
• Analyzed procurement, sales, inventory and logistics data from different sources and created business reports for management which helped in taking effective decisions to increase revenue and reduce costs.
• Provided root fixes for performance and long pending issues and decreased incoming support issues by 15%.
• Commended for ability to work independently with limited supervision and accuracy in design and developments