VANAJA KAPILAVAYI

Email: adki4w@r.postjobfree.com

Linkedin profile : www.linkedin.com/in/vanaja-kapilavayi-481288a2 Cell No.: 408-***-****

Profile Summary

Detail-Oriented professional with over 12 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 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

Core Competencies

Data Warehousing

Leasing and Financing

Business Intelligence

Requirements Analysis

Data Integration

Team Management

Onshore & Offshore Model

Production Support

Professional Experience

Company : Mudiam inc –Sep 2019- till date

Project : EDW & ODS.

Role : DW/BI Developer /Lead (Analyst Programmer) .

Project Description:

Loading the client feed files into ODS (Operational Data Source) & EDW (Enterprise Data Warehouse).

Getting client feed files from different regions and other third party systems.

Maintaining the data into EDW, DW and ODS Staging Area (Oracle) for other downstream applications.

After loading the data into EWD & ODS, generating flat file using Informatica jobs and these files will be used by some other downstream applications and others to populate the data into Multivendor portal.

Applying some business rules to create the flat files for downstream applications.

Responsibilities:

Understanding the business rules and sourcing the data from multiple source systems.

Interacted with users and supported crossfunctional teams.

Extracted the raw data from source CRM to staging tables using Informatica Cloud.

Developed Cloud mappings to extract the data for different regions (APAC, UK and America).

Refreshing the mappings for any changes/additions to source attributes.

Developed the audit activity for all the cloud mappings.

Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.

Generated automated stats with the staging loads comparing with the present day counts to the previous day counts.

Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.

Created and developed mappings to load the data from staging tables to EDW DataMart tables based on Source to Staging mapping design document.

Implemented Type1, Type2, CDC and Incremental load strategies.

Followed ETL standards - Audit activity, Job control tables and session validations.

Used Exceptional mappings to generate dynamic parameter files after the staging loads.

Used Shared folders to create reusable components (Source, target, email tasks).

Developed single dynamic ETL mapping to load more than 30 reference tables.

Used Sql queries to validate the data after loading.

Maintained and automated the production database to retain the history backup tables to 30 days.

Developed/Automated (PowerCenter) jobs.

Troubleshooting on data discrepancy issues raised by business team

ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues

Work on Performance degradations of the ETL Jobs

ETL monitoring and reporting on SLAs and data availability

Work on Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug Fixes; Enhancements)

Communication to the users and Business for Planned application downtime notifications

Ramp up and Ramp down activities during Outage of the Applications

Adhoc Validation of the data load as per client request.

Environment: Informatica 10.1,IICS, Oracle 11g, Phython, Putty, Oracle, SQL Server, PL/SQL, TOAD, Scheduling tool

Company : Accenture - Apr 2010 – Aug 2020

Cisco Systems Inc. – July 2013 – Sep 2019

Company: Accenture Team Lead Project: Capital Project Connect

Cisco Systems Capital Corporation, a wholly owned subsidiary of Cisco Systems Inc., provides leasing and financing solutions for the benefit of Cisco, Cisco’s partners, and customers. Cisco Capital began a major cross functional project called “Project Connect.” This project aims to implement a global lease and loan origination and servicing system to support Cisco Capital’s business and primary processes.

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.

Resolving Complex issues and providing solutions.

Hosted weekly/daily status meetings and managed communications. Worked on the Data issues raised by Business team/users and resolving the production issues within SLA

Dev, QA, UAT, PROD deployments for enhancement requests

Troubleshooting on data discrepancy issues raised by business team

ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues

Work on Performance degradations of the ETL Jobs

ETL monitoring and reporting on SLAs and data availability

Work on Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug Fixes; Enhancements)

Communication to the users and Business for Planned application downtime notifications

Ramp up and Ramp down activities during Outage of the Applications

Adhoc Validation of the data load as per client request.

Worked on Reconciliation of the management reports

Worked on the enhancement reports

Worked closely with clients and Business to ensure a detailed understanding of the needs

Participation of critical Month End and Quarter End closing activities

Engage and work with cross functional teams in case of priority issues

Provide support for release and period close activities.

Coordinated and provided quarterly SOX audits and as an SME participated in PWC walkthroughs for all the specified controls.

Being a Technical SME identifying the vulnerabilities for applications and work on remediation

Provide technical Level 2 and Level 2.5 support during US (PST) hours and resolve the production issues within SLA

Provide technical support during application upgrade and release activities

Worked on many automations.

Environment: Informatica 10.1,IICS, Oracle 11g, linux, Putty, Oracle, SQL Server, PL/SQL, TOAD, Scheduling tool

