Professional Summary

• Having 8 years of experience as a Data Migration and Business Intelligence Consultant, specializing in the space of BI reporting, ETL and Databases.
• Experienced in Data Migration, Migration strategy, Planning, Design and supporting till cutover.
• Have immense experience in multi data source exploration and data analysis.
• Have immense knowledge in strategizing the report delivery and consulting business on the key reports.
• Have experience in design strategy and implementation.
• Experienced in creating Repository Development like physical and metadata layer, development and design and performance tuning of reports and dashboards for supporting the business analysis in a corporate wide reporting using OBIEE 10g/11g.Have also worked extensively on Jasper and Actuate.
• Database experience in Oracle 9i/10g, SAP HANA Database,SLT .
• Have decent knowledge in IBM Maximo 7.5.
• Hands on experience in ETL tools like Informatica 8.6.1 Designer, Workflow Manager, Workflow Monitor and maintenance using Oracle SQL, PL/SQL, SQL Loader.
• Have experience in data modeling using Erwin tool while covering designs like Star Schema Modeling, Snowflake modeling, Physical, conceptual and logical modeling.
• Involved with implementation of the various phases in SDLC life as well as the Scrum Developer using Agile Methodologies.
• Experience configuring metadata, Answers, Delivers / IBots, creating interactive reports / Dashboards, cache monitor, and building Analytics Repository using OBIEE Admin tool
• Experience in configuring Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports and setting up office integration for OBIEE publisher
• Experience in Configuring Multi User Environment MUDE on Shared environment to allow development team to work concurrently
• Excellent team player both in individual and team lead capacity.

TECHNICAL SKILLS:

• MDM: IBM Infosphere, WCC,WPC
• B2Bi: Integration Server, WebMethods Trading Networks
• Programming Languages: Java, J2EE, Pl/Sql, UNIX ,HTML
• Application Servers: Apache Server, IBM WebSphere
• RDBMS: Oracle 10g/9i, SQL Server 7.0, DB2,Oracle 10g,11i, SAP HANA Sp4
• Other Database : SAP HANA SP4, Oracle Hyperion Essbase
• Operating Systems: Windows XP/NT, UNIX,LINUX
• Tools: TOAD, PL/SQL Developer, Microsoft SQl Server
• Scheduling tools: DAC Database Administration Console OBIEE 10g,OBIEE 11
• Version Control tools: VSS
• ERP/CRM : SAP ECC,Siebel CRM,SAP ERP,ORACLE EPM,OracleEBusinessSuite
• Data Modeling: SAP HANA Studio, DAC
• Data warehouse ETL Tools: OBIEE 11.1.1.5, OBIEE 10g , Informatica Power Center 8.1/7.1,Jasper ,Actuate, Qlikview
• Data Mapping: XML, Electronic Data Interchange EDI

Project Experience:-

Role: Data Migration and ETL Analyst

Colorado Springs Utilities is energy and utilities firm which involves in Water, Electricity and gas supply. To maintain their reporting and application, they use IBM Maximo as their Asset maintenance application. Now the product is upgraded and re implemented and it needs Data migration and report delivery. So the entire source system with multiple interface is analyzed and integrated there by data from multiple source is taken analyzed. Data migration activities were involved in pulling the data from source to target. Informatica is used as ETL tool and Oracle is used as the DB.

Responsilibilities

• Involved in the Business side to collect the requirement gathering.
• Analyzed the data source for data migration.
• Involved in preparing Data Migration Strategy Document and also formulated the planning for Data migration.
• Created Design Document for data migration at High Level and Low Level.
• Developed informatica mapping and transformation rules
• Developed detailed design document and delivery document.
• Played a complete Data Migration and ETL Analyst
• Developed Data marts for the report delivery
• Developed neat cut over plan and guided the business in terms moving the data migration
• Developed conceptual, Logical and Physical data model.
• Developed Data dictionary for the data and the mapping.

