Software Development Power Center

Vanaja G Mobile# : +91-879*******

Email ID : ******.****@*****.***

LinkedIn : https://www.linkedin.com/in/vanaja-gorthi-659491a8

Experience Summary:

** ***** ** ********** ** software industry in DWH/BI and wide range of progressive experience with ETL/ELT Informatica Power Center/IICS/IDMC that includes software Development, Maintenance and Support.

Expertise in requirement analysis, design, and development of software solutions to support the business needs of Global Corporations.

Be able to translate functional specifications into ETL design supported by detailed technical specifications for the support of the Data Warehouse's development on an ongoing basis.

Extensively worked on PC components-Mapping Designer, Transformation Developer, Workflow Manager, Workflow Monitor and IICS/IDMC components-Mappings, Mapping Tasks and Taskflows.

Expertise in Evolving Strategies for Extraction, Transformation and Loading of data from various Heterogeneous Data Sources.

Worked with different data sources like Flat Files and Relational Databases.

Proficient in RDBMS concepts and Data Warehousing Concepts.

Worked with UNIX Commands and Shell Scripting.

Assisted in Informatica training for Trainee candidates and Mentoring Junior team members.

Focused, hardworking, self-motivated, team oriented coupled with excellent communication, inter-personal skills, and a good team player.

Ability to work & interact with Global team (Technical Leads & Business Users) distributed across regions.

Technical Expertise:

Elements

Particulars

Primary Skills

Informatica Power Center 8x/9x/10x, IICS/IDMC

Cloud Technologies & Tools

Informatica IICS/ IDMC-CDI, Snowflake, Salesforce-CRM

Databases

DB2, Oracle 12c, Teradata 16, Vertica, Exasol, Hive, Snowflake

Database Connectivity & Tools

ODBC, Oracle SQL Developer 4.1, SqlDbx, QAAqua Data Studio, Teradata SQL Assistant 16, Toad 13, DBeaver

Languages & Scripts

SQL, PL/SQL, UNIX Shell Script, Autosys JIL Script, LUA Script

Scheduling Tools

Autosys R11 & 11.3, Control-M, Active Batch

Configuration, CR/RFC, CI/CD & Other Tools

Putty, WinSCP 6.3.1, Tortoise SVN, TFS, Pac2000, HP Service Center 6.2, ServiceNow, DevOps-GitHub, TeamForge, Jenkins, MFT

Domain Knowledge

Banking and Financial Services, Retail-REIT, Biotechnology

Testing & Project Management Tools

Quality Center, JIRA, Version1

Operating Systems

Windows 98/2000/XP/Vista/7/8/10/11, UNIX, Mac OS

Remote Desktop Tools

Citrix Workspace, Amazon Workspace, Azure Virtual Desktop

Documentation

MS Office 2007/2010, Visio, JIRA-Wiki, Lucid chart

Experience Details:

ØWorked as a Sr. Data Integration Developer for Biogen, Bangalore since Jan 2024 to Jun 2024 - Remote.

ØSenior Software Developer at Biogen (Team lease payroll), Bangalore from Mar 2023 to Jan 2024 - Remote.

ØSenior ETL Data Engineer at Apar Technologies, Bangalore from Nov 2020 to Mar 2023 - Remote.

ØSr. Consultant at Infogain India Pvt. Ltd., Bangalore from May 2018 to Feb 2019.

ØBI Senior Analyst at NTT DATA Inc. (Keane Inc.), Bangalore from Oct 2011 to Mar 2018.

Educational Qualification: B.Tech from JNTU University, Hyderabad.

Project Details:

Biogen Capability Center India (Biogen Inc – USA)

Biogen Inc. is an American multinational biotechnology company based in Cambridge, Massachusetts, United States specializing in the discovery, development, and delivery of therapies for the treatment of neurological diseases to patients worldwide.

Role

Individual Contributor

Environment

IICS/IDMC, Snowflake, MFT, Active Batch, DevOps, GitHub, S3, ServiceNow, MyCIMS, JIRA, Jira-WIKI page, Lucid Chart.

Team Size

9

Responsibilities

·Analysis of the requirements from URS/STTM document.

·Discuss with Product Owner and Business Team for the requirements.

·Create Lucid Chart with design approach.

·Schedule the Design Review with Internal team/Support team.

·Build the integration and document the UTR in DEV.

·Schedule the Job Plan in Active Batch scheduler.

·Involved in peer review.

·Followed the CR process from ServiceNow for deployment activities.

·Scheduled the Deployment Walkthrough and Support handover to the Support Team.

·Deployed the code using DevOps. Maintained DB objects in GitHub.

·Migrated code to the higher environments SIT, UAT and PROD.

·Prepared and Uploaded the STTM and Design documents to MyCIMS document repository.

·Created the WIKI page with Integration related details for Support team.

·Performed Hyper Care for the Production runs.

9. Project Name

ConnectiveRx to CCS (Co-ordinated Care System)

Project Description

The objective of this integration is to transfer data from CRX to CCS(Salesforce-CRM) for Copay claims. This helps Biogen to track all copay claims data and to provide reimbursements for patients and reporting purpose.

