SUMMARY:

A Software Engineer professional with 11+ years of experience in the IT industry. Proven performer, with history of great customer service, leadership, timely strategic business solutions, with on time and budget delivery. Adept at managing and coordinating cross cultural and geographically distributed teams.

TECHNICAL SKILLS:

Databases: Oracle 10G, 11G and 12c

BI Tools & Products: OBIEE, Tableau, Jira, Confidential Views, Confidential Platform, Confidential Generators and Confidential Analytics

ERP Confidential: Oracle EBS 11i & R12 Apps (HR, Payroll, PO, QA, AP, SLA, INV, OPM - GMD) ETL - Informatica PC 8.6.1, 9.0.1 and 9.1.0 & SQL*Loader |

Languages: SQL, PL/SQL, Python

Customer Service Tools: Salesforce, RightNow

EXPERIENCE:

Confidential, Redmond

Responsibilities:

• Currently working in Support Services
• Handling all types of SRs related to Install/Upgrade/Patching/Performance/Administrator and troubleshooting
• Expertise in Data Warehousing Technology
• Strong data modelling/design experience
• Functional knowledge of Oracle EBS modules with an emphasis on HR and Payroll modules.
• Performing the gap analysis
• Good knowledge and exposure in QA, INV, PO, AP modules
• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment
• Strong in SQL skills
• Strong in PL/SQL skills
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading
• Extracted data from various heterogeneous sources like Oracle and non - Oracle and loaded into target using Informatica
• Proficient in Analysis & Development of ETL processes for Data Marts using Informatica Power Center
• Extensive work experience in ETL tool - Informatica
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in writing DB queries, Store procedures, Triggers, Functions etc
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations
• Good Understanding of Data Modeling Concepts.
• Strong troubleshooting and problem solving skills.
• Extensive experience with OBIEE (Formerly known as Siebel Analytics) based BI Confidential
• Experienced in gathering OBIEE reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer
• Hands on experience in configuring and set up of OBIEE Security and configuring object level and database level security
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Expertise in Customizing Extend Confidential Views and Confidential Analytics
• Monitored the projects using scrum works tool and conducted stand up meetings with the team daily to assess projects’ status to identify & mitigate development blockers
• Involved in hiring software engineers at various levels in organization, ensured their training regarding products & processes, mentored the team to achieve targets
• Positive attitude with good Presentation Skills, hard working in nature, believe in team work and decision making by consensus, capacity to withstand pressure, no geographical barriers
• Ability to adapt to new skills and technologies and Dedicated to maintaining high quality standards
• Customer base includes Qualcomm, Emerson, Boart Longyear, Smith Medicals, Graco to name a few

Confidential

Principal Software Support Engineer

Responsibilities:

• Resolved incidents in a timely manner as per SLA’s
• Solving complex customer issues using methodical troubleshooting based on expert knowledge of Oracle EBS Confidential functionality and technology
• Working closely with customers daily to understand their needs, support business change and deliver a consistently high quality customer experience
• Manage issue tracking process, making sure identified issues are brought to resolution
• Strategic thinking and planning on how to address and support business needs using Confidential BI products
• Resolve moderately complex production issues related to data integrity, availability etc
• Apply practical system controls and processes to ensure maximum performance, accuracy, and availability of supported Confidential BI products
• Writing SQL and PL/SQL block to resolve the issue
• Provide remote-based functional support for multiple EBS modules
• Support client customization, sharing implementation and best practices advice
• Coordinates technical and application support with third party vendors
• Develop application break fixes for critical product defects
• Create scripts to identify, analyze and correct data issues
• Be a pro-active contributor to a support organization which is running 24x7x365, this will require the ability to work flexible hours, including evenings, weekends and holidays and monitoring email regularly outside standard business hours
• Provide hands-on assistance using proprietary tools in a test environment or via remote client connectivity
• Collaborate with team members in a virtual team environment to extend field experience to different client situations
• Handling all types of SRs related to Install/Upgrade/Patching/Performance/Administrator and troubleshooting
• Collaborating the development for bugs raised for customer
• Collaborating with customer directly through web conference by logging remotely into customer instances and resolving the issues
• Handling all high-level escalation
• Designing standard reports
• Write knowledge base article
• Spreading best practices to customer
• Communicating state of business, experiment results, etc to Engineering team. Work closely with the Engineering team to implement these requirements and clearly communicate the stated business needs
• Lead training sessions
• Take complex technical concepts and explain to team in simple business terms

Development Lead

Confidential

Responsibilities:

• Actively involved in design, development and testing of the target industry solutions
• Provided technical direction and best practices to be followed by the team
• Ensure delivered solutions are realized in time frame committed
• Performed required research to aid in the development process
• Building and analyzing dashboards and reports
• Create ad hoc queries, data sources or reports to support the business
• Involved in Team Reviews and Retrospectives
• Review the work of other team members and ensure it meets the required standards
• Translate use cases and requirements into user stories
• Created and entered user stories/tasks in the project management system
• Worked in conjunction with the Product Owner/Practice Head on the estimation and refinement of stories as well as manage scope and risk
• Mentor to all team members on their assigned project tasks

Senior Engineer

Confidential

Responsibilities:

• Tested report & dash boards for Confidential analytics data marts in OBIEE and Cognos for financials, HRMS, order management, procurement and discrete manufacturing modules of Oracle EBS
• Checked working of Confidential workbench, developed to empower users to customize operational reporting solutions provided by their view product
• Released “mayhem” to fix bugs in new operational reporting solutions for cash management, flow manufacturing and project management modules of Oracle EBS
• Tested addition of data marts for working capital, incentive compensation and depot repair modules for both 11i and R12 versions and for Oracle and SQL Server 2005 and 2008 releases
• Checked provision of flexibility of fetching segments defined across multiple charts of accounts in one concatenated column with global extension across 40 modules for 11i & R12 versions
• Made reporting solutions for Oracle process manufacturing modules compatible for Oracle R12 version; fixed many bugs and productized the custom solutions provided to customers
• Tested requirements and identified gaps between 11i and R12 versions of Oracle EBS in sub ledger accounting method, supply chain management and discrete manufacturing modules
• Handled testing of operational reporting solutions to general dynamics for depot repair, tele service and field service modules of service module segment for Oracle EBS

Confidential

Responsibilities:

• Prepared test plans and approaches, documents for functional aspects defined in business requirement document and executed test cases for functional area defined in application setup
• Assisted in conducting inspections and independent third party testing for the verification, testing and commissioning of mechanical smoke control systems
• Programmed addressable fire alarm systems
• Performed code reviews as part of the fire protection and life safety systems design process
• Coordinated with the customers to understand their security requirements and adjust the system per their needs
• Interfaced with the customer representative and managed a small team for the project
• Inspected the work site and studied the building plans and blue prints, determined the equipments required for the installation in accordance to the same
• Clients included: Saudi Oger, Hilton Hotel Jeddah, Ajyad Makkah Makarim Hotel and Al Faisaliyah Center Riyadh to name a few