Role: Systems Analyst

Confidential

• Confidential is State Streets online client information-delivery portal. Clients around the world can access the data, tools and products they need to manage all their information. It is an integrated online delivery platform, where cli ents can view, download and extract various reports like Transactions, Holdings and Performance etc. It also allows for setting alerts, querying and comes with other information tools. State Street holds assets worth more than 2 trillion . All these asset under management for the clients mainly Investment banking, mutual funds ,private equity all maintained by a platform entreprise service platform. The data is centralized there by making master data management and served through web interface. The upto information service is given to the client. Reports are categorized based on region, country, securities etc.
• State Street Procure to pay reporting part was done by OBIEE. The information about Procurement and Spend Analytics stream line process were introduced. The objective is to have a subject area for the procurement and spend Analytics.

Responsilibilities

• Involved in the Business side to collect the requirement gathering.
• Analyzed the Oracle EBS Procurement and Spend Analyzer.
• Developed reports in OBIEE 10g leveraged the existing data model.
• Analyzed Oracle EBS procurement and spend to build subject areas like Spend Analyzer, Procurement performance, Supplier Performance and Employee Expenses.
• Played a key role in implementing iBots and OBIEE Scheduler to ensure the suppliers information is well received to the key officials on the supplier performance.
• Involved in Data Migrated having oracle EBS as data source.
• Data Analysis involving source and target is analyzed and data migration activities were done.
• Data Mapping and Data Mart Analysis
• Used SAP HANA as our data base for building marts.
• Developed reports for renowned investment bank, mutual funds and hedge funds.
• Developed security focused reports like Equity securities, Derivatives and Fixed Income reports.
• Managing projects in both Agile and Waterfall development environments and migrating from waterfall to agile.
• Keeping the team together all the time to ensure successful sprints.
• Defined project scope and objectives through internal project management methodologies. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office, on time within budget.
• Provide visibility to team impediments/risks and helps eliminate them.
• Coaches and mentors agile team members and provides constructive performance feedback Trained and coached a development team of 6-8 and management team of 12 to utilize Agile Methodology with Scrum.
• Helped the product owners to come up with set of stories for better understanding for estimate and development and also to prioritize the requirements of sprint.
• Representing the team to report overall project status and upcoming risks and suggest solutions about it.

Role : Systems Analyst

Confidential

Confidential is part of the SUPPLY CHAIN division of Deutsche Post DHL, the world's leading logistics group, with more than 285,000 employees in more than 220 countries and territories around the world and 2011 annual revenues of more than 55 billion euros. Deutsche Post DHL is the parent company of DHL, the global leader in international express, overland transport, and air freight. Being part of the global DHL Supply Chain and sister company to DHL Express allows us to add more value to our customers' supply chain management solutions in the Americas and around the world.

Responsilibilities

• Participated in Requirement gathering and prepared the design documents
• Involved in migrating RPD and Catalog , from OBIEE 10G to OBIEE 11G using Upgrade Assistant Tool
• Worked on Oracle BI Administration Tool for customizing the Physical Layer, Business Layer, Presentation Layer that came with OBIA and modifying it according to the business requirements
• Involved in Gap analysis, requirements gathering, functional/technical specifications, development, deploying and testing
• Configured and Modified RPD as per the requirements
• Worked on Answers/Delivers/Dashboards/Report Changes as per the Requirements
• Set up Delivers iBots to support the needs of the end users
• Implemented Data Level Security, Object Level Security
• Migrated Repository and Presentation catalog between different environments like Dev, Test, QA and Maintenance
• Worked on Web logic Security Realms to Administrate Users and Groups
• Designed and Tested Reports in the Dashboards for the Oracle SCM Analytics modules and created the Ad-hoc report according to the client needs
• Worked on Enterprise Manager Console to deploy the RPD and Catalog
• Worked on Catalog Manager , for Partial Deployment , archive/Back up and Documentation
• Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval and involved in ETL support activities like : monitor, troubleshoot, track, and document day-to-day production issues
• Used concepts like order to cash, Procure to Pay.
• Involved in financial reporting using Hyperion Essbase.
• Extensively used Supply chain management oracle Ebusiness Suite

