Sign in

Lead Technology/Technical Analyst

Durham, North Carolina, United States
January 30, 2018

Contact this candidate



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



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


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



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


Siebel Analytics, OBIEE integrated with Siebel/EBS


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.




Wells Fargo

Work Location

Charlotte, US




Technical Analyst - Reporting/DIDQ Tracks


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



Wells Fargo

Work Location

Charlotte, US


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


ProfitView FE Onshore Lead


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.



NAB Australia

Work Location

Pune, India


OBIEE 11g, PL-SQL Developer, OFSAA


Asset Lead - Value Control, Reconciliations and IAP teams.


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.



Estee Lauder Companies

Work Location



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


Offshore Lead - Business Intelligence


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.



Metro AG (Germany)

Work Location

Dusseldorf, Germany


Oracle BI Publisher 11g, Oracle PL/SQL


Onsite Lead


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



Kraft Foods (Mondelez International Inc.)

Work Location

Chandigarh, India


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


Senior Developer


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.



TOLL Holdings

Work Location

Chandigarh, India


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


BI Developer


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.


●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”




VISA Status

Valid H1B Visa

Current Address

Charlotte, NC

LinkedIn URL


Will be furnished upon request.


●Tableau Desktop

●T-SQL (Basics and Advanced)

●Capital Markets.

●Counterparty Credit Risk

Contact this candidate