Sailaja Lukkana Global Business Services

Education

Qualifications Master of Computer Applications in Computers

G Pulla Reddy Engineering College, India, 2004

Languages

Bachelor of Science and Computers in Computers Dr Jyothirmayi Degree College, India, 2000

English Fluent

Telugu Fluent

Hindi Good

Kannada Good

Mobile No: +1-857-***-****

Professional experience

Profile - 15 + years overall working experience in – Power Center Informatica, Informatica Cloud and SSIS Data ware house projects, Developments, Integration, Unit Testing, Client Interaction, Onsite Implementation, Go Live, and Production support.

-Experience in leading and managing agile teams. Handled multiple roles –Technical Team Leader, SME for a few applications, and Data Modeller.

-Experience in working collaboratively with diversify team located in various geographies.

-Executed software projects for Insurance, Retail, Banking and Health care industry.

-Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

-IBM Certified Design Thinking Practitioner

-Certified External Informatica

-Proficient in developing Slowly Changing Dimensions to keep and track of Historical data.

-Flexibility to change/leverage any new Technology. - Actively participated in Recruitment Drives.

Contact Number: 91-917*******

Key Skills - RDBMS: DB2, Netezza, Oracle, AMS, SQL Server, Teradata

-Languages: Oracle SQL

-O/S: Windows, Linux

-Key Skills: Informatica Cloud,Informatica PowerCenter, Power Exchange, SSIS, RTM, Datastage, Abinitio

-Secondary Skills: Data Profiling, Web Services, Unix, Salesforce, Ariba, Web Services, Message Queue, Mainframe and Informatica Cloud, Data maps

-Scheduling Tools: Control M, DAC

- Knowledge of Data warehouse concepts, SQL and PL/SQL

Career History 11/2009 - 01/2015

Cognizant Technology Solutions, India Senior Associate

-Mainly involved in the ONSITE and OFFSHORE Communication for requirement gathering from the Business users.

-Involved in creation of Low Level Design, High Level Design

-Mainly involved in ETL design & development.

-Involved in reviewing and creation of Informatica mappings.

-Involved in Data Profiling,Genarating Data Lineage report using Metadata management tool,code review and SQL tuning.

-Involved in end to end development.

-Assisted team in developing development, bug fixing skills and debugging functional as well performance issues

-Solely responsible for all project related migrations and deployments to QA and production environments.

-Involved in handling production problem tickets and issue resolution.

-Involved in post production warranty support.

-Taken interviews, enabled new joiners with proper documents and knowledge to start working in project

-Take part in estimation and sprint planning as Team Lead

-Supported project manager with all information needed in time

02/2008 - 11/2009

Mastek, India Software Engineer

-Mainly involved in design & development

-Involved in developing Packages and SQL tuning

-Coordinate and communicate tasks with developers

-Created LLDs

-Developed critical modules

Assignment History 06/2018 – Till Date

BCBSMA

Projects Description: As part of See Beyond Remediation, multiple See beyond projects moved from See Beyond Integration tool and Java technology to Informatica ETL Tool.

Implemented CMS mandate projects like MRF, RxDC and Reward Integrator

As part of Ariba to Salesforce Migration we have developed interface to take export of Ariba data and load into Intermediate stage tables, read DW data and load into stage tables. Using those Intermediate stage tables and then loading into salesforce objects.

This has helped BCBSMA to decommission See Beyond Integration tool and move on to Informatica ETL Tool to host all its data warehouse needs.

This application is now capable to loading the data in an automated fashion to the Downstream systems.

Completely automated to:

1. Identify that a file has been uploaded in Tumbleweed server and Process the file immediately and load data to target db.

2. After loading data send notification to customers

3. Reduced the overall process execution time.

03/2018 - 06/2018

4 months

Stanford University

-

Project Description: As part of this project developed 2 interfaces

1.ODS to Eden(Salesforce) 2.Marketing Cloud to Eden(Salesforce)

Team is responsible to configuring processes from ods,mc to salesforce instance Position: Team Lead

Contribution: • Provide technical solutions for the client requirements.

•Develop / customize the code to meet the client’s coding standards.

•Maintaining proper documentation for all the development/enhancements done.

•Identifying the bottle necks of the load and providing solutions.

