BI/Data Warehousing/Hyperion Sr. Consultant

Sudipta Datta *************@*****.*** 248-***-****

Professional Profile

Result oriented professional with 16 years of IT and business experiences in analyzing, designing, implementing, testing, documenting, delivering, supporting and enhancing diverse software projects and applications. Demonstrated strong planning and leadership skills in the areas of project management. Also demonstrated leadership in communicating business goals, programs, and processes for the business segments. Most recent experience includes work with Visteon Corporation as application consultant for Hyperion financial management and Hyperion planning business intelligence applications tool suits.

Key Skills

Business Intelligence; Data Warehouse (DW) / Data Mart (DM) design (conceptual and logical data modeling), implementation of DW / DM, Extract Transformation and Load (ETL) in DW/DM, Metadata gathering; integration between Operational Data Store (ODS), staging and DW; Reporting; Executive Dashboard design and implementation; OLAP; Business analysis; Data mining

Project management: IT applications and management consultancy. Applications cloning

Security: Software and applications security analysis; Sarbanes Oxley security audits

IBM Mainframe: COBOL, JCL, MVS, TSO/ISPF, CICS, DB2, VSAM

Software: Oracle Hyperion Essbase; Hyperion Financial Management and Planning; Smartview; ETI* Extract and Data Integration Manager 9.X (informatica) ETL tools, ERWin; Crystal Reports; Infocaptor Excel and Microsoft Access Dashboard designers; SPSS (Data Analytics and Mining tool);Oracle, Microsoft SQL Server; PL/SQL (table structures, views, procedures); Visual Studio; Visual Basic scripts; Unix, shell scripts, Autosys, HTML, Microsoft Office, C, IBM WebSphere, J2EE/Java

ITIL Tools: Visual SourceSafe, PVCS; Remedy ITIL problem management, Remedy ITIL change management, ManageNow

Testing Tool: Test Director

Concepts: Service Oriented Architecture (SOA)

Certifications

· Oracle Certification on Hyperion Financial Management 9.3.1 Installation and Configuration

· Oracle Certification on Hyperion Planning 9.3.1 Installation and Configuration

· ETI* Extract 4.0.2 Master User (Data Warehouse ETL Administrator)

· ETI* Extract ETL Conversion Specialist

· Remedy Problem Management, Remedy Change Management

Career History

February 2001 – Present IBM, USA Application Consultant (Senior IT Specialist)

October 1993 – January 2001 Tata Consultancy Services (TCS), USA / India IT Analyst

Assignment History

February 2005 – Present IBM Client: Visteon Corporation, MI, USA

Applications consultant – Hyperion Financial Mngmt. and Planning

Financial and Analytic reporting for sales, marketing, management reporting, budgeting, planning and forecasting; Microsoft Office Integration with Smartview. ESSBASE (Cube design, load Rules, calc. scripts, HBR etc.). Hyperion Financial Management. DIM 9.X

Working as a Liaison between the Visteon BI team, IT Team, Vendor (Oracle), IBM Middleware team, Server team and Oracle DBA. Communicates to IBM executive and Visteon senior managers. Maintained peer relationships across IT areas (infrastructure, operations, etc) to support effective implementations. The middleware (WebSphere, Java JDK, Oracle client) installation and configuration. Visual Basic scripting for Hyperion batch jobs. Hyperion Financial Management, and Hyperion Planning applications installation, configuration and tuning in Development, QA, Production and Disaster Recovery environments.

Executive Dashboard design and implementation for GL and AR.

March 2004 - February 2005 IBM Client: Visteon Corporation, MI, USA

Lead Analyst – Visteon applications security

User security management. Sarbanes Oxley audits and periodic users access reviews for Visteon applications. Worked as a Liaison for several teams conducting the Impact Analysis, maintaining application system security configuration and SOD (Separation of Duties) databases. Developed security questionnaire, checklists, policies and procedure standards for applications security for Visteon applications.

Communicated with IBM and Visteon senior managers to ensure system security requirements are implemented across Visteon Applications.

