SUMMARY

• Over 11 years of diversified experience in the IT industry in managing and implementing projects spanning across all SDLC components
• Have proficient experience in project estimations, resourcing, forecasting, requirements gathering, and own the entire project teams independently for their delivery interacting with different stakeholders
• Track record of creating automated and efficient workflow improvements to increase productivity while executing to specific time and cost constraints
• Vast technical experience in business intelligence and data warehouse solution design
• Extensive experience in creating business requirements, functional requirements, test cases, and user manual documents
• Experience in evaluate BI tools by analyzing various hardware and software requirements in terms of cost, functionality, features, usability, performance and support
• Experience in monitoring and reviewing the development work of development team and technical mentoring
• Expertise in applying best practices and Industry standards in implementing Business Intelligence and reporting environments
• Exceptionally customer - focused with a keen ability to document and translate multi-level requirements into productive solutions
• Have technical and functional experience along with sound Business knowledge in the Banking, Financial, Insurance, Manufacturing and Pharmaceutical industries
• Proven ability to liaise with business and technical stakeholders to reach mutual goals
• Excellent leadership and communication skills, interacting abilities and training capabilities, possesses problem resolution, strong analytical skills, proactive on recognizes problems and decision making skills
• Experience in multi-vendor work environment and Onshore/Offshore models

TECHNICAL SKILLS

Business Intelligence: IBM Cognos, OBIEE, QlikView, Tableau

ERP: People Soft 8.3/9.1

Databases: Oracle, SQL Server, Vertica, MS Access, TOAD

Web servers: Microsoft Internet Information Services (IIS) 6.0/5.1

Directory servers: Sun One, Netscape Directory Server 6.2

Programming skills: SQL, PL/SQL, VB 6.0, VB.NET, PASCAL, C, C++, HTML

Modeling tools: Erwin

Microsoft Suite: MS Project, MS Excel, MS Word, MS Visio, MS PowerPoint

Operating systems: Windows 10/8/XP/NT/2000/2003

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

Project Manager & Functional Analyst

Responsibilities:

• Worked in partnership with HR Information Delivery/Analytics lead to manage and define requirements for HR Analytics systems and tools
• Accountable to HR executives for guiding all projects through requirements, design, development, and implementation phase gates for all new reporting and enhancement initiatives
• Worked in partnership with HR Technology Business Intelligence team to develop reporting/analytics tools
• Defined, planned, and managed projects deliver reporting/analytics using Cognos and OBIEE reporting tool
• Continually communicate with business stakeholders, IT staff, the user community and PMO representatives
• Responsible for risk assessment, contingency planning, impact analysis, and prioritization of all action items.
• Worked in partnership with HR Technology Testing COE to manage and test SIT and UAT
• Shared a technical staff of 12 and coordinate resourcing efforts to accomplish all development work
• Helped BI team perform gap analysis as related to ETL processes that populate reporting and analytics requirements
• Provided technical guidance to team members for architectural consistency and technical accuracy
• Continuously worked with Support and Operations team to troubleshoot and tuning in order to isolate and identify problems and to optimize system and reportingperformance
• Participated in Governance recurring meetings and prioritized projects as agreed by business and IT teams
• Ensured development work is maintainable, supportable and met standards consistently

Environment: Cognos, OBIEE, Oracle 10i, Vertica, PeopleSoft 8.3/9.1, MS Office, HPQC, Remedy, Seibel Call Center, SharePoint, Windows 7

Confidential, New York, NY

Sr. Techno-Functional Analyst

Responsibilities:

• Accountable for conveying business-related requests to technical teams as well as monitoring and ensuring timely and accurate IT deliverables
• Documented all activities and provided regular status updates to senior management
• Developed business requirement documents, test cases, and use cases for any/all relative requests
• Assisted Developer in building Framework model and creating packages
• Involved in Functional and User Acceptance Testing along with process documentation.

Environment: Cognos 10.1/8.4, Eclipse BIRT, TOAD, Oracle 9i, ERWIN, Windows XP

Confidential, New York City, NY

Sr. Business Intelligence Analyst/BI Manager

Responsibilities:

• Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Participated in Governance and Open Items List (OIL) recurring meetings and prioritized projects as agreed by business and business technology teams
• Ensured quality and timely delivery from development team, coordinated with delivery team on day to day basis to monitor progress, issues and track them at granular level
• Constantly worked with business users, onsite and/or offshore technical team to ensure deliverable quality and deadlines (SLAs) are met
• Conducted regular meetings with various stakeholders to provide status updates, discuss challenges and available options to overcome those challenges
• Performed proactive risk identification, prepared risk responses, mitigated various risks with contingency reserves and schedule compression and followed issue escalation procedures as required
• Administered and monitored SharePoint portal
• Compared data and performance of Oracle BI with current model for data quality and consistency
• Documented change requests and helped CRM development team understand the requirements
• Involved in UAT as RSD/ASM/TM at various levels of life cycle and participated in pilot meetings for CRM project
• Extensively written SQL queries to pull data from multiple data sources for complex Ad-Hoc reports
• Supported Confidential Animal Health and Confidential acquisitions and integration
• Ensured development work is maintainable, supportable and met standards consistently
• Managed post production warranty support and transitioned to support team
• Documented business requirements, work instructions, how-to user manuals, power user manuals and best practices at various levels
• Trained business users both in technology and applications and help understand data, reports and dashboards

Environment: Cognos 7.3/ 8 BI Suite, Oracle BI 7.8/10.1, Windows XP, SQL Server 2000/2005, MS Office Suite

Confidential, New London, CT

Data Analyst/Cognos Reporting Consultant

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation and development of end user reports
• Gathered and Analyzed User requirements, finance data and designed hierarchy to meet the requirements
• Served as liaison between the Finance Information Department and technical support team to ensure data integrity
• Installed and configured ReportNet, Framework Manager, Cognos Impromptu, PowerPlay, and PPES
• Created packages/metadata models by combining data from different data sources using Framework Manager
• Involved in migration of Impromptu catalogs to ReportNet using Metadata Migration utility
• Created Master-detail, drill-through, Cross tab, Charts, Nested Cross tab and complex repots in Report Studio
• Maintained public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet
• Involved in validating final report data against the source and improving performance of reports
• Created Multidimensional cubes and generated categories using Transformer
• Created appropriate user classes, users, and database signons in Access Manager to provide different levels of authentications and security for the users
• Published cubes and OLAP reports using PowerPlay Enterprise Server to Cognos Portal
• Trained power users to use Query Studio for Ad Hoc reporting
• Provided End User training and managed support-related activity

Environment: Cognos ReportNet 1.1 (Framework Manager, Cognos Connection, Report Studio, Query Studio), Impromptu 7.3, Power play 7.3, Power play Transformer 7.3, MS Access, TOAD, Oracle 9i, Windows XP, MS office Suite

Confidential

Programmer/Analyst

Responsibilities:

• Exposed to software project development life cycle including requirements gathering, analysis, design, implementation, debugging, documentation, and testing
• Worked closely with Business Users and SMEs in the defining and documenting functional requirements
• Authored complete set of user documentation

Environment: Windows 98, Oracle 7.3.2, Visual Basic 6.0, HTML, MS office Suite