SUMMARY 

I am presently living and working  for nearly more than 12 years. Before moving to, I was working in United Overseas Bank,. I have more than 12 TWELVE plus years of IT Industry experience. I am specialized in Data Warehousing, Business Intelligence, ETL and Reporting Business Intelligence Reporting Suites and Analytics. I have worked with various multi - national companies like  Bank,  Technologies, various domains like Software,  Financial Services, Institutional Investors and Telecom. I have been extensively involved in all phases of the software projects from Business Requirement Definition, Study, Analysis, Design, Coding, Testing, Integration, Implementation and Documentation of various IT Projects and Systems. I have good oral, written and interpersonal skills. I have higher standard of ethics and values.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/2008 R3, UNIX, Sun Solaris, AIX v5, AS/400, ES9000 and MVS

Languages: C, Java, SQR, COBOL, CICS, HTML, PL/SQL, Transact-SQL, and JavaScript,ERP Peoplesoft, SAP,Middle-Ware Hyperion EPM v11.1.1.4, Interactive Reporting v11, OBIEE v11g, BI Publisher, BI Answer, DAC, Hyperion Planning v9.3, v11, SmartView 11, EPMA, Add-In, HFM, ODI, Web Analysis, Foundation Service, SAS (Statistical Analysis Tool),Databases DB2, Oracle, Essbase v7.2, v9.3, v11, Sybase, MS-Access, IMS DB/DC and MS SQL Server,Database

Tools/Editors: TSO/ISPF, SQLPlus, QMF, SQLNavigator, DSEDIT, TOAD, DBArtisan,ETL Tools DataStage v8, Informatica Power Center v5, Microsoft Analytical Service (OLAP), MS DTS Packages, SSIS packages.,Products,

Tools & Technologies: Netscape IPLANET, Apache Web Server 2.3, JRUN 2.3.3, ORBIXWEB, Webgain TopLink, PVCS, Brio Enterprise Server, EIS, Pivot, OLAP Query, Chart, Reports,Intelligence client, SQR,, JCL, Unix Shell,Scripts, Windows Scripts, Microsoft Office,Methodologies SDLC, OOAD, SOA, RDBMS, DW, BI, ETL, OLTP and OLAP,

Design Tools: Rational Rose 2000, Visio, Erwin v7, PowerPoint.,Development Tools VisualCafe, Quest Central 5.0, Websphere Application Developer Studio 5.1.2,

Testing Tools: Silver Run, QA Run,Connectivity JDBC/ODBC, Open Client, SQLNet, TCPP

PROFESSIONAL EXPERIENCES:

Confidential, Philadelphia 

Architect and Designer

• Provided  to the Users, Production Support groups.
• Data Modeled and Designed ETL process using  Data StageClient V8.7 to load the Pilot Partner Programs files into Oracle data warehouse tables.
• Involved in the Design, Development and Enhancements of Dashboards and Reports using Oracle  Interactive Reporting v11.1.1.4
• Installed and Configured Hyperion Oracle 11g of Production Server.
• Deployed and Tested Clients, Servers, Users, Groups, Reports, Jobs and Schedules.
•  Reports, Jobs,  Active Directory Groups and other artifacts to the new Oracle11g from Hyperion v9.
• Administrated and Maintained Hyperion v11 Users, Groups, Roles and Scheduled Jobs.
• Prepared User-Level Documentations and End User Guides.

Environment: ETL IBM DataStage v8 (Director, Client), Hyperion Interactive Reporting v8.3, v9.3, v11.1.1.4, Windows 2008 R2, HFM (GL, SL), Tomcat v5, Oracle EPM v11g, MS SQL Server, Essbase v9.3, Smart-View and Oracle database 11, IIS Web server, Citrix, EPMA v9.3

 Senior Oracle Hyperion 

• Architected, Designed and Developed Data Processes, Reports, and Dashboards.
• Developed Proof-of-Concepts and provided Power-Point presentations using Smartcuts with parameters.
• Extracted data Rating, Contract Information and Customer Information in DB2 IXF format from  Source System and ftp the files to Bank
• Helped to the automation of these processes using ETL tool DI from Business Objects.
• Did Analysis of data and created financial reports.
• Publishing, Distribution and Administration of  Reports in theServer

Environment: UNIX (IBM Aix), MVS, DB2 v7.5, v8.2, Oracle Hyperion Performance Suite v8.3.1, v6.5, Business Object v11 (BO), IW (Information Warehouse), Crystal Reports v7, MIW (Market Information Warehouse), WFE (Web Front End), CA (Credit Analyst Tool), JavaScript, QMF, HTML, and SQL

Confidential, Eden Prairie, MN

 e-Billing & Dashboards Development

• Installed Configured, Administrated and Maintained the Enterprise Servers v8.2 and SQR Server Development environments.
• Analyzed Business User’s requirements Documentation.
• Designed, developed and deployed dashboard 
• Created Stored Procedures and Processes in Postscript Database.
• Developed Dashboards, Billing Reports for data analysis.
• Did data analysis, reported the findings and suggested solutions to the Business Users.

Environment: Windows 2003 Server, IIS Web Server, PostScript, Oracle 10g, Hyperion Intelligence Explorer, Hyperion Performance Suite v8.1, v8.2, v6.5, Essbase v7.2, JavaScript, HTML, SQL

Time Tracking System

• I gathered, translated business & data requirements from business users into Reports.
• Coordinated and facilitated meetings with business users, written functional specifications, design specifications and unit test plans.
• Designed User Interfaces with frond-end-analysis components and controls.
• Designed and developed dashboards, reports using Brio Designer and coded with Brio scripts API, JavaScript’s and Transact-SQLs.
• Ensured Best Practices were followed.

Environment: AIX, Windows NT, ODBC, Sybase v12, Transact-SQL, Sybase dsedit, BrioQuery Designer v6.2, Brio Enterprise Server 6.2, 6.5, Transact-SQL, ETL Informatica Power Center v5

 Loan Operations System

• This Project was to convert all reports running under mainframe using  Tool 
• I was able to quickly understand the tool, terms and methodology of generating reports. Converting them exactly into Brio based reports.
• I was involved in the installation and configuration of  Server on Windows NT.
• SQL*Net is used for database connectivity.
• Created the required .oce files and ran queries from various data sources.
• I converted around 50 reports. It includes both aggregated and daily computational reports.
• Developed well-formatted and structured reports.

Environment: Windows NT, IIS, SQL Net, Oracle, Brio Query Designer v6.2, SQL Navigator, Brio Enterprise Server