Role : Developer/Analyst

Confidential

Confidential is a global provider of services for managing risk, helping customers to safely and responsibly improve their business performance. DNV Business Assurance Certification, assessment, training/education that supports customer's products, processes, and organisation globally over a wide spectrum of fields. We help companies build sustainable business performance and create stakeholder trust. As one of the world's leading certification bodies, we help you assure the performance of your organisation, products, people, facilities and supply chain.

Responsilibilties

• Gathered Business Requirements and documented as Business Requirements, Functional Requirements
• Created/Modified Metadata repository .rpd by using Administration Tool: Physical, Business Model and Mapping and Presentation Layers.
• Worked on different performance tuning methods Caching Aggregate tables
• Developed Ad-hoc and standard Reports / Dashboards with different Analytics Views like Multiple Compound layouts, Tables, Pivot Tables, Graphs, Column Selectors using OBIA
• Created reports using Filters, Prompts, Column selector, Conditional formatting, Charts etc as per the user requirements
• Configured iBots using Delivers, Job Manager to deliver Analytics content/report through mail to business users based on schedule
• Involved in developing Informatica Mappings Mapplets during enhancements
• Developed Informatica mappings with re-usable transformations mapplets using various Transformations
• Involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL
• Involved in Testing.
• UAT designing, executing, documenting, signoff
• Extensively involved in implementing reporting for Siebel CRM and oracle EBS
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Role :Developer/Analyst

Confidential

Confidential is an Confidential multinational banking and financial services corporation headquartered in Confidential. It is the second largest bank holding company in the United States by assets. The bank had different Application throughout US to handle the customer information and transaction based on the need. The crux of the project clearly deals with customer where the 360 degree view of customer information has to be generated when needed. The bank earlier used the CDI data modeling proposed by Siebel KYC The purpose of the project is mainly to overcome the Anti-money laundering and fraud management. Having Siebel based application online a new system proposed by IBM WCC is being replaced.

Responsibilities:-

• Interacted with Clients to gather business requirements
• Participated in the entire Software Development Life Cycle SDLC phases including Data Analysis, Data Modeling, Development, Supporting
• Analyzed Business Requirements and converted them into mapping design
• Developed data mapping for Sources, Targets, and Business Transformation rules
• Developed mappings for slowly changing dimensions Type I, II and Facts using Informatica Tool
• Used different Data Warehouse techniques like Star-Schema, snowflake schema
• Worked with various active passive transformations within Informatica like Expression, Lookup, Filter, Rank, Aggregator, Router, Update strategy, Stored Procedure, Joiner etc
• Developed Mapplets and Reusable Transformations for calculated business units
• Involved in the performance tuning of the programs
• Responsible for ETL Objects and Database Objects migration for each release
• Tested target data against source system tables by using SQL statements
• Monitored daily data loads and provided support after hours.
• Involved in the Software Development Life Cycle SDLC phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.
• Involved in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT using Test Link.
• Used IBM WCC for Master Data Management. Integrating multiple legacy systems.
• Worked on a concept and implementing Anti money laundering concepts AML .

Domain Skill:

• Banking and Finance
• Reporting Analyst and I have developed reports
• Reports based on Financial Statements, Balance sheet, Cash flow , Income statement
• Corporate finance, Capital Markets,
• Securities market, Hedge funds, mutual funds
• Equity Securities, Fixed Income Securities, Derivatives , Asset Under management, Risk Managements,
• Mortgage Backed Securities, Portfolio Management.
• Logistics
• Order to Cash
• Procure to Pay

Skill Learning out of private training and Interest:-

CFA Chartered Financial Analyst , Qlikview ,Big data Hadoop ,SAP Hana.