Developer Data

SUMMARY

Leading team as an application designer and developer for waterfall as well as agile based projects.

Good in areas of Research, Analysis, Design, Development, Testing and Implementation of Software Systems.

Proficient in Oracle Goldengate architecture, mapping and deployment support.

Multiple years of experience in DWH-BI technologies.

Excellent problem solving skills, with an enthusiasm to learn more.

Strong communication skills to work with client, business users and team members.

Ability to work independently as well as in teams, taking care of team dynamics and challenges.

Proven customer facing experience in both pre-sales and delivery.

TECHNICAL SKILLS

Languages : Java

Web Technologies : HTML, CSS, JSP, Servlets

Oracle Stack : Goldengate, OBIEE, ODI, OSB, WorkSpaces, Timesten (IMDB),

Non Oracle Stack : Informatica, Hadoop

Operating Systems : Windows XP, Windows Server 2003, Windows 7, Unix

Databases : Derby, Oracle

Framework : Struts

Tools : PL/SQL Developer, SQL Developer, JDeveloper, Toad, SVN, Putty

PROFESSIONAL EXPERIENCE (9 Years)

Tech Mahindra Ltd.

Client: AT&T, Richardson

(March, 2013 - till date)

Project: Data Transformation & Integration (DTI)

Role: Application designer and developer

Description:

DTI application provides architecting, design, and development services for receiving Informatica batch files and Goldengate replication data feeds from a variety of data sources, performing required data transformation and aggregation and replicating the integrated data to the various operational data stores in the data fabric layers of the enterprise.

Responsibilities:

Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Module Lead for review.

Analyze functional/non functional requirements.

Prepare the AID, application design based on HLD, DMS and briefing from Data analyst.

Seek inputs from the developers on specific modules as applicable.

Consolidate all modules and provide to Module Lead/ Architects/ Designers for review

Develop GG extract, data pump, replicat processes and analyze applications for GG suitability.

Suggest changes in design on technical grounds.

Follow coding standards and best practices to develop code and check code quality

Rework on the code based on inputs if required

Guide developers in identifying, preparing and conducting unit test cases and fixing defects

Golden gate configuration, replication implementation, production support and troubleshooting

Conduct/ guide conducting of unit and integration testing and fix defects

Review/ approve code to be moved to testing environment

Provide support to the QA team and coordinate for various phases of testing

Maintain versions of the code or consolidate version maintained by the Developers.

Support to Administrators during configuration, code backups, deployment etc

Monitor work of the developers and share work with them.

Provide guidance through SDLC

Share activity status with supervisor and highlight concerns if any in Design or Code

Create/ update knowledge articles (case studies, lessons learnt) in the knowledge management repository.

Environment: Oracle Goldengate 11g, Informatica, UNIX, Oracle SQL, PL/SQL

Oracle Financial Services Software Ltd.

(Sep, 2008 - March, 2013)

Client: Major European Bank

Project: Payment DataMart

Role: Developer

Description:

This core service is used to store all payment related, account related, posting, branch, charge, payment audits, participant related like sender receiver creditor debtor, EOD details, relation master, payment comments, payment currency information etc. into staging data warehouse and through ETL, staging area data get transformed and loaded into PDM data mart. PDM is fact dimensional schema model having payment fact and different dimensions attached to it. PDM data is used for generating ad-hoc and scheduled reports.

Responsibilities:

Follow coding standards and best practices to develop code and check code quality

Share developed code with supervisor for review

Rework on the code based on inputs if required

Creating New Reports, Making Changes to existing Reports in OBIEE 11g

Created User Prompts, Conditions and Filters to restrict the data as per the specifications

Created Alerts and Notifications in the reports to highlight critical data

Guide the developers in identifying, preparing and conducting unit test cases and fixing defects

Consolidate the test results and share with supervisor.

Conduct training through academy or internally within the team

Environment: Informatica, OBIEE, java, Oracle

Client: Major European Bank

Project: Payment Data Warehouse

Role: Developer

Description:

Payment Dataware House is comprehensive solution for Payments related Business Intelligence. It's a “Payments” aware base model for a quicker implementation. This platform supports Standard operational reporting, Dashboards for Management Information & Decision Making. A very flexible model that can be enhanced based on Bank’s requirements including reporting and analytical needs.

Responsibilities:

POC initiation activities.

POC planning.

Understanding the requirement of customer.

Created and managed Data Sources.

Created reports like customer centricity and STP/ NON STP volume.

Created alerts/ notifications through emails.

Involved in discussions internal/ external for the requirement analysis.

Demonstrated the POC to customer.

Actively involved in rpd creation team.

Organized WebEx Demos given to the Prospect.

Environment: Oracle Goldengate 11g, Informatica, Oracle Business Intelligence 11g, Oracle 11g

Technology and Innovation Team:

I built POCs on Technologies like Goldengate, OBIEE, TimesTen, TeamCollaboration, OIF, OSB-BAM integration.

I have conducted Trainings on Java, Ruby, SOA, TimesTen, Goldengate, Fresher’s Training, Team Collaboration, Universal Content Management, Various SOA Products (SOA, OSB, BPM, CEP), XForms.

Proficient in Configurations and installations of Oracle Fusion Middleware Components like Identity Server, Web Pass, Policy Manager, Access Server. Webgate

Responsibilities

Interaction with client for requirements analysis and understanding of the required functionality.

Preparation of project design, developing new & modifying existing components.

Preparing Unit Test Cases, Black Box and White Box testing, performance testing,

POC initiation, planning and conducting Demos presented to the potential customers.

EDUCATION

Bachelor of Engineering from University of Rajasthan, Jaipur in 2008

EXTRACURRICULAR ACTIVITIES

Awards

Graduation with HONOURS in Bachelor of Engineering.

Organization level 2 time winner of appreciation award in Oracle Financial Services Software Ltd.

Received appreciation award in Tech Mahindra for contributions in project.

Positions of Responsibility

Have been the part of organizational committees in college to organize events as seminars by various reputed organizations.

Winner of many extracurricular activities in college.

Interest

Gardening.

REFERENCES

Gaurav Jain: Senior Software Engineer, Tech Mahindra Ltd.

******.*.****@************.*** / +1-678-***-****

Amit Rathi: Principal Consultant, Oracle Financial Services Software Ltd.

****.*****@******.*** / +1-813-***-****

Umesh S Aherwadikar: Solution Architect Manager, Oracle Financial Services Software Ltd.

************@*****.*** / +91-982-***-****

Contact this candidate