SUMMARY:

• About 15 years of vast IT experience.
• Worked on technologies from several vendors like Microsoft, Oracle & Open source.
• Worked on designing & developing solutions in various architectures like Client Server, web based & 3 - tier architectures.
• Worked in OLTP, OLAP and ETL (DW/BI/EPM) systems.
• Worked on various platforms like Windows/Linux.
• Worked in development projects as well as 24x7 Production support projects.

TECHNICAL SKILLS:

Software skills: OLAP Oracle Hyperion v9/v11 (Essbase, Planning, FDM, HFM) OOAD UML with Rational Rose DBMS Oracle, PL/SQL, Unix Shell Scripts, Oracle Administration, Replication, SQL Server 2000, MySQL Administration Front End VB.Net, C#, ASP.Net, VB 6.0 Platforms Linux/Unix/Solaris, Windows Other tools Bugzilla, Mentis for bug reporting, SQL Developer/TOAD, Remedy, Citrix Reporting Tools Hyperion Financial Reporting, OBIEE ETL Oracle Data Integrator (ODI), DataStage 8.1

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Working as onshore lead supporting over 30 essbase ASO/BSO and Planning applications.2. Leading a team of 5 offshore resources
• Tech lead for new application development
• Tech Lead for Hyperion upgrade.
• Work on enhancing applications and fixing bugs/errors
• Do the monthly closing tasks.
• Interact with Halliburton and Confidential management

Confidential

Responsibilities:

• Working as Level 3 developer2. Triage and resolve tickets coming to Level 3 within SLAs, working with end users and Level 2 teams and suggesting solutions/code fixes
• Developing Essbase scripts and database modification scripts (dbmods) as per Confidential standards for modifying production data
• Participating in daily, weekly status calls with Confidential and Confidential management.
• PlatformDatastage 7.5, 8.1, UNIX, Oracle, iWay Data Integrator, Mainframe, Autosys, Oracle, SQL Server, DB2

Confidential

Responsibilities:

• Making sure all applications are up and running at all times.
• Resolving failures within SLAs, working with end users and upstream teams in resolving failures
• Working with multiple teams, leading them towards resolution of business critical issues.
• Doing periodic maintenance activities
• Participating in daily, weekly status calls with Citizens as well as Confidential management.
• Managing team, supervising them, managing their schedules/shifts, doing their appraisals, keeping them motivated etc.

Confidential

Responsibilities:

• Resolving user tickets/requests.
• User provisioning 3. Running jobs on demand, fixing job failures 4. Patching
• Responding to user queries 6. Doing new code migrations (Business rules, web forms, calc scripts) 7. Metadata migrations 8. Importing/exporting security 9. Creating new applications 10. Bouncing services 11. Doing shakeouts 12. Raising SR with vendors (Oracle) for bug fixes etc.

Project Exelon Production Support

Confidential

Responsibilities:

• Do the daily scheduled activities like running of Mainframe schedules, monitoring them and ensuring that they complete successfully. Troubleshoot and resolve the failures, if any and under SLAs.2. Work on enhancing the functionality of existing applications as per business specifications and as per Exelon process and SOX compliance and SLAs. The work involves coding new unix functionality, modifying maxls, develop new Load rules, new calc scripts, new JCL jobs, modifying existing web forms and Business rules as per user requirements etc.
• Create solutions/proposals as per need to enhance the existing applications. Work with business users to understand/finalize requirements.
• Interact with offshore resources and coordinate support activities with them and help them in their activities work.

Confidential

Responsibilities:

• Sales Enablement - Worked on RFPs, capability presentation decks, draft contract terms and conditions etc.SME Services - Work as Subject matter expert on Essbase and HFM and provide support to other projects.
• Essbase Asset Development - Worked on various assets like Hyperion Essbase bootcamp ppt, Essbase trouble shooting guide, Hyperion Financial Management ppts, HFM beginner level development etc.
• Proficiency/capability development - Conduct classroom sessions and development of material.
• Assets evaluation - Evaluating assets and rating them based on a number of predefined parameters
• Hyperion online resources administration - Administer the various Confidential Hyperion online resources like Hyperion internal s etc
• Hyperion Financial management (HFM) asset development - Worked on various HFM assets like HFM ppts, HFM beginner level development etc.
• Project Confidential Production Support

Confidential

Responsibilities:

• As Essbase offshore support, my role is to keep all these applications up and running, doing maintenance, operational, enhancement, troubleshoot activities. I resolve application related tickets within very stringent deadlines. Additionally I do Essbase administration, creating users, assigning privileges, resolve users tickets. In addition, I am actively involved in client interaction & routinely make and give presentations.

Confidential

Responsibilities:

• As Team Leader/PLSQL Developer I was in involved in writing stored procedures for data loading using APIs, de-duplicating records, data cleansing, batch creation and scheduling, exporting & importing data using data pump, gathering statistics, verifying index usage, Oracle Administration, space usage monitoring & system monitoring using custom scripts and v$views, performance tuning, documentation, data modeling, making hardware and software specifications etc.

Confidential

Responsibilities:

• Database designing, normalization, writing stored procedures, triggers, constraints, materialized views, database administration, identifying storage requirements, performance issues, response times and doing database tuning, backup etc. I was involved in managing teams, work assignment, scheduling, database designing, user interface designing, coding, writing test cases, unit testing, integration testing & stress testing. I was involved in technical issues, requirement analysis, Software Requirement Specification (SRS), technical writing and client interaction. Also involved in site preparation, of users, pilots testing and rollout.

Confidential

Responsibilities:

• As Programmer/Team Leader I was involved in database designing, normalization, UI designing, coding & final testing. Involved in technical issues, requirement analysis, Software Requirement Specification (SRS) documents and client interaction, project rollout, MySQL Administration, backup etc.

Confidential

Responsibilities:

• Involved in rollout of Vahan and Sarathi, requirement gathering and customization of software and involved in user . Also implemented smartcard based driving license and registration. Did maintenance operations, database tuning for the transport office at ranchi location. Wrote shell scripts for automated backup etc.

Confidential

Responsibilities:

• As Team Leader / Database administrator I was involved in database designing, normalization, writing T-SQL stored procedures, triggers, work assignment, scheduling, project tracking, unit testing and integration testing.

Confidential

Responsibilities:

• As Team Member involved in Database designing, normalization, integrity constraints, writing stored procedures, backups etc
• ProjectERMS (Enterprise resources management System)
• PlatformVB 6.0 / Oracle 8i / Crystal Reports 7.0 / Rational Rose

Confidential

Responsibilities:

• As Software engineer, I was involved in designing the forms, tables, identifying classes by studying the system requirements, identifying and drawing use cases and then coding, writing stored procedures, triggers, views etc, designing reports using crystal reports.