SUMMARY

• He is working currently on the Ohio Department of Taxation as Product Specialist (IBM Cognos Analytics), with over 13+ years of IT consulting and Management experience in diverse industries with special focus on Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and Customer OLAP, ETL tools and Reports Generation.
• Previously worked on the State of Ohio and State of Indiana Integrated Eligibility System as the BI Dev Lead for the State enhancements team and BI QA Lead for the vendor, handling responsibilities of managing estimations, planning, design, development and implementation of multiple releases and helping the Vendor with Subject Matter Expertise on Eligibility solutions.
• Experienced in complete life cycle of Cognos BI (Installation, security, configuration, migration, and deployment)
• Expertise in Business Requirement gathering, Business Process flow, Business Process Modeling, Business Analysis, and designing Physical and Logical Data Models
• Worked for various client engagements in Public Sector, Life Sciences, Energy, Supply Chain Management, and Retail sectors, have gained exposure to all phases of project development to architect and implement full lifecycle business intelligence solutions
• Expert in architecting, planning, installing, and configuring IBM Cognos BI, EP, IBM Powerplay.
• Scaled up the infrastructure based on the increased user base and reports.
• Administered and supported reporting tools to provide self - service reporting solutions and capabilities to end-users.
• Extensive experience in designing security model for packages, reports, and cubes in Cognos connection
• Experienced in Cognos namespace integration with Access Manager and LDAPs
• Derived Joint Application Development (JAD), analyzing business requirements, developing specification documents to meet the business need and providing consultation on tools to meet the business requirements
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring
• Strong complex reporting skills - developed reports that utilize Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports
• Created models and published packages using Framework Manager and combined data from SAP BW and Non-SAP BW data source for reporting
• Created Transformer models for building power cubes and implemented drill-through from Cubes to reports.
• Created Data Mapping Documents and worked with business to write transformation rules
• Worked on Report Studio, Analysis Studio, Query Studio and for Report design in Cognos BI 10.X/8.X and IBM Cognos Analytics 11.1
• Knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools.
• Experience in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 10.X
• Mentored and trained users for the successful execution of the project
• Expertise in Client/Server application development using Oracle 9i/10g/11g, SQL Server, PL/SQL

TECHNICAL SKILLS

BI Tools: IBM Cognos Analytics 11.1

COGNOS: 8BI/10.X- Framework Manager, Analysis Studio, Report Studio, Metric Studio, Active Reports Event Studio, COGNOS connection, Cognos Powerplay Transformer.

COGNOS: Series 7.3 - COGNOS Impromptu Administrator COGNOS Power Play Transformer, Power Play Enterprise server, Upfront Administration, Cognos Visualizer, Access Manager.

SAP BI 7.0: Tableau

ETL Tools: Informatica 10.x

Hardware/Operating Systems: WINDOWS 95/98/XP/2003/2008

Middleware/Databases: Oracle 9i/10g/11g/12.1/DB2

PROFESSIONAL EXPERIENCE

Confidential

Product Specialist

Responsibilities:

• Collaborate with Technical Architecture Specialist, System Specialists and Programmers.
• Analyze the functional and technical impact of reports planning decisions.
• Track and document expected volume and type of use of the reports.
• Participate in report design reviews to verify that design meets quality standards and functional/technical requirements
• Provide basic product support and provide accurate and complete answers to detailed product questions in a timely manner.
• Coordinate enhancements to business and logical data models with data base administration to make the appropriate changes to the physical data model in Cognos11 Framework Manager
• Create complex Cognos professional report using Cognos Report Studio.
• Lead test and trials.

Environment: IBM Cognos Analytics 11.1, Cognos Connection, Report Studio, Framework Manager, Oracle 12.1.x

Confidential

BI Reporting Architect

Responsibilities:

• Worked with functional SMEs, business users (Department of Medicaid and Job and Family Services), functional lead to understand the business requirements/business rules, and ensure alignment with development teams
• Utilized the functional and technical domain know-how of the Integrated Eligibility System to lead and manage client’s delivery team for multiple enhancement releases.
• Worked across different teams including client, third-party vendors, functional, technical, and testing teams to ensure successful delivery.
• Lead the design of detailed technical design documents (TDD) for reports based on functional designed documents (FDD)
• Reviewed functional design documents (FDD) developed by vendor to validate adherence to business requirements
• Reviewed technical design documents (TDD) developed by vendor and mentor the developers to align the technical solution with the functional design
• Lead working sessions with the data modeler in translating logical data model into physical data model. Mapped source data to target with transformation logic
• Leading reports maintenance and operation (M&O) testing team.
• Working with the development team and business analysts in gathering and analyzing functional or technical requirements as well as supporting and executing test plans, cases or scenarios for various Cognos BI products and reports
• Provide the overall guidance and develop the quality assurance strategy, test, and evaluation master plan (temp) for all phases of development
• Mentored the technical team with creation of complex reports involving custom prompts, filters, calculations, multi - page, multi-query reports

Environment: Cognos 10.2, Cognos Connection, Report Studio, Frame Work Manager, Informatica, Oracle 11g, Tableau