•Task planning, scheduling and tracking the task closely to identify potential risks and issues to ensure on time running process.

•Continuous monitoring of the work progress tracking and helping other team members

•Contributing in Enhancements, testing, creating mappings as well as Design Documents.

•Collaborate with the team members to execute and commission the projects as scheduled.

•Analyze the current load process to Improve the performance of the jobs to reduce the load time.

•Coordinate and communicate tasks with team members.

•Ensure that development is performed as per requirements.

09/2016 - 03/2018

19 months

EBAY

-

Project Description: Applications Supported:

-People X

-Visier and Visier Head count

-Manhattan

-Custodian

-First Advantage

-Recruit

-PCT and Stock

Technologies Used: Informatica,Oracle,Unix and Control M

I have been responsible for more than 5 applications during the period on 1.8 years. I have been working HR based solutions to eBay where I have been involved in coding and development. Also, I am responsible for minor enhancements and bug-fixes as part of AMS Team.

Position: Team Lead

Contribution: • Provide technical solutions for the client requirements.

•Develop / customize the code to meet the client’s coding standards.

•Maintaining proper documentation for all the development/enhancements done.

•Identifying the bottle necks of the load and providing solutions.

•Task planning, scheduling and tracking the task closely to identify potential risks and issues to ensure on time running process.

•Continuous monitoring of the work progress tracking and helping other team members

•Contributing in Enhancements, testing, creating mappings as well as Design Documents.

•Collaborate with the team members to execute and commission the projects as scheduled.

•Analyze the current load process to Improve the performance of the jobs to reduce the load time.

•Coordinate and communicate tasks with team members.

•Ensure that development is performed as per requirements.

•Completed POC to integrate informatica powercenter with Hadoop and Salesforce

05/2016 - 09/2016

5 months

MACY's

-

Project Description: Macy's, is a mid-range to upscale chain of department stores owned by American multinational corporation Macy's, Inc. Macy's is known for its niche in popular culture and the diversity of its merchandise. Macys has implemented Oracle eBusiness Suite R12 purchasing and financial modules for their retail business and is using OBIEE for Human Resource & Financial analytics. The main aim of this project is to generate Analytics reports for Financials, EAM subject areas. The ETL work includes new Development, Enhancements & Performance tuning.

Technology/Software : Informatica8.6, ODI 11.7, oracle, Unix,DAC,OBIEE Position: Designer

Contribution: • Analyze the current load process to Improve the performance of the jobs to reduce the load time.

•Identifying the bottle necks of the load and providing solutions

•Ensure that development is performed as per requirements.

02/2015 - 05/2016

16 months

Direct Line Group

-

Project Description: Direct Line Group is a leading provider of personal-lines general insurance, with operations in Germany, Italy, and the United Kingdom. During the past 5 years, the manner in which customers engage with organizations such as it has changed dramatically and changes in customer behavior are affecting their ability to attract and retain its customers. They realize that it needs to transform its distribution capability

and deliver significant improvements in how it manages customer interaction. This will require an extensive transformation of business in the market place and must include the systems to support it

The scope of this project is to implement solution for operational data store (ODS) and Enterprise Data Warehouse (EDW) based on Teradata FSLDM. It involves following major milestones:

1.Data integration with different data stores e.g. MDM, ODS based on Sprint methodology (Sprint 5 to 15)

2.FSLDM data modeling and data mappings to legacy applications e.g. Guide Wire

3.Building subject area for ODS

4.Building subject areas for EDW

5.Publish data to front-end or analytics products Position: Designer

Contribution: Leaded below subject areas

1.SVOC

2.Interactions 3.Marketing Supressions

and data model changes using ERWIN Tool

Customer Interactions: A “Customer Interaction” is a transaction where there is a direct, external communication with a person, commonly a Customer or a Prospect. This interaction can be between the Customer/Prospect and DLG or an appointed 3rd party. Customer interactions can be categorised as below:

•Marketing Communications

•Document

•Feedback

•Chase / follow-up

•Multiple

And will be through the following channels:

•Direct Mail

•Email

•SMS

•Fax

•Call Centre (Agent Voice call, Automated Voice call)

•Digital Platform (Web DLG Portal, Aggregator)