Duration

From (MM/YY)

01/24

To (MM/YY)

06/24

Responsibilities

·Implemented the existing Accelerator Framework to extract the files from MFT path and stage them in Snowflake internal stage area.

·Load the data from files which are at snowflake stage to STG_CRX schema tables/views.

·Created IICS/IDMC mappings/Mapping Tasks/ Task Flows to extract the data from views and load the data to CCS-Salesforce object.

8. Project Name

ESE - External Stakeholder Engagement

Project Description

The RAW data of ESE application will be used for multiple applications. One of the requirements is to have a metrics dashboard defined for External Stakeholder Engagement HCP Continuous Improvement project.

Duration

From (MM/YY)

03/23

To (MM/YY)

12/23

Responsibilities

·Implemented the existing Accelerator Framework to extract the files from MFT path and stage them in Snowflake internal stage area.

·Load the data from files which are at snowflake stage to PRE_GOVERNED and SRC_INT_ESE schema tables.

7. Project Name

Account360 Dashboard

Client

Equinix Inc.

Project Description

Equinix is a REIT (Real Estate Investment Company) company, has 200+ data centers in 24+ countries, all data centers are interconnected. It provides the data center services to its customers based on their needs. Account 360 dashboard will provide details for Orders, which are entered through Seibel source system.

Environment

Informatica 10.4, Exasol, Oracle, DevOps, GitHub, Jenkins, Tableau, LUA Scripting, Python, Control-M

Duration

From (MM/YY)

11/20

To (MM/YY)

03/23

Role

Individual Contributor

Responsibilities

·Analysed the existing ETL system and discussed the upcoming release requirements with the onsite team.

·Created/Modified ETL/ELT mappings, LUA scripts for data load from stage to Data Mart Tables.

·Sync-up Exasol data to Big Query.

·Prepared Data Fix statements for Exasol Data Mart tables

·Deployed code using DevOps. Maintained ETL objects in Jenkins and DB objects in GitHub.

Team Size

13

6. Project Name

RADAR (Regulatory Audit Data Archiving and Reporting)

Client

Hewlett Packard Enterprise (HPE)

Project Description

To implement an archiving strategy to retain corporate financial transaction information from retired applications in a format available for ad-hoc query capabilities, necessary to respond to requests from tax authorities. On-Board RADAR set of assets from Hewlett Packard Enterprise acquisitions and to migrate into one common, all-inclusive worldwide tax information source.

Environment

Hadoop-SQOOP, Hive, Informatica, Vertica, BOE, Windows 10, UNIX Shell Scripting

Duration

From (MM/YY)

05/18

To (MM/YY)

02/19

Role

Module Lead

Responsibilities

·Understanding the existing business model and customer requirements.

·Responsible for Requirement gathering and analysis for the project.

·Prepared the Source to Target Mapping (STTM) document based on the S2T docs.

·Coordinated with SMEs to ensure proper understanding of requirements.

·Involved in loading data to Hive Tables and writing hive queries.

·Developed and tested mappings to transform the data from source systems to target.

Contributions

·Allocating the work items to the team and assist them for issues.

·Involved in end-to-end implementation of the project activities.

Team Size

30

5. Project Name

CDD (Customer Due Diligence)

Client

WELLS FARGO

Project Description

This project aims to implement a data mart to provide a holistic view of Wholesale Customer Due Diligence (CDD) data which aggregates data from various source systems.

By implementing this project Wholesale will be able to run analytics to provide controls for BSA/AML purposes and in turn support the action plan for the Consent Order (CO). These controls will allow Wholesale to monitor adherence to CDD standards and provide important analytics to help manage the process end-to-end.

Environment

Informatica 9.6, Informatica MM, Teradata, Windows 7, UNIX Shell Scripting, Autosys R11.3 and SSRS, Pac 2000

Duration

From (MM/YY)

10/16

To (MM/YY)

03/18

Role

Team/Technical Lead

Responsibilities

·Coordinated project development and project management activities.

·Analyzed the existing ETL system and discussed with Business about the prerequisites and required environment set-ups.

·Coordinated with team and business to ensure proper and timely communication in understanding the requirements.

·Maintained regular status (WSR) reporting and strictly adhered to project timelines.

·Prepared Technical Specification Documents.

·Provided the Estimates of ETL's depending on the complexity.

·Involved in performance tuning for the mappings/sessions/workflows.

·Written Autosys JIL files to automate the jobs execution.

·Created the DLD (Design level Doc) and KT Supporting docs.

·Prepared excel formulas to generate Test Data to insert into the tables.

·Involved in SIT, UAT and production deployment.

Contributions

·Responsible to implement the end-to-end project activities.

·Standardize all release related documents as per latest company Guidelines.

·Helped to new team members for understanding the Project activities and their responsibilities.

·Prepared RTM and Test Plan docs.

·Implemented Automated WDM Framework to execute the workflows.

Team Size

7

4. Project Name

China VAT

Client

WELLS FARGO

Project Description

