Objective


Seeking a Technical/Lead role in the Business Intelligence and EDW area



Employment

February, 2007 -  March, 2009

December, 2003 -  February, 2007

IT Engineer with 5 years of experience.
Proficient with Informatica, Kalido, Cognos, Teradata, Oracle, SQL, Unix.

Experience in implementation and support of Data Warehousing projects since the start of my career. Worked on 2 different environments Oracle and Teradata as Data warehouse. experience is in requirement analysis, Business Modeling, Data Modeling, Design, Development, Testing and Production support. With extensive experience in ETL, ETLT and Business modeling projects, I have written and verbal communication skills. A team player, self-starter and capable of working independently.

have worked on BI area using Cognos 8 starting from understanding the business requirements, defining metrics, defining the report layout, development, UAT and user training and support .I have completed the entire life cycle of a BI project in 5 months.

DELOITTE CONSULTING

March, 2007 -  March, 2009
ETL Developer

Ethicon Endo-Surgery, Inc EES develops and markets advanced medical devices for minimally invasive and open surgical procedures. The company focuses on procedure-enabling devices for the interventional diagnosis and treatment of conditions in general and bariatric surgery.
JnJ EES EDW project provides end to end solution and implementation for Enterprise Data Warehouse. Requirements gathering, Analysis ETL and business intelligence. Also provides the 24*7 support. Though the project has the onsite-offshore counter parts, the offshore is involved in analysis of the source system and data modeling. This is a unique characteristic for about this project.

Key Responsibilities in DATA IN ETL Tool : Informatica and Business Modeling Tool : Kalido : Understand the business requirements and perform source system analysis.
Based on the initial analysis, lay down 40% business model. This business model is further refined by talking to business, understanding the details, doing source system analysis.
Making sure the business model answers all the questions needed from the BI perspective.
Understand various metrics needed by the business for its operational and analytical answering.
Refine the Business model further if need be and mark it to completion.
The Business model has to fit the dimensional model so that it becomes easier for design and development.
Develop key deliverables, Design documents
Create Change Management documentation for assigned implementations

Designing a data model to support data merge activities, defining ETL extraction, transformation and loading procedures, identifying the environment and staging areas.

Create data model using Kalido. Create mappings for the summary load.
Develops and executes effective test plans to ensure quality and stability and mark it ready for System testing
After the successful completion of system testing, facilitate the User Acceptance testing. Depending upon, how the user want the UAT to be done, help in performing the UAT. Have series of meeting set up and make sure that the UAT is completed in the required timelines.
Make sure the release plan and the required job schedules are tested and facilitate the production move.
Understand and follow the IT Services transition process to ensure a smooth transition of support to Support Teams
Get involved in code optimization and aggregation of data as required.

Tracks time and fulfills required status reporting requirements.
Estimates tasks for project planning and sets timelines

Provides management and other team members clear and timely updates on status of assigned responsibilities
Train new team members on Informatica, Kalido and business modeling.

Key Responsibilities in DATA OUT : BI Tool : Cognos
Understand the business questions to be answered as a part of BI analytics having series of meeting with the user
Make sure that the data needed for the BI reports are captured as a part of Data in. If not facilitate the Data In process.
Understand the data.
Create report templates using mock up data and get it verified from the user to make sure that is what they want.
have a green flag, initiate the development process.
Create query subjects and query items in the framework Manager, to make sure that the development process is simplified. Create query subjects and query items such that they are friendly for development reuse.
Using Report Studio and Query Studio create first cut of reports and Heat maps as per business requirements.
After the first cut, get them verified from the business and further refine them.

Gained experience in Framework manager- able to built query items and query subjects so that development becomes easier.
Facilitate the unit testing and system testing.
Once the UT and SIT are completed, have series of session with the business users and perform the UAT.
Facilitate the production move.

Technical Environment : Informatica 7.1.4
Kalido 8.3 for Business Modeling
Cognos 8 as a BI tool
Oracle as an Enterprise Wide Data warehouse
Oracle for Staging
Unix shell scripting
Maestro for scheduling jobs

TATA CONSULTANCY
Services

April, 2004 -  February, 2007
Role : ETL Developer and Team Lead

SUPERVALU

is a leader in the grocery retailing industry. They combine experience in grocery retail and supply chain operations - 2 highly complementary core competencies.
SuperValu has a 3 TB warehouse with various subject areas like retail, wholesale, category management and employee workforce management. Teradata is used as final database for the warehouse and oracle for staging. Microstrategy is used as a reporting tool on the front end.

Key Responsibilities : Developed mappings/workflows to meet the ETL requirements.
Wrote complex Teradata bteqs for aggregation of data.
stored procedures to enhance performance.
Scheduled jobs in Autosys taking into account the ETL dependencies.
Assisted and set Script and Informatica Coding Standards for easy maintenance.
Interpreted technical design requirements effectively
System Impact Analysis.
Fine tuned long running SQLs and bteqs.
Supported the production environment 24*7 and met the SLAs

Ensured closure of open issues

Technical Environment : Informatica 7.3
Teradata as an Enterprise Wide Data warehouse
Oracle for Staging
Unix shell scripting
Microstrategy as a BI tool
Autosys for scheduling jobs

December, 2003 -  March, 2004
Role : IT Specialist

Education

Training

Teradata Certified Professional V2R5 , February 2005 .
Teradata Certified SQL Specialist V2R5 , October 2006 .
Birth Date : 6 August 1981
I is able to work for any employer since I have an EAD valid till 25 December 2009 .
interested in sponsorship of H1 so that I is able to work independently .


Miscellaneous

National City Mortgage is a division of National City Bank.
They specialize in originating residential mortgage loans through their retail, wholesale and telemarketing channels. National City's mortgage operations originate, acquire, market and service those loans.
NCMC
s Loan Origination Systems consist of various application components, Loan Delivery, Doc Tracking, Accounting Systems and various interface systems.
Key Responsibilities : Analyzed the problems reported by the users and providing solutions with the Loan Origination systems.
Provided Tier- I issue resolution to end-users.
Set up profiles for users on the network for thin clients, laptops and desktop pc
Technical Environment : Windows
Citrix Client
Novell Netware for Heat
Worked on team to develop next-gen prototype for IBM Intranet web portal, integrating several legacy sales/forecasting tools into a single application. Created Java-based portlets and Java Server Pages JSPs to build a unified user experience. Used WebSphere Content Manager suite to implement a document catalog, for storing and tagging thousands of user-generated reports. Used IBM Internal site standards for interface coding. Extensive use of Java, AJAX/JavaScript, SQL and Unix shell scripting required. Assisted with proof-of-concept reviews and stress testing.