Company : Accenture - Apr 2010 – Aug 2020

Cisco Systems Inc. – Jan 2011 – Jun 2013

Company: Accenture Sr software developer Project: Asset Datamart,EFRA and Partner Datamart

Develpoed and Supported three datamart including BO reporting. Asset datamart is all about the assets related to all leasing and available assets from client.EFRA is all about finance reporting for all business regions. Consolidated contract information for all regions and available for finance reporting.Partner Datamart is all about EMEA region leases, assets and contracts.

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 nagement 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.

Resolving Complex issues and providing solutions.

Hosted weekly/daily status meetings and managed communications. Worked on the Data issues raised by Business team/users and resolving the production issues within SLA

Dev, QA, UAT, PROD deployments for enhancement requests

Troubleshooting on data discrepancy issues raised by business team

ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues

Work on Performance degradations of the ETL Jobs

ETL monitoring and reporting on SLAs and data availability

Work on Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug Fixes; Enhancements)

Communication to the users and Business for Planned application downtime notifications

Ramp up and Ramp down activities during Outage of the Applications

Adhoc Validation of the data load as per client request.

Worked on Reconciliation of the management reports

Worked on the enhancement reports

Worked closely with clients and Business to ensure a detailed understanding of the needs

Participation of critical Month End and Quarter End closing activities

Engage and work with cross functional teams in case of priority issues

Provide support for release and period close activities.

Coordinated and provided quarterly SOX audits and as an SME participated in PWC walkthroughs r all the specified controls.

Being a Technical SME identifying the vulnerabilities for applications and work on remediation

Provide technical Level 2 and Level 2.5 support during US (PST) hours and resolve the production issues within SLA

Provide technical support during application upgrade and release activities

Worked on many automations.

Company : Accenture

Project Name: OS/DB Migration project.

Client: Chemours Start Date: Jan 2010 End Date: Dec 2010

Migration Analyst:

ssssChemours is in the process of moving away from IBM as the Infrastructure partner. All Chemours application are currently hosted in the IBM Data Center and Chemours has decided to move these servers to out of IBM Data Centre.

The strategic direction from Chemours is to move all Non Production environment to Azure and all production environment to a new on-premise data center.

Chemours has also decided to move away from all Oracle (Mandatory) and DB2 (case-to-case basis) databases.

The project is executed in 2 waves as below

Wave 1 – Informatica

Wave 2 – Unix,Tableau

Roles and Responsibilities:

Prepared Design document for migration

Prepared Recommendation documents as per PAM for New systems

Created Firemon requests as part of network access between different servers

Installed Informatica and Tableau tools

Migrated the data from Old data center to New Data center

Configuration of system as per IBM configuration

Created test case documents

Involved in unit and integration testing

Provided knowledge transfer to the production support team.

Environment: Informatica Power Center 10.x, Business Objects, UNIX/Linux, Windows, Oracle, SQL Server, PL/SQL, TOAD, Scheduling tool TES, HP Quality Center

Cisco Systems Inc. – Mar 2007 – Apr 2010

Company: Accenture ETL Developer Project: AMS-Asset Management Solution

Asset Management Solution is initiated to have a single source of truth database for assets which will contain consistent data elements and data fields for Fixed Assets Management Lifecycle.

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.

Environment: Informatica Power Center 9.x, Business Objects, UNIX/Linux, Windows, Oracle, PL/SQL, TOAD, $Universe

Cisco Systems Inc. – Mar 2007 – Apr 2010

Company: Satyam / Accenture Sr. Support Analyst Project: Capital Applications

Capital DataMart and LeasePak reporting applications are used for decision support purposes. Cisco Capital uses various systems to support the leasing process all the way from lease initiation to receiving revenue (cash) from customers.

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.

oEstablished Month End/Quarter End checklist for smooth execution

oProactive communication

oProvided users with quality data for reporting

oWar room management

Coordinated and provided quarterly SOX audits and as an SME participated in PWC walkthroughs for all the specified controls.

Environment: Informatica Power Center 9.x/8.x, Business Objects, UNIX/Linux, Windows, Oracle, SQL Server, PL/SQL, TOAD, $Universe, HP Quality Center

Education & Credentials

Masters in Computer Applications

Technical Informatica 10.x,Informatica IDQ and MDM

IICS ● Business Objects ● Tableau ● Oracle SQL, PL/SQL ● MS SQL Server ● UNIX Shell Scripting ● Linux

Phython

● Windows ● MS Office Suite ● $Universe ● Tidal ● Remedy/Service Now ● HP QC

IICS

Contact this candidate