EXPERIENCE SUMMARY:

I am an associate with Confidential Limited with 8+ years of work experience. My main area of experience has been project development, process design and development, maintenance & enhancement of various sizes. I have worked primarily in the domain of Banking, Telecom and Manufacturing. My technological forte is Tableau 8.x, SAP BO XI3.x&4.x Designing & Reporting and its related Administration activities including installation and troubleshooting, have hands on and familiar with Informatica 8.x&9.x and its installation, mapping designing and allied activities. Have attended comprehensive training programs in DWH/BI, which includes Data Warehousing Concepts and various Data Warehousing tools.

CAREER OBJECTIVE:

To establish my career in the field of Business Intelligence and move ahead, enhancing my knowledge and fulfilling organisational goals.

KEY COMPETENCIES & SKILLS:

SAP BO XI 3.1

Tableau

Informatica 8

Datastage 7.5

SQL

Cognos

DB2

Unix

Business Performance Mgmt

Business Process Mgmt

Performance Engineering

TECHNOLOGY:

IBM DB2 & ORACLE 9i /10g & Sybase ASIQ 12

Squirrel SQL Client / TOAD /RapidSQL

Autosys Scheduler

HPSA

ClearCase, Perforce, CascadeBO XI R2,SAP BO XI 3.1,SAP BOE 4.0, Crystal Reports XI

Informatica 8.6.0/9.1.0/9.5.1

ILM Test Data Management

DataStage 8.x

Dashboards SP4 (XCelcius 2008)

Tableau Desktop 8.x & Alteryx

Standard SDLC method

Data Ware Housing Concepts

Agile Methodology

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Consultant (BI Architect)

Responsibilities:

• Responsible for transforming their AS IS Digital Reporting
• Responsible for providing insights & supporting their daily activities.
• Responsible for setting the long term strategy for their Digital Analytics
• Retrospection of existing process and redefining to enhance their digital analytics experience
• Liaise with other business users to understand their digital need and assist them in preparation of Key Business Requirement and defining organizational KPIs.
• Coordinate with offshore team as required
• Ensuring quality deliverables and process adherence
• Manage the digital program and complete accountability

Solution Environment: Windows 7

Tools: Tableau Desktop 8.3, Tableau Server, Adobe Site Catalyst, Alteryx, In - house tools (AFBI & MSSBI )

Confidential, Irvine, CA

Technical Lead

Responsibilities:

• I am responsible for understanding the sensitive data within the CGs database.
• Create policy, define data domain, apply rules and run profiles on the identified data in scope.
• Creating the Design document for the data masking and getting it reviewed and baseline.
• Responsible for troubleshooting the issues in the developed workflows.
• Ensuring Quality Standards and improve overall quality of deliverables
• Manage the team size of 5 resources, assign and assist in their daily tasks.
• Mentoring team member. Building competencies and skill within the team.

Solution Environment: Windows 2008

Tools: Informatica 9.5.1, TDM 9.5.0, Oracle, Sybase, MS SQL Server, UnixProject Name

Confidential

Technical Lead

Responsibilities:

• As part of Source Build, a target Datamart WGB was to be cloned from the existing TMI-RBSG Datamart. WGB is populated with rainbow data from RBSG as one-off load activity. I was responsible to create the Application Design Document and Component Design. Was responsible for getting the documents reviewed, freeze and baseline.
• As part of SEPA module, I was responsible to migrate the Bankline application from Informatica 8.6.1 to Informatica 9.0.1
• Responsible for unit testing and performance tuning of the Bankline workflows.
• Responsible for client interaction and providing the weekly project status call.
• I was responsible for troubleshooting the issues in PWC environment and preparing the RCA documents.
• Creating reusable components which can be used across projects and business units.
• Ensuring Quality Standards and improve overall quality of deliverables
• Manage the team task and provide effort estimation.
• Mentoring team member. Building competencies and skill within the team. Coordinating for providing Technical and Behavioural trainings to the team members and new on- boarding within the Account.

Solution Environment: Windows XP

Tools: Informatica 8.6.1/9.0.1 , Oracle 10g, Unix, BO 6.5, HPSA, Clear Case.

Confidential

Technical Lead

Responsibilities:

• Design and develop the Informatica mappings for the new requirements and unit test them.
• Prepare the High Level Design & Low Level Design and deployment documents.
• Deploy the Informatica mappings on the PROD server
• Responsible for analysing the existing mapping to accommodate the new user requirements or changes. Optimizing the existing mapping and sessions.
• Creating reusable components which can be used across projects and business units.
• Ensuring Quality Standards. Improving overall quality of deliverables and laying down Defect Prevention Plan. Defining team task and effort estimation.
• Building competencies and skill within the team.

