Lakshmi Balu

adpvkr@r.postjobfree.com

984*******/759-***-****

PROFESSIONAL SUMMARY:

** ***** ** ** ********** in the Analysis, Design, Development, Testing and Implementation of business application systems for different domains

Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

Strong Data Warehousing ETL experience of using Informatica 10.2/9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor, Informatica EDC, Datastage 11.5 Designer. Director

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Extensive testing ETL experience using Informatica 10.2/9.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Datastage 11.5, Oracle, Teradata and Business Objects.

Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.

Expertise in working with relational databases such as Oracle, Teradata.

Experience as solution provider for complex requirements and design the ETL job framework for various Data layers as a part of the core competency member.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming and Informatica. Also have had quite good experience in Performance Tuning at both Database Level and Informatica.

Experience in using Automation Scheduling tools like Autosys and APPWORX

Worked extensively with slowly changing dimensions.

Experience in reporting tools like Cognos, Business Objects

Hands-on experience in agile and across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Played various roles on Projects that required Datawarehouse Consulting which include Architect, Consultant, and Project/Team Lead roles with a maximum project team size of 8.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Education

Course

Institution

Board/

University

Year of

Completion

Marks %

/ CGPA

B.E (IT)

XII

X

PSG College of Technology,

Coimbatore.

SRV Higher Secondary School, Rasipuram.

DAV Higher Secondary School, Gopalapuram, Chennai.

Bharathiar

University

State Board

CBSE

2003

1999

1997

8.9

96

86.6

Technical Skills:

ETL Tools: Informatica Power Center 10.2/9.1(Designer, Workflow Manager, Workflow Monitor, Repository manager), Informatica EDC,Datastage 11.5, Informatica BDM trained by Edurekha, Abinitio trained in Wipro technologies

Databases: Oracle /Teradata/SQL Server

Data Modeling tools: Erwin

OLAP Tools: Cognos /Business Objects

Languages: SQL, PL/SQL, UNIX, Shell scripts, JCL

Scheduling Tools: Autosys,APPWORX

Versioning: CVS, GIT

Contact this candidate