SUMMARY

• More than 11 years of software & system development experience in Information Technology.
• OBIEE Design and Architecture, Administration, Support, Maintenance, Troubleshooting and Development expertise on 10.x applications.
• Hyperion System 9 and System 8 report development, dashboards based on business requirements following SDLC and providing Hyperion Server Administration
• Considerable experience in OLAP application development utilizing the Essbase Multi-Dimensional database that includes Essbase Cube Analysis, Design and Maintenance, Database Backups, Performance Tuning and Optimization.
• Tier III Production support utilizing Oracle Applications.
• Extensive experience with collecting, organizing, analyzing data and distribute it throughout the enterprise using Hyperion Intelligence tools.
• Experience in Data Warehousing, specifically with experience in ETL Development using SQL, PL/SQL and Unix shell scripts, Testing the data and building and/or enhancing an overall data warehousing production environment.
• IT professional with technical experience in different n-tier client/server systems, database management, software development, support, maintenance, trouble shooting, configuration and major project implementation.
• Data processing, statistical analysis and results reporting using SQL, Shell/AWK programming, Brio/Hyperion, and all Microsoft Office Tools across Unix and/or Window multi-platforms.
• Excellent in interpersonal communication and writing skills and ability to work well in team or as an individual.
• Proficient in Oracle RDBMS, Unix, Awk, SQL, PL/SQL programming, web design and C/C++.

TECHNICAL SKILLS

SQL, PL/SQL, Awk, Korn Shell Scripts, CGI/Perl Scripts, Visual Basic, C, C++, Java, HTML

Platforms

Solaris, Unix/Linux, Windows-2000/NT/XP/98/95, MS SQL Server, MS-DOS

Databases

Oracle 10g/9i/8i/7i, Teradata, My SQL, SQL Server, MS Access

Networks

Layers and protocols of OSI, ATM, BISDN, TCP/IP, HTTP, SS7, GSM, CDMA

Tools

OBIEE/Siebel Analytics 10.x/7.7, Weblogic 10.3, BI Publisher, Hyperion System 9, Brio/Hyperion Designer 8.3/8.5, Brio/Hyperion Explorer, Brio/Hyperion Dashboard Builder 8.3, Brio/Hyperion Server, Hyperion Essbase, AllFusion Erwin Data Modeler, Toad 8.6.1, Quickbooks Pro 2008, SQL Navigator, Oracle Express, Oracle Enterprise Manager, Oracle Express, OWB Audit Viewer, Oracle Warehouse Builder, Discoverer, Oracle Portal, Oracle Workflow Builder, SQR, MQC Ticketing, AR System, Niku, Visual Studio, MS-Visio, MS-Project, Adobe Photoshop, Adobe Acrobat, Exceed

Applications

MS Access, MS Office, MS Outlook, MS FrontPage, OrCAD, AMSCAD/PCB Design

Professional Experience

11/00 - Present

Client: Confidential, (2009-2010)
BI Architect/Developer

Working on Investment Banking division that assists clients in achieving their objectives through mergers and acquisitions, debt, equity and other capital rising. The department, and its Global marketing solutions group is a leader in innovating new and creative ideas for clients which help them access the best and most efficient capital sources. Reporting framework is a transformational activity under the Financial Systems Initiative (FSI) and is being delivered by the Information Delivery work stream. Objective is to provide the appropriate tools, system support, standardization and improved service to the financial community for OBIEE PC Data Warehouse related projects.

• Extensive experience with real time installation and configuration of OBIEE on DEV/QA/UAT/PROD/DR environments
• Strong database development and BI modeling capabilities; experience in architecting complete data models combining multiple transaction systems ETL tools and relational and multi dimensional data stores for star, snow flake schema designs and reporting.
• Designed security matrix, configured SSO architecture and maintained user security and permission setup with optimum system uptime and performance for 1000+ users' environment.
• Development and support of usage Tracking reports, iBots support, cache seeding, cache purging and RPD merge methods
• Setup multi user development environment for parallel development as well as multiple instance on single servers to support several parallel project developments.
• Performed multiple roles spanning the full spectrum of business analysis, SDLC, development, implementation, support, infrastructure set up and demonstrated leadership abilities.
• Supported and maintained release activities from development to UAT and PROD and DR environments.
• Expertise with metadata (RPD) and dashboard design including hierarchies, foreign and complex joins, initialization blocks, presentation/repository session variables.
• Administration, deployment, support and troubleshooing with OC4J and Weblogic web servers.
• Environment: OBIEE 10.1.3.4.x, SQL, PL/SQL, Linux K Shell/C Shell, Oracle 10g/11g, Oracle WebLogic 10.3

