SUMMARY

• Having 14+ Years of experience in the field of Business Analysis, System Analysis, Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL and ETL tools and reporting tools that include Software Development Life Cycle from Analysis and Design to Implementation and Support.
• Strong knowledge of assigned business area(s) operations and the IT systems/applications used.
• Worked in triaging issues, identifying root cause of systemic issues and ensuring a fix is identified and implemented.
• Worked extensively on Oracle8i/9i/11g and DB2 databases.
• Expertise in Dell Boomi Integration Tool
• Expertise in developing jobs in IBM DataStage.
• Involved in Designing, writing Algorithms and Specifications
• Strong in writing Stored Procedures using PL/SQL, Strong in writing SQL queries
• Involved in Designing, testing and implementation.
• Excellent Programming and trouble shooting skills, and an ability to deliver under pressure.
• Interacted with business technical groups and analyzed business needs.
• Have a professional attitude and good communication skills, self - motivated and multi-task oriented, with strong work ethic and ability to work effectively.

TECHNICAL SKILLS

Databases: Oracle, DB2, MS Access, SQL Server, Mongo DB

Tools: IBM Datastage, Toad, SQL * Plus, Actuate Reports, SQL Developer, Boomi - Integration tool

GUIs: Microsoft Visio.

Operating Systems: MS - DOS, Windows 9x/2000/XP, UNIX

Languages: SQL, PL/SQL, HTML, VB Script.

Other Tools: Mercury Quality Centre, VSS, Perforce, SERENA migration tool, RALLY

ERP: Actuate Reports, Power BI

Project Management: Design review Sessions, Work Breakdown Structure, Estimates/Scheduling, Resource Allocation, Project Release Planning, Tracking and Reporting

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst

Responsibilities:

• Responsible for implementation and maintenance of EDI healthcare transactions systems using 834.file standards
• To facilitate evaluation of delivered technology solution to ensure it satisfies the business needs. Accountable for triaging issues, identifying root cause of systemic issues and ensuring a fix is identified and implemented.
• Responsible to develop Boomi processes for data integration between multiple systems. Develop reports out of Boomi process and configure the SFTP to send the files to the required destinations.
• Write / Update queries and data maintenance in Postgres Database.
• As a Product Owner, responsible for effective communication between the customers and the development / testing team to make sure the goals and vision is clear and meets business objectives.
• Responsible for the prioritization of the backlog items based on the overall strategy and business objectives.
• Proficient in creating Requirement specifications and any required system level crosswalks for business system integrations with the IT department.
• Strong knowledge of assigned business area(s) operations and the IT systems/applications used.
• Negotiate and align agreements by facilitating communication between the business and technical teams though the project lifecycle.
• Lead the production of detailed functional requirements and/or user stories, including non-functional requirements, provided oversight for the development of user acceptance criteria, test plans and test cases. Oversees functional/user testing (User Acceptance Testing) and accountable for user sign off.
• Ensure adequate documentation of user stories in Rally, work closely with the development and testing teams to plan the development/testing timeframes and plan the sprints for the implementation.
• Track and resolve project issues, facilitate UAT for the project, setup defect meetings, monitor the test execution status and provide updates. Accountable for ensuring business requirements are reviewed, addressed and accurate in deliverables before release.

Environment: IBM DB2, Oracle 11g, Boomi - Integration tool, Microsoft Visio, Mongo DB, Rally, SFTP, Postgres Database

Confidential

Senior Developer - Tech Lead

Responsibilities:

• Develop and test ETL jobs using IBM Datastage.
• Set up the configurations in the Datastage administrator.
• Develop ifb files for Siebel Interface Configuration.
• Involved in the migration of the datawarehouses from Informatica to Datastage.
• Develop queries and stored procedures using Oracle /PLSQL.
• Involved in the integration of the database with the front end applications.
• Gather requirements and analyze them and prepare the requirements document. Also ensure that the functional specification is clear and complete.
• Impact analysis of the newly requested system level updates.
• Apply configuration changes to the application to meet business requirements
• Review and test the changes and queries from the team.
• Involved in unit testing and integrated testing.
• Involved in preparing the User Test plans.
• Involved in fixing the bugs at the runtime.
• Act as a liaison between the development/testing team and the business users.

Environment: Oracle 11g, SQL Developer, Windows 2000/XP, STAR Team, DataStage 11.0, putty, WS-FTP Pro, HP Quality Center, RTC Source control, SERENA

Confidential

Senior Developer - PL/ SQL /Tech Lead

Responsibilities:

• Gather requirements and analyze them and prepare the requirements document. Also ensure that the functional specification is clear and complete.
• Impact analysis of the newly requested system level updates.
• Design the database and develop the ER diagram.
• Write PL/SQL packages, procedures and schedule jobs.
• Partition the tables based on the business requirements.
• Set up the job triggered packages and procedures.
• Involved in unit testing and integrated testing.
• Involved in preparing the User Test plans.
• Involved in fixing the bugs at the runtime.
• Involved in preparing program flows and test plans.
• Track and Trace requirements from design to implementation to tests using Mercury Quality Center (MQC).
• Act as a liaison between the development/testing team and the business users.

Environment: Oracle 11g, Toad, Windows 2000/XP, MQC, VSS, Microsoft Visio.