Experience Summary

• Around 9 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
• Around 7 years of experience in Informatica
• 3 years of on-site experience working with Client (Business and CE teams)
• 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
• Worked with Offshore Team.

Technical Skills
ETL Tools : Informatica9.10/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, ERWIN,
Visio
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.

Education:

• MCA Holding prestigious RedHat Certified Engineer

Professional Experience

Confidential,TX Feb ‘2011 to Present
Health Management System (HMS) Carrier Loads, Client Loads
Senior Informatica Lead Developer/Data Analytics

HMS organization is providing Business Intelligence to State and Federal government to reduce the cost in Health Insurance Sector. Eligibility Loads project is to load Eligibility information of Commercial Insurance and AIDCAT information provided by State and Federal. Extract data from Mainframe source, Process for Cleansing, reformat, data validation; apply rules, Transform, Embed BI and Load in to DB2 data mart. Power Exchange is to read source data from Mainframe system, Power Center for the ETL, ECTL and DB2 as Targets.

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
• Using DT Studio for UDT transformation.

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 Nov’ 2010 to Jan’ 2011
Enterprise Data warehouse for Banking system
Senior Developer

SPAN is EDB Ergo Company, as part of complete solution of the Nordic Banking DW, with the Help of IBM expertise, designed an Enterprise Data Warehouse. Our job is to design ETL process, Intermediate Schemas and SCD2 for each stage.

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,CA Aug ’2009 to Sep ‘2010
Centralized Reporting System
Senior Developer

Kony Labs invented a new paradigm in mobile application development world. They needed an EDW and Centralized reporting system for its clients. This project designed to serve their purpose. Also, project provides complete information for billing, Analysis and BI purpose.

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,DE Dec ‘2006 to Oct ‘2010
Card Services – Paperless Statement Notification
ETL Developer

JP Morgan Chase is a leading bank in USA, worked in ETL team for Card Services Campaign and Statement Notification. KANA Connect tool as for bulk e-mail sender. Power Center as an ETL tool for transform and load data into KANA database. Statistics on statuses of email needed to load Card Services Data Mart. Cumulative data (Statistics) need to load in to EDW. URL redirecting is a Java based application to manage all Card Services related URLs. Production support on existing workflows, Report generation was one of the major roles.

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 July ‘2005 to Nov ‘2006
The One Net
Java Developer

BankOne was one of the leading banks in USA. TON (The One Net) is provide all services for the corporate users. TON transformed in to COL (Chase OnLine) with new flavors. The project is dedicated to serve Check Services, Hold Payments, Cancellations, Account transfers and Investments both in batch mode and as independent transactions. Worked on this project from off-shore including Production Support.

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,WI Feb ’2004 to June ’2005
Safebox, Escrow
Java Developer

Metavante is a leading solution and service provider for the banks in USA. Safebox and Escrow applications provide user-friendly UI to be used by customers on their own. Implementation is done from off-shore.

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.