SUVRADEEP RUDRA

Contact 408-***-****/408-***-****, Email: jcebbc@r.postjobfree.com

OBJECTIVE

To pursue a challenging career in the field of Information Technology and to be a versatile leader who can translates the business strategy, business goals, and businesses processes into an IT solution and delivers the optimum business value to the clients in time and with maximum quality.

SUMMARY:

• Around 7+ Years of IT experience in data warehousing with strong technical knowledge of project related activities ranging from requirement gathering, project documentation (business, functional and use case documents),development of test plans and test cases for Business functionality and maintenance (using the latest tools for managing change requests and defects). Overall it has provided me a well rounded experience with project SDLC.

• Developed next generation Actionable BI (BI 2.0) solutions by integrating Siebel Analytics with other Oracle BI products. It is decision-centric BI application that is built on SOA architecture.

• Involved in Systems Analysis - with full competency, performs the specification and analysis of functional, nonfunctional, and information requirements in order to develop the specifications of an IT solution.

• Involved in migration of COGNOS BI environment to MicroStrategy .Involved in AS-WAS and AS -IS analysis between two BI environments.

• Expert data modeling skills i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts. Experience with Erwin Data modeling tool

• Strong experience in Data modeling, ETL, Data Warehousing, Business Intelligence and RBDMS with emphasis in Data Warehousing tools using industry accepted methodologies and procedure. Good Knowledge in Star Schema and Snowflake Schema.

• Strong knowledge of Data Warehousing, MDM (Oracle Customer Hub), Data analysis, Database, Oracle BI products, Data Mining (Predictive Analytics), Oracle Data warehouse for Retail (OWD-R) and SOA based Data conversion and Integration.

• Involved in Sales, Marketing, Financial Analysis & Reporting using OBIEE Apps with SIEBEL and Oracle E-Business Suite as source system.

• Involved in SQL code migration using REDGATE SQL Compare 8.5 and data synchronization using REDGATE SQL Data Compare 8.1

• Strong experience in various Databases like ORACLE,MS SQL SERVER and TERADATA

• Strong experience in data modeling, ETL (Informatica, Oracle Data Integrator - ODI), business intelligence and converting client’s requirements into a successful OBIEE solutions.

• Experience with IBM Rational® RequisitePro® - requirements management tool and with Erwin Data Modeler , IBM® Rational Rose® Data Modeler for database application development

• Experience in the development of test plans and test cases for Business Functionality.

• Excellent team player with Strong communication, customer service and organizational skills.

• Experience in working with top consulting firms like Deloitte, Oracle, Keane Inc.

• Client served: Juniper Networks, Net App, University Of California, CLARKS, Honeywell, T.K.MAXX (UK), and Zion’s Bank. Has Retail, Manufacturing and Financial industry knowledge.

TECHNICAL SKILLS:

Statistical Packages SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS,

SAS/REPORTS, SAS/ACCESS, SAS/STAT.

Technology

BI, Data warehousing, Database, Data Mining, SOA based Data Integration, Oracle Business Intelligence Enterprise Edition 10.1.3.,Data Analysis

BI Packaged Applications ORACLE BI Applications 7.9.4 (Siebel Applications), MicroStrategy

ETL Tools Informatica (Power Center) 7.1.2, Oracle Data Integrator (ODI), Microsoft DTS, SOA based Data Integration (ODI - BPEL),BO-DI

OLAP Oracle OLAP , Hyperion Essbase - Training only

Data Mining Tools Oracle Data Mining (ODM)

Database Technology Teradata SQL, MS SQL Server 2000,T-SQL, MS SQL Server DTS Oracle 10g – ORACLE PL/SQL (creating views, triggers, and Stored Procedures),DB2 (Production Support role)

Reporting Tool OBIEE Reports and Dashboard Design (Siebel Analytics), Oracle Portal, BI Publisher, Oracle Business Intelligence Discoverer, OBIEE Repository Design & Development

Master Data Management Oracle's Customer Hub.

Configuration Tools Microsoft Visual Source Safe 6.0, CVS.

Scheduling Tools UNIX Crontab and SHELL programming.

Quality Management Mercury QTP, Mercury Quality Center 9.0

CRM Packages www.salesforce.com ,Siebel 8.0 – Marketing, Sales (Functional modules)

DW Modeling Tool Erwin 4.1, MS Visio.