•Web Chat

•App

•Telematics installation

•Promotions product Fulfilment

•Multiple

Prior Experience 11/2009 - 01/2015

63 months

Amex

DELTA DATA TRANSFER, AIC, METRO,MR30 PILOT, Costco

Redemption Reporting,REARCH EFF,BIDWFilestoBIS

Project Description: Acquisition Incentive Control: Acquisition Incentive control enables the CCSG and OPEN marketing to withhold incentives and bonuses/ merchandise and / or privileges associated with acquisitions based on their incentive control rules.

This also aims to ensure that all disclosure channels are updated with the necessary bonusing policy and to maintain the details so as to track the CMs who were rejected for a bonus and the reason(s) for rejection.

BIDW is expected to build/enhance reports that would show declined Card Accounts

Delta Data Transfer: As part of this project, BIDW to extract Bonus ID related data from for any new Bonus ID or any changes to existing Bonus IDs on a daily basis. On a daily basis LSC will send Delta Bonus IDs and POIDs to BIDW. BIDW will extract the distinct POIDs

from LSC Backend file and send them to Nexus. Nexus will return the campaign data for those POIDs to BIDW. Then, BIDW will process LSC Backend and Nexus data.

•Provide ability within BIDW to extract the data Bonus data from the LSC.

•Provide ability within BIDW to extract the data Campaign data from the Nexus.

•Provide one time data load of historical data required for enhanced

•Reuse an existing balancing process for balancing between LSC and BIDW (Business Intelligence Data Waterhouse).

•Reuse an existing balancing process for balancing between BIDW (Business Intelligence Data Waterhouse) and NEXUS.

Marketing Execution Tools Roadmap : As part of this Metro project,

BIDW stores one summary fact which holds eligibility date with the combination of CARD number and Promotion Prog ID and we are sending Eligible information and Source codes information to BIGDATA Team.

The goal of the Bonus initiative is to provide a select group of managed clients MR incentives as either a spend growth opportunity or to prevent attrition. This project specifically covers targeted clients in the Top Client Group only, and does not cover all OPEN customers. The Business is targeting 3-5% of managed customer for this effort.

These offers are product agnostic and clients are targeted on spend and/or total spend opportunity. The business will be employing a variety of offers based upon specific criteria. Currently there is no automated or manual way to offer incentives to this target group

As part of this MR30 project, BIDW receives with POIDs from Sales Force and compare with the complete file (In-flight & Enrolments data) to generate an output file which will be shared with Sales Force again

A requirement was implemented to adjust the manual redemption received from MR-Business. The objective was to analyze and increase the accuracy of input data from the business.

Point Of Arrival (POA) for Electronic File Feed (EFF) is an initiative to meet the following business objectives:

-Establish a process where business can provide a more accurate data

-Establish a quicker feedback mechanism to validate EFF inputs against various business rules that need to be adhered to and only take valid data forward

-Automate sourcing of data from SOR wherever possible instead of manual input and enable audit tracking

-Improve efficiency by reducing the manual work around and adjustment result in manual errors

Sourcing of data from SOR, Informatica Analyst (RTM) and File based were three forms input accepted in the order of priority listed wherever appropriate. The new version of EFF’s are being implemented in multiple releases

The ETL process (Extract, Transform and Load) consists of processing and loading of data from RIT Tables to BIS files along with MM accounts. On the first day of install, data to be provided from inception to the particular month for file generation with all statuses and delta file will be provided on subsequent months. Total of 9 files to be delivered to BIS and details of each file is as below. Iterative approach is taken to deliver first 4 files by 11/11/2011 and next 5 files by 12/16/2011 thru 12/23/2011

Contribution: Mainly involved in the ONSITE and OFFSHORE Communication for requirement gathering from the Business users.

Mainly involved in ETL design & development.

Involved in reviewing and creation of Informatica mappings.

Involved in code review and SQL tuning.

Involved in end to end development.

Solely responsible for all project related migrations and deployments to QA and production environments.

Involved in handling production problem tickets and issue resolution.

Involved in post production warranty support.

Mentoring new team members.

Resolving if any issues in transformations and mappings with help of Technical specifications.

Communicated with Infa Admin Team, related RTM Queries

Contact this candidate