SUMMARY:

• I am a qualified IT Professional with broad expertise in many areas including process analysis, Business Intelligence and Business Application development.
• A goal oriented problem solver, I have had hands - on involvement in the development of application enhancements, systems support and systems development that have included incident and root cause analysis, security development, change integration, utilization analysis, usage improvement and operations management.
• Extensive experience and record of success in a client facing role, working with Govt.
• Stakeholders/business users (Supervisors, Technical leads, Program Leads) beginning with user needs assessment.
• Developed and implemented series of BI solutions to increase productivity, reduce costs, and ensure accurate business insights.

TECHNICAL SKILLS:

• Business intelligence analysts with focus areas of Business Intelligence, B2B and Business Application
• Over 10 years of good knowledge of Data warehouse, various Reporting tools and ETL processes.
• Developed OBIEE 11g/12c, Hyperion Interactive Reports, Oracle BI Publisher reports and Crystal reports 8.5, Cognos, designed dashboards, published jobs.
• ETL tools experience like Informatica Power Center 6.0, Data Stage 6.2.
• Experience in writing, testing and implementation of the Stored Procedures, views, functions at Database level using Oracle, PL/SQL, SQL, MS-ACCESS, JavaScript etc.
• Understanding of version control and change management processes.
• Created functional and technical mapping specifications and documentation
• Familiar with IBM Cognos and Tableau Desktop. skills in Agile Development and Test Driven Development experience with the daily stand up, backlog grooming, sprint planning, sprint review, sprint retrospective and other meeting as required by the team.
• Worked as a software developer using .NET, Java, C, Visual basic for Web, WAP, application software.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis Area, MO

OBIEE 12C Technical Lead, Business Intelligence Consultant

Responsibilities:

• OBIEE Reporting Implemented for Exelon Power
• Created and implemented an OBIEE data model often referred to as an RPD.
• Created user security and Access Governance processes utilizing Active Directory and new Access Governance System flows.
• Conducted training sessions including onsite and online delivery formats across eight Exelon Power sites to train and educate business and IT staff as OBIEE Authors, End-users and Admins.
• Collaborated with other Business units in Exelon to develop the OBIEE application data governance framework which will allow the business and IT teams to engage effectively for the maintenance and support of this new platform.
• Performed an assessment of the current Hyperion Interactive Reports in production (published and ad-hoc) that need to be converted/migrated to the OBIEE 11g/12c platform.
• Identified business SME’s from each department within Organization to perform an assessment validation to ensure only needed reports are converted/migrated to OBIEE 12C.
• Developed a scope statement, project schedule timelines for report conversion/migration.
• Architect/Technical leads to design and develop OBIEE RPD, Answers/Analysis and Dashboard etc.
• Performed RPD and web catalog deployments, administration of BI servers.
• Participated in organization’s security needs assessment, performed security tasks including creating users, groups, roles, application policies and data connections.
• Coordinated and facilitated reporting requirement analysis & design sessions with key Business Users / Stakeholders

Business Intelligence/Data Warehouse/ Report Developer

Responsibilities:

• Designed & Developed dashboards, canned, ad-hoc reports using OBIEE, BI Publisher, Hyperion Interactive Reporting, scheduled the report jobs for email delivery.
• Performed reporting requirement analysis & design, coordinate with Business Users.
• Scheduled and maintain the report jobs.
• Performed production support with reporting issues, migrations between different server environments.
• Performed in-depth analysis and documentation of business logic and requirements.
• Involved with migration of Hyperion Interactive 9.1 reports to Hyperion Interactive reporting 11.1.1.
• Converted all the Informix based SQL to the Oracle 10g backend.
• Involved with data modeling task using star schema.
• Extracted data from multiple sources and processed / analyzed relevant data and reported results.

Confidential

Business Intelligence Analyst

Responsibilities:

• Extracted data from multiple sources and processed / analyzed relevant data and reported results.
• Developed Hyperion Interactive Reports and Crystal reports, designed dashboards, published Hyperion jobs.
• Worked with BI, Hyperion Performance Suite, and Enterprise Data Warehouse.
• Data Integration and ETL using client IBM DataStage 6.2.
• Helped in preparing the mapping document source to target.
• Created DataStage Jobs.
• Involved in unit, performance, Regression and integration testing of data stage jobs and prepared Documentation.
• Created/tested/implemented triggers, Procedures, functions at Database level using PL/SQL.
• Wrote technical specifications for projects.
• Participated in weekly status meetings.
• Worked closely with internal and external resources on company projects to determine business requirements, project design, development, configuration, testing and documentation to deliver project results in a timely and economical fashion.

Brio Designer/Developer

Responsibilities:

• Designed and Developed Report Using Hyperion Suite (BRIO).
• Used JavaScript and SQL to manipulate the data.
• Designed the Mapping, ETL tool using stored procedures and MS DTS.
• Helped the team for assembly test.