Lakkoju, Laxmi Narayana

Email: acg740@r.postjobfree.com;Ph: 210-***-****

PROFESSIONAL SUMMARY:

9+ years of experience in designing, developing, testing and maintaining

business intelligence applications in Data Warehouse and Database Business

Systems for Banking, Financial, Insurance Industries

Performed as an On/Off Shore Lead, ETL Lead, ETL Developer & Database

technologies along with domains.

Experience in requirement gatherings, analyzing business processes and

making necessary changes.

Experience with Data Warehouse Concepts such as Star schema, Snowflake

Schema, Fact and dimensional tables. Experience includes designing,

implementing and integrating various Data warehouse and Data Marts.

Experience working with data modelers to translate business

rules/requirements into conceptual/logical dimensional models and worked

with complex de-normalized data models.

Clear understanding of Business Intelligence and Data Warehousing Concepts

with emphasis on System Development Life Cycle.

Experience in analyzing the Sources,Preparing S2Ts,creating Analysis &

Design documents and creating the Data stage jobs and monitoring

Experience in Developing and implementing Live office connectivity to BO

Enterprise, Building Dashboards in Xcelsius 2008/Sap Dashboards, Reports

(Query as Web Service), Performance Dashboards, Score cards and Metrics.

Proven abilities in creating complex reports by linking data from multiple

data providers, using free hand SQL, stored procedures and functionalities

like Combined Queries.

Experienced in Data Modeling, Data Architecture, Business and Data

Analysis.

Exceptional experience in dealing with various databases like Oracle, DB2,

SQL Server, Teradata, Sybase, and Flat files.

Experience in educating and supporting end-user reporting needs using

Business Objects.

Involved in the Change Control Process, Defect Review Board, BI Peer

Reviews, and Product Support.

Highly organized, dedicated with a positive attitude and a quick learner.

Excellent communication skills, Self-motivated, highly committed to

responsibilities, ability to work independently and can perform well within

cross-functional teams.

1 TECHNICAL SKILLS:

ETL IBM Web Sphere DataStage 9.1/8.1/7.5.1 (Administrator, Designer,

Director) Informatica Power Center 8.1/7.0, OLAP and OLTP

Reporting Tools Business Objects 6.5.1/XIR2/XI 3.0/ 4.0, BO Developer Suite

