PROFILE SUMMARY:

• 10+ years of IT experience in Software Development, Production Support and Maintenance projects with extensive hands - on experience in data warehouse projects including project delivery roles across different domains such as Retail and Healthcare.
• Experienced in project management, serving as client's point of contact for Executive system reporting, project status reporting and issue resolution among other responsibilities.
• Experienced in providing IT Services for an organization, taking ideas from concept-to-production, providing leadership in the evaluation, selection and implementation of new information technology solutions and have been involved deeply in full scale implementation of core IT projects in the company.
• Worked on Big Data Hadoop framework using Pig Scripting, Map Reduce, Hbase, Hive .
• Experience in developing Pig scripts and Hive Query Language.
• Written Hive queries for data analysis and to process the data for reports.
• St rong experience in Oracle 11g/10g , application performance tuning, Oracle SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance works.
• Experience using PL/SQL Developer, Oracle SQL Developer
• Expertise in maintaining data quality and data profiling.
• Expert in ETL process using Informatica Power Center Designer (9.6.1), Workflow manager, Workflow monitor, Informatica server and Repository Manager.
• Experience in MOLAP reporting which includes Hyperion Essbase and Pilot Analysis Server.
• Experience in all phases of Software Development life cycle.
• PMI Methodology Experience
• Project planning, Project Charter, Issue Management, Risk Management, Defect Management, SDLC, Waterfall Model and Agile Model.
• Project tracking & project health reporting to executive sponsors, IT & Business Directors, Functional managers & key project stakeholders. Recommend & suggest action required to bring project back on track.
• Experience in leading large project teams including development team, vendor/ contractor team, system integration team, user acceptance testing team.
• Change management/ Change requests using Enterprise Change Management approval process.
• Project communication using tools like weekly status meetings, status reports, emails etc.
• Project closure by capturing lessons learnt, perform root cause analysis on issues, and perform post production warranty support before transition to O&M (Operations & Support team).
• Lead Implementation planning with development team, release management team, database administrators & business users to perform checkout
• Maintain risk & issue logs along with mitigation strategy, due dates, responsible parties, priorities etc.
• Designed Project road map tool to help DW PMO office in resource capacity planning & forecasting.
• Domain expertise in Health Insurance, Retail industry.
• Executed projects in Multi-Vendor/ Contractor Environment. Project execution in Matrix organizations.

TECHNICAL SKILLS:

Processes & Methodologies: Implementing SOX controls

ETL Testing: System Analysis, Business Analysis

Full SDLC Implementation: Release Strategy and Change Management

Information Technology Skills: Full application life-cycle development, including needs analysis, requirements gathering, project planning, scheduling, Project Tracking, Project assessment, effort estimation. Application architecture and design, database design, application development, testing, deployment, system and user documentation, user training, and application support/maintenance

Major Skill: Data Warehousing, Business Intelligence and Project Management

ETL/Reporting: Informatica 9.x / Pilot Analysis Server / Hyperion Essbase

Hadoop Technologies: Map Reduce, Pig Script, Hive, R

NoSql Databases: HBase

Application Skills: MS Office (Excel, Power Point)

Platforms: Windows XP, Unix

Third party Software: HP Quality Center

Database Skills: Oracle 9i, Oracle 11g and MS SQL Server 2000

WORK EXPERIENCE:

Confidential, CA

Environment: Informatica 9.x, Oracle 11g, Pilot Analysis Server, UNIX, JavaScript, Perl

Responsibilities:

• Imminent member in framing the approach to Design the code for the pre-required file format from the DW production Database with production support and onsite experience
• Coordinating with the different source and downstream systems to provide the solution and support the load and the minor enhancements in which the alignment of the different teams required
• Supported EIS Executive Information System
• SOX point of contact for DW team
• Manage multiple projects from requirement gathering to implementation
• Work with release management team for implementation of major projects
• Experience data modeling, ETL (Extract-Transform-Load) concepts, query performance tuning and testing
• Working on Proof of concept for Big Data through Apache Hadoop
• Monitoring the system’s performance and provides the round-the-clock support for the DW applications
• Project planning, roll out project schedule & milestones, task allocation
• Project status reporting on weekly basis to sponsor group, business & IT stakeholders. Escalate issues with recommended solution for PMO Director & Sponsor group attention
• Coordinate with Infrastructure Managers for hardware procurement, server set up, database set up
• Coordinate with Resource/ Functional managers for resource allocation on project
• Coordinate with Business stakeholders to get requirement documents in timely manner
• Coordinate with SIT (system integration testing) manager to draft quality management plan, testing strategy, QA tool set up, track test cases & results
• HP Quality center & ALM tool to log test cases & defect tracking during testing phase.
• Lead PMO department’s strategic initiatives related to resource forecasting, future projects road maps

Confidential, AR

Environment: Windows Server 2003, Hyperion Essbase Analytic Services 7.x

Responsibilities:

• Preparing and monitoring the Batch jobs
• Preparing and modifying the Essbase Procedures and Calculation Scripts
• Security Updates - Handling the Security filters, User groups efficiently using MaxL Scripts
• Handling and Validating Transparent and Linked Partitions
• Retrieving and validating the data using the spreadsheet addins

Confidential, CA

Environment: Windows Server 2003, Hyperion Essbase Analytic Services 7.x

Responsibilities:

• Formulate Performance metrics & capacity planning, new developments
• Providing solutions to the client’s requirements, which involve Design/Modification/Maintenance (Outlines, Calc Script, load rule etc) of Essbase Cubes through Essbase Application Manager/esscmd, MaxL, automation, maintenance of data integrity
• Preparing and monitoring the Batch jobs
• Preparing and modifying the Essbase Procedures and Calculation Scripts.
• Handling Outline Changes: adding new accounts, renaming the present members, adding or modifying the aliases and UDA-s, realignment of the present members
• Security Updates - Handling the Security filters, User groups efficiently using MaxL Scripts
• Handling and Validating Transparent and Linked Partitions
• Retrieving and validating the data using the spreadsheet addins

Confidential, CA

Environment: Windows XP, NT, Oracle 8i, MS SQL Server 2008,VB.NET,C#, HTML,XML

Responsibilities:

• Understanding requirements, designing, Coding, integrating Deploying and Testing of Windows Application
• Imminent member for designing the Banking and ERP application for the organization
• Supported web team with designing the application/database