PROFESSIONAL SUMMARY:

• 10.6 yrs of rich IT experience including proven track record in Hyperion Planning/essbase, Software Development Life Cycle including development, analysis, design, development, testing, integration, deployment & implementation.
• Extensive experience in Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Web Analysis, Smart view for Office, ESSCMD, MaxL, MDX and Essbase Excel Add - in.
• Hands on experience in Oracle Enterprise Management Architect (EPMA) technology and Oracle Financial Data Quality Management (FDQM) technology.
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes and calc scripts to facilitate effective business decision making.
• Key strength in optimization and tuning of Essbase cubes across Block Storage (BSO) and Aggregate Storage (ASO) Essbase Cubes.
• Proficient in dynamically building Dimensions, Attributes using Rules files and loading Fact data in Essbase applications by means of several build methods such as generation, level and parent-child s.
• Strong skills in using Java, J2EE, Struts, AJAX, JSP, EJBS, Oracle, SQL, PL/SQL.
• Expertise in developing applications using Java/J2EE technologies based on Struts Framework and MVC architecture.
• Expertise in developing web components that include Servlets and presentation layer using JSPs that can generate dynamic content based on custom tag libraries and worked on Cascading Style Sheets to display static data content.
• Expertise in developing applications using IBM RAD, WebSphere Application Developer (WSAD), and Jboss-4.0.2 with Eclipse and IntelliJ Idea.
• Extensively worked and implemented several design patterns such as MVC,
• Business Delegate, Session Façade, Service Locator, DAO, DTO, Singleton, Object Factory and Front Controller.
• Experience in working in a environment where parallel development efforts are in place using Release management tools Rational ClearCase and Rational ClearQuest and as well CVS, VSS.
• Extensively worked on performing unit test cases using Junit
• Expertise in database tier and developing database schemas that includes tables, triggers, stored procedures in oracle and DB2.
• Exposure to different business domains including Insurance, EProcurement,
• Banking and Manufacturing with diversified Technologies from client-server, web, B2B, B2C.
• INS21 Certified from AICPCU.
• Experience in Source code Management tools like Rational Clear Case, CVS, VSS and Clear Quest for bug management.
• Strong basics in Data Structures and OOP Concepts.
• Experience in Jakarta struts and other MVC architectures.
• Hands on working experience in UNIX, Linux environments deployment / monitoring and maintaining applications servers and database systems.
• Experience working in environment where Six Sigma compliance achieved.

TECHNICAL SKILLS:

OLAP, ETL and BI tools: Financial Data Quality Management (FDQM) Financial Reporting, Web AnalysisR eporting Tools: Spreadsheet Add-In, Smart viewStar Schema, Dimension and Fact tables

Modelling Tools: Logical and Physical Modeling.MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++

Programming Languages: Shell Script, Java, PL/SQL, C and C++Servlets, JSP, EJB, JDBC, JMS, Struts, JSFJ

2EE Technologies: Hibernate

Application Servers: IBM RAD, Web Sphere, Jboss and Web Logic

Framework: MVC, Struts

Databases: Oracle, DB2, MS SQL server and PostGre SQL.IBM RAD, WSAD, Eclipse, Intellij Idea

IDE s & Utilities: Builder, JUnitHTML, XML, XSL, XSLT, SAX/DOM, JSF

Web Dev. Technologies: AJAX

Scripting Languages: JavaScript, VBScript, ANT Scripts

Middleware: SOAP, JMS, SOA Architecture.

Operating Systems: Unix / Linux, WINDOWS 98/2000/NT/XP

Design/ Version control: UML, Rational Clear Case, CVS, VSS, SVN

Bug Tracking tools: Rational Clear Quest, FogBugz

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

Oracle Hyperion Architect

Responsibilities:

