Lead Technology/Technical Analyst

ANIRUDDHA MEHTA

Mobile: 704-***-****

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

PROFILE SUMMARY

●A result oriented professional with excellent analytical, problem-solving, interpersonal and communication skills with ability to work in time-constrained environment, along with experience both as individual contributor and as a team player.

●More than 7.5 years of adept experience in gathering Business Requirements, Impact Analysis, Technical Design, Development, Implementation and Testing of various functionalities of Business Intelligence, Datawarehousing and ETL.

●Expertise in OBIEE/OBIA, Oracle BI Publisher and Informatica Powercenter and good understanding of SSIS and SSRS .

●Oracle certified OBI Apps implementation specialist.

●Extensive experience in providing end-to-end BI solution by Dimensional modeling design, Creation of Logical/Physical models, Configuration of OBIEE repository, Creation of Analyses/Answers, Agents/Delivers and Interactive Dashboards.

●Experience in OBIEE Performance tuning by Reports/dashboards re-deign, RPD configurations, Cache management, server optimization and database tuning.

●Extensive knowledge of OBIEE Security model using LDAP Authentication, Setup of Users and groups, RPD Authorization and data level and object level security setup.

● A good experience on OBIEE integration(SSO) with Siebel and EBS applications with experience of customizing Write-back functionality and Action Links.

●Strong Data modeling experience using Star/Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables.

●Proficiency in Informatica Designer Components (Source analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer, Workflow manager and Workflow monitor)

●Expertise in Design and development of Oracle BI Publisher reports and their Integration with Siebel application.

●A good experience of conducting technical workshops and trainings for application users along with an exposure to Pre sales activities for OBIEE projects.

●Familiarity in conducting Functional and Technical sessions to peers and project juniors for BI/DW basics and project related trainings.

●Skilled in working with MS-Excel, Macros and VBScripting.

WORK EXPERIENCE

●Currently employed as Lead Technology in Synechron Inc. with total experience of around 15 months till date.

●Worked as Technology Analyst in Infosys Limited with total experience of 6.5 years from Oct 2009 till Apr 2016.

SKILLS/EXPERTISE

Domains

BFS : Counterparty Credit Risk, Wholesale Banking - Profitability, GL and Reconciliations

HR, Retail and Consumer Logistics.

Developer Tools

BI Tool: OBIEE 12c, OBIEE 11.1.1.X, 10.1.3.X & BI Applications 7.9.X, Oracle BI Publisher

ETL : Informatica Power Center

Database Tools: TOAD, SQL*Plus, SQL Developer, Teradata SQL Assistant, SSMS

Applications

Siebel Analytics, OBIEE integrated with Siebel/EBS

Databases:

Oracle 9i/10g/11g, SQL Server 2000/2005, Teradata, SQL Server

Operating Systems

Windows NT/XP/2000/98, UNIX/Linux, Solaris

Microsoft Tools

MS-Excel, MS-PowerPoint, Visio and MS-Word.

PROFESSIONAL EXPERIENCE

Project:

Client

Wells Fargo

Work Location

Charlotte, US

Environment

SSMS, JIRA, SSIS, SSRS, Tortoise SVN

Role

Technical Analyst - Reporting/DIDQ Tracks

Duration

Jan 2017- Present

Project Description:

Counterparty Credit Risk (CoRS) is Counterparty Risk Management system developed in-house for Wells Fargo for assessing/calculating Counterparty Risk Exposure based on financial products, sub products and Limit Management to help the Risk Officers to take critical decisions effectively and thus enhancing Enterprise Risk Management capability.

It is replacement of existing system (Adaptiv) which is SunGard product, with enhancements related to performance and added functionality so as to customize and compute the risk measures such as Mark to Market (MTM), Potential Future Exposure (PFE), Expected Positive Exposure (EPE), Trade Related Exposure(TRE) across all the products.

This system acts as primary source to the CoRS-Reporting layer where all the reports and outbound feed are sent to business users and downstream applications respectively. This entire project is developed in Agile methodology.

Primary Responsibilities:

●Gathering the Business requirements/stories, conducting grooming sessions with SMEs and Product owners for in-depth understanding of the functionality and performing impact study on the existing architecture.

●Worked in Agile and writing stories/requirements to cater to each Sprint deliverables, their tracking in JIRA for progress/ pending/ completed items and product backlog.

●Perform the Data Reconciliation between Source and Target systems and root cause of analysis of the data mismatch.

●Arrange the Business/Technical story grooming session with Development and QA team to help them in understanding the requirements and resolved the issues faced by them, along with coordination with client and project management teams.

●Development logical data mapping between source and target for Development team to build the ETL mapping.

●Handled the existing ETL, SSRS reports and outbound feed deconstruction activity with the Technical Team.

● Coordinated with offshore and onsite team to help them in understanding the requirements and resolved the issues faced by them

●Writing SQL Queries needed for data analysis purpose

Project:

Client

Wells Fargo

Work Location

Charlotte, US

Environment

OBIEE 11.1.1.7.0, Oracle 11g, SQL Developer, Teradata SQL Assistant

Role

ProfitView FE Onshore Lead

Duration

May 2016- Dec 2016

Project Description:

ProfitView is a Wholesale profitability platform which is used to gauge profitability of Customer, Relationships, Products, AUs, Locations using the industry standard tools and practices. It is centered around Oracle Financial service applications framework and is using OBIEE for user reporting and analysis purposes.

Primary Responsibilities:

•Prioritization, estimation, impact analysis and development work for Production Defects, Key enhancements and fixes to cater to the business requirements, along with testing and coordination with various stakeholders like QA team, DB team and business users.

•Working on Security revamp related enhancements to tune up overall system's performance along with reduced storage requirements.