(Supervisor, Designer, Web Intelligence, Crystal Reports XIR2 and

Xcelsius Dashboard

Data Modeling Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling,

Tools Fact and Dimensions Tables, Physical and Logical Data Modeling and

Erwin

Databases Oracle 10g/9i/8i, DB2V7.0, MS SQL Server, Teradata, Ms Access,Sybase

Programming/Oth SQL, PL/SQL, C, UNIX Shell Scripting, Remedy, SharePoint, Quality

ers Center

Operating Win 98, UNIX, Linux, MS-DOS

Systems

CERTIFICATION SUMMARY:

In the year 2012 Certified as SAP certified HANA Developer

In the year 2008 Certified in Insurance Concepts,LOMA

In the year 2009 Certified in IBM DB2 Data Base Fundamentals.

2 PROFESSIONAL EXPERIENCE

3 United Services Automobile Association, San Antonio, TX

Jun 12 -Till Date

4 Role: Sr. ETL Developer

5 BO Usage Mart:

6 BICC @ USAA interested in the BO content perform some analytics on the

same, so that the most frequent usage content can be retained and very

minimal usage content or unused content can be removed from the system so

that system resources can be effectively utilized

7 Data modeling:

Worked with the Data modeler on the Data mart design

Identified all the Facts and Dimensions

Worked with Data Modelers to concrete the DB design

Worked with the DBA on instantiating the DB

8 ETL Development:

Analyze the Business Requirements and Involved in Analysis, Design,

Development, UAT and Production phases for new modules and enhancements of

the application.

Develop ETL jobs to load data from Enterprise data warehouse to Data mart,

Used DS parallel extender's ability to design the DS objects to run

efficiently using optimal resources

Used Environment Variables, Project parameters, job parameters, apt config

file, Stage Variables and Routines for developing Parameter Driven Jobs.

Understanding the existing rules of analyzing risk and develop a strategy

(ETL) to reduce false positives

Coordination between offshore & Onsite teams

Preparation of the estimates, time lines of the deliverable and project

execution plan.

Analysis of the data sources.

Preparation of S2T, A&D and design documents

Created parallel jobs using data Stage Designer.

Excessively used complex stages like aggregator, Lookup, Change capture,

joiner, Funnel, etc...

Created sequential file sets and Data sets as per the requirements.

Specified the partitioning methods as per the stages where ever required.

Debugged the jobs and resolved the formatting and other data quality

issues.

Created and scheduled the sequencers.

Involved in creating the Control-M tables to schedule the jobs

Adhering to cleanup standards using Data Clean.

Quality Process Management using IQMS.

Knowledge transition about the existing systems to the new joiners.

Prepare and validate product architecture and design model.

Configuration and defect management using star team.

Guiding project team to prepare UTP and UTRs for the functionality testing

Integration of all the modules.

Co-ordination with third party vendor teams.

Involved in the project and views creation in StarTeam while moving the

code to UAT and Runways

Involved in all the configuration management activities till code moved to

production.

Involved in Release Management of the application and Production Support

for fixing the issues.

Co-Ordination with off shore teams (Development & Testing teams).

Environment:Oracle 10g, Perl, Unix shell scripting, plsql. UNIX, IBM

Web sphere Data Stage 8.1,DB2, My Sql, Win SCP,Command Center, Star team,SQL developer, Squirrel, Teradata,Mainframe, BTEQ, RDC,Bridger XG,choice point,humming bird, putty, IPMS, IQMS,NORKOM

9 United Services Automobile Association, San Antonio, TX

Nov 11-Jun 12

10 Role: ETL Developer

11 USAA is product based company in the areas like Automobile, Insurance,

P&C, Bank and wide range of products. USAA has got so many IT projects

involved there is an existing Profitability management system which has got

some draw backs and therefore impacting the accuracy of the measures. This

is an upgrade to existing Hyperion profitability management system.

ETL Development:

This project involved the knowledge of HPCM tool along with batch scripts,

Unix Scripts,PL\SQL and solid ETL jobs.

Optimized SQL Queries for maximum performance.

Used Datastage Designer 8.5 to develop the jobs.

Extracted data from disparate sources - relational databases, oracle

database, flat files and loaded into data warehouse.

Analyzed, designed, developed, implemented and maintained Parallel jobs

using Enterprise Edition of Data Stage.

Experienced in developing parallel jobs using various Development/debug

stages (Peek stage, Head & Tail Stage, Row generator stage, Column

generator stage, Sample Stage) and processing stages (Aggregator, Change

Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate

Stage)

Worked within a team to populate Type I and Type II slowly changing

dimension tables from several operational source files.

Developed Job Sequences for automating and scheduling the Datastage Jobs.

Created sequencers to sequentially execute the designed jobs. Used Execute

Command Activity Stage, Notification Activity Stage, STP stage, job

activity, routine activity and sequencer stages to implement these

sequencers.

Worked on the Control-M scheduling tool for scheduling the jobs designed in

the Datastage.

Experience in generating and interpreting mapping documentation, and

translating into detailed design specifications using ETL code.

Working knowledge of mainframe based tools such as File Aid.

Created Shell scripts for scheduling the Datastage jobs using wrappers.

Used Datastage Director to execute the jobs.

Worked on the Roll out Plans and actively involved in the migrations of

code across the Environments.

Testing:

Created detailed test cases to test various aspects of jobs, batch jobs,

scripts and Control M Jobs.

Experienced in developing test plans for data warehouse solutions.

Interacted with Business users in all phases of testing In order to

provide best results.

12 United Services Automobile Association, San Antonio, TX

Sep 09-Nov 11

13 Role: ETL Developer

14

15 USAA is product based company in the areas like Automobile, Insurance,

P&C, Bank and wide range of products.

16 USAA Competitors partner with many military affinity groups to

provide products and services. USAA currently does not have the

infrastructure necessary to support affinity partnerships and is therefore

unable to prevent competitors from accessing channels frequented by

existing and potential USAA members. The process for managing an affinity

partnership includes many components and if tracked manually would require

many resources. So USAA has decided to come up with Common System called

Affinity Group Management System.

Responsibilities:

ETL Development:

Worked with Business Users, Subject Matter Experts to gather Business

Requirements and created System Requirements Documents.

Worked with data modelers, business analysts, data architects,

administrators, technical and QA team members to set up environments and

maintained documentation throughout the project life cycle.

Developed functional and technical specification documents, created ETL

design documents and process flows.

Developed reusable DataStage Insync jobs that can capture the data changes

between the load ready datasets and target tables and load the target

tables while ensuring the re-startability.

Developed Control-M jobs to automate the processes as per the USAA

standards and involved in migrating them to stage and production.

Created Interfaces that move the planned, forecasted, allocated planning

data to EDW and downstream Marketing Sales Data Mart.

Created Interfaces that integrates AGMS Customer Contact history with EDW

Customer Contact History and developed jobs that feed actual volumes by

drop date onto Marketing Sales Data Mart.

Designed and developed ETL interfaces that integrate PeopleSoft financial

data related to Purchase Orders, Invoices, Invoice Accruals and Purchase

Order Accruals that are associated to the AGMS.

Developed jobs in Data Stage Enterprise Edition using different stages like

Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate,

Sort, Peek, Change capture, Filter, Copy, Sequential File, and Data Set.

Used Data Stage Enterprise Edition for splitting the data into subsets and

to load data, utilized the available processors to achieve job performance,

configuration management of system resources in Orchestrate environment

Used Administrator to administer the locks on the jobs and other

Administration activities for DataStage Server.

Used Control M to create internal and external Dependencies of jobs.

Undertaken the Lead capabilities from Onsite and delegated the work to

offshore.

Environment: Business Objects XI 3.1/4.0, IBM Information Server 8.1,

Crystal Xcelsius 2008,SQL Server 2008, DB2, Win NT/XP, UNIX

17

ING North Americas, Hartford, CT (TCS-Client)

Jun 07 - Sep 09

Role: BO Developer

19 ING is a Company which offers various insurance Products across the

world. The core business is Insurance.

20

21 ING come with an Insurance Plans for their Customers called the Horizon

Plan. Horizon Data Mart, mainly Focuses on ING Customers who avail the

Horizon Plan. My roles in the project is to pull data based on requirements

and present it in reports which Business Interested in, Maintaining

Existing Universes and handling new reporting requirements as per user

specifications and working on enhancements of existing Reports.

22 Responsibilities:

Implementation/Migration:

Active role in planning and implementation of importing objects and users

from BO 6.5 to BO XIR2 and conversion of reports from Deski to Webi as per

end users request.

Migrated objects from development to test and test to production

environments of Business Objects on timely fashion and queue-driven

environment.

Migrated BO objects from Development to QA after testing and QA to

Production in BO XI R2.

Administration:

Involved in the Administration, Create Groups, users, permissions using

Central Management Console (CMC).

Developed a Content Management Plan which shows the level of access that

can be assigned to the groups and users.

Experience in Installation of Business Objects XI R2 and maintain the fixes

for the business continuity.

BI Development:

Built universe on the designed schemas, well tested and exported them to

repository using Business Objects Designer Module.

Developed complex universes by using features like aggregate aware, Index

aware, Conditions and hierarchies to Perform linking of universes by Kernel

method to optimize the universe development and performance improvement.

Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and

checked the integrity.

Created various reports like Master/Detail reports, Cross Tab reports,

slice and dice reports, and drill down reports, Charts using Freehand SQL

and Stored Procedure as data providers.

Created complex reports using multiple queries and involved in tuning the

reports in order to increase the accessing speed.

Testing:

Created detailed test cases to test various aspects of the universe, BO

and CR reports.

Interacted with Business users in all phases of testing In order to provide

best results.

Environment: BO 6.5.1, Business Objects XI R2, UNIX, Windows 2003, Sybase,

IBM Information Server 8.1, Data Stage Enterprise

ING North Americas, Hartford, CT (TCS-Client)

Oct 08 - Mar 09

Role: BO Developer/Crystal Reports Developer

23 ING is a Company which offers various insurance Products across the

world. The core business is Insurance.

24 E-Statements are an ING application which provides the user with the

ability to view statements online. It generates the annual compensation,

statements disbursements which are termed as the predefined reports and

also this provide the user with a facility to generate statements based on

their LOB i.e. Retail, Retirement services and Life insurance.

Responsibilities:

Created and maintained the Business View which is a semantic layer for the

crystal reports.

Resolved all the anomalies in the Business View and made it Defect free and

available for Reporting.

Created the Crystal Reports based on the use cases provided from the

client.

Extensively used suppression formulas to hide the reports data.

Used Sub reports on need basis and formatted the report as per the

requirements.

Created new Desktop intelligence and Web intelligence reports based on

requirements.

Maintained existing Web intelligence and Deski Reports.

Converted existing Excel Reports into the Crystal reports.

Maintained existing Reports and worked on the enhancements.

Environment: Windows 2003, Business Objects XI R2/Crystal Reports XI R2,

Db2.

SYNTEL LTD, India.

Apr 06 - May 07

Role: ETL and BI Developer.

The SMS/800 is a centralized system that performs toll-free number

management. All Service providers that assign toll-free numbers for use

within the US and Canada must use the SMS/800 to verify the availability of

specific numbers, reserve them, create customer records, and download

records to local exchange carrier Service Control Points (SCPs) to

facilitate call processing.

SYNTEL is involved in analyzing the current SMS/800 system and designing

the new system. The existing system is heterogeneous and very complex in

nature to operate. The new system would be homogeneous and automated to a

large extent.

Responsibilities:

As a Technical Team Member involved in Development of different modules.

Identifying the business user requirements.

Created And maintained universe Using Designer

Solved the join path problems by creating the Aliases and Contexts.

Created user groups and assigned User Based Access (Security

Implementation) to the reports and universes using the Business Objects

Supervisor.

Generated reports with Universe created in Business objects Designer as the

data providers with various functionalities that displayed data in a

graphical format.

Understanding of client requirements

Designed and developed reports from universes using free hand SQL.

Created the reports using Business Objects Functionalities like Queries,

Slice and Dice, Drill down, Master Detail and Formulas.

Created standard and Ad hoc reports using business objects.

Environment: Informatica Power Center 7.1, Business Objects 6.5.1, Oracle

10G, UNIX and Windows.

Verinon Technology Solutions Pvt Ltd, India

Mar 05 - Apr 06

Role: BO Developer

Advance America, USA is a payday loan bank, which offers small amounts of

loans for high interest rates. It has 2148 branches all over US. All the

branches generate loads of data on a time-to-time basis. This data is

stored in different locations on different databases like Oracle, Sql

Server 2000, Ms Access and Flat Files. The bank's initial goal is to Pool

Data from all the locations at the end of the day integrate at the central

location and build the capability to better analyze business (present and

history) depending on various criteria, while the ultimate goal is to offer

effective and additional services to Customers. Our goal is to prepare a

data warehouse with 2 years of historical data of every transaction for all

locations at a central zone on a daily basis. We have also developed a Web-

Based Point-of-sale E-Business Application (E-Advantage). This DSS can be

used to generate granular, aggregate level reports generated using Business

Objects, which can be used by the managers and users through the web, which

helps the organization to analyze and track the vital business dimensions

and exponential increase in ROI. This data warehouse is the enterprise data

warehouse, which enable the integration of data warehouse and Internet

technology gives to provide real-time business intelligence to the client

Responsibilities:

Involved in installation, configure and tune of Business Objects 6.5.

Created reports from the Universes as the main Data Providers.

Generated various reports as per the client's requirements

Created the reports using Business Objects functionalities like Slice and

Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Designed and developed reports from universes, personal data files and free

hand SQL.

Interaction with end users, regularly in order to generate the reports

required, these reports were generated using Business Objects functionality

such as Slice and Dice, Master/detail, User Responses and Formulas.

Environment: Oracle 9i, Business Objects 6.5.1 and Windows 2000

Contact this candidate