March 2003 - February 2004 IBM Client: Visteon Corporation, MI, USA

Applications consultant – Environment cloning

Assessing, planning, & designing the consolidation of Visteon environment which was cloned from the Ford environment during separation and consisted of more than 150 applications. Collected data needed for the cloning effort within these two environments. Analyzed data and business requirements. Developed recommendations and detailed cloning plans. Produced knowledge acquisition plans, knowledge acquisition requirement documents. Developed a detailed design of the architectural solution and conducted solution testing. Communicated to IBM project peers/managers, IBM executives, Visteon senior managers, IT architects, IT team and analysts. Served as a mentor to team members.

March 2001 – February 2003 IBM Client: Ford Motor Company, MI, USA

Data warehouse Architect (in F@ST reporting I project)

Design & development of ETL conversions: Extract grammar and template writing, extract metadata and transformation metadata gathering; implementation of Code Insertion Points (CIP) to embed PL/SQL procedures, Oracle schema retrieval, implementation of data transformation filters. Unix shell scripting, Autosys scripting. DW Design: Logical data modeling, process modeling (Business modeling) and integration between ODS, staging and DW., Enterprise Reporting using Crystal Reports. Conversions, objects and packages migration to PVCS / Visual SourceSafe. Coordinated the activity of multiple developers and DBA in a large project environment. Technical architecture study and inventory analysis.

August 1999 – January 2001 TCS Client: Cummins Engine Company, IN, USA

Data warehouse Administrator/Architect

ETL Extract tool administration. ETI* Extract grammar and template writing; implementation of Code Insertion Points (CIP) to embed PL/SQL procedures, implementation of C scripts and SQL scripts for Oracle schema retrieval processes automation; design of data transformation filters, to help conversion analysts in data mart conversions development. DW / DM design (logical data modeling), process modeling and proof of concepts Implementation for integration between ODS, staging and DW. Enterprise Reporting using Crystal Reports

July 1998 – July 1999 TCS Client: Tata Iron and Steel Company, India

Assistant Consultant

Business Intelligence/Analytics thru Data mining. Development of expert systems applications related to pattern recognition and data mining of Oracle data files using Association Mining algorithms. Code walkthrough. Unit and module test plans and bed preparation and testing. Developed training materials.

May1997 – June 1998 TCS Client: Tata Iron and Steel Company, India

Project manager

Project coordination, monitoring and control. Communicated at several levels of the organization to gather requirements and present solutions. Discussions with Tata Steel managers to cover functionality, operations, technical issues and scope of work. Preparation of SOW, different charters. Review of system requirement documents and high level design documents. Planning & estimation of software developmental effort. Code walkthrough and technical discussions. Participated in interviewing process for potential team members. Tracking, QA, deployment and CR and incident management. Served as a mentor to team members. Guided documentation team.

January 1996 – April 1997 TCS Client: US West Communications, CO, USA

IT Analyst

Developed batch applications for validation of batch inputs, intermediate processing, update of database and generation of reports. Code walkthrough; unit and module test plans and bed preparation and testing. Program documentation including structured flow diagrams and program run charts. Assistance in preparation of production workflow for the initiation and control of batch runs using the job scheduler. Guided the documentation team.

October 1993 – December 1995 TCS Client: Indian Postal Services, New Delhi, India

IT Analyst

GUI forms and query screens development in SQL* Forms 3.x/4.5. Report writing in SQL* Reports 1.1/2.5. Database trigger writing. Units and modules test plans and bed preparation. Units, modules and integration testing. Causal analysis of modules. User manual preparation

Educational Background

Master of Science in Computer Science & Engineering, 1993; Jadavpur University, India

Bachelor of Science in Computer Science & Engineering, 1991; University of Calcutta, India

Awards

· IBM Service Excellence award for outstanding contribution in 2008

· IBM Bravo! award for outstanding contribution in 2004

· Member of IBM 95% Club for outstanding contribution in 2002

· Flying Fish award from Ford F@ST reporting I project for outstanding contribution in 2001

Contact this candidate