Project Sql Server
Resume:
ALAKANANDA ROY
Phone: 704-***-****
email: abjlvq@r.postjobfree.com
SUMMARY
. 7+ years of IT experience and 6+ years of experience in OLAP and Software
Development.
. 6+ years of extensive experience in design, analysis, development and
implementation of various applications in client/server environment using
Hyperion Essbase 9.X/7.X/6.X, Hyperion Reports 7.0/2.6, Hyperion Analyzer
7.X/6.X, Hyperion Planning, ESSCMD, MaxL, Essbase Excel Add-In, VBA, EIS
on both Windows 2000/NT4.0 and Unix environment.
. Extensive Experience of Hyperion System 9 BI+, and exposure to Hyperion
EPM 11.1, the latest version of Hyperion.
. Strong Understanding of dense and sparse settings, performed dynamic
calculations, developed and optimized report queries in Microsoft Excel,
loaded data from various databases to cubes.
. Designed and developed numerous Essbase MDDB (Block Storage & Aggregate
Storage) applications with excellent balance of dimensions, developing
various OLAP Models & Meta-Outlines.
. Strong database development and business intelligence modeling
capabilities; Strong Essbase calculation script knowledge.
. Strong Knowledge of RDBMS concepts and design.
. Expertise in Oracle 9i, SQL Server 2000, Microsoft SQL Server 2005, SQL
and PL/SQL, Teradada,
BTEQ (Basic Teradata Query Language)
. Specialized in all aspects of high performance tuning and optimization of
databases-sparse and dense configuration, block density and compression,
outline structure strategies, dimensional schema design (Star schema),
relational schema design, batch update streamlining, load optimization
(load rules, transformations) and calc script optimization.
. Involved in writing Essbase calculations scripts, automated the Essbase
Cubes using Esscmds/MaxL, Batch Scripts and Shell Scripts.
. Involved in upgrading, testing and migrating of cubes in different
environments.
. Extensive experience in UNIX Shell Scripting for automation and error
checking.
. Strong understanding of Java and J2EE concepts.
. Versatile team player with excellent analytical, presentation and
interpersonal skills with an aptitude to learn new technologies.
TECHNICAL SKILLS
OLAP Hyperion System 9 BI+, Hyperion Essbase 7.x/6.x,
Essbase Integration,
Services
9.3.1/7.x/6.x, Hyperion Shared Services, MaxL, MDX, Esscmd,
Hyperion EPM 11.1
Databases Oracle 9i/8i/7, Essbase 7.x/6.x, MS-SQL Server
2005, Teradata 7.1.0.08
Distributed Systems Enterprise Java Beans, JDBC
Programming Languages C++, C, Java, Assembly, Visual Basic 6.0, SQL,
PL/SQL, Shell
Scripting, SAS
Web design Java Servlets, JSP, DHTML, JavaScript, XML
Operating Platforms Linux, UNIX, Microsoft Windows NT/2000.
Reporting Tools Hyperion Reports, Hyperion Analyzer, Hyperion Spread sheet
Add-In, Hyperion Planning, Interactive Reporting (Sys
9), Web Analysis (Sys 9), Web Analysis - Web
Analyzer, Hyperion Workspace Business Objects and
Crystal Reports
Web Server Apache Tomcat, Web Sphere 5.1/5.0, Web Logic
PROFESSIONAL EXPERIENCE
JPMorgan Chase - Columbus, OH
Dec 2009 - Present
Hyperion Essbase Consultant
Organization Group: Retail Financial Services (Consumer Banking)
Project Summary: Baseline 2010 - Chase - WAMU Integration Project
Responsibilities:
. Responsible for new Essbase development requests for Baseline 2010 -
Chase - WAMU Integration Project.
. Involved in Aggregate storage and Block storage cube development and
maintenance.
. Responsible for creating and modifying Essbase load rules, calculation
scripts, report scripts, outline formulas and MDX scripts for new
requirements.
. Optimization, performance tuning and maintenance of Hyperion Essbase,
Planning and Finance applications.
. Responsible for creating partitions to improve performance.
. Developed Various Maxl and Shell Scripts to automate data loads and
partitions.
. Involved in creating OLAP models and metaoutlines using EIS. Created
various filters in EIS as per user requirements.
. Created Essbase outlines based on report specifications and schema
delivered.
. Performed member and data loads in Essbase Integration Services.
. Involved in setup and security measures and granted access to users and
assigned them to specific user groups through Shared Services based on
their needs.
. Extensively worked with Excel Add-in, Smartview, Hyperion Reports &
Hyperion Analyzer.
. Involved in migration of cubes from version 9.3.1 to version 11.1.
. Provided technical support to all business units, offered suggestions and
proposed solutions to resolve issues.
. Provided technical support 24/7 and responsible for end-user training
with various applications.
Environment: Hyperion EPM 11.1, Essbase Administration Services 9.3.1,
Integration Services 9.3.1, Essbase Shared Services 9.3.1, Oracle Hyperion
Essbase System 9, Excel Add-In, Web Analysis - Web Analyzer.
Bank of America - Charlotte, NC
May 2009 - Dec 2009
Hyperion Essbase Consultant
Organization Group: Segment Channel Product Analytics
Project Summary:
Affinity Deposits Weekly Sales Cube for ICA - Segment Analytics team.
IM - Lead Generation Cube for Interaction Management Team.
Responsibilities:
. Responsible for building two new Essbase Applications one for Affinity
Deposits Team and one for Interaction Management Team.
. Engaged in entire software development life cycle for Hyperion Essbase
cube development, including data analysis, application design and
creation, documentation and conversion to production.
. Teamed up with business analysts for gathering requirements, functional
specifications, testing strategies and developing a project plan.
. Developed SAS code to extract data from Microsoft SQL server 2005.
. Developed BTEQ scripts to extract data from Teradata.
. Developed Shell Scripts and MAXL scripts to dynamically load dimensions
and data to Essbase Cubes.
. Developed ASO and BSO cubes and converted existing BSO cubes to ASO.
. Responsible for building load rules, calculations scripts, outline
formulas, MDX scripts and report scripts.
. Performance tuning & optimization of cubes for satisfying the users
reporting requirements.
. Restructured cubes and Essbase outlines in order to optimize performance
and calculations.
. Extensively worked with Hyperion Workspace (eDict), Hyperion Analyzer,
Cognos (RAZOR) and Essbase Excel Add-ins.
. Responsible for user and group administration and security maintenance
through Hyperion Shared Services.
. Additional tasks included configuration, and production support
Environment: Essbase Administration Services 9.3.1, Essbase Shared Services
9.3.1, Oracle Hyperion Essbase System 9, Excel Add-In, Interactive
Reporting (Sys 9), Web Analysis (Sys 9), Web Analysis - Web Analyzer,
Hyperion Workspace, SAS, Teradata 7.1.0.08, Microsoft SQL server 2005,
Cognos.
Chicago Mercantile Exchange - Chicago, IL
Oct 2008 - May 2009
Hyperion Essbase Administrator
Organization Group: Infosource
Responsibilities:
. Involved in the design and implementation of integration of Nymex data
into existing ASO/BSO cubes in Essbase version 9.3.1
. Administered and supported CME Group Hyperion system 9 Planning and
Essbase and HFM applications.
. Involved in cube outline creation, dense/sparse configuration and
enhancements as per user requirements.
. Responsible for building and modifying Essbase load rules, calculation
scripts and report scripts for new requirements.
. Developed MaxL/ESSCMD scripts and Batch Scripts/shell scripts to automate
the Essbase processes.
. Developed calculation scripts, outline formulas and MDX formulas.
. Responsible for user and group administration and security maintenance
through Hyperion Shared Services.
. Involved in production support, troubleshooting of issues reported and
establishing back-up procedure and restore as needed.
. Responsible to manage Dev, QA, prod and DR environments.
. Extensively involved in cube performance improvements and implementing
partitions.
. Work on Windows script and SQL Server ETL to transform data/automate
loads.
. Worked extensively with Excel Add-In and Hyperion reports/Interactive
reports for creating reports.
. Involved in design reviews and system documentation
Environment: Hyperion system 9 Planning and Essbase, Essbase
Administration Services 9.3.1, Essbase Shared Services 9.3.1, Hyperion
System 9, Excel Add-In, Oracle 11i, Informatica, Business Objects.
JPMorgan Chase - New York, NY
May 2008 - Sep 2008
Hyperion Essbase Consultant
Organization Group: TSS MIS
Project Summary: Installation and implementation of Essbase Version 9 on a
new Unix platform.
Responsibilities:
. Essbase Technical Support which primarily involves the installation and
implementation of EssBase version 9.3.1 on a new Unix platform.
. Involved in security administration, production support and maintenance
of Hyperion EssBase.
. Involved in writing Essbase calculations scripts, automated the Essbase
Cubes using Esscmds/MaxL, Batch Scripts and Shell Scripts
. Responsible for automated data loads, multiple dim builds, intelligent
calculation, parallel calculations.
. Responsible for handling the day to day Hyperion environment by
Processing security requests such as adding and removing authorized
users, scheduling and monitoring processes and handling user questions.
. Involved in Performance optimization and tuning of calculation times.
. Worked extensively with dimensions, dense/spares configuration,
partitioning, load rules and exports.
. Involved in Database corruption diagnosis and recovery handling.
. Monitored and involved in reporting of system performance, availability,
and utilization.
. Coordinated & executed system upgrades and patches.
. Worked extensively with Executive Viewer, Excel Add-In, and Smart View.
. Supported a comprehensive reporting system using Hyperion Analyzer using
the approach of Financial Dashboard.
. Maintained security through Hyperion Shared Services.
. Participated in design reviews.
Environment: Essbase Administration Services 9.3.1, Essbase 7.1.6,
Hyperion System 9, Hyperion Reports/Interactive Reports, Excel Add-In,
Executive Viewer 9.3.1.1, Oracle 10gR2, AIX 5.3
Bank of America - Charlotte, NC
Oct 2007 - April 2008
Hyperion Essbase Consultant
Organization Group: AIM (ANALYSIS AND INFORMATION MANAGEMENT)
Project Summary: To create an enterprise wide analytics environment that
will enable the Card Services organization to drive profitability
and customer delight by providing deep insights on the performance impact
of tactical and strategic initiatives. The Hyperion Essbase application
provides business intelligence analysis services to the bank through
interactive client tools.
Responsibilities:
. Responsible for Hyperion Essbase cube development and support, including
data analysis, application design and creation, documentation and
conversion to production.
. Designed and developed Aggregate Storage cubes for Call Center Management
Application using Essbase Administration Services 9.3.1.
. Designed outlines and Developed rules files for dimension building and
loading the data. The load involved data file as well as SQL load.
. Developed MaxL scripts and shell Scripts to automate the Essbase
processes.
. Implemented incremental data load using load buffer and created data
slices to optimize data loads.
. Implemented partitioning and write back functionality for performance
tuning.
. Designed and developed Daily Accounts and Monthly accounts cubes in BSO.
. Developed calculation scripts, outline formulas, Esscmd scripts.
. Involved in troubleshooting, Performance tuning and Performance
monitoring to meet user requirements.
. Designed transparent and linked partition for optimizing performance.
. Worked extensively with SQL server 2005.
. Migrated cubes from MSAS to Essbase using EIS which requires thorough
understanding of star schema.
. Worked extensively with Excel Add-In, Hyperion reports and Executive
Viewer 9.3.1.1. for creating reports.
. Involved in the production support and security maintenance of various
Small Business ASO and BSO cubes.
. Involved in detailed documentation for the Single Source BI Layer
Project.
Environment: Essbase Administration Services 9.3.1, Essbase Integration
Services 9.3.1, Essbase 7.1.6, Hyperion System 9, Excel Add-In, Executive
Viewer 9.3.1.1, Microsoft SQL server 2005.
JPMorgan Chase - Jersey City, NJ
Dec 2006 - Sept 2007
Hyperion Essbase Analyst
Organization Group: Global Finance (Ops)
Project Summary:
Development of 2008 Planning System for the entire JPMC Corporation:
The 2008 Planning Project is intended to produce the foundation for broad
Line Manager engagement in the planning process across the firm,
specifically in the area of active participation in the creation of budgets
at the position by position level for salary and benefits and contractors,
and for key direct expenses at the cost center level. Additionally, the
project will streamline the current Corporate Planning consolidation
platform through the convergence and standardization of reporting
dimensionality with Actuals reporting and introduce a more efficient
architecture (ASO/BSO Hybrid Architecture) across the current Essbase
Planning application that will build upon efficiencies that have already
been realized in the environment.
Responsibilities:
. Identified requirements, documented them and translated the system
specifications into physical design for Essbase data cubes.
. Engaged in entire software development life cycle. Involved in defining
operational requirements, functional specifications, designing
documentation and testing strategies.
. Involved in Consulting with users/Clients on database enhancements,
maintenance, analytics and reporting.
. Responsibilities included developing and optimizing outlines, calc
scripting, rule files creation, data load and extraction, data testing,
data integrity validation and database settings optimization.
. Implemented Essbase in connection with financial budgeting and sales
forecasting to produce reports.
. Supported and maintained user account information including rights,
security and groups.
. Maintained and updated the databases' security filters and performed
daily back-up procedures
. Generated Essbase calc scripts, involved in optimization of Calc Scripts.
. Developed MaxL scripts and Batch Scripts to automate the Essbase
processes.
. Assured optimal match between cube design and report specifications.
. Optimized structure, loading and calculations through appropriate dense
and sparse settings of dimensions, storage allocations and by dynamic
calculations and debugging.
. Developed detailed test plan for UAT and Building Validation Reports.
. Involved in loading test cases and logging defects in Mercury Quality
Center
. Managed system upgrades and client installations based on users
requirements.
. Developed Crystal reports for Direct Expense and Salaray&Benefit reports.
Environment: Essbase 7.1.6, Hyperion System 9, Hyperion Reports 7.0,
Excel Add-In, Crystal Reports, Oracle 10gR2, AIX 5.3 64bit(Operating
System), MS project, MS Visio.
Merill Lynch - Jersey City, NJ
Oct 2005 - Nov 2006
Hyperion consultant
Project Summary: Currently Merrill Lynch operates nine different Oracle
instances globally. Eight are considered regional General Ledgers (GL) and
one serves as a Consolidating General Ledger. Due to the instance
separation, each region has developed its own reporting structure, reports
and in some cases its own reporting tools. With the FDW (Financial Data
Warehouse) initiative, the US and Regional instances will be upgraded to
Oracle 11i and share a global chart of accounts. As a result, the
opportunity exists to consolidate the various reporting solutions and
standardize reporting formats across regions through Hyperion Products.
Responsibilities:
. Involved in Production & Design of Financial and Management Reporting
Application.
. Involved in Consulting with users/Clients on database enhancements,
maintenance, analytics and reporting.
. Involved in development of Legal Reporting /Management Reporting cubes.
. Extensively involved in troubleshooting and managing 24/7 Production
support.
. Performance tuning & optimization of cubes for satisfying the users
reporting requirements.
. Developed calculation scripts, outline formulas, Esscmd scripts and
financial reports.
. Error Handling, Trouble shooting, handling restructuring and server
problems.
. Involved in Migrations of databases from development servers to
QA/Production servers.
. Security Maintenance: Maintaining users, user groups and access
securities for all the developers & end users depending on their current
privileges to SOB/LE in Oracle GL.
. Automated monthly/annual PDF/Snapshot book generation, developed Excel
Templates for user interface in Essbase database.
Environment: Hyperion Essbase 7.1.5/7.1.2/7.1, Hyperion Reports 7.0,
Essbase Administration Services 7.1.2, EIS 7.1.2, Excel Add-In, IBM AIX,
Windows NT 4.0, Oracle 9i.
Pepsi Bottling Group, Winston-Salem, NC
Dec 2004 - Sep 2005
Essbase Developer Analyst
Project Summary: PBG had implemented Hyperion Essbase and required cube
additions to the existing suite of main applications. The project required
analyzing and modifying outlines for the existing data cubes and creating
new cubes. Administrator role included working on creating backups and
archiving, creating filters for security and user management. The project
also required providing technical support to end users.
Responsibilities:
. Translated end user requirements into application design specifications.
. Engaged in entire software development life cycle. Involved in defining
requirements, functional specifications, designing documentation and
testing strategies.
. Participated in outlining requirements and development of a project plan
with business personnel.
. Created outlines and optimized them by grouping and positioning.
. Developed Calc script to calculate complex values like Cash Cost/ User
and YTD commitment, Variance, Capital expenditures forecasts, Budgeted
cash flow statements etc.
. Developed batch scripts and MaxL for automating and scheduling month
close process.
. Created and modified rules files for accommodating data format changes
and enabling cube loading.
. Implemented mathematical functions for computing derived data and worked
on optimization of data loads and calc-scripts.
. Executed performance tuning and optimization in both the data retrieval
and data loading scenarios.
. Developed a comprehensive reporting system using Hyperion Analyzer using
the approach of Financial Dashboard.
. Prepared profitability reports, templates, analyzer report, forecasting
templates and templates for ad-hoc forecasting.
. Developed web forms using Hyperion Planning web client for the users.
. Administered users and user groups.
. Developed web forms using Hyperion planning web client for the users to
input Forecast, Budget, Actual Accounting changes and other variance
explanations data.
. Wrote shell scripts for automation, scheduling and error checking.
. Provided production support during the latter part of the project.
Environment: Hyperion Essbase 7.1.2, Hyperion Reports 7.2, Hyperion
Analyzer, Hyperion Planning 3.3, MS Excel 2000 Spreadsheet Add-In, HP UNIX,
MS Project.
S1 Services (India) Pvt. Ltd. Pune
Jan 2003 - Nov 2004
Software Engineer
S1 provides customer-interaction software solutions for financial and
payments services. There are more than 4,000 customers in 49 countries,
including regional and national banks, community banks, credit unions,
retailers, telcos, and processors who rely on the banking and payments
software.
Responsibilities:
. Worked on Requirement analysis, gathered all possible requirements
from end users and involved in transforming the requirements in to
exact implementation details.
. Participated in the design of database structure and table schema
layouts.
. Extensively worked with Oracle Packages, Procedures and Views.
. Designed and implemented user interfaces using Java Servlets and JSP.
. Generated reports by writing complex SQL Queries and stored
procedures.
. Provided effective technical support and tactical development for
multiple front/middle/back office applications.
. Responsible for complete regression testing of applied bug fixes and
application releases.
Environment: Java, Servlets, JSP, HTML, MS FrontPage, Oracle 7.0
EDUCATION
. Master of Science in Computer Science, University of North Carolina at
Charlotte.
. Bachelor of Engineering in Electronics and Telecommunication, Vikram
University, India.
Contact this candidate