Prog. &Scripting languages C#, ASP.NET, Java Script, Vb Script, Mercury-HP QTP script

Others SQL * Loader, Oracle SQL Developer, TOAD 8.0/7.4, Mercurey - HP PPM, Database Performance tuning, RequisitePro, REDGATE SQL Data Compare 8.1, REDGATE SQL Compare 8.5

EDUCATION:

Academic

MBA in Finance (pursuing) Devry University, CA, USA.

Master of Computer Applications University of Madras, Chennai, India.

Professional Affiliations / Certifications

• Microsoft Cetified professional - SQL Server Database

Training

• Leadership Essentials, Harvard Business School Certification

• Lean Six Sigma – Yellow Belt Certification

• Hyperion Essbase Conducted by Oracle (San Jose).

• Zilliant Precision Pricing SuiteTM Conducted by Zilliant.

• Industry Proficiency Level 1 (Business Analyst)

Presentations

• OBIEE Workshop Presentation at Juniper Networks, Sunnyvale, CA, USA.

• Oracle Data Mining at Oracle, Bangalore, India.

• Actionable BI (BI 2.0) integrating OBIEE with SOA, Oracle, Bangalore, India.

• Retail Business Intelligence Application (RBIA) presented at National Retail Federation Convention (NRF) in New York.

PROFESSIONAL EXPERIENCE:

Project: San Francisco Health Plan, San Francisco, CA Feb’10 to Till Date

Environment: MS SQL SERVER, ORACLE, ERwin Data Modeler, SAS, UNIX, Proprietary legacy systems

REDGATE SQL Data Compare 8.1, REDGATE SQL Compare 8.5

Responsibilities: BI - EDW Business Analyst / Developer

San Francisco Health Plan is a City-sponsored health plan providing health insurance to more than 55,000 San Franciscans. San Francisco Health Plan works to promote preventive health care and to improve chronic care for its members. The effectiveness of the efforts is measured by HEDIS; SFHP reports performance by a subset of those measures for Medi-Cal and Healthy Families programs. HEDIS is used to compare health plans both statewide and nationally.

The goal of the EDW project is to reach the national Medicaid 90th percentile on all measures.

BI Analyst Responsibilities:

• Provide SAS programming support for a broad range of epidemiologic and pharmacoeconomic studies using insurance claims data

• Process and analyze data to support clinical and financial initiatives for managed care organizations

• Create and execute unit test plans based on system and validation requirements.

Ability to understand and develop audit rules for industry standard health data code sets such as ICD-9/ICD-10, CPT/HCPCS, Revenue codes, and NDC (Pharmacy)

• Assist statisticians in the summary of encounters data for reports, including summary tables, data listings, and figures

• Active participation as a business analyst for migrating SFHP’s in house claims processing system to QNXT™. It is an "n-tier" environment and service-oriented architecture .TriZetto's next-generation enterprise application system

• Active participation in monthly departmental meetings and providing the necessary inputs on how to improve the standards

Technical Responsibilities:

• Develop technical specifications, code, test, and implement new, complex SAS program logic, and modify existing programs to extract data from large databases and prepare data for analyses in a fast paced Managed Care environment.

• Collaborate with various functional business units to gather reporting requirements.

• Develop the Data Model for the staging environment using ERwin.

• Extract, transform and summarize administrative data using SQL and/or SAS

• Design, develop, implement, and assist in validating ETL processes. Migrating database changes from dev, to test, to production

• Involved in SQL code migration using REDGATE SQL Compare 8.5 and data synchronization using REDGATE SQL Data Compare 8.1

• Worked closely with Statisticians, Data managers.

• Converted stored claims data into vendor-specified flat text file formats using SAS to export to vendor's SQL Server 2000 DBMS.

• Analyzed data using SAS to produce key HEDIS statistical data.

• Successfully provided HEDIS measure data that accounted for utilization anomalies and/or inconsistencies based on strategic data analysis and research.

• Supports auditing vendor by constructing and supplying SQL queries for the purpose of sampling client utilization data

• Document all ETL related work per SFHP*s methodology.

• Maintain existing code and fix bugs whenever needed.

• Ensure that all timelines of loading/validating data are met.

• Ensure smooth functioning of our development, QA and production environments.

• Create ad-hoc and automated reporting solutions.

Project: NetApp, Sunnyvale, CA Mar’09 to Mar’10

Environment: Siebel CRM 8.0, Oracle, Oracle Customer Hub, T-SQL SERVER,

