Data Project
Resume:
Lalitha Mohini Gayathri Devi Chintha E-
Mail: acbz60@r.postjobfree.com
Phone: +91-986*******
CAREER ASPIRATION
Looking for a challenging position as Tech Lead in an esteemed organization
where I can contribute my experience of specialization in Functional and
Technical Analysis for the Projects in any of the domain along with the
technical expertise.
PROFESSIONAL SUMMARY
. Having 5.8 years of experience in Analysis, High and Low Level
Design, Development and Implementation of Data warehousing Systems
worked for large Clients with extensive usage of Teradata, UNIX and
Informatica and Mainframes.
. Worked extensively in Development Projects on Teradata, Inforamtica,
UNIX and Mainframes, Complete END to END experience in all areas of
Software Development Life Cycle, Worked extensively in ETL process,
adapted in development of Data Warehouses, Experience of working in
Banking Domain. Expertise in the implementation of all kinds of
projects like Enhancement, Deployment or New Developments.
. Having strong knowledge in (ETL) Teradata SQL and utilities and
Informatica & TOAD
. Expertise in applying Enterprise Data warehousing concepts to various
business applications.
. Having Expertise knowledge in Teradata database and has good exposure
on Performance Tuning of Queries and spool space remediation.
. Worked on Teradata Performance monitoring tool 'View Point' and
PMON(Performance Monitoring Tool)
. Technically worked extensively on Teradata utilities like Fast Load,
Multi Load, Fast Export, T-Pump and BTEQ and has exposure to work on
mainframe systems in Banking & Manufacturing domain.
. Worked on Teradata Performance monitoring tool 'View Point'.
. Good knowledge of understanding COBOL programs and worked on version
control tool- Change man and file aid and CA-7 Scheduler.
. Having Expertise knowledge in Teradata database and has good exposure
on other databases Mainframe DB2.
. Created ETL mappings using Informatica Power Center to move Data from
multiple sources like Flat files, Oracle into a common target area
such as Staging, Data Warehouse and Data Marts.
. Expertise in implementing complex business rules using different
Transformations, Mappings and Mapplets.
. Has exposure to UNIX shell scripting.
. Possess excellent analytical and problem solving skills.
. Committed to continuous improvement, excellent communications, and
project management skills. Self-disciplined, focused, solid teamwork
and a team player.
. Good experience in technical documentation.
EXPERIENCE:
. Working as Tech Lead in Mahindra Satyam Computer Services Ltd,
Hyderabad from Feb 2012 to till date.
. Worked as Senior Software Engineer in Tata Consultancy Services,
Hyderabad from April 2008 to Feb 2012.
EDUCATION:
. Graduated in Bachelor of Technology (CSE) from Acharya Nagarjuna
University, Guntur Dt in 2007.
TECHNICAL SKILLS:
Programming Languages SQL, Mainframe JCL,COBOL,UNIX/Shell Scriptin
Databases Teradata (TD12,TD13), Oracle, DB2
Teradata Utilities Fast Load, Multi Load, Fast Export, T Pump, BTEQ
ETL Tools Informatica 9.1, 9.5
Operating Systems UNIX, Mainframes OS/390
Defect Tracking Tools Quality center, Maximo Tool (in Mainframes)
CISCO tools Golden Gate and Data mover,TOAD,DollarU, Kintana,
PVCS, SRM
Performance Tools View Point, PMON (Performance Monitoring tool),
Teradata Manager
Domain Experience Banking/Finance/Revenue
CERTIFICATIONS:
Technical Certifications:
DB2 700
. DB2 -700 Basics Certification
Domain Certifications:
. Certification in General Banking
. Certification in U.S Banking.
CLIENT ENGAGEMENTS:
. Bank Of America
. CISCO
PROJECT'S PROFILE
CLIENT : CISCO, U.S.A
Organization: Mahindra Satyam Computer Services Ltd., Hyderabad
Cisco Systems-EDWTD: The CISCO Data warehouse is a 32
Terabyte Teradata Database, which stores
the historical and operational data of all the measures like
Bookings, revenue, expense, Marketing,
CIBER, Attach rate and other Service area metrics of Cisco
Systems, Inc.
CISCO Data Warehouse can be broadly divided into 6 different tracks, which
are as listed below.
1. CDW Common
2. Finance
3. Marketing
4. Internal
5. Customer & Sales
6. Product & Services
Project # 7 Q1FY14 Restatement of Bookings and Revenue(Apr2013-till
date)
Bookings, Revenue & COGS restatement is an annual activity taking place in
Q1 of the new fiscal year. Restatement allows the business to view the last
3 year's performance by the current year's organization and account
structure enabling year-over-year reporting for growth, discount, customer
segment, etc. For FY14 restatements, enhancements are proposed to increase
reporting capabilities by providing a consistent view of historical
bookings, revenue and COGS data.
V We give the aggregated data to the APJC (restated team) on Fiscal Week
basis for a particular Line key for 3years and for 2009 &2010 for both
Bookings (products and Services).
V The APJC team will restate the Sales Territory Key and the Sales Rep
Number based on their requirement and gives the restated data back to
EDW.
V EDW teams provide a Final reporting table where we incorporate the
changes attributes (given from Restated team) for a particular key and
also the incremental keys.
Role: Tech Lead
Responsibilities:
. Analysis on the BRD (Business Requirement Document) and
requirements Gathering.
. Vast development of the SQL Queries using Multiple Joins,
Partitions .
. ETL Design and development.
. Tuning the Queries while development for efficient running of
Queries in Teradata.
. Scheduling of jobs using Dollar U.
. End to End unit Testing and validations.
. QA and PROD Support.
.
Solution Environment: Teradata SQL Assistant (TD13), Oracle, Informatica
(9.5), UNIX.
Project # 6 EDW impact due to GWDW Staffing (Jan 2013-Mar2013) :
GWDW is the Source (Oracle) where there are changes to the Source tables
which have an impact on the EDW side. This initiative is about the analysis
on those tables at EDW side and implementing the same in Teradata.
Role: Offshore POC
Responsibilities:
. Analysis on the BRD (Business Requirement Document) and
requirements Gathering.
. ETL Design and development.
. SQL's Development according to the Business Requirement.
. Fast Export to load the data into a file and providing to the
Business for validations.
. Tuning the Queries while development for efficient running of
Queries in Teradata.
. Scheduling of jobs using Dollar U.
. End to End unit Testing and validations.
. QA and PROD Support.
.
Solution Environment: Teradata SQL Assistant (TD14), Oracle, Informatica
(9.1), UNIX.
Project # 5 BE IAM Security (Dec 2012- Jan2013):
BE IAM Security is to Extract the security data from IAM and enrich into
EDW Layers. Create a separate Profile for a user with access to all
Business Entities something like TOTAL_CISCO_BE for both internal and
external, this ensures that all the BE values and need not be checked to
implement at application level if user has total access.
As part of Business entity & Sub Business Entity IAM Security enhancements
requested by Finance team, there are changes at EDW and IAM side.
EDW to IAM:
New requirement will be publishing the Entity Type code with the Entity
name
IAM to EDW:
In EDW side, we will be setting up the security on both the entity name and
the Entity type code. We add two level 0's for External and
Internal.CorrespondingPV/BV definitions will be changing.
Role: Team Lead
Responsibilities:
. Analysis on the BRD (Business Requirement Document) and
requirements Gathering.
. ETL Design and development.
. Development of SQL's according to the requirement.
. Tuning the SQL Queries during Development for efficient running of
Queries in Teradata.
. Preparation of the Deployment plan and Scheduling of jobs using
Dollar U.
. End to End Unit Testing and validations.
. QA and PROD Support.
Solution Environment: Teradata SQL Assistant (TD13), Oracle, Informatica
(9.1), UNIX.
Project # 4 CISCO EDW -Performance Optimization Team (Mar 2012-Nov 2012):
Performance Optimization team is responsible for tuning the Poor Performing
Queries in Teradata to reduce the SUM CPU consumed. Understanding of cost
based query optimizer, identification of potential bottlenecks with queries
from the aspects of query writing, skewed redistributions, join order,
optimizer statistics, physical design considerations (PI and USI and NUSI
and JI etc.).In Depth understanding on the Teradata Explain to analyze and
improve query performance.
Role: Team Lead
Responsibilities:
. Performance tuning, including collecting statistics, analyzing
explains & determining which tables needed statistics.
. Worked on Creating and managing the partitions for SQL handling huge
data.
. Deliver new and complex high quality solutions to clients in response
to varying business requirements.
. Refresh the data by using Fast Export and Fast Load Utilities.
. Loading data from various data sources and legacy systems into
Teradata Production and development warehouse using BTEQ, Fast Export,
Multiload, Fast load and Informatica.
Solution Environment: Teradata SQL Assistant (TD13), Oracle, Informatica
(9.1), UNIX.
CLIENT : Bank of America, U.S.A
Organization: Tata Consultancy Services., Hyderabad
Project # 3 Data Warehouse Resource Pool (DWRP) - Performance Remediation
Team and DBA Activities (Jan 2010 - Feb 2012)
The Warehouse (The W) of Bank of America is the second largest warehouse
in the world. There are several Mainframe jobs running which consists of
Complex Teradata SQL Queries. These Queries consume lot of resources like
SUMCPU, IMPACT CPU & SUM IO.
This initiative deals with Process Improvements and enhancing the
system performance through Performance tuning activities of the CPU Heavy
hitter queries and Space reclamations and there by reduction of Overhead on
the system.It also deals with the resolution of the Help Desk Spool Space
Tickets and tickets related to the User Queries tuning.
Role: Team Lead
Responsibilities:
. Monitoring the Production system using the View Point tool.
. Keeping watch on the Heavy Hitter queries in production and work on
performance tuning of them and thereby reducing the overheard on the
Teradata Production Box.
. Space reclamation of the space more than over allocated and occupied
due to skewness.
. Working on the Help Desk Spool Space Tickets and the Tickets related
to the tuning of the User Queries.
. Query Tuning: Tuning the high CPU consumed Queries to decrease the SUM
CPU and IMPACT CPU.
. Archive Jobs Remediation.
. Collect Stats Remediation: Analyzing the Collect Stats in the
Production jobs and remediation.
. Analyzing the long running, highly Skewed and non-complaint Queries
and tuning on the same.
. DDL Conversions: Changing SET-MSET and vice versa for effective
distribution of the data.
. Utility Conversion : MLOAD-TPUMP and MLOAD-BTEQ Conversion which saves
the SUM CPU.
. Working on the migration of tables from one region to the other region
.Fast exporting the table's data to files and then loading the Files
data into the tables of other region.
Project # 2 Data Warehouse Application Management System (AMS) - (Feb
2009 - Dec 2009)
Data Warehouse Management System consists of the following:
. Channels
. Deposits
. House Holding
. Loans
. Opt-out
The loans and reconciliation system involves receiving and backing up of
files from many Bank of America Loan Systems on a daily and/or weekly, and
/or monthly basis. It transforms each feed into flat file(s) using client-
defined transformation rules within COBOL/EZPLUS programs. These flat files
are delivered and loaded into The W (Corporate Teradata Warehouse). After
the load, reconciliation is done for the load statistics. Same process is
carried out for other systems in the Data Ware House Management (Channels,
Deposits and House Holding).
Bank of America Data warehouse is one of the largest in the world, loading
approximately 300 GB of data per month. Some of the functions handled by DW
Management group include delivering the flat file(s) "AS IS" and/or loading
the flat file(s) into The 'W' according to Service Level Agreements and
providing ongoing support by resolving problems and answering questions
related to the data to the clients of the W, documenting and distributing
DWIS sub-routine (or program) names used during new development for Special
Data Warehouse (DW) Column Derivations and Common Edits and Output sub-
routines.
As a part of the 'W' team we provide,
- 24 X 7 on call support to around 450 applications comprising the entire
warehouse
- And also execute enhancement and maintenance tasks like permanent fixes
to repetitive abends, User Ad-hoc requests and so on.
Warehouse provides critical data to many downstream applications like ECRIS
(Enterprise Credit Risk Information System), Regulatory Reporting etc. The
Warehouse group has committed SLA's to the end users and the Support Team
should ensure that SLA's are always met. Apart from the regular support to
the warehouse, the team also undertakes additional activities like Disaster
Recovery, Hardware Upgrade, End of Month Activities, Manual Runs and Full
Platform Support. Utmost care is taken on archive methodology of 'The W'
Data since the data availability is crucial from the Warehouse point of
view to provide very critical reports to the business.
Role :Team Member
Responsibilities:
. Ensured smooth running of the entire system by continuous 24 x7
Support.
. Development of Teradata Utilities in Mainframe Environment.
. Analysis of code to resolve data issues raised by end users in the
Warehouse
. Preparing the Turn over documents for the new applications.
. Ensuring that the Bank's customer and organizational data is been
loaded into the Warehouse successfully.
. Meeting the day to day Service level agreements (SLA) for loading the
data into the Warehouse.
. Collection of various process and product metrics (Weekly and Monthly
dashboards) for the project from IRIS tool for Bank.
. Perform production support tasks such as scheduling, documenting the
process, tracking run times, identifying the root causes for the
delays for the applications in Production. .
. Identifying the applications consuming more CPU utilization and taking
necessary steps to so that these applications don't bring down the
production servers.
. Planning and Managing the application runs during planned and
unplanned outages for production servers such as Informatica Servers,
UNIX servers, database servers and coordinating for the outages to
completion and completing the applications within SLA.
. Monitoring the Production environment and sending notifications to the
respective person/team in case of server performance going down.
. Coordinate for the new applications that are moving into Production
with development team for initial run issues, knowledge transition to
the support team and defining the process for the same.
. Resolve user queries and close Help desk tickets with the data issues.
. Involved in Requirements gathering.
. Analyzing the specifications of the project and map it with the Client
Requirements.
. Unit Testing and validation before handing it over to client
. Working on Process Improvements and enhancing the system performance
through Performance tuning activities.
. SIT Support.
. Working on the Help Desk Tickets that are raised by uses and solving
the issues if any persists.
Solution Environment :Teradata V2R6, Mainframes (MVS), Change man, CA7,
Maximo, Quality Centre.
Project # 1 Data Warehouse Resource Pool (DWRP) :EIM LOANS Development
Project - (June 2008 - Jan 2009 -Chennai)
It deals with data related to loans provided to the customer. Loans system
includes consumer loans, credit line, dealer reserve and variable rate
products. In the warehouse, we provide many options like automatic fee
calculations and assessment, insurance program support with commission
tracking, unlimited payment schedules, automated payment splits, automated
delinquency management for non-accrual, charge-off and recovery, memo
accruals, and stop activities.
Major Projects that I worked upon are
. Student Loans Projects - Bringing the Student loans data to W
(Warehouse).
Value added activities that worked upon
. Performance Management/ Tuning activities.
Role: Team Member
Responsibilites:
. Analyzing the specifications of the project and map it with the Client
Requirements.
. Working on Process Improvements and enhancing the system performance
through Performance tuning activities.
. Unit Testing and validation before handing it over to client
. SIT support.
. Working on the Help Desk Tickets that are raised by uses and solving
the issues if any persists.
Solution Environment : Mainframes (JCL & COBOL), Teradata and CA7
Scheduler
Personal Details:
Name : Lalitha Mohini Gayathri Devi Chintha
Date of Birth : 21st April 1986
Passport Number : G6797065
Languages Known : English, Hindi, and Telugu.
Contact this candidate