Client: Confidential, (2008)
BI Architect

• Created complex dashboards using Hyperion Portal/Designer and thin client 8.5 and System 9 workspace.
• Worked on several Special Programming Requests that involved building complex EIS panels and OLAP reports, charts and pivots. Used dynamic limits and provided user friendly dashboards to business users.
• Involved in data analysis while reviewing business requirements and generated complex queries
• Involved in tier 3 production support for worldwide user base supporting system 8 and 9 including BI server maintenance and support involved in change requests for report developments as well as providing updates on existing reports.
• Involved in defining BI strategies and provided BI related architectural solutions and performance tuning. Including report related issues, was also involved in MEC and QEC support activities.
• Environment: Oracle's Hyperion Workspace 9.3.1, Hyperion Intelligence Designer 8.5/8.3.2, Hyperion Intelligence Dashboard Builder 8.3.2.4, Hyperion Portal, Hyperion Server Administration, Hyperion Architect, Oracle 10g, SQL, Toad 8.6.1

OBIEE/Siebel Analytics 7.7 support

• Used the Siebel Analytics Administration tool to develop and enhance meta-data and repository configuration
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Worked extensively with Physical Layer, Business Layer & Presentation Layer implementation & modifications.
• Created numerous executive level reports and dashboards providing insight into the insurance and financial information.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports (Drilldown, Aggregation) and Ad-hoc queries to meet client requirements using Siebel Answers.
• Built business model and established relationships & foreign keys (Physical & Logical) between tables.
• Generated various Analytical reports like Formulary Report and Direct Sales Reports (pivots, charts, tabular) using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Created proactive agents iBots for reports scheduling and interactive dashboards to alert the marketing team of business changes.
• Managed day-to-day rpd, scheduler and iBots and security privileges maintaining users and groups.
• Environment: Oracle 10g/9i, Siebel Analytics 7.7, SQL, PL/SQL, Toad 8.6.1

Client: Confidential, Mount Laurel, NJ Confidential(2006-2008)
BI Architect (Predatory Lending/Fraud Project)

• Production Support of Existing Hyperion reports
• Research existing/future business requirements for Hyperion reports
• Meetings with Business Support Teams to understand business requirements and provide reporting plans for Operational Reports/Dashboards
• Meetings with Data Architecture Team and Administrators to discuss conceptual, Logical and Physical data model changes and creation of new dimensions or retrieval of new elements in existing dimensions for reporting requirements.
• ODBC System Data Source setup for Oracle, Sybase, SQL Server for OCEs and Templates set up for business users.
• Hyperion Portal Administration, Report Development, Schedule reports, Email Reports and Export reports to external network for business users.
• Trouble Shoot issues with Hyperion Portal, reporting and jobs related errors, auditing and perform usage tracking and administering Service Configurator and Manage Calendars
• Designing, maintaining and building conceptual, physical and logical database models.
• Development of Hyperion dashboards for Management users. Publish them on Portal, test and maintain.
• Create Operational and Analytical queries / reports / views / dashboards etc for business users based on Ad hoc requirements
• Create logical data models based on data availability and reporting requirements, primary keys, foreign keys.
• Working on Star Team application that enables both local and remote team collaboration through the use of tightly integrated components critical to efficient product development
• Creating DB Change Requests, Configure version control options. Creating Tasks, Branch folders and files by creating separate project views. Managing Projects, Views, Folders, Files, Change Requests, Tasks, Topics, Audit Log.
• Keeping track of HDS and SRS tickets and provide solutions.

EssBase Implementation and Support Project