•System's Performance improvement initiatives to improvise the OBIEE reports/dashboards performance.

•Identify critical issues and processing faults to optimize BI dashboards and reports.

•Identifying bugs and their relevant fixes, along with coordination with Oracle support for OBIEE 12c upgrade related challenges.

•Onsite-Offshore coordination and communication with key stakeholders.

Project:

Client

NAB Australia

Work Location

Pune, India

Environment

OBIEE 11g, PL-SQL Developer, OFSAA

Role

Asset Lead - Value Control, Reconciliations and IAP teams.

Duration

Dec 2015 - Apr 2016

Primary Responsibilities:

•Key responsibilities include anchoring the Daily activities (Daily Controls, Reconciliations), Adhoc business requests.

•Account hierarchy change analysis which includes Impact of GL Remaps/Exception pointing (Add/Remove) and Margin analysis, which included impact on P&L and Treasury.

Project:

Client

Estee Lauder Companies

Work Location

Pune,India

Environment

OBIEE 11.1.1.6.10, BI Applications 7.9.6.2( HR Analytics ), Informatica PowerCenter 9.0.1, 8.6.1, DAC 10.1.3.4.1, Weblogic 10.3.5/10.6, Oracle 11g,SQL Developer

Role

Offshore Lead - Business Intelligence

Duration

Feb 2015- Nov 2015

Primary Responsibilities:

•Establish new processes and standards for development and migration operations to boost the project approach and scope.

•Provide regular support and resolution of analytical problems and reporting needs of OBIEE and data warehouse application.

•Development of many complex Informatica mappings and mapplets to build key interfaces for loading data into Data Warehouse.

•Set up incremental data load from existing daily full data load to datawarehouse.

•Involved in troubleshooting the load failure cases, including database problems.

Project:

Client

Metro AG (Germany)

Work Location

Dusseldorf, Germany

Environment

Oracle BI Publisher 11g, Oracle PL/SQL

Role

Onsite Lead

Duration

Jan 2014- Jan 2015

Primary Responsibilities:

●Conduct sessions and workshops with key business users and country coordinators for business requirements gathering.

●Analysis & Validation of the Business Requirement Specifications provided by the client

●Preparation of Estimates and Impact analysis of the Business requirements

●Creation of Complex reports with data sets from different sources and the related layouts as per business requirements

●Scheduling of BI Publisher reports and implementation of Bursting feature to deliver reports to multiple business users

●Creation and testing BI Publisher reports using BI Publisher Desktop and their integration with Siebel-CRM application

●Creation and Testing of PL/SQL procedures, functions and packages

●Performance tuning of the existing reports and PL/SQL packages

Project:

Client

Kraft Foods (Mondelez International Inc.)

Work Location

Chandigarh, India

Environment

OBIEE 10.1.3.4(Consumer Goods and Trade Promotions), Informatica 8.6, Oracle BI Publisher 10g, ControlM, PL/SQL

Role

Senior Developer

Duration

July2012 – Dec 2013

Primary Responsibilities:

●Development of major enhancements and change requests related to Informatica mappings and workflows, along with OBIEE and BI Publisher reports

●Provide primary support for all Informatica and OBIEE issues

●Development and testing of Informatica mappings and workflows, ETL performance tuning. Validate that the all the data transformations are correct according to the business rules and data warehouse is correctly populated with the transformed data

●Create OBIEE Dashboards, Delivers, Reports, Filters and Prompts and also involved in RPD configuration.

●Creation and testing of BI Publisher reports using BI Publisher Desktop and their integration with Siebel CRM application

•Redesigned the application to enhance the performance of OBIEE reports along with tuning Informatica mappings

•Configured BI Scheduler and created iBots to schedule and deliver analytics content to multiple delivery destinations and also as Cache Seeding mechanism.

•Integrated OBIEE with Siebel for Single Sign On mechanism.

•Regular monitoring of data load jobs in ControlM scheduling tool to ensure successful completion of daily ETL loads

•Apart from technical responsibilities, also took care of internal processes and project quality parameters through Infosys internal systems and well-rehearsed with CMMI practices for project

•Involved in impact analysis and high level estimates for OBIEE upgrade from 10g to 11g.

Project:

Client

TOLL Holdings

Work Location

Chandigarh, India

Environment

OBIEE 10g (Sales analytics and Service Analytics), Informatica 8.6, DAC 10.1.3.4.1.

Role

BI Developer

Duration

May 2010 – May 2012

Primary Responsibilities:

•Development of Informatica mappings and customizing the seeded one for Sales, Marketing and Service modules of Siebel Analytics

•Writing test cases for ETL and OBIEE reports to ensure quality deployment and migration to production

•Managing OBIEE metadata and deploying the RPD, Web Catalog in OBI Clustered environment

•Drive the workshops with business users to deliberate the business process and customer needs for reporting.

AWARDS, RECOGNITION AND CERTIFICATIONS

●Most Valuable Player – 3 consecutive times

●(On the Spot) – Technical Skill Award

●Oracle certified “ OBIEE 11g Pre-sales and Sales specialist”

●Oracle certified “ OBI Application implementation specialist”

●Oracle certified “ OBI Application Pre-sales and Sales specialist”

●Microsoft certified in “Programming in HTML5 with JavaScript and CSS3”

PERSONAL INFORMATION

Gender

Male

VISA Status

Valid H1B Visa

Current Address

Charlotte, NC

LinkedIn URL

https://www.linkedin.com/in/aniruddha-mehta-6b7b252b

REFERENCES

Will be furnished upon request.

RECENT TRAININGS

●Tableau Desktop

●T-SQL (Basics and Advanced)

●Capital Markets.

●Counterparty Credit Risk

Contact this candidate