SUMMARY

• 15.2 Years of IT experience.
• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
• Good team player, strong interpersonal and communication skills combined with self - motivation initiative and positive attitude.
• Good in Onsite-Offshore work co-ordination.
• Worked on Oracle Database supporting OLTP and Data Warehouses.
• Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
• Strong experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
• Created worklets by grouping different sessions related to a subject area.
• Have knowledge about the Informatica PowerExchange.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Developed effectively different type of SCD’s based on the specifications.
• Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger project.
• Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
• Experience in interacting with onsite clients while being responsible for deliverables.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Quick to learn.
• Worked in Agile work environment.
• Handle the work independently.
• Had a good knowledge and completed training in Oracle Data Integrator (ODI)
• Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
• Organizing timely meetings with Business and other teams, then sharing the MoM based on the meeting outcome.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows XP/2003/2007/8

Languages: C, C++, Java, SQL, PL/SQL

Databases: Oracle, MS Access, DB2

Web Related: Salesforce, HTML

ETL Tools: Informatica Powercenter 10.2, Informatica Cloud 9.6, Informatica Powercenter 9.1, Informatica Powercenter 8.6, Informatica Data Quality 9.6, ESP, Ab Initio

Schedulers: DAC (Data Warehouse Administration Console), CA7 in Mainframes, Control-M, Crontab, Autosys

Reporting Tools: Cognos, OBIEE

Utilities: TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Agoura Hills, CA

Senior Software Developer, Team Lead

Responsibilities:

• Leading ETL design and implementation to ensure smooth data extraction, transformation and load into data warehouse
• Responsible for transforming logical business requirements into appropriate schema and data model.
• Responsible to create both logical and physical data models using ERWIN
• Experience with modern cloud based DWH products like AWS Redshift
• Responsible in mapping the requirements with FDS and URS document for functional phase and develop the program respectively.
• Managing Centralized data for entire organization at one stop
• Experience with modeling normalized and de-normalized data structures
• Responsible for designing and developing the ETL for consolidated reporting from Salesforce, legacy DB and other data sources into Salesforce wave.
• Responsible for design efficiency to minimize data refresh lags between systems to report timely data.
• Responsible to enhance the existing data warehouse star schema.
• Tune the Oracle databases and ETL for maximum performance.
• Responsible for Data Profiling, Data Cleansing, and Data Auditing.
• Extensive design and development experience in Datawarehouse and data mart design
• Experience with loading large volume of data from Salesforce and oracle-based sources (Merlin) using tools like Informatica
• Experience of data modelling and data bases like Redshift, Oracle & MySQL
• Experience with modern cloud based DWH products like AWS Redshift
• Ability to decode and write complex SQL queries
• Performance tuning of queries and data loading process
• Experience with data analytics using tools like Salesforce
• Lead the project with a team of ten members and mentor newly joined engineers to the optimum level of efficiency.

Environment: Informatica Cloud, Informatica Powercenter 10.2, Salesforce, Oracle 11, Unix, BitBucket

Confidential, Boston, MA

Senior Software Developer

Responsibilities:

• Gather and analyze the requirements from Business Analysts of Confidential .
• Prepare the technical design documents.
• Perform project activities in compliance with the Agile/Scrum methodology.
• Designed and created the tables by following Snowflake Schema Methodology.
• Estimate the efforts (in terms of hours) based on the tasks assigned and plan the work accordingly.
• Make use of the ETL tool like Informatica PowerCenter, ESP and Oracle SQL/PL-SQL appropriately in the project considering multiple factors such as optimal performance and easy maintenance of code by maintaining the industry standards.
• Design and develop new code for bringing in new functionality as per the Business expectations
• Providing knowledge to the code for handling multiple Business cases for a given scenario thus reducing the efforts for doing re-work.
• Migrate the code from development to UAT
• Do the unit testing and integration testing as per test cases.
• Fix the bugs that get popped up during this process
• Provide test results to Business and get their sign-off to go-ahead for further process.
• Creating scripts in Unix for auditing and scheduling of batches by considering their dependencies
• Deploy the code to Production following the process from end to end.
• Track the issues and work on them on priority issues.
• Include enhancements in the code based on the on-going business changes.
• Preparing the documentation for easy maintenance of project.
• Update Business and Manager about the timely status of work completion and projected timelines.

Environment: Informatica Cloud, Informatica Powercenter 10.2, Informatica Powercenter 10.1, OBIEE, SQL Server, Oracle, PL/SQL, Control-M, Unix

Confidential

Senior Informatica Developer

Responsibilities:

• Discussed with Business users to understand their current requirements
• Analyzed the list of existing workflows at each subject area level.
• Prepared the technical design documents.
• Estimated the efforts (in terms of hours) based on the tasks assigned to team and guide them accordingly.
• Designed and developed new workflows wherein the functionality was not incorporated in existing code.
• Purged a part of the existing code that is not required anymore and enhanced where needed.
• Used Informatica Cloud to extract the data from Salesforce to Oracle database.
• Track the issues and work on them on priority issues.
• Tuned the workflows that are having performance issues by taking the statistics from the production environment.
• Created PL/SQL procedures in the instances wherein PL/SQL works much more efficiently than Informatica
• Prepared the test cases and got the sign-off from Business.
• Created deployment groups and migrated the code from Dev to QA environments
• Performed the unit testing and integration testing as per test cases.
• Involved Business wherever needed and got necessary approvals by contacting various teams (like Business users, Informatica Admins, Change Management)
• Deployed the code to Production following the process from end to end.
• Update the Business and Managers about the timely status of work completion and projected timelines.

Environment: Informatica Power Center 9.6, Informatica Cloud 9.6, Informatica Power Center 8.6, Salesforce, Oracle 11, SQL Server, PL/SQL, Unix, Autosys and TOAD.