SUMMARY:

• Bachelor in Business Administration (Accounting & Finance) and Master in Information Systems.
• Eight years of IT professional experiences as a Programmer and Analyst in a data warehousing environment.
• Eight years of extensive experiences in developing and supporting Data Models, Queries and Reports in Brio (Hyperion) Enterprise Explorer, Designer and Interactive Reporting (IR).
• Five years of EIS/Dashboard/User Interface development experiences in Brio by using JavaScript.
• Three years of scheduling and distributing reports through Broadcast Server.
• Two years of experiences in registering BQY files on OnDemand Server to be accessed by Brio Insight/Web users.
• Two years of Brio Broadcast and one year of OnDemand Servers Administration and Support.
• One year of Hyperion Foundation experiences.
• One year of SQR programming experiences.
• Two years of extensive experiences in creating Data Providers and Reports by using BusinessObjects User Module.
• One year of extensive experiences in developing and maintaining Universes by using BusinessObjects Designer Module.
• One year of extensive experiences in administering BusinessObjects Supervisor Module.
• One year of Web Intelligence experiences in developing and publishing reports on the web.
• Six years of Oracle, one year of DB2, one year of SQL Server and two years of Sybase experiences.
• Strong analytical skills.
• Team lead, Team player and self-starter with excellent communication and inter-personal skills.

COMPUTER SKILLS:
Operating Systems- MS-DOS, Win NT/XP, Unix (Sun Solaris), Mainframe (MVS).
Programs- C++, Java, SQL, PL/SQL, SQR 6.2.
Web Development Languages- ASP, ASP.NET, XML, HTML, JavaScript.
Web Development Technologies- IIS, Personal Web Server.
Databases- Oracle 8i/9i, DB2 6.0, Sybase, MS SQL Server, Hyperion Essbase 7.0, MS Access.
Database Access Technologies- ODBC, ADO, OLEDB, ADO.NET.
Reporting Tools- Brio (Hyperion) Performance Suite 5.5/6.5/6.6/8.0/8.3.2/8.5, Brio (Hyperion) Enterprise Designer 5.5/6.5/6.6/8.0/8.3.2/8.5, Hyperion Reports, Hyperion Analyzer, Brio (Hyperion) Insight, Hyperion Foundation 8.3.2/8.5, Hyperion SQR Server 8.0, SQR Developer 8.0, Hyperion System 9 BI+ v9.3.1 (Interactive Reporting, Financial Reporting, Production Reporting), BusinessObjects 5.0/5.1, Webintelligence 2.6, Broadcast Agent Server, Oracle Developer 2000, Cognos Impromptu, Crystal Reports 8.5, Crystal Enterprise Server, SSRS.
ETL Tools- Informatica PowerCenter 5.1.
Systems Design Tools- MS System Architect, Visio, Erwin.
Other skills- MS Word, MS Excel, MS PowerPoint, MS Project.

PROFESSIONAL EXPERIENCES:
Analyst/Hyperion (Brio) Developer
Confidential,Iselin, NJ August 2004 - Present
Clients: Confidential,
Responsibilities:

• Interacted with users to collect requirements.
• Created Technical Specs.
• Created Data Models, Queries, Pivots, Charts, Reports and Dashboards.
• Converted/Modified exiting reports.
• Converted existing reports from Crystal to Brio.
• Created Master Data Models for Adhoc Querying.
• Performed Unit and Integration Testing on Reports.
• Scheduled and Published BQY files on Portal.
• Posted reports on OnDemand Server to be accessed and to be run by the users on the web.
• Leaded Brio Developers in team.
• Scheduled jobs on Broadcast Server (BCS) to be run based on the completion of the data loads and set the jobs to send the results to web server so that the users can access them through web site.
• Administered Broadcast and OnDemand Servers (creating OCEs and users’ accounts; granting/revoking users’ access; updating bqys).
• Documented BQY files.
• Trained Users.
• Supported Users with their problems.

Environment: Hyperion Intelligence Explorer/Designer (6.6.4/8.3.2/8.5), BrioInsight, Crystal Reports, Broadcast Server, OnDemand Server, Hyperion System 9 BI+ 9.3.1 (Interactive Reporting, Financial Reporting), Oracle (8/9/9i), JavaScript, SQL, TOAD, Windows-XP, MS SQL Server 7/2000, Hyperion Foundation 8.3.2, Hyperion Dashboard Builder, Sybase ASE, SQL Server 2005, Windows Server 2000, MS Access, SQL*plus, Unix, Cygwin Xterm.

Analyst/Brio Developer/Tester
Confidential,Schaumburg, IL August 2003 - August 2004
Clients: Confidential,
Responsibilities:

• Created Technical Specs based on Business Requirements.
• Developed Data Model, Queries, Reports and EIS according to Tech Specs.
• Created Unit Test Plan in order to validate the report format and the data.
• Scheduled and published documents.
• Created Meta Topics and Meta Topic Items to make Database Tables and Columns user-friendly.
• Developed complex reports by embedding SQL statement on Request items and Limits.
• Leaded three people- Business Analyst, Hyperion Developer and Tester in Brio team.

Environment: Brio Explorer 6.5, Oracle 9i, SQL*plus, Windows 2000/NT, Unix, Hyperion Designer 8.0, Oracle 8i, PL/SQL, JavaScript.

Brio SQR Developer/BusinessObjects Developer
Confidential,Iselin, New Jersey Feb 2002 – August 2003
Clients: Confidential,
Responsibilities:

• Updated Technical Design Documents (TDDs) for Brio and BusinessObjects reports based on the change in the data model.
• Modified SQR reports based on the change in the data model.
• Developed new SQR reports against the new model.
• Modified BusinessObjects reports based on the change in the universes mapped to the new data model.
• Developed new BusinessObjects reports against the new universes.
• Validated the data of modified new reports against that of old reports in production.
• Developed Data Models, Queries and Reports by using Brio Designer.
• Created Meta Topics and Meta Topic Items to make Database Tables and Columns user-friendly.
• Developed complex reports by embedding SQL statement on Request items and Limits.
• Tuned the queries by using hints on Database Columns on Request Line and validating the order of Limits.

Environment: Hyperion SQR Developer 8.0, Script Editor, BusinessObjects 5.1, Sybase, Rapid SQL, Hyperion SQR Server 8.0, Korn Shell Script, BrioQuery Designer 6.6, Oracle 8i, Win XP, Unix.

BusinessObjects Developer/Brio Developer
Confidential,Edison, New Jersey July 2000 – Feb 2002
Client: Confidential,
Responsibilities:

• Created BusinessObjects Data Providers and Reports in User Module by collecting and analyzing the users’ requirements.
• Participated in Designing, building and maintaining BusinessObjects Universes by using Designer.
• Scheduled and distributed reports through Broadcast Agent Server.
• Developed and Published reports on the web through Webintelligence.
• Involved in BusinessObjects administration in upgrading the tool, creating users’ accounts, granting/revoking users’ access, and also maintaining the security of objects.
• Supported the users with their BusinessObjects related problems.
• Created complex reports by linking data from multiple sources, and by using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Created Data Models, Queries, and Reports in Brio Designer by analyzing the users’ requirements.
• Scheduled and distributed jobs/reports through Broadcast Server.
• Supported the users with Brio and Database related problems.
• Developed complex reports by embedding SQL statement on Request items and Limits, and by integrating the data retrieved from Oracle to the Data from DB2.
• Created OLAP Queries and Reports against Hyperion Essbase.
• Assisted DBA in mapping new tables and columns in physical schema to logical by using Allstate’s homegrown product Metadata Control Application (MCA).
• Compared updated metadata files to old files in Unix and ran a validation report from that. Upon validation report was confirmed okay, those updated files were shipped out to data centers’ Unix boxes for productions by running script commands.

Environment: BusinessObjects 5.0, Webintelligence 2.6, Broadcast Agent Server, Oracle, SQL*plus, Win NT, Unix. BrioQuery Designer 5.5, Brio Broadcast Server, MS Excel, IBM DB2 UDB 7.0, Hyperion Essbase 7.0, Mainframe (MVS), Unix (Sun Solaris).

Assistant Accountant and Auditor
Confidential,Dhaka, Bangladesh June 1996 – April 1997
Responsibilities:

• Prepared and verified Financial Statements (Balance Sheet and P & L).
• Prepared Audit Reports.
• Generated Pay-slip and Payroll monthly.
• Prepared Bank Reconciliation statement.
• Assisted in preparing annual budget.
• Prepared cash flow statement.
• Participated in financial analysis.

Environment: MS Access, MS Excel, MS Word, Windows NT.

ACADEMIC PROJECTS:
Developed Student Registration, Employee Self Service, CD Library and Inventory
Control databases in Oracle.
Developed Real Estate, Payroll and Grant Track databases in Microsoft Access.

EDUCATION:
Master of Science in Information Systems
Bachelor of Business Administration

RELEVANT COURSES: Data Base Theory, Structured Systems Analysis and Design, Software Engineering with Java, Java Programming, Hardware and Data Communications, Project Management and Telecommunications.