China is applying VAT to all industries on a phased basis. The expectation is that VAT will be applied to financial services early 2016. Wells Fargo wants to build an in-house strategic solution for Global VAT calculation and maintain a repository of all applicable transactions. Data Mart is one part of the whole VAT project, which mainly used to store the transaction data and calculate the VAT. To get started China VAT calculation is to be on-boarded.

Environment

Informatica 9.5, Oracle, Windows 7, UNIX Shell Scripting, Autosys Jobs and Java

Duration

From (MM/YY)

08/15

To (MM/YY)

04/16

Role

ETL Developer

Responsibilities

·Analyse the mapping specification, Source and Target databases to understand the business logic and involved in preparing the LLDs.

·Developed the Informatica outbound interfaces to generate the feeds.

·Created Tables, Views, Synonyms, Triggers and Procedures in Oracle.

·Providing monthly/weekly/daily reports to management.

·Quality checking as per the SLA set by the client.

·Generating quality reports and provides the same to management.

·Mentoring the team members to rectify the errors done.

·Involved in UT, SIT, UAT and production deployment.

Contributions

·Designed and implemented Naming conventions to follow throughout the project.

·Standardize all release related documents as per latest company Guidelines.

·Helped to new team members for understanding the Project activities and their responsibilities.

Team Size

8

3. Project Name

Liquidity analytics & reporting system (LARS)

Client

WELLS FARGO

Project Description

The Liquidity Analytics & Reporting (LAR) Group, as part of the Wells Fargo & Company (WFC) Corporate Finance Treasury (Treasury), is responsible for liquidity risk-related analytics and reporting to WFC senior management and regulators. Key aspects of liquidity risk analysis include understanding the following: Nature and timing of cash flows, Market conditions, Funding concentrations and Legal entity dimension.

Environment

Informatica Power Center, Oracle, Windows 7, UNIX, Autosys and QC

Duration

From (MM/YY)

02/14

To (MM/YY)

08/15

Role

ETL Developer

Responsibilities

·Analyzing the requirements (enhancements and bugs through QC).

·Tracking issues, Prioritization and interacting with on-site team/client for issue resolutions.

·Developing the mappings as per the Mapping Specification document using various transformations for data loading into ODS and Data Mart tables.

·Performance Tuning of Source queries, Mappings and Sessions.

·Responsible for Development and Testing of all the mappings and workflows.

·Created Sequence, Stored Procedure, Functions and used in session pre/post-sql.

·Provided the support for daily and on-demand data loads.

·Performed Code and Technical Review with team members and involved in peer review.

·Involved in UAT (User Acceptance Testing) phase code fixing.

·Prepared deployment list for ETL, DB and Autosys changes and validated them in PROD.

Contributions

·Have coded PL/SQL procedures to Log the data statistics of source data.

·Designed and implemented Reconciliation process.

Team Size

9

2. Project Name

PRIVATE BANKING

Client

WELLS FARGO

Project Description

Private Banking is a core business component of the overall Wealth Management strategy, providing wealth management advice and strategic liability management through customized banking solutions and services. Custom and packaged credit solutions, premium depository relationship accounts, and interest rate management tools are available to creatively address even the most complex client's wealth management needs.

Environment

Informatica 9.5, DB2 v9.1, Oracle, Teradata, UNIX, Autosys R11, JIRA Tool.

Duration

From (MM/YY)

01/13

To (MM/YY)

12/13

Role

ETL Developer

Responsibilities

·Analyzed the requirements (enhancements and bugs through JIRA) and prepared analysis documents, ETL design documents, mapping specification documents and code review documents.

·Responsible for Development and Testing of all the mappings and workflows.

·Prepared Test plan and unit test cases and involved in Test Cases review.

·Performed Regression Testing. Issue tracking, Prioritization and Resolution.

·Performed Code and Technical Review with team members.

·Used ETL Code Validation to check naming conventions for the ETL objects, which reduces manual validation and maintains the industry standards.

Team Size

10

1. Project Name

IM DASHBOARD

Client

WELLS FARGO

Project Description

The new Investments Navigator provides an easily accessible, centralized source of client investment data to help IM's manage portfolio risk, grow their business, and deliver exceptional client service. It offers actionable summary information for critical portfolio management tasks, with the ability to drill into additional details.

Environment

Informatica 8.6.1, DB2 v9.1, UNIX, Autosys, OBIEE, Java

Duration

From (MM/YY)

10/11

To (MM/YY)

12/12

Role

ETL Developer

Responsibilities

·Prepared the Mapping Document (ETL Story Doc) based on Data Stories.

·Developed the mappings using various transformations like Expression, lookup, Router, Filter, sequence generator, joiner and Aggregator.

·Designed and Generated DDL Scripts for tables and Views.

·Prepared Test Data, Unit Test Cases for the mappings and executed.

·Performance Tuning and debugging of existing ETL processes.

·Fixing the Bugs, Performed Code and Technical Review with team members.

·Prepared migration object list for UAT and PROD, involved in code promotion validated the objects post deployment.

Team Size

6

Contact this candidate