SUMMARY:

• About 9 years of total IT Experience in System Analysis, Designing, Development, Testing and Production Support.
• Experience in Application Development and Maintenance using Oracle (PL - SQL), UNIX, Pro*C/C, OBIEE, Kennan Billing System and ETL
• Over 2 years of domain experience in Telecom billing , 4.5 years of experience in Airline billing system and about 2 years of experience in BFSI domain.
• Experienced in data modeling, writing, tuning and optimizing SQLs and PL-SQL programs.
• Expert in Creating Tables, Views, Sequences, SQL queries, PLSQL Packages, Function, Stored Procedures, Triggers, Materialized Views, Indexes and Cursors etc.
• Proficient in Advance features of Oracle 11G for PLSQL programming like Records, Collections, Dynamic SQL, Ref cursor, Bulk binding etc.
• Expertise in Data Loading techniques using Oracle SQL loader, UTL file and Oracle utilities etc.
• Skilled at UNIX/LINUX for writing shell scripts and Batch process.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards using Analytics and OBIEE.
• Extensively worked in Design and Development of Physical, Business model and Mapping and Presentation Layer.
• Expertise in OBIEE Administration tool, Security, Answers and Dashboard development.
• Expertise in creating Measures, Dimension Hierarchies, Aggregates, Variables, Time series Measures.
• Expertise in Building Interactive Dashboards by using Roll-Up, Drill Down, Slice and Dice and Pivot Capabilities.
• Expertise in creating Reports using Oracle BI Publisher, Scorecards and KPI’s.
• Extensive Experience with all the phases of Software Development Life Cycle including analysis, Planning, Code Development, Testing, Implementation and Maintenance.
• Excellent Documentation skills in Preparing High Level Estimates, Impact Analysis, Detail Design Document, Unit test case preparation and Release notes.
• Assisted QA teams for BUG fixing, System Integration Testing and User Acceptance Testing.
• Identified as Potential SME in Application Knowledge.
• Strong database skills, procedural programming and development knowledge.
• Knowledge of Data Integration and Virtualization using Denodo Platform and Denodo data Virtualization certified Developer.
• Experience in leading projects. Handled roles like Technical Lead, System analyst, and Senior Developer.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Ability to learn and Perform, Experience in handling critical tasks in different situations, problem solving, critical thinking, troubleshooting, root-cause analysis.

TECHNICAL SKILLS:

Languages: SQL, PLSQL,C,Pro*C,Unix, Kenan Billing framework, Data Integration.

Tools: OBIEE, Oracle Application Express, RPM, DRTT, Rational Clear Quest, TOAD, SQL DEVLOPER, Source insight, GDB, RPM,RMT,CLEAR CASE, SYNERGY, SVN,CMT,GIT,JENKINS, Talend, Puppet, Denodo.

OS: Windows XP, HP-Unix, Sun Solaris, AIX, Cent OS, RedHat Linux.

Databases: Oracle 9i,10G,11G

Scripting: Shell Scripting, Groovy

PROFESSIONAL EXPERIENCE:

Confidential, Livingston, New Jersey

Oracle PLSQL & OBIEE Consultant

Responsibilities:

• Enhance the central credit risk repository and integrating it with other CIT systems.
• Work in conjunction with business analysts to create solutions to pressing data needs in the
• Corporate Risk Management department.
• Balance data from multiple loan and leasing systems is fed to a staging area that then feeds the central repository.
• Translate functional requirements into code and prepare design documents.
• Perform Data Analysis, Code and test PL/SQL processes
• Develop and Enhance front end application using Oracle Application Express
• Perform database tuning and optimization. As needed, provide code reviews of SQL & PL/SQL processes
• Design, develop and maintain OBIEE Metadata Repository including the physical layer, business model mapping and presentation layer
• Develop various types of reports using Analysis, Dashboards, BI Publisher, Prompts, Agents, Scorecard’s and KPI.
• Conduct code reviews, KT sessions, IA reviews for junior team members
• Help and mentor the junior team members to understand and gain the application knowledge

Environment: Windows, SQL, PLSQL, Oracle 11G, OBIEE, Oracle Application Express, SVN.

Confidential

Senior Engineer, Technical Specialist, Senior Technical Specialist

Responsibilities:

• New Airline Billing product development, implementation and support
• Understanding technical environment
• Requirement gathering from SITA BOPS team
• Impact analysis of new requirements and projects.
• Providing estimation for new projects and requirements.
• Translating business requirements in to technical requirements and Design the architecture.
• Ensure reuse, formal modeling techniques and alternate approaches during design.
• Development and Unit testing
• Develop RPD, and design various type of reports using OBIEE.
• Creating work processes and end-customer interaction processes
• Meeting SLAs
• Provide the RCA and solution for BUGS and Fastracks.
• Transitioning work to team members.
• Deployment, Testing
• UAT and Production Support
• Conduct code reviews, KT sessions, IA reviews for junior team members
• Help and mentor the junior team members to understand and gain the application knowledge
• Mentoring and tracking of peers.

Environment: Solaris 10. Windows, RedHat Linux, SQL, PLSQL, OBIEE, C, Pro-C, Unix, Oracle 9i, Oracle 11G, Groovy, Kennan Billing framework, Shell scripting, Talend.

Confidential

Oracle PLSQL Consultant

Responsibilities:

• Lead and Track various tasks.
• Onsite coordinator for all the meetings, client discussions and presentations.
• Porting of multiple scripts and binaries.
• Porting of various Stored Procedure, Packages and functions.
• Root cause analysis of all the issues.
• Provide Support for new server builds.
• Automate the installation of various software’s and packages in the new server.
• Performing Sanity testing and Sanity checks
• Unit testing of the migrated modules.
• Data analysis and validation of all modules.
• Documentation and Reporting
• Support the Non regression tests.
• Production support for all the issues reported.

Environment: Solaris, RedHat Linux, Windows,Kenan Billing, SQL, PLSQL, C, Pro-C, Unix, Linux, Oracle 9i, Oracle 11G.

Associate System Engineer

Confidential

Responsibilities:

• Application developer role which involves development and enhancement of existing application.
• Integrate Confidential with new interfaces and develop required modules in the application.
• Analyze the impact of requirement on existing system and obtain the optimal solution.
• Provide root cause analysis and provide bug fixes.
• Create unit test plan and execute the test cases.
• Solve production tickets created by customer.
• Review the code to ensure the functionality works according to the requirement.
• Provide Support for Integration Test, System Test and UAT tests.
• Maintain RMT, DRTT tools to track static and dynamic defects.
• Maintain configuration and versioning tool

Environment: UNIX, Shell Scripting, Oracle 10g (PLSQL),C++, Power builde