Teradata, UNIX SCRIPTING,

Responsibilities: Business Analyst

• Capture and document Business Requirements from client conducting interviews and workshops.

• Understand the data flow design between Net App’s Customer Hub and D&B Data Center and also how data is integrated to upstream systems like CRM, ERP.

• Map the attributes to upstream system that consumes the Customer Hub data.

• Implementing D&B hierarchy structure for customers inside Net App business.

• Implementing D&B vertical, by utilizing the standard industry code, provided by D&B.

• Incorporating all customer demographic information into Business requirement templates.

• Perform GAP Analysis related current COGNOS BI environment and map client requirements into Microstrategy functionality.

• Data Quality Analysis using T-SQL scripts and identify data quality issues and resolve

• Teradata Utilities like Multi Load, Fast Load and Fast Export from the root cause.

• Financial Analytics : Cash flow Analysis, Expense Analysis, Net Working Capital, Receivable turnover, Ratio Analysis (Current Ratio, Debt to Asset, etc)

• Sales Analytics: Sales Overview, Forecast & Goal Analysis, Pipeline Analysis, Win Loss Analysis, Discount & Margin Analysis, Sales Booking Analysis, Sales Channel Analysis, Sales OEM Analysis, Intra-Day Quotes, Partner Analytics, and Pipeline Analytics

• Marketing Analytics: Marketing Overview, Booking Analysis, Win Loss Analysis, and Customer Analytics

Deloitte Consulting Experience

Project: ZION’s Bank, Salt lake city, UT, Dec’08 to Mar’09

Environment: Oracle PL/SQL, BusinessObjects - Data Integrator, BusinessObjects, Mercury-HP Quality Center, Excel, MS Visio, IBM RequisitePro

Responsibilities: Consultant – BI/DW Analyst

ZION’s bank integration with LDS Church - Nonprofit FSI institution, this solution is being called as CUBS Online Application. The project involved Data Conversion from Legacy Applications to CUBS Online Application and also to build Data Warehouse for analytical reporting. The goal is to build the global Data Warehouse and an integrated reporting environment using BusinessObjects.

• Define Test Strategy and Approach for Data conversion and Data Warehouse Testing

• Developed testing strategy - different cycles of testing, define objective of testing in each cycle, entry/exit criteria. Developed Test

• Validate defined data mapping requirements from legacy systems to CUBS application, identify anomalies, and work with business analysts and database administrators to resolve issues.

• Developed test plans and test cases from requirements documents

• Develop data conversion scripts (SQL) and reports

• Prepared all necessary technical documentation related to the data conversion

• Coordination with the offshore test analysts and Business Analysts

• Gain experience with agile project framework

• Mentored new resources in the team and helped them to understand the CUBS Data model and the overall Data conversion architecture

• Responsible for tracking all the deployment requests created by the developer in Mercury PPM application and creation of reports that will help Deloitte leadership to have broad understanding of the overall project health.

• Track and update all deployment requests over the daily business meeting calls.

• Involve in Change Management - identifying, assessing and managing changes. Change deployment management - identifying, managing, mitigating and escalating through effective communication.

• Collaborated with client’s leadership in developing best practices

Project: JUNIPER NETWORKS, Sunnyvale, CA Feb’08 to Dec’08

Environment: Siebel CRM 8.0, OBIEE (Siebel Analytics) Application 7.9.4, DAC, Oracle database.

Responsibilities: Consultant - Siebel Analytics Application Analyst and developer

BI Analyst Responsibilities:

• Worked with M2S (Market to Sell) track and involved into following Subject Areas

o CRM Campaigns

o CRM Planning

o Sale Pipeline

o CRM Quotes

o CRM - Service

o OLM – Opportunity Life cycle Management

• Worked with Financial Analytics track and involved into following Subject Areas

o Financials - AP Balance

o Financials - AR Balance

o Financials - AR Overview

• Work with business representatives at all levels to define, design, and drive appropriate reporting/BI solutions

• Used BM® Rational Rose® Data Modeler which has ability to map logical and physical models to flexibly evolve database designs into the application's logic.

• Understanding the Marketing Business process of Juniper Networks and map it to Siebel Marketing Model.

• Working with Deloitte Siebel practice to create MDM strategy, Data Governance, Business Intelligence workshops for Client.

• Explaining the business user the OBIEE sales and marketing Analytics module.

