Jayasri Lekkala
Aldie
Summary
Experienced Database/Product Support Analyst with a strong background in database design, troubleshooting and performance optimization. Proficient in tools and technologies such as Informatica Power Center, Oracle, Teradata, and Service Now, with a proven ability to analyze complex issues and deliver effective solutions. Dedicated to leveraging technical expertise and analytical skills to support and enhance database systems in a dynamic environment.
Insightful Analyst known for high productivity and efficient task completion. Possess specialized skills in data interpretation, statistical analysis, and predictive modeling which enhance problem-solving capabilities. Excel in communication, teamwork, and adaptability, ensuring seamless collaboration and innovative solutions in dynamic environments.
Overview
17
17
years of professional experience
1
1
Certification
Work History
PRODUCTION SUPPORT/DB ANALYST
ACO_MS
Windsor Mill
06.2018 - Current
- Analyze, Design and Improve databases in support of ACO-MS Project Development.
- Responsible for addressing the production ServiceNow tickets related to ACO-MS Users.
- Involved in analysis of the issues from the ServiceNow tickets and update the Contact roles in Database.
- Involved in Writing Backend Procedures, View for ACO-MS Reports.
- Call the Users to explain the process and provide resolution for the Issues.
- Experienced in identifying Business requirements, Technical requirements, Database Design and Troubleshooting.
- Manipulated Stored Procedures, Views using MySQL workbench.
- Assigning User role using POSTMAN.
- Updating the ticket status in ServiceNow system.
SR. INFORMATICA DEVELOPER
Research Triangle Institute
Windsor Mill
12.2016 - 05.2018
- Worked closely with stakeholders to understand their reporting needs and provided solutions accordingly.
- Undergone HIPAA, PII, HHS rules and HealthCare information related training Sessions.
- Prepared Mapping document & Technical Design document based on Business requirements & Data dictionary.
- Conducted walk through on Technical Design document internally with the development team and also with technical leads, team leads and Data Architects.
- Developed Worklets and created Workflows in the Workflow Manager and promptly checked the status of the workflows in the higher environments.
- Created and updated Test scenarios Document to conduct end to end testing while moving from Development to Validation.
- Implemented Partitioning as part of performance tuning of the ETL load through Informatica.
- Verified Cognos reports to check the data being populated is accurate to crosscheck the ETL Data loaded.
- Involved in testing of different ETL processes while migration of Informatica from Solaris to Linux.
- Created and monitored the tickets in JIRA.
SR. INFORMATICA DEVELOPER
CSC
Columbia
11.2010 - 11.2016
- Responsible for analyzing the requirements, design, development and support of data warehouse efforts.
- Developed dimensions and facts mappings, mapplets and workflows in Informatica Power Center.
- Created source to target mapping document, solution specification and details design document.
- Used various transformations like SQL, Joiner, Aggregator, lookup, transaction control, expression, connected/unconnected lookup, update strategy, etc.
- Implemented data quality rules using Informatica Data Quality (IDQ) and saved mappings in Model repository.
- Created and migrated mapplets from IDQ Model repository to Power Center and executed workflow.
- Extracted data from various sources like XML, Oracle and flat files, Transformed and Loaded to Oracle target database.
- Written UNIX scripts to execute workflows and deployment.
- Parameterized all input values in mappings and sessions to re-use in multiple projects.
- Worked in reverse engineering to identify design to requirement bottlenecks.
- Prepared deployment documents for deploy ETL code into different environments like SIT, UAT and Production.
- Responsible for handling Trouble tickets, Service requests.
- Used different optimization techniques like Session portioning, by writing optimized query and changing session settings to Optimize ETL sessions.
- Conducted peer review meeting and code walkthrough meetings.
- Coordinated with QA team in resolving the defects in HP Quality Center raised by the testers.
- Involved in Informatica Administration responsibilities during Installation and created User Roles and Groups.
- Performed Administrator Role providing Access Privileges and also Monthly Maintenance to Stop and Start the Informatica server from the UNIX.
- Migration of the Code from Informatica PowerCenter Repository Manager 8.6.1 to 9.1.0 and 9.1.0 to 9.5.1 and 9.5.1 to 9.6.1.
- Involved in Folder Migrations from one environment to the other environments.
ETL/INFORMATICA/TERADATA TECHNICAL LEAD
Anthem Blue Cross Blue Shield
Richmond
10.2009 - 11.2010
- Participated in business requirement meetings and walkthroughs to understand business/functional specifications as end user point of view.
- Involved in Analyzing the System requirements, in designing and development of data warehouse environment.
- Preparing TSD and ETL Specs based on BSD and Mapping document.
- Conducting walk through on TSD with client tech leads, team leads and Data Archs and DBAs.
- Involved in development of the Code and executed Unit Test Cases.
- Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
- Creating job setup document for job scheduling tool WLM.
- Given Technical clarifications and assigned work to off-shore team and monitored the work status daily.
- Extracted data from Flat files, SQL Server and Oracle and loaded them into Teradata.
- Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
- Transferred data using Teradata utilities like Fast Export, Fast Load and MLoad.
- Worked on WLM to automate and Schedule the Workflows and jobs.
ETL/BO CONSULTANT
State Farm
Bloomington
07.2008 - 08.2009
- Involved in analyzing the requirements along with Project Manager, designing the project along with Architect and development in data warehouse environment.
- Working on Informatica tools like Source Analyzer, Mapping Designer, Warehouse Designer, Workflow Manager, and Workflow Monitor.
- Involved in Universe designing in Business Objects with solving complex loops in Universes.
- Created reports using Business Objects functionality's like Filters, Sections, Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
- Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
- Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
- Worked with complex queries for data validation and reporting using SQL and PL/SQL.
- Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
- Involved in designing and development of pre and post session routines and batch execution routines.
- Implemented Performance tuning of the ETL by utilizing dynamic cache for Lookups partitioning the sessions.
- Worked on Autosys Scheduler to automate the Workflows.
- Tested all the mappings and sessions in Development, UAT environments and also migrated into Production.
Education
MASTER OF SCIENCE -
COMPUTER ENGINEERING
Skills
- Informatica Power Center/IDQ
- Oracle
- PL/SQL
- MySQL
- Unix / Shell Scripting
- Teradata
- ServiceNow
- PostgreSQL
Certification
- AWS Certified Solutions Architect Associate
- SnowPro Core Certification
- Microsoft certified Azure Data Fundamentals
Timeline
PRODUCTION SUPPORT/DB ANALYST
ACO_MS
06.2018 - Current
SR. INFORMATICA DEVELOPER
Research Triangle Institute
12.2016 - 05.2018
SR. INFORMATICA DEVELOPER
CSC
11.2010 - 11.2016
ETL/INFORMATICA/TERADATA TECHNICAL LEAD
Anthem Blue Cross Blue Shield
10.2009 - 11.2010
ETL/BO CONSULTANT
State Farm
07.2008 - 08.2009
MASTER OF SCIENCE -
COMPUTER ENGINEERING