• Involved in software development life cycle (SDLC) of the application: Part ofrequirements gathering, developing the design, Code Development, detailed SubSystem Design.
• Replacing the Legacy system (Hyperion Application Link) using Oracle Data integrator and automated the process for periodic dynamic dimension building and data loading.
• Migrating application the Animal Health application of Abbott from Essbase 9.x version to Essbase 11.x version ( Oracle Enterprise Performance Management Architect environment)
• Migrating ACS, CMS applications of Abbott from Essbase 7.x, 9.x to latest versionsEssbase 11.x
• Create Business Intelligence Reporting and financial Reporting Solutions using Oracle Hyperion technologies.
• Automation of the Dimension building process on Enterprise PMA shared library, Automation of Validation activity, Automation of Deploy activity from Planning to Essbase using EPMABatch client and Interface tables.
• Creating batch process to automatically get info from EPMA services and Active Directory to list number of and types of licenses used by Hyperion users ( for Audit and licenses acquisition purpose )
• Automation of EPMA LCM backups with ability to recover application through disaster recovery process.
• Using Oracle Financial Data Quality management tool, Designing and implementation of the ETL process (Extraction from source, Transfer using the mappings and Load i.e. Export to Essbase environment), thus providing Auditing capabilities through FDQM tool of the data flow to the Oracle Hyperion business Intelligence Essbase system.
• Automation of the Daily jobs using Windows Batch and MAXL scripts.

Confidential, IL

J2EE Developer/ Production Support/Onsite

Responsibilities:

• Involved in software development life cycle (SDLC) of the application: Part ofrequirements gathering, developing the design, Code Development, detailed SubSystem Design.
• Created Functional Requirement documents, Detailed Design documents along with system flows, dependency and architectural diagrams.
• Development along with System tests, integration tests, regression tests and supportfor UAT tests the enhancements and fixes for the Wcard and PSC applications.
• Enhancement of current web services of the application.
• Enhancement of the in store Web application and Internet Web application using HTML, JavaScript, JSP for both WCARD and PSC applications of Walgreens.
• Implemented new batch jobs and maintenance of the current batch jobs using Korn shell and Shell programming and FTP.
• Creating Reports using PLSQL and Java and Adobe.
• Application EAR manufacturing, development activities through IBM RAD 7.0.0.8 and responsible for production code releases.
• Responsible for implementation of Web service integrations.
• Extensive experience on Oracle 10g SQL, PLSQL and exposure to TeraData SQL extractions from Java applications.
• Maintenance of parallel running iterations for both WCARD and PSC systems using Version Control system called CVS (Release Management).
• Monitored the error logs from production using Log4J and fixed the production issues.

Environment: IBM RAD 7.0.0.8, Java 1.5, Servlets, JSP, CVS, JUnit, Oracle 10g, SFTP, UNIX .sh and

Confidential, Cincinnati, OH

J2EE Developer/ Team Lead / Production Support.

Responsibilities:

• Involved in software development life cycle (SDLC) of the applications:Requirements gathering, Analysis, developing the design, Code Development, detailed Sub System Design.
• Holding responsibility of production servers and provided production support including maintenance activities.
• Acted as offshore coordinator to the team in India for outsourcing some of the development work.
• Involved in Integration with in-house system called Loan Information Service to get data from legacy systems.
• Responsible for integrations with Net Spend Cards, Check Scanning Device integrations.
• Responsible in integrations with third party vendors like Veritec, Teletrack, Certegy, Chexar, Valid Systems as a part of risk management.
• Responsible for implementation of Web service integrations.
• Implemented J2EE design patterns like Singleton, Data Access Object (DAO) andBusiness Delegate and Service Locator.
• Extensive experience on Oracle 10g SQL and PLSQL.
• Maintenance of parallel running iterations of the project like Stars 4.0, Stars 4.1 using Version Control system called CVS (Release Management).
• As a onsite Developer leading a team at offshore, took responsibilities like designating the release versions and creating release streams for development teamand eventually managing the QA, UAT, Reporting and production versions of code for deployment and code revert activities.
• Hibernate was used as persistence layer to connect to the database.
• Monitored the error logs using Log4J and fixed the problems.
• Application hosting in Jboss-4.0.2 application server in Linux environment. This includes developing required JSPs, EJBs and several helper classes needed for the application.
• Implementation of new modules which are provide rich Internet application look and feel with JSF, IceFace.

Environment: Jboss-4.0.2, Java 1.5, Servlets, EJB, JSP,JSF, Hibernate, Struts, CVS, JUnit, Oracle 10g, ScriptX, SFTP, ANT, Toad Expert, Linux Cron Jobs, Putty and WINSCP.

Confidential, Schaumburg, IL

J2EE Developer

Responsibilities:

• Involved in developing the functional specs using UML in Rational Rose.
• Designed and implemented the customization of risk navigator as well as auto audit using Struts framework
• Involved in developing java classes from Xml files Using XMLBeans and used them along with Hibernate for storing information and getting information from Database.
• Designed and implemented data model using Hibernate as the persistence layer that uses DB2 database.
• Involved in developing J2EE framework APIs that are used in the process of workflow and customization modules
• Implemented several design patterns such as Singleton to access DAO, Business Delegate and Session Façade.
• Implemented Service Locator to abstract all JNDI usage and Transfer objects as data carriers.
• Involved in designing and developing of presentation layer that is capable of handling dynamic data content using custom tags.
• Implemented database stored procedures in DB2 database.
• Implemented web services and were called using JAX-RPC SOAP protocol, WSDL descriptor file and Universal Description, Discovery and Integration Registry (UDDI).
• For Release Management Used ClearCase for version and source control and ClearQuest for tracking the project changes.
• Monitored the error logs using Log4J and fixed the problems.
• Developed and Deployed EJBs and other Components in the Websphere Application Server
• Developed the building components of application such as JSPs, EJBs using Websphere Studio Application Developer (WSAD)
• Performed unit testing for modules using JUnit.
• Provided source code documentation using JavaDoc for future s

Environment: Websphere 5.0, Java 1.4, Servlets, EJB, JSP, DB2, Web Services, Hibernate, Struts, Rational ClearCase and ClearQuest, JUnit, WSAD, ANT and Citrix and VPN environment.

Confidential, NYC, NY

Team Lead /J2ee Developer

Responsibilities:

• My responsibility was to lead a team of four members (Module Lead). Monitoring the work, delivering the module on time, and meeting the dead lines.
• As a module lead, was responsible for Understanding the SRS and writing software requirements specifications and use case document
• Involved in System design and developed STRUTS and Session Beans.
• Monitoring the team by giving solutions whenever needed.
• Deploying and maintaining the application in the Linux server.
• Writing EJB’s and coding in Java with Oracle.
• Involved in data base design and normalization of tables.
• Writing Stored Procedures, Functions, Triggers and Complex queries.
• Meeting the milestones by delivering the module on time.

Environment: Jboss 4.0, Java 1.4, Servlets, EJB, JSP, Postgre SQL, Struts, Java Mail, Eclipse, CVS, ANT and Unix platform.

Confidential

Sr Software Engineer / Developer

Responsibilities:

• My responsibility was to lead a team of four members (Module Lead). Monitoring the work, delivering the module on time, and meeting the deadlines.
• As a module lead, was responsible for Understanding the SRS and writing software requirements specifications and use case document
• Involved in System design and developed STRUTS and Session Beans.
• Monitoring the team by giving solutions whenever needed.
• Writing EJB’s and coding in Java with Oracle.
• Involved in data base design and normalization of tables.
• Writing Stored Procedures, Functions, Triggers and Complex queries.
• Meeting the milestones by delivering the module on time.

Environment: Jboss 4.0, Java 1.4, Servlets, EJB, JSP, Oracle 9, Struts, Java Mail, IntelliJ Idea, CVS, VSS, ANT and Unix platform.

Confidential

Software Engineer / Developer

Responsibilities:

• Developed JSP pages, action classes and DAO files for the relative modules.
• Application Level Data base Programming-using JDBC/SQL, PLSQL.
• Source Code Management (WinCVS)
• Supporting and participating in product demos to clients for product promotion.

Environment: Jboss 4.0, Java 1.4, Servlets, EJB, JSP, Oracle 9, Struts, Java Mail, IntelliJ Idea, CVS, VSS, ANT and Unix platform.

Confidential, Spartanburg, SC

Programmer Analyst / PL/SQL DeveloperSQL performance Tuning

Responsibilities:

• Developing PL/SQL procedures for populating the data into the report tables.
• Performed Unit and Integration testing on the PLSQL procedures, Triggers and Packages.
• Performed ETL processing using SQL Loader by extracting information from Flat files to Oracle database.
• Prepared Functional Specification documents for the requirements and get sign off by clients to start creating Oracle procedures and functions.
• Did SQL performance tuning using Explain Plans and statistics.
• Did analysis of the reports that were developed by the PLSQL procedures with the Seibel reports that were generated at the client site using and pin pointing the areas where the discrepancy occurs and what changes need to be done at the functional specifications level.
• Source Code Management (VSS).

Environment: Oracle 9, SQL Loader, Toad Expert, VSS and Seibel Reporting tool.