VANAJA K
Fremont,CA
Summary
Experienced technical lead with a proven track record in leading teams and successfully delivering complex projects. Skilled in various technologies, excellent problem-solving abilities, and a strong commitment to achieving quality results. Detail-Oriented professional with over 15+ years of experience in Requirements gathering, Analysis, Design, Development, Testing, and Production Support of applications mainly in the field of Data Warehousing and Business Intelligence. Strong understanding of Relational, Multi-Dimensional Database concepts. Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling. Expertise in implementing complex business rules using different Transformations, Mappings and Mapplets. Strong background and experience in 24X7 production support processes and procedures utilizing on site/off shore model. Expertise knowledge on improving Performance and Troubleshooting of the Informatica mapping and sessions and monitoring Informatica run time statistics. Ability to handle different system environments and technologies. Strong experience in Informatica Power Center Client (including Designer, Workflow Manager, Workflow Monitor, and Repository Manager). Strong experience with UNIX shell scripting, SQL, PL/SQL Coding & scripting. Flexible and versatile, can easily adapt to new environment. Possess excellent analytical and problem-solving skills. Committed to continuous improvement, good communications, and project leading skills. Self-disciplined, focused, solid teamwork and a team player. Demonstrated ability to be part of cross functional teams with emphasis on healthy coordination and constant follow-up to achieve results in time. Good experience in technical documentation. Received recognition from end users for outstanding service. Talented Team Leader experienced and dedicated to enhancing employee satisfaction and business success. Diplomatic and friendly with proven commitment to employee training. Hardworking team player bringing necessary experience and knowledge to tackle any operational demand.
Overview
16
16
years of professional experience
Work History
Team Lead
Tata Consultancy Services
04.2021 - Current
- Handled very critical applications EDW/Finance/Sales Compensation/MBR for Corporate Sales Bookings of Cisco
- Preparing High level design, low level design, technical design, test plan and deployment plan
- Analyze requirement to be implemented and discuss with client for further clarification.
- Understanding the scope of the Project and technical modeling, Analyzing the specifications and requirements provided by the clients, analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented.
- Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology.
- Design and Development of Dataflow and ETLs using Informatica
- Coding based on the Specifications provided by the Client and Bug Fixing
- Code new programs and modules for enhancement of the Data Capture process and automate various manual processes.
- Preparing Unit Test cases and integration test cases and testing the application against test cases
- Bug Fixing using HP QC Tool
- Preparing the deployment plan and deploying the code using Kintana tool
- Handled several enhancement objects (change requests) by developing ETL (PDO type), creating tables, creating uprocs, creating sessions (Control M) and managing it to completion.
- Directed and supervised team of 8 engaged in production and development.
Team Lead
Accenture
07.2013 - 10.2020
- Partnered with business clients and gathered requirements
- Analyzed source systems and impact to existing applications
- Involved in designing and developing the ETL/Integration solution for the ongoing projects
- Worked on various sources, transformed and loaded data into Data Warehouse Targets using Informatica
- Supported various Informatica workflows and other ETL components as part of Application Management and Support
- Fine-tuned Informatica mappings for performance improvement
- Involved in different testing phases - Application Testing and User Acceptance Testing by coordinating ‘Defect Triage’, interacting with different Development Groups and actively fixing bugs/defects
- Troubleshoot data discrepancies and identify root cause and bug fixes
- Hosted weekly/daily status meetings and managed communications.
ETL Developer
Accenture
09.2007 - 06.2013
- Collaborated with Business users and IT Architects for requirements gathering, business analysis
- Analyzed the source systems for information required in the warehouse
- Developed FRD (Functional requirement Document) and data architecture documents
- Involved in the design and development of complex Informatica mappings according to the business rules to load the Capital- Global DataMart
- Used Informatica Designer for developing mappings using transformations, which includes Aggregation, Update Strategy, Lookup, Stored Procedure and Router…etc
- Worked with mapping debugger and Analyzed Session Log files in case of session failures to resolve errors in Informatica mapping or session configurations
- Performed System Integration testing and led UAT from IT perspective
- Worked on the deployment plan, documentation, and contingency plans
- Responsible for offshore coordination and point of contact for project deliverables.
Sr. Support Analyst
Satyam / Accenture
03.2008 - 08.2012
- Accountable for business engagement, root causing, issue resolution, and bug fixing
- Reviewed and analyzed functional requirements as part of the enhancements track
- Developed mappings using Informatica Designer to load the data from various source systems to the DataMart
- Ensured batch completion and incident management
- Identified Performance bottlenecks and fine-tuned ETL mappings
- Use of Informatica version control to track the changes made to the mappings, workflows
- Handled multiple successful Month End (ME)/Quarter End (QE) periods
- Established Month End/Quarter End checklist for smooth execution
- Proactive communication
- Provided users with quality data for reporting
- War room management
- Coordinated and provided quarterly SOX audits and as an SME participated in PWC walkthroughs for all the specified controls.
Education
Master of Science - Computer Science
Osmania University
Hyderabad05.2007
Skills
- Data Warehousing
- Leasing and Financing
- Business Intelligence
- Requirements Analysis
- Data Integration
- Team Management
- Onshore & Offshore Model
- Production Support
- Informatica Power Center
- IICS
- Business Objects
- Tableau
- Oracle SQL
- PL/SQL
- MS SQL Server
- UNIX Shell Scripting
- Linux
- Teradata
- Universe
- Tidal
- Service Now
- HP QC
- Complex Problem-Solving
- Production Monitoring
Education Credentials
Masters in Computer Applications
Timeline
Team Lead
Tata Consultancy Services
04.2021 - Current
Team Lead
Accenture
07.2013 - 10.2020
Sr. Support Analyst
Satyam / Accenture
03.2008 - 08.2012
ETL Developer
Accenture
09.2007 - 06.2013
Master of Science - Computer Science
Osmania University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Divya KandimallaDivya Kandimalla
SQL Support Engineer at Tata Consultancy Services (TCS)SQL Support Engineer at Tata Consultancy Services (TCS)