• Involved in design and development of numerous EssBase applications with excellent balance of dense and sparse dimensions, arrange in an hourglass fashion, starting with Accounts, Time and then largest dense to the largest sparse at the bottom of outline.
• Besides the optimizing block size also configured Data Cache, Data File Cache and Index Cache to achieve high degree of performance gain.
• Developed load rules using Parent Child, Level and Generation references.
• Loaded data from flat files and numerous relational database systems using SQL and ODBC for data load performance gains. Optimized data load rules by sorting and arranging sparse dimension columns.
• Analyzed the raw data and converted it into valuable business information by design & development of appropriate cubes and generated reports.
• Involved in installation and upgrade of Hyperion EssBase and EssBase integration services.
• Involved in writing custom Essbase Calculation Scripts, automation of Essbase cubes using MaxL, ESSCMD and MDX.
• Developed Batch scripts and Rules files to dynamically upload dimensions and data to Essbase cubes. Also developed rules for multi-dimensional databases.
• Responsible for security groups and access for the users in Hyperion reports.
• Migrated reports from the QA environment to Production environment.
• Extensively involved in regular changing of the outlines for cubes.
• Developed various excel templates for user interface in EssBase database.
• Extensively involved in gathering and defining requirements, functional specification documentation and testing strategies.
• Involved in all parts of multidimensional database design process after Essbase Analytic Services and an application creation including analyzing business needs, database outline draft, checking system requirements, loading test data into the database, define calculations, define reports and verifying with users.
• Involved in several decisions for database partitioning for Replicated, Transparent and Linked partitions as well as suggesting a need not to create a partition as well as troubleshooting and maintenance of partitions.
• Environment: Oracle 9i, Hyperion Essbase 9.3.1, Essbase Analytic Services 9.3, Essbase Excel-Add-in, Essbase Visual Explorer, Oracle's Hyperion Workspace 9.3.1, Hyperion Intelligence Designer 8.3.2, Hyperion Intelligence Dashboard Builder 8.3.2.4, Hyperion Portal, Hyperion Server Administration, Hyperion Architect, SQL, SQL+, PL/SQL, Toad 8.6.1, Informatica Designer/Repository Manager/Workflow Manager 7.1, AllFusion Erwin Data Modeler 7.1.0.1075

Client: Confidential, Warren, NJ through Confidential, (2005-2006)
BI Architect
GDW/GRS - Global Data Warehouse/Global Reporting System

• Designing, maintaining and building conceptual, physical and logical database models.
• Study complex business requirements and translate into solutions concept.
• Review and signoffs on all High Level Design/Low Level Design for the Global Data Warehouse, Staging, Global Data Marts and Hyperion Metadata Repository Structure and Global Reporting System using Hyperion Performance Suite.
• Reviews and approve current Infrastructure, Application Architecture, Technical Architecture, Data Architecture, Desktop Architecture, Security Architecture and Security Plan.
• Provide ongoing maintenance and operation support from System Integration Testing to Signoff.
• Develop Migration Plans from Development to Test to Production.
• Define System Specification Documents, perform changes and follow guidelines for company's change control process.
• Interact with high level business users and with other application partners and gathering and understanding business requirements.
• Development of Hyperion dashboards for Management users. Publish them on Portal, test and maintain.
• Development of complex EIS Dashboards with dynamic limits.
• Hyperion Portal Administration and Hyperion reports Performance tuning.
• Create Operational and Analytical queries / reports / views / dashboards / etc for business users based on their Ad hoc requirements.
• Environment: Oracle 9i, Hyperion Intelligence Designer 8.3.2, Hyperion Intelligence Dashboard Builder 8.3.2.4, Hyperion Portal, Hyperion Server Administration, Hyperion Architect, SQL, SQL+, PL/SQL, Toad 8.6.1, Informatica, UNIX (Sun Solaris), K Shell

Client: Confidential, Rochester, NY through Confidential, (2005)
Principal Consultant - Team Lead
FIX - Financial Information Confidential

• Function as SME for Financial applications suite.
• Run jobs during 15 day Financial & Operational close and recommend permanent fix for recurring issues.
• Provide support for Oracle Warehouse Builder, Oracle forms and reports, OFA and other ancillary Oracle product sets.
• Trouble-shoot issues with the system, provide appropriate production fixes.
• Monitor job executions, capture and document statistics and issues. Update production support documentation.
• Participate in disaster recovery drills.
• Participate as team member for deploying builds into the QC environment and releases into the production environment.
• Act as Team Lead for junior resources.
• Keep track and enter effort into time tracking and ticketing systems.
• Environment: Oracle 9i, OWB, Oracle Forms and Reports, OFA, Oracle Express, SQL, PL/SQL, TSQL, SQL+, Netscape, Apache, Microsoft Web Servers, OS UNIX, OS NT, Unix Shell Scripting, Database Administration

