SUMMARY

• Around 7 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Banking, Telecom, and Retail domains.
• Working experience in all the phases of the Data warehousing life cycle (SDLC) including: design, development, analysis & testing of the data warehouses as ETL developer using Informatica 8.x/9.
• An expert in Informatica with full life - cycle implementation & post go-live production support experience.
• Played the role of Point of contact with the client as well as an Onsite coordinator. Managed team and involved in the daily activities, communications and calls.
• Extensive experience in Informatica server activities during the up-gradation and version control.
• Good knowledge in the installation and Configuration of the Informatica Client tools and configured the repository manager Folders and users and privileges.
• Hands on experience in Dimensional Data Modeling using Data Modeling, Star Join Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
• Involved in 24/7 Production support, monitored workflows using workflow monitor, fixed issues and improved the performance of the ETL loads.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, workflows, and sessions.
• Participated in data analysis, ETL requirement gathering and data cleansing activities.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages) and UNIX shell scripting to run pre session and post session commands.
• Expertise Programming skills developing the Stored Procedures, Database Triggers and Packages using PL/SQL.
• Experience to work with Oracle, SQL, PL/SQL, SQL Loader.
• Worked with heterogeneous data sources like Oracle 8i/9i/10g/11g, SQL server, Teradata, Netezza flat files, and XML files.
• Expertise in Designing Fact Tables, Dimension Tables, Summary Tables.
• Proficient in writing Test cases & Scripts, Executing Test cases & Scripts, Analyzing Results and Defects Tracking & Reporting. Extensively involved in Functional, Integration and Regression testing.
• Worked on transformation of complex business scenarios using Lookup, Update Strategy, Normalizer, Aggregator, Expression transformations.
• Have knowledge on Business Objects 6.5, and trained on Cognos.
• Confident, friendly, innovative person, adaptable to new change, and dedicated to work.
• Quick Learner, Inspiring Team Lead, and Tech Expert and would take more responsibilities to achieve team goal.

TECHNICAL SKILLS

ETL Tools: Informatica 8.1/8.6/9.1

Reporting Tools: Business Objects 6.5, Crystal Reports 7.5.

Other Tools: AUTOSYS, IBM TIVOLI SCHEDULER.

Databases: Oracle 9i/10g/11g, SQL Server, DB2, NETEZZA, MySQL

Systems: UNIX, Windows 9X/NT/2000/XP/2K3

Languages: UNIX Shell, PL/SQL, SQL, HTML, ASP, CSS, Java

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Informatica Senior Developer

Responsibilities:

• Working on Requirements analysis,
• Working with DBA to design the Data model, Star Schema and implementing CDC
• Converting the Requirements into Business Rules for ETL Transformation
• Development of Informatica Mappings, Sessions, and Workflows of varying complexity.
• Identifying the Bottleneck in the performance and resolution.
• Code Building and Migrating to Production, through all phases of SDLC

Environment: Informatica 9.0.1, Oracle 11g, UNIX Shell, AUTOSYS

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• ETL Development for New Initiatives Such as P2P, First, CAPMAN, SKIRE etc
• Each of the Initiatives involved
• Development of Informatica Mappings, Sessions, and Workflows of varying complexity.
• Development Of Unix Scripts that supports functionality
• Assisted in Data Model Design with DBA.
• Code Building and Migration to Production, through all phases of SDLC
• AUTOSYS Job Schedule Design and Implementation
• ETL Migration from Informatica 8.1 to 8.6
• Supported the Oracle Upgrade from 9i to 10g
• Migration of Unix Scheduler from IBM Tivoli Scheduler to AUTOSYS.
• Identified the Bottleneck in the performance and resolution.
• Implemented several Tuning Performance improvement in Informatica/oracle 10g
• Developed Unix Shell Scripts, for different functionality such as
• File Pattern Match / File Transfer using SFTP/NDM
• Oracle stats Collection of Tables to improve performance

Environment: Informatica 8.1/8.6, Oracle 10g, UNIX Shell, AUTOSYSIBM Tivoli Workload Scheduler

Confidential

Business Objects Designer

Responsibilities:

• Automated validation of Integrity Check and Auto Resolution using Excel VB macro. The Excel Macro, provides easy option to import the business object Universe In to Excel file as a Document, also it can be used to create objects/classes from excel.
• In addition to that, as part of the requirement justification, I have designed eight complex Business Objects reports that demonstrate the purpose of the new universe.

Environment: Business Objects 6.5, Netezza, Oracle 9i

Confidential

Crystal Report Developer

Responsibilities:

• I have worked on 50+ SORs (Statement of Requests) and Each SOR can be either creation of new reports and modification of existing reports.
• I have reverse engineered the data model to understand the business of the source system, and provided report solution to the business.
• In addition to that, Also, I have managed 300+ reports that are created in the past six years in the crystal reports application.

Environment: Crystal Reports 7.5, Oracle9i

Confidential

Crystal Report Developer

Responsibilities:

• For prime integrator, I have developed enhancements with around 1000 lines of code, which saves 50 hrs. of manual work every month.
• For CSIS, I have identified several bugs that caused the application to fail on various scenarios. The bugs have been passed on to developer to resolve it.
• As a support person, I ensured the application is available online always, with the help of fall back server.

Environment: Oracle Pl/SQL, SQL Server, ASP, SSIS, IIS, Apache

Confidential

Developer

Responsibilities:

• In addition to the coding, I have implemented “in screen div popup” based on Ajax, which was appreciated by clients and it was implemented across the project.
• Also, I have learnt the struts Validation framework in a short period of time, implemented the same across the project.
• Also, I have developed custom validation class that extends struts validation framework, which can be used by the entire team.

Environment: JAVA, JSP, Struts, Oracle Pl/SQL

Confidential

Software Trainee

Responsibilities:

• JSP or web Interface for Bank Customers/ Employees
• Java Applets frontend (thick client) for Bank Employees.
• Web Services Interface for applications interactions
• During the Confidential Training, I have volunteered as Web Designer for Gurukul, Confidential Mysore Dc Newsletter. I have designed newsletter for four consecutive editions based on HTML/CSS/JavaScript along with the help of tools such as Adobe Photoshop / Macromedia Dreamweaver. I have implemented a JavaScript based quiz, which brings in large no. of clicks to the newsletter.

Environment: JAVA, JSP, Struts, Oracle, and all generic concepts of IT.