Developer Quality Assurance
Resume:
Sandip V. Joshi
************@*****.***
OBJECTIVE: Seeking a challenging position in Software Engineering that
offers professional growth.
EDUCATION: Texas A&M Kingsville University, Texas, USA
Master of Science in Computer
Science, Dec. 2007
Terna Engineering College, Navi
Mumbai, India
Bachelor of Computer Science, Aug. 2005
TECHNICAL SKILLS:
Languages/Methodologie SQL, C, C++, C#, PL-SQL, Visual C++, ASP.Net, HTML,
s VB, VC++, Perl
Databases MySQL, Hyperion Essbase 6.x/7.x/9.3.1x, Oracle
8i/9i/10g/11i, SQL Server 7.0, MS Access
Technologies DHTML, VB,JMS, RMI, JDBC, ASP
Operating Systems MS DOS, MS Windows 2.1/3.1/95/98/NT/2000/XP/2003/Vista
, Red Hat Linux 6.x, HP-Unix 9.x
Reporting Tools: Hyperion Reports 7.x/9.x/11, Hyperion Analyzer
7.x/9.x, Excel Spreadsheet Add-In, Hyperion Planning
3.3, Crystal Reports, Hyperion workspace 9.x/11,
Hyperion financial management 9
Analytics Tools: Hyperion ESSBASE 6.x /7.x/9.x, EAS 6.x/7.x/9.x, EIS,
Shared Services, Hyperion DRM 9.3.1
Software tools and Microsoft Office 2000/XP, Adobe Acrobat 6.0
Utilities Professional, SQL* Loader,Smart Draw Professional
EXPERIENCE:
Senior Hyperion Financial Reports Developer
Calypso Technologies, New York, NY
Apr. 09 to Nov. 09
Technologies: Hyperion System 9 BI+ Essbase administration services, Oracle
11i, Excel Add-ins, Windows NT, Hyperion Financial Reports Fusion Edition
11.1.1, Hyperion Web Analysis Studio 11.1.1, Hyperion Financial Management
11.1, Hyperion Smartview11.1
Responsibilities:
> Analyzed requirements of users and accordingly made changes in outline.
> Developed various Reports for the end user as per their requirements and
created many reports to suit preprinted format of the company using
Hyperion Financial Reports and Hyperion web analyzer.
> Worked closely with team leader to interact with users to know user
requirements.
> Anticipated the possible results of new approaches and suggested
improvements.
> Designed and developed enterprise environments to meet business needs.
> Performed quality assurance on reports and recommended necessary
improvements in reports for better performance.
> Prepared Profitability Reports, which detail Unit Cost, Price and Volume
Trends, and Expense Variances over prior periods
> Designed userPOV and prompts to cut down on the number of reports.
> Created numerous templates which were used to design similar other
reports.
> Performed detailed documentation for all reports.
> Guided and trained calypso team for maintenance of financial reports and
planning applications.
> Analyzed requirements of users and accordingly made changes in outline
> Performed comprehensive data analysis and consolidation.
> Troubleshot production cube for end users and developers.
> Involved in optimization and tuning of cubes.
> Assisted Hyperion admin in setting security filters, migrating reports
from development to qa.
> Implemented transparent partition in Aggregate storage Cube. (ASO)/Block
Storage Cube to reduce the data load and retrieval time for end users.
With transparent partition the retrieval time was reduced by almost 60%
and data load time to 70%
Hyperion Reports Developer
Accenture for Ameren UE, St Louis, MO
Jul 08 - Mar. 09
Technologies:
Hyperion financial reports 9.3.1, Hyperion system 9 BI+ web analysis
studio, Hyperion system 9 BI+ Essbase
Administration Services 9.3.1, Hyperion system 9 BI+ workspace 9, Hyperion
financial management system 9BI+
Responsibilities:
> Created numerous reports in Financial Reporting Studio on Income
Statement, Statistics, Net Revenue, Net Income and Expenses to calculate
Budget and Actuals; Summary and Detailed reports, Monthly and Quarterly
reports, Consolidating and Combined reports. Also created Books and
Snapshots.
> Assisted essabse cube development team in development of ASO and BSO
cubes.
> Involved in designing numerous report Templates used to design similar
other reports.
> Created data forms using Hyperion Financial Management forms builder
and customized as per user requirements.
> Communicated with users, essbase cube development team and functional
team to gather user requirements and improvised reports matching user
requirements and report standards.
> Developed Hyperion Web Analyzer reports by providing the user-friendly
features such as Traffic lighting to highlight data.
> Assisted Essbase development team in building block storage and aggregate
storage cubes.
> Assisted report owners to make reports more effective in performance,
easy to use and maintain.
> Gathered excellent knowledge of advanced concepts, features and
functionalities of HFR and Hyperion web analyzer, Hyperion workspace such
as conditional formatting, suppression, member functions, drill down,
drill through, variance etc.
Hyperion Essbase Developer
Verizon Business, Richardson, TX
Feb. 08 - Jul. 08
Technologies: Hyperion System 9 BI+ Essbase administration services, UNIX,
Oracle 11i, Excel Add-ins, Windows NT, Hyperion Planning System 9.3.1
Responsibilities:
> Involved in the full development lifecycle of cube development
including development, test and production
> Automated cubes using MaxL statements and running it through UNIX shell
scripts to avoid fragmentation of outline building skeleton cube and from
that building full cube.
> Created Data Source Configuration through Hyperion Configuration Utility
9.3 in Hyperion System 9 Designed, Developed and Implemented numerous
Planning applications and Essbase application from transactional data
which is now the platform for all the financial reporting and analysis.
> Involved in Creating Data Forms and Folders and Customizing Data Forms
> Developed complex Business Rules in planning which involved Building
Runtime Prompts and Adding Formulas to Business Rules.
> Created and registered planning applications in Hyperion System 9
Workspace
> Analyzed requirements of users and accordingly make changes in outline
> Built Block Storage (BSO) and Aggregate Storage (ASO) cubes
> Performed comprehensive data analysis and consolidation.
> Developed complex calc scripts for allocating cost to lowest level
members
> Troubleshot production cube for end users and developers.
> Optimized and tuned of Bizmerge and Segmentation cube
> Developed MDX statements that involved the usage of complex formulae
> Upgraded and migrated existing 7.1.6 cube to 9.3.0.1
PROJECTS:
. "Text Data Compression" using VC++
Developed a program to achieve the text data compression by using
Huffman and Lempel-Ziv coding
. "Master Form Wizard For generation of web forms using C#"
Developed a program in C# which allows user to select columns from
desired Oracle database and generates code for web forms.
CERTIFICATIONS:
? Introduction to Oracle9i: SQL plus IZ - 007
. Certified Associate in Project Management. (PMI)
? Certified RDBMS Developer
? Certified Object Oriented Developer.
? Comptia Project Plus
TRAINING:
? Oracle 9i: DBA Fundamentals 1
? Oracle 9i: DBA Fundamentals 2
? Oracle 9i: Performance & Tuning
From Oracle India Private Limited.
Contact this candidate