Client: Confidential, Brooklyn, NY through Confidential, (2004-2005)
Senior Database Developer

Confidential, is the core project for Confidential,. To reduce high cost of operations and maintenance, AMEX plans centralized repository for all AMEX business information such as AMEX trades and quotes, Master data files, Billing Information, Competitive Research data, Market and economic research data. Involved in all parts of life cycle of a project like gathering Business Requirements Specifications - BRS, documenting Functional Requirement Specifications - FRS, documenting Design Specifications - DS, Build Code for ETLs, Release, Testing, Integration testing and regression testing.

Responsibilities:
ETL Development

• Review and analyze data model in MS Access.
• Detailed Documentation on FRS and DS for ETL development for both Dimension tables and Fact tables.
• Define External Tables, Views, Primary Keys, Partitions, Alteration to dimension as well as Fact tables, and Sequences, ETL processes for interim tables as well as target tables. ETL development for Slowly Changing Dimensions.
• Wrote enormous ETL (Extraction, Transformation and Load) functions to retrieve data from the Flat files which are FTP'd from the Mainframe as well as other sources to UNIX or UNIX to UNIX and perform various types of transformations on the data and FTP that data to UNIX servers where it gets loaded into Oracle 9i tables in ADW environment.
• Specify and modify dependency for all Dimension and Fact tables and update system tables for ETL processes.
• XML source file usage to load XML data to oracle. Provide mapping. Use Java parser shell scripts to parse XML files to text files and develop ETLs.

Testing

• Coordinate the collection, extraction, metadata, data marts and data warehouse development.
• Gather, manage, model and detail system requirements. Developed test plans, test scenarios and test scripts for manual as well as automated testing to ensure proper business compliance.
• Creation of Data Test Files for Primary Dimension Value and Slowly Changing Dimension values.
• Running the ETL Process and reporting Errors to Development as well as Management Team using AR (Action Request) System that helps automating and managing processes in continuously changing business needs.
• AR system usage for creating DR (Defect Report) requests as per business rules, modify requests, generate reports, set options and customize form views and field defaults
• Unit testing and Integration testing as per the business needs.

Reports

• Hyperion Performance Suite - Designing dashboards and developing reports using Hyperion Intelligence Client, Hyperion Intelligence Designer.
• Strategically discussed and defined various aspects of ADW to deploy Hyperion Performance Suite for. Architecture, Licensing, Application Support, System Support, Client Connections, Data Storage Requirements, Operations, Monitoring, Scheduling, Software Components, Data Backup and Recovery, System Management, Hyperion Server Administration, Hyperion Resource Monitoring, Auditing, Hyperion Server Standards, Hyperion Folder Structure, Hyperion Security Methods, Hyperion Versioning, Data Model and Repository, Standard Files, Metadata Integration, Limitations, Release Management.
• Hyperion Performance Suite - Server Administration

Client: Confidential, Florham Park, NJ Through Confidential, (2000-2004)
Systems Engineer/Programmer

• Analysis of business requirements, design and Implementation of new programs/modules based on the users' special business needs.
• Worked on Universal List project. Main work is on data processing of telephone numbers' files, korn shell programming and create reports according to client's requirements using our own HSL (High speed Lookup) database and HSL tools.
• Extensively involved in writing Korn shell scripts, AWK, CGI/Perl scripts for the web-based forms and business reports, Reports, SQL-PL/SQL for users on Solaris platform based on their changing requirements.
• Korn shell programming for weekly TN processing and automatic archive log backup files in tapes.
• Worked with different internal and external parties in getting/understanding client requests, making project suggestions, communicating data-based results and transferring data in/out among many vendors/parties across multi-platforms.
• Environment: UNIX (Sun Solaris), Korn shell, Awk, Oracle 8i, SQL, PL/SQL, CGI/Perl, Toad, Hyperion Intelligence, C/C++, OOD

ULIST Web

• Developing and maintaining the ULIST project intranet website with all projects' details, reports, online queries using HTML, Java Scripts, CGI/Perl Scripts.
• Adobe Photoshop, Adobe Imaging, MS Visio for graphic designing
• Published UNIX text files on the web which allows graphical user interface for client to run a query and develop excel reports and pivot tables using CGI/Perl Scripts and HTML.
• Environment: UNIX, Windows 98/2000, HTML, Java Scripts, CGI/Perl, Adobe Photoshop, Adobe Imaging, MS Visio