• Requirements gathering for Analytics, creating Data model using IBM Rational Data Architect for Technical Design Document.

• Mapping the requirements with Siebel Analytic 7.9.4 out of the box subject areas.

• Analyze technical input from Siebel CRM and map it to target (Analytics).

• Analyze business requirements and translate them into FDD (Functional Design Document) and TDD (Technical Design Document). Identify and lead resolution of Process problems.

• Writing Test Cases during UAT phase and co-ordinate with Business during production Cut over.

• Participate in all user acceptance testing, provide test output using HP Quality Center Enterprise Edition and participate in the creation of user notification or documentation on projects.

Technical Responsibilities:

• Installing and configuring Siebel Analytics Application (7.9.4) in Dev, Test, and Stage Environments.

• Upgrading existing Siebel analytics Application (7.8) to new version (7.9.4).

• Creating and migrating the DAC metadata repositories.

• Resolve issues during synchronization of metadata between DAC repository and Informatica repository.

• Strong experience using DAC (Data Warehouse Administration Console) to schedule & manage tasks.

• Installing the Out of the Box Informatica Metadata Repository and manage metadata repository for migration from Dev environment to Staging and to production environment.

• Use Repository Manager to import Metadata for sources and targets and resolve issues related to metadata tables like ‘OPB’ tables and ‘REP’ tables.

• Involved in developing the Custom Informatica ETL mappings.

• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using out of the box subject area.

• Configured iBots to deliver Analytics content based on schedule.

• Implemented security by creating roles & web groups, and LDAP.

• Configured Dashboards visibility (Object and Data level security) with respect to user's responsibility and web groups in an integrated environment.

• Perform Data Quality analysis on the Target data by developing SQL scripts

Oracle Corporation Experience

Project: CLARKS. Newton Upper Falls, MA Oct’07 to Feb’08

Environment: Oracle BI EE (Siebel Analytics), Oracle OLAP, Oracle Portal, Oracle database.

Responsibilities: Consultant - Siebel Analytics Application Architect.

• Working with client to define corporate KPI"s and business intelligence corporate strategy.

• Capture and document Business Requirements from client conducting interviews and workshops.

• Used external loaders (SQL*Loader) to load the data into the staging tables.

• Perform GAP Analysis related to BI Application’s Data Models and ETL, creation of high-level and detailed design documentation, map client requirements into Siebel Analytics/OBIEE functionality.

• Creating an Analytical Workspace using Oracle AWM, this includes Dimensions, Cubes and helps to organize business categories and measures.

• Solving complexities of Ragged and unbalanced Hierarchies.

• Creating Levels, Hierarchies, and Attributes of the Dimensions using AWM.

• Creating Oracle OLAP Cube.

• Creating the Measures (both General measures and Calculate measures)

• Selecting proper implementation choices (like Sparsity, Compression, Aggregation, etc) for better Data loading and Aggregation of the Cube.

• Creating the Mapping to load the Cube (Oracle OLAP Cube).

• Using AWM plug-in, this allows for the creation of relational views over cubes.

• Creating interactive dashboards using Oracle BIEE by utilizing the relational views.

• Integration of Reports with Oracle9iAS Portal.

Project: ROSS. Pleasanton, CA Sep’07 to Oct’07

Environment: Oracle BI EE (Siebel Analytics), BI Publisher, Oracle database.

Responsibilities: Consultant - Siebel Analytics Application Developer.

The main aim of the project is to Integrate of BI Publisher with BI EE; create reports in BI Publisher by using the dataset of BI EE. Creating reports on EPM Subject Areas (HCM and SCM). This was to create BI Publisher with Peoplesoft EPM BI Applications.

• Configure analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions).

• Customize and modify the physical, business and presentation layers of metadata repository using Siebel Analytics Administration Tool.

• Manage security - Create groups in the repository, add users to the groups, and grant privileges explicitly through group inheritance for each subject area and dashboards.

• Create dimension sources for each level of aggregates and specify aggregate levels.

• Create pixel perfect Layout with Charts and a Table for the BI Publisher Report.

• Analyzing the BI publisher data (What If conditions) in MS Excel using BIP Plug-in.

• Publishing the Template for a BI Publisher Report.

Project: University Of California. Merced, CA Mar’07 to Aug’07

Environment: Oracle BI EE (Siebel Analytics), Oracle BPEL, Oracle database.

Responsibilities Consultant - Siebel Analytics Application Developer