Solution Environment: Windows XP SP3, VM Ware Client

Tools: Oracle 10g, Informatica 8.6.1, Unix, Cascade, SAP BO XI3

Confidential, Irvine, CA

Technical Lead

Responsibilities:

• Taking care of SAP BO Reporting issues and their resolution.
• Looking into Informatica mappings for any ongoing change or bug fixing.
• Creating, modifying JIL and managing Autosys jobs.
• Creating reusable components which can be used across projects and business units.
• Requirement Analysis, Understanding current process and re-defining them wherever necessary to streamline them or improve process and improve on work productivity.
• Ensuring Quality Standards. Improving overall quality of deliverables, report package quality and process quality and deploying Process Flows and laying down Defect Prevention Plan. Defining team task and effort estimation.
• Mentoring team member. Building competencies and skill within the team. Coordinating for providing Technical and Behavioural trainings to the team members and new on- boarding within the Account.

Solution Environment: Windows XP SP3, VM Ware Client

Tools: BOXI 3,Web Intelligence Rich Client, Info view, Sybase ASIQ, Oracle 10g, Informatica 8.5, Autosys, Unix

Confidential

Senior Solution Integrator

Responsibilities:

• Creating Universe for the development of BO XI3 reports. It’s testing and deployment.
• Migrating BO 6.5 reports to BO XI 3 environment and it’s testing in target environment.
• Analysing, estimating and preparing Solution documents for the development of reports using “ Confidential ALEX”.
• Development of BO XI3 reports as per application standards.
• Deployment of reports on BIS server and setting their scheduling as per Clients need.
• Supporting business user during Acceptance Testing and data validation of the migrated reports and fresh BO reports.
• To provide assistance to key account projects on BO Reports related tasks of creation or customization.
• Troubleshooting Reporting and BO Server issues.
• Managed a team size of 5 members at client end.
• Involved in knowledge sharing sessions and mentoring of new joinees.
• Involved in taking technical interview for talent acquisition.

Solution Environment: Windows XP, Windows 2003 Server R2,Citrix Server, OSS RC, Confidential ENIQ 2.5,ENIQ 11.2

Tools: BO 6.5, BOXI 3,Desktop Intelligence, Web Intelligence Rich Client, Universe Designer,Dashboard Design, BO CMC,BO Administration,BO Import Wizard, Sybase ASIQ

Confidential, St. Paul

Module Lead

Responsibilities:

• SPOC for data load and reporting .Had complete ownership of my module.
• Requirement understanding. Reviewing RTM prepared by the business analysts (BA), sharing the understanding with BA & rest of the team (onsite & offshore).
• Design, development and testing of reports apart from data load from legacy systems and transactional systems.
• I have worked here as a ETL, BO and Crystal Report developer.To accomplish the reporting I was involved in understanding their reporting requirements, proposing solution environment, reporting tools, understanding their existing database and coming up with a reporting specific data model.
• Fully involved in on-site-offshore coordination for the same and also looking into data load of reporting tables using Informatica 8. Design, development, testing and performance monitoring of ETL mappings &reports is also to be performed.
• Involved in integration of reports with Java applications being used by client .Reports UAT was completed with successful handover to client and support for some duration.

Solution Environment: Windows XP

Tools: IBM DB2, Crystal Report XI, BO XI R2, BO CMC, BO Administration, eBI Version Manager 12.1.0,Informatica 8.6,Juniper Network for VPN access, Squirrel SQL Client

Confidential

Developer

Responsibilities:

• My responsibilities included handling MASD (Mgmt Advisory & Services Division) which had 72 reports sent to RBI on annual and quarterly basis.
• To accomplish this I had to interact with Client for understanding their business requirement .I was complete owner of MASD, its reporting activities and guiding ETL team for loading needed data in appropriate tables.
• UAT was completed successfully &signoff on reports was done with 100 % CSAT.

Solution Environment: Windows 2000

Tools: IBM DB2, BO XI R2,Desktop Intelligence, Web Intelligence,Universe Designer, Erwin,Datastage 7.5

Confidential

Developer

Responsibilities:

• My responsibilities included monitoring workflows.
• Troubleshooting the issues in the failed workflows or mappings
• Developing the new mappings or modifying the existing one as per request.
• Unit testing the mappings.

Solution Environment: Windows 2000, Citrix server

Tools: Informatica 8,Oracle 9i, Visual Source Safe

Confidential

Developer

Responsibilities:

• Design the BO Universe as per business logic provided in the Requirement specification document.
• Developing BO reports and unit testing them.
• Troubleshooting and fixing the issues in the BO reports

Solution Environment: Windows XP

Tools: Business Objects XI R2, Web Intelligence, SQL Server 2000