Oracle - Data Warehousing and Business Intelligence, Application Server

• Worked on development and implementation of Oracle 9iDS tools such as Discoverer for End Users, Warehouse Builder, Oracle Portal, and Oracle Workflow Builder.
• Developed reports on Oracle Discoverer which provides intuitive ad-hoc query, reporting, analysis and Web-publishing feature that empowers business users at all levels of the organization to gain immediate access to information from Data Marts, Data Warehouses, online transaction processing systems and oracle E-business suite.
• Complete in depth study on Oracle Warehouse Builder that provides an easy to use, graphical environment to rapidly design, deploy, and manage business intelligence systems.
• Working on browser based Oracle Portal that enables end users & web developers build and publish data driven websites.
• Worked on workflow management system that supports business process definition and automation.
• Environment: Oracle 9i/8i, Oracle Discoverer, Oracle Warehouse Builder, Oracle Portal

Pre-Mover Project

• A business process developed to identify the trend of the residential customers planning to move and thereby leading to data feeds for marketing department.
• Tasks involved daily loading of millions of call detail data using SQL Loader in multiples tables.
• Wrote stored procedures and functions, packaged procedures, triggers, embedded PL/SQL blocks for day-to-day processing to load and to do complex updates of call detail information.
• Regular maintenance and performance tuning of the database.
• Regularly created reports through shell scripts and Hyperion tool and used cron jobs to automate these processes.
• Statistical analysis of data gathered providing data feeds and scrubbing of the database and provided excel reports.
• Environment: UNIX, Oracle 8i, SQL Plus, SQL Loader, PL/SQL, Korn shell, Brio/Hyperion Designer, ES Designer

Smart Vendors

• Worked on querying, report building and developing Executive Information Systems and dashboards with fully automated reports for end users for easy access to information from database using Hyperion Designer, ES Designer with backend Java scripts.
• Further customization, additions and enhancements using geographical view for state level data.
• Worked with different databases to develop dynamic digital dashboards that provide real time, fast, visual, intuitive information and scheduled access to key performance indicators, operational analysis and strategic management reports in an easy-to-use web format that increased productivity.
• Took advantage of the ad hoc power of dashboards to dynamically generate maps giving users the ability to discover hidden spatial relationships and analyze information in powerful new ways.
• Delivered business critical information using Hyperion Intelligence drove an interactive understanding of business opportunities and trends, empowering clients to make optimal decisions.
• Environment: Brio/Hyperion Intelligence, ES Designer, Windows 2000/NT, Oracle 8i, Teradata, Java Scripts and MS Office

Confidential, Hoboken, NJ

1/99 - 10/00

Teaching Assistant/Research Assistant

• Instructed/assisted students in Data Structures and Algorithms, Operating Systems, OOD Concepts & Programming in C++, and Pure & Applied Mathematics.
• Provided technical assistance for programming work and solving problems to undergraduate students.

Confidential, India

4/98 - 12/98

Programmer/Analyst
Billing System

• Designed and developed E/R diagrams, normalization for "Inventory System" with RDBMS, SQL and PL/SQL.
• Wrote stored procedures and database triggers using PL/SQL based on user applications for business management.
• On the basis of Entity Relation model, the efficient use of primary and foreign key created a real effective database according to the company's specifications.

Employees-Customers Relational Database System

• Designed and developed an "Employee-Customers Relational Database System" for a computer hardware supplier company using translation of Entity-Relationship graphs into relations; storage usage data using SQL *Plus, PL/SQL (Platform - Oracle 8.0); Relational Algebra, Relational Calculus, Equivalence among relational query languages, Integrity constraints and relational database design (normal forms) and testing using queries.

Confidential, India

8/97 - 2/98

Programmer/Analyst

• Successfully implemented a project for MSG foundation utilizing various life cycles of software engineering: Requirements Analysis (Visual Basic - Front-end tool), Specification, Object Oriented Analysis, Detailed Design, Implementation of (MS Access Database with platform Java), System Testing, Integration, Maintenance and Cost Estimation.

Education

• Master of Science, Computer Engineering, Stevens Institute of Technology
• Bachelor of Engineering, Instrumentation & Control
• Courses in Project Management Fundamentals, Hyperion Essbase, OBIEE/Siebel Analytics 7.7, Oracle