SUMMARY

• Around 10 years’ experience in software Analysis, Design, Architecture, Development, Implementation and Maintenance. This involved hands - on development using Informatica, Shell Scripting, SQL and Java (such as XML, JDBC, Servlets and JSP) technologies. The development experience complemented with solution design expertise using UML
• 7 years of experience in Informatica
• Worked on HDFS, demonstrated HIVE usage for Informatica
• Exposure to all phases of software development lifecycle, which includes requirements collection, design, development and maintenance.
• Detailed understanding of Data warehouse concepts and applications.
• Expert in Shell scripting and SQL scripting. Automating the applications
• Experienced at Data Modeling.
• Contributor for R&D team for Hadoop and Open Source BI tools.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Experienced in deployment and configuration of BEA WebLogic Application Server 6.1/8.X.
• Experienced in GUI/IDE Tool using Eclipse, WSAD 5.1.2 and WorkSpace Studio
• Excellent team player with strong problem solving and trouble-shooting capabilities, ability to work efficiently in both independent and team work environments.
• Proved ability to work well with a wide variety of people at various levels.
• A self-starter with positive attitude, willingness to learn new concepts and acceptance of challenges.
• Extensively used BASH(awk), PERL programming for Text Processing.
• Good working knowledge in Insurance domain (USA), banking domain especially in Credit Cards Processing, Retail Banking, Treasury Services, Paperless statements and Marketing campaigns
• Have been leading off-shore team.

TECHNICAL SKILLS

ETL Tools: Informatica9.01/8.x/7 - Power Center and Power Exchange

Databases and Tools: Oracle 8i, DB2 9.0, SQL Loader, TOAD, KANA-Connect

Data Modeling and Tools: OLTP, OLAP, Star Schema, Dimensional Modeling, ERWINVisio

Programming Languages: Shell, Java, SQL, Pl/SQL, PERL, XML, XSL, JSP, UML and TCL/TK

R&D Contribution: Performance Tuning for ETL, HADOOP implementation for Bulk Data,(Power Designer, JUDE), OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Senior Lead Developer

Responsibilities:

• Analyze existing data/database in legacy environment
• Design maps for new exhibit.
• Performance tuning for the existing maps.
• Key role played in setting Review/Coding standards.
• Leading off-shore team from onsite.
• SME for informatica development team
• Creating Test cases for both Qualitative and Quantitative paradigm.
• Test cases/Test objects review
• Developing Shell scripts.
• Review TRD documents.
• Impact Analysis, mitigation plans.
• Co-ordinatiion between front end and back end team.
• Identified reusable functionality, developed re-usable Transformation, Mapplets, Sessions and Worklets.
• Designing ABC (Audit Balance Control) tables and ABC informtica reusable objects
• Used shared folders in Power Center hence implemented usage of reference objects.
• Designed loosely coupled Mappings that support high flexibility for future enhancements.
• Scheduling, automating the jobs to meet user needs.
• Debugging with debugger and Verbose Initialized, Verbose Data types.
• Followed Peer review, Group review for the source code.
• Effective utilization of Quality Center for tracking the issues, tasks and escalation.
• Contributing for second level of Production Support.
• Creating Project Plans, Managing Timelines, Quality Assurance and Status Reporting
• Gathering business requirements, analyzing and delivering them into DWH solutions.
• Successfully planned and managed all phases of a DWH Project Life Cycle.
• Customized migration plan from lower environments to higher environments
• Responsible from IRP for Data Center move.
• Initiative demonstration and set up HDFS dev region.
• Demonstrated HIVE connectivity with informatica provided examples.

Environment: Informatica Power Center 9.01/8.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), MS-Visio, Toad, Passport, DB2,SQL/PLSQL, UNIX, LINUX shell scripting, Windows XP.

Senior Lead Developer/Data Analyst

Responsibilities:

• Analyzed the existing data for Requirement gathering at initial stage of project. Contacted Business users for clarification and worked with Business Analyst to have complete understanding of Business needs and expectations.
• Used Passport tool to analyze raw source data.
• Created High Level Requirement document.
• Extensively used Visio tool to represent Flow Controls, Activity diagrams.
• Extensively used Visio for the Data Modeling (Conceptual and Logical Modeling)
• Reverse Engineering for the Existing Schema and enhanced Schema using Visio
• Creating Detailed Design document of the system with all flow controls.
• Designed and used control tables, configuration tables and Stats tables.
• Risk analysis - Mitigation, avoidance plans.
• Used Power Exchange for reading data from Legacy system
• Identified reusable functionality, developed re-usable Transformation, Mapplets, Sessions and Worklets.
• Implemented User Defined Functions.
• Used shared folders in Power Center hence implemented usage of reference objects.
• Extensively worked with Variables and Parameters in the mappings to pass the values between sessions.
• Designed loosely coupled Mappings that support high flexibility for future enhancements.
• Scheduling, automating the jobs to meet user needs.
• Analysis and implementation in Performance Tuning.
• Implemented Pass Through, Auto Hash, User defined Hash Key and Data Base Partitions for performance tuning.
• Analyzed Bulk Load option, Third party Loaders suggested by Informatica.
• Debugging with debugger and Verbose Initialized, Verbose Data types.
• Creating Test cases for both Qualitative and Quantitative paradigm.
• Followed Peer review, Group review for the source code.
• Done R&D and used Informatica Approved code review tool (Sameeksha).
• Unit testing of the mappings. Preparing Validation SQL scripts.
• Writing Stored Procedure for testing complex business functionality.
• Implemented complex Stored Procedures for the validation rules on the tables.
• Designed and Implemented views to make quick access for business users for the reports and Analysis.
• Converting SP in to Informatica for performance improvements.
• Created cheat sheet, Template and Check List for developer for Implementation, code review and production deployment.
• Interacting with client (BA team) for validations and evaluation to move in to production.
• Performed R&D on various tools provided in Informatica website. Chosen for implementation that are suitable for current project improvements.
• Effective utilization of Track+ for tracking the issues, tasks and escalation.
• Extensively used Shell Scripting quick analysis on source tables, reports on log files, errors and debugging information, Rejected rows in log files.
• Leading and coordinating off-shore team. Proving off-hours support based on need.
• Contributing for second level of Production Support.
• Dynamic generation of parameter files
• Started working on Delta File Creation (Pre-Stage) using Informatica
• Automating audit and report process
• Assistance in preparing training documents
• Deriving coding standards, best practices

Environment: Informatica Power Center 9.10/8.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), MS-Visio, Toad, Passport, DB2,SQL/PLSQL, UNIX, LINUX shell scripting, Windows XP.

Confidential, NJ

Senior Developer

Responsibilities:

• Understanding and Analysis on existing POC.
• Complete study of detailed Design Document.
• Implementation of existing POCs in the form of Stored Procedure and correlate the test results as per Design Document.
• Used SQL developer for Reverse Engineering of existing DB system.
• Implementation of Pl/SQL for the quick demo to BA team.
• Implemented Triggers for dynamic bulk updates.
• Reviewing PL/SQL scripts, performance tuning of the Pl/SQL.
• Extensively used SQL Transformation, SP Transformation for the on the fly table creation and Dynamic bulk loading.
• Design Mapping, implementation, Testing POCs
• Demo of POCs in Customer conference.

Environment: Informatica Power Center 8.6, MS-Visio, SQL Developer, Oracle 11i, SQL/PLSQL, Solaris, shell scripting, Windows XP.

Confidential, San Mateo, CA

Senior Developer

Responsibilities:

• Lead the Java team for UI development.
• Direct interaction with Business Team, Stake holders to understand the requirements
• Support for Cloud set up to use the DB, OS as services.
• Played a technical lead role for the delivery responsibilities like development, testing.
• Generated Requirement Document by studying the existing application, by analyzing the existing data and MOMs of Business meetings.
• Designed a Star schema for the page hits and its categories with various dimensions Geographic, Device and Operating system.
• Conceptual, Logical and Physical design for Data Warehousing (Star Schema).
• Creating control tables, configuration tables for the smooth process.
• Loaded facts from Weblogic log database.
• Implemented SCD2 for Geographic, Device Type, OS dimensions.
• Designing DB system that serves billing, analysis and reporting needs.
• Design Mapping, implementation Transformations
• Reviewing Pl/SQL scripts, and Reporting.
• Efficient usage of special kind of Stored Procedures, at pre-source and Post-target loads.
• Developing shell scripts for automation for daily loading of facts from log files, populating report tables.
• Integrated Data warehousing, Shell scripting and Java to building Centralized Reporting System.

Environment: Informatica Power Center 8.6, ERWIN, SQL Developer, TOAD, Power Designer, Oracle 11i, SQL/PLSQL, Solaris, shell scripting, Windows XP.

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Performance Tuning of all existing mappings in Production.
• Enhancement of existing mapping based on business requirements.
• Developing new mappings by using/not using existing reusable components.
• Requirements gathering by working with CE team.
• ETL for KANA system.
• Extensively used XML, XSL for template generation for the KANA.
• ETL for Card Services Data Mart.
• Extracting KANA reports from KANA system, Transform and Load in to Data Mart.
• Implemented to load data in various combination to build BI for business team.
• Used different types look up transformations as part enhancements of the existing mapping.
• Efficient overridden queries for the look up transformation, especially to improve performance, to return single value from different tables which are in referential integrity, reusable look up transformation.
• Functional and technical specs preparation.
• Planning the effort and estimation and tracking for assigned job.
• Reviewing off-shore jobs, efforts.
• Automation of monitoring, reporting and e-mail notification of existing jobs.
• Effectively managed URL Redirecting application for Card Services business URLs

Environment: Informatica Power Center 7.1, SQL Developer, TOAD, Oracle 8i, SQL/PLSQL, Solaris, shell scripting, KANA Connect, KANA Response, XML, XSL, PERL, JSP, JAVA, JAVA Script, Windows XP.

Confidential, Columbus, OH

Java Developer

Responsibilities:

• Analysis of the system (Check Services, Account Transfers and Investments).
• Proactive Identification of production issues by automation of DB SQL scripts and get notified by Solaris OS e-mails.
• Developed patches and deployed to avoid recurring production issues.
• Design and implementation of Batch system
• Creating whole design document of The One Net system to make ease for the Chase Online System.
• Developing proof of concepts for the Chase Online project.
• Development of Change Requests and Work Orders.
• Lead whole team for development and Maintenance.
• Involved in design using UML. Design artifacts include Use Cases, Class diagrams and Sequence diagrams.
• Involved in client liaison and interaction.
• Implementation of Batch process - Automates report generation, scheduling transaction. Controlling transaction from Check Services to Account transfer application.
• Developed JSP’s as part of presentation layer for Chase Online project.

Environment: Java 1.4., Web Services, JSP, Servlet, HTML, JDBC, XML, WebSphere, Apache ANT, DB2 and Shell Script.

Confidential, Milwaukee, WI

Java Developer

Responsibilities:

• Understanding Detailed Design Document.
• Understanding JUDE, Visio driven flow diagram and activity diagrams.
• Implemented JSPs
• Extensively used Java Scripts for form validations and interactive submission.
• Worked Java Mail Services.
• Understanding MVC, MVC2 architecture.
• Worked Aspect Oriented Programming to generated more re-usable components.
• Worked on preparing Test Case by having Detail Design Document.
• Participated Peer review and Code reviews for the JSP
• Effective usage for Bugzilla for the bug tracker and escalation.
• Extensively worked on Java Doc - Auto generation of documentation using Java
• Involved in design using UML. Design artifacts include Use Cases, Class diagrams and Sequence diagrams.

Environment: Java 1.2., JSP, Servlets, HTML, JavaScript, Aspect Orient Programming (AOP) JDBC, XML, Web Logic, Apache ANT, Oracle.