This project is based on the foundation of Actionable BI (BI 2.0), which is intrinsically linked with real-time and event-driven BI and the application of these technologies to business processes.

The main tasks were

Introduced BI solutions using Oracle stack of products.

Building Dashboard and KPI’s for Executives.

Capability of taking Action on the Dashboard.

Alerts and workflow are being routed into Dashboard.

Take action against it.

• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.

• Created the physical layer of the repository.

• Implement Oracle Partition on the physical layer and changes done accordingly to the Business Model.

• Create the Dimensions and Hierarchies and organize the Presentation layer.

• Created Dashboard and integrated Answers using BI EE and iBots.

• Created Charts, Query, Narrative view, Column selectors and view selectors.

• Created Dashboard Prompts for use in exercising dashboard wide control over requests that are embedded into a dashboard page.

• Create global filters Create Proactive agents (iBots) and configured Interactive dashboards to alert the users as per the requirements.

• Utilized BPEL process for decision and action process Web services.

• Involved in building PL/SQL packages and stored procedures and expose them as web services using Oracle’s Developer.

• Designing the flow of Alerts and workflows get routed directly to and from the Dashboard, leveraging the SOA based architecture.

• Integrate BIEE and BPEL (Business Process Execution Language).

• Conducted testing/validation and debugging the applications using SQL scripts

Caritor Inc (now Keane) Experience

Project: HONEYWELL Aerospace – BI Implementation. Tempe, Arizona Jan’06 to Feb’07

Environment: SAP, Oracle BI EE (Siebel Analytics), Oracle database, Oracle Pl/SQL, Informatica 7.1, Mercury QTP, Teradata –SQL, UNIX shell scripting, TOAD.

Responsibilities: Consultant - Siebel Analytics Application Developer/Production Support

As part of Central Data Team for HONEYWELL Aero - BI implementation, working in large-scale technical delivery programmed environment, including detailed experience in technical data migration, data conversion, and data cleansing activities.

• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.

• Customizing the Answers reports of Contact Center Telephony Analytics.

• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 7.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).

• Develop ETL strategy and work plan based like PL/SQL Queries and Procedures for extracting, collating, cleansing and importing data from legacy systems.

• Created complex Informatica mappings to load data. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and also using mapping for Oracle Stored Procedures.

• Define static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.

• Define additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.

• Using existing SAP-LSMW objects, to load data into SAP production server.

• Create SAP-Queries based on the request for valuators to review the data after the load is complete.

• Mercury Quick Test Professional scripting. Using Visual Basic to code script for fixing production issues.

Project: HONEYWELL (ACS) Data warehousing Project, Minneapolis, MN Jul’03 to Jan’06

Environment: Oracle BI, Informatica 7.1, Oracle –PL/SQL, TOAD, DB2 .

Responsibilities: Consultant - Siebel Analytics Application Developer/Production Support.

As a solution provider for the Honeywell Order management process it involved implementation of BIEE (Siebel Analytics) Application’s Order Management infrastructure and up gradation and daily maintenance of Enterprise data warehouse.

• As a BI Consultant understand the new requirements and propose solutions based on the detailed facts gathered.

• Managed cross-functional teams for data consolidation.

• Worked with teams consisting of Technical Architects, DBAs, and DS Analysts.

• Involved in gap analysis related Order Management Analytics.

• Working with clients to define corporate KPI’s and management reports.

• Ensure compliance with organizational and project standard practices and processes.

Project: HONEYWELL (ACS) – Salesforce.com™ Integration. Minneapolis, MN

Environment: ORACLE 9i, ERWIN 4.0, DB Replication Tool.

Responsibilities: Consultant – Business Intelligence Application Developer.

The aim was quickly adapt to changing business needs by leveraging not replacing, existing technology investments. Honeywell is using an on demand CRM tool www.salesforce.com. This project requirement is to integrate the Oracle ERP with SFDC application. A third party tool ‘DB REPLICATION’ is used to transfer the data from this data mart to salesforce.com™.

• The objective is to extract data stored in salesforce.com™ and to load finally into a single data warehouse repository.

• Design and Development of Data Mart., Installations and configurations of DB REPLICATION tool as per Honeywell’s requirement.

• Developed data Mappings between source systems and warehouse components.

• Populating the Physical data model.

• Involved in customizing the Subject areas and hence the reports are generated based on the requirement.

References Available on request.

Contact this candidate