PROFESSIONAL OVERVIEW

• 10 years of IT, Business Intelligence and Database Management expertise using various BI suite and Querying Software supporting multi-tier and distributed environments.

• Industries and Domains Served: Biopharmaceuticals, US Government, Financial, Transportation and Service sectors. Work experience with US Navy and IBM Global Business Services.
• Experience in gathering consumer requirements, Data warehouse development/configuration and testing of data ensuring database accuracy and integrity.
• Extensive experience in Agile Framework documenting requirements via a variety of methods, including BRDs, functional/system specifications, use cases and activity diagrams.
• Strategically drive and prioritize BI projects maintaining essential business workflow.
• Experience working in cross functional environments and acted as liaison between IT and Business, IM/Quality, Biostatistics and Drug Safety departments.

• Experience in developing and refining standard safety analytical tools and conduct analysis using Cognos, Business Objects, SQL using TOAD and SQL Plus.

• Experience in building DW schema/models sourced from Oracle, SQL Server, SAP, DB2.

• Experience in SAP BW to Cognos Integration Process in an ERP environment and participated with infra- structure team in installation and configuration of Cognos8 in Windows and Unix environments.

• Experience working in Cognos Administration. Implemented security for models and Packages.
• Experience in development and maintenance of Cognos 10 BI based report/design system.
• Extensive experience in data retrieval processes interpreting various industry based business scenarios including but not limited to datamart /DW and Transactional source.
• Strong Knowledge of Cognos BI SDK development in conjunction with Integrated Development Environment.
• Experience identifying data gaps and inconsistencies and propose solutions and fixes to designees.

• Experience in building complex reports using Cognos Report Studio such as Dashboard Reports, Master-Detail reports, Drill-thru reports, Prompt Pages, etc. Experience in creating Departmental Cubes and Corporate-Level Dashboards.
• Strong experience in creating and publishing packages using Framework Manager's Relational and DMR models.
• Experience working with TrackWise EQMS for change control Management and HPQC in developing and managing tests in test plan module.

• Experience in Report OQ and SQL scripts verification and field mapping specifications in support of database migration.
• Experience in developing stored procedures using PL/SQL.
• Experience in developing test scripts for functional and regression testing.

• Thorough understanding of ETL jobs and tools such as Informatica, Decision Stream, Microsoft SSAS, SSIS and Data modeling tools such as ERwin.
• Worked with offshore technical support team in resolving multiple trouble tickets.

TECHNICAL SKILLS

Business Intelligence:

SAP Business Objects XI, IBM Cognos 10.2 ,10.1,Cognos Business Insight Advance , Cognos 8.4/8.3/8.2/8.1 Analysis Studio, Report Studio, Query Studio,Metric Studio, EventStudio, Framework Manager , Cognos Dymanic Query Mode, Cognos TM1, Oracle E business suit , Access Manager, LDAP

RDBMS:

Oracle AERS and ARGUS, Insight ,Siebel CRM 8, SAP Net Weaver 7.0 , Oracle 10g/11g/9i,

SQL Server 2008/2005, DB2, Sales force CRM

Quality and Project Management:

TrackWise EQMS, HPQC

BI/ ETL and Model Tools Knowledge

SSIS/SSAS, Informatics, Decision Stream, Erwin

DB Querying Tools:

SQL Plus, Toad 10.5, 10.6, TOAD for Data analysts

Web Servers:

Apache, Websphere, IIS

Languages:

XML,VB.NET, SQL, T-SQL, PL/SQL, MDX

Professional Experience

Confidential

Senior Cognos Consultant/Architect Oct'11 Feb'14

BMS Amylin is a biopharmaceutical company dedicated to improving lives of patients through the discovery, development and commercialization of innovative medicines.

• Responsible for performance and management of the design, creation and generation activities of
• Business Objects XI and Cognos BI based Data reports in request to product safety information requests on a SharePoint based tracking system.
• Worked with Argus safety and Argus insight and its BI layer of Business Objects XI performing Ad hoc Analysis. Actively using BO/WebIntelligence to slice and dice data using product Microcube.
• Responsible for providing all Case volume metrics to BMS and Amylin Integration teams.
• Developed and maintained Cognos 10 versions BI based reporting system including providing recommendations to FM model fixes.
• Owns triage designee responsibilities in gathering report design requirements incorporating into business specific reports.
• Generated product safety information, Validate data and provided line listings for Periodic Reports, Perform signal detection support Analysis Ad Hoc , Created specialty and SAE reconciliation reports.
• Performs gap analysis, identify discrepancies, advice solutions to issues exists in database schema, reporting software's or in the defined business rules.
• Acted as a liaison between Global safety and Biostatistics for product safety, risk assessment, signal management and mitigation activities.
• As a Scrum development team member ,created report specification document including reporting application, query /layout parameters and outlining test/validation scenario.
• Develop new SQL and PL/SQL code and modify the stored procedures to fix the reports.
• Provided case metrics and product structure tree by product and ER diagrams helping assess migration load.
• Run test SQL scripts and Report OQ in support of source to target verification and documented mapping specs.
• Worked on HPQC test plan ,test lab , test defect and test ready for approval modules.
• Coordinates with QA department using Trackwise quality management system in implementing Report development and risk based report SDLC .
• Experience working with Quality Management team in handling deviation, compliant reporting and risk management using TrackWise EQMS software
• Liaised through deviation and CAPA for GXP report SDLC process.
• Participated in risk based report SDLC including determination of migration paths assisting regression and functional testing.

Environment

Cognos 10.2, 10.1 BI, Cognos Business Insight Advance, TOAD for Oracle 10.6 , Business Objects XI, SAS 9.2, SAS Enterprise Guide 4.3, AGILE Framework, ARGUS , Insight, ARGUS oAERS, TrackWise change control EQMS, HPQC ,Oracle 11g, SQL, PL/SQL

Confidential

Senior Cognos Consultant/Architect

The Department of the Navy Base Realignment and Closure BRAC Program Management Office PMO is responsible for Overseeing all base closure, realignment, and care taker activities. Developing and implementing plans, priorities, and procedures for base disposals and their associated environmental cleanups

Responsibilities

• Worked on all Reporting needs of Program Management, BRAC Finance and Budget Control

• Developed multi sourced and multi tab Environmental Execution Report being used by leadership and managers.
• Worked as Cognos Administrator and created and maintain all user account on Cognos namespace using Access manager.
• Developed Dashboard using cognosportlet carrying both Reports and Charts meeting cross functional needs of Base Closure Managers.
• Worked extensively on Portal customization using XML.
• Responsible for QC/QA of all Reporting deliverables.
• Performed Raw Files Analysis and track source data for reports accuracy and data integrity.
• Meeting users and gathered value added information that incorporated into reports and dashboards.
• Log, Maintain and followed up on IBM Cognos technical/software issue tickets on regular basis.
• Recommend and Coordinate with ETL Personal to modify Data flow and Table Updates on SSIS and Oracle SQL Developer.
• Communicated with Navy's server hosting team in resolving development and production server issues.

Environment

Cognos 8.4.1 Studios Report Studio, Query Studio, Analysis Studio , Cognos 8 BI Framework Manager, .Net based sourced DB, HQ NORM MS Access DB , Access Manager, Oracle 10g,11g , Microsoft SQL 2008, Microsoft SSIS

Confidential

Sr. Cognos Consultant

In an effort to reduce administrative and operational costs, Philadelphia Prison System implemented state wide repository by centralizing inmate data.

Responsibilities

• Worked in a team developing code and rules within various tables such as Disciplinary violation and Infraction tables distinguishing granular details and incorporating them into data model.
• Worked on the Framework Manager Model focusing on end users specific requirements and concerns.

• Resolved issues within the Metadata Model using Cognos 8 BI Framework Manager.
• Resolved ambiguous join paths between On Campus with no Dockets/Charges joins affecting query tables.
• Analyzed entity-relationship diagrams and data Marts to validate design against end users requirements.
• Investigated and identified issues existed in the ETL model design using Microsoft SSIS and SSAS.
• Written PL/SQL stored procedures to fix the reporting issues
• Worked on the Relational and DMR models in updating the changes.
• Created and republished cubes for RS and AS users.
• Created advance drill through dashboards and conducted training session for the staff..
• Worked with the Data warehouse Administrator in implementing security to the model and packages.
• Created User, Role and Contact using Cognos Administration.
• Set user Permissions to view contents of a container in cognos Administration.
• Documented error logs and fixes.
• Trained the Staff on RS, QS and AS.

Environment

Cognos 8.2 Studios Report Studio, Query Studio, Analysis Studio ,Cognos 8 BI Framework Manager

Powerplay Transformer, Oracle 11g , PL/SQL, Microsoft SQL 2005, Microsoft SSIS and SSAS.

Confidential

Sr. Reporting Analyst- Consultant

Responsibilities

• Worked with the Integration team responsible for integrating Cognos Segments to IBM in understanding and analyzing various reporting methods.
• Worked on BPM Process to execute strategies enabling Sales and Marketing force to analyze and report.
• Run and Publish multiple extracts using Metrics Designer and transferred into Metric studio.
• Created Cubes and used Analysis Studio for building and analyzing reports and validated
• output against Oracle discoverer based reports.
• Used MDX to navigate the structure and retrieved data from OLAP cube.
• Created Win Loss Analysis Dashboard combining Sales and Marketing Departments.
• Created Detailed Integration report in RS using join and union of queries.

• Created Master-Detail reports for Marketing Operations.
• Worked with the IT Admin Team in handling Cube Logistics.
• Installed and configured Cognos clients for business users.
• Used Cognos Transformer and PowerPlay8.4 in creating ,testing and UAT of cubes.

Environment

Cognos 8.4/8.3 Studios Report Studio, Analysis Studio , Cognos 8.3/8.4 PowerplayTranformer., Metric Designer, Cognos TM1,Oracle 10g, Apache Webserver, DB2, Oracle E-Business suite .

Confidential

Cognos Consultant

The Walt Disney Company is the third largest media and entertainment corporation in the world, with IBM being Solution Provider , Walt Disney IT aims to provide a common platform for deploying an enterprise wide Cross Segment Reporting, Forecasting and Planning solution to their users.

Responsibilities

• Involved in all phases SDLC in an ERP environment .
• Worked closely with HR in developing HR report writing and HR data analysis.
• Interacted with users at various levels to gather, understand, and analyze business-reporting requirements.
• Analyze technical design elements in BEx Query Designer according to report selection criteria to meet functionality in Cognos.
• Execute Queries in BEx Query Analyzer , Filter Characteristics , Drill down and across on values, Hierarchy and Hierarchy Nodes as required.
• Imported BEx query metadata in Framework Manager, created packages based on cubes and published them to Cognos Server.
• Worked along the integration team in optimizing report performance.
• Developed Finance and HR Reports using Finance/HR Query in Report Studio.
• Used MDX to navigate the structure and retrieve the data from OLAP cube for HR Metrics.
• Created Report based on Drill through definition using MDX Expressions.
• Created Prompt Pages based on BEx Variables and Parameters in Cognos.
• Worked closely with the team in resolving SAP to CognosIntegration Issues.
• Analyzing business and functional requirement to perform SIT and UAT for Reports.
• Migrated reports from version 8. 2 to version 8.3

Environment

Cognos 8.3/8.2 Studios Report Studio, Analysis Studio, Query Studio , Cognos Suite Report Net 1.1 MR3, SAP BW 3.5, SAP NetWeaver7.0 ,WebSphere, Apache Webserver, DB2.

Confidential

Cognos Developer

Responsibilities

• Imported and created Metadata models from multiple databases and published packages to Cognos Connection using Cognos 8Framework Manager.
• Building Metadata models for various Applications.
• Importing existing Oracle Stored Procedures objects and converting to Cognos Query Subject
• Creating and Publishing packages Daily Sales, Monthly Sales, Financial Sales, Executive Summary, Management and Secured user group for Aftermarket Sales application
• Building and Designing Metadata model using existing Crystal Queries
• Creating and publishing packages using existing Crystal Queries
• Involved in setting up the Security at package level, data level and object level to restrict the data access in the Framework Manager and report level and folder level in the Cognos Connection.
• Building and Designing Metadata model for the Cube using Powerplay Transformer and reports are designed using Analysis Studio.
• Providing report estimates on different applications for Crystal to Cognos Conversion
• Created various ad hoc reporting templates list reports, chart reports, cross tab reports for power users in Query Studio.
• Created Master-Detail reports, Burst reports, Drill-thru reports, Prompt Pages Cascaded input prompts and Simple prompts , Dashboard Reports in Report Studio.
• Worked with the ETL team analyzing multi dimensional data using Microsoft SSAS.

Environment:

Cognos 8.1 Studios Report Studio, Analysis Studio, Query Studio, Metric Studio , Cognos Suite Report Net 1.1 MR3, Crystal reports 8.5, Oracle 10g, Oracle E-Business suite, SQL Server 2005, Apache Webserver

Confidential

Cognos Developer

Responsibilities

• Imported Meta Data from Multiple Sources in to Framework Manger
• Created Business View and added business values specific to reporting requirements
• Created, modified, and Published Framework Manager Packages on ReportNet Server
• Generated Ad-hoc Reports and Standard Reports Using Query Studio and Report Studio
• Created Reports different formats like HTML,PDF,EXCEL and Delimited Text
• Created Parameters, Prompt Pages using various Prompt types Value Prompts, Text Box Prompt, Date Prompt, Select Search Prompt, Interval Prompt on the reports
• Developed reports using List, Crosstab, Chart, Repeater and Blank Reports
• Created standard Calculation on Query Item and Applied various Filters to Data like Tabular, Group Filters on Query items, and Formatted the Reports
• Created Drill-through connection to link 2 Reports, Book Marks and Conditional Block Lists.
• Created Models by using Impromptu Query Definition IQD in PowerPlay Transformer.
• Developed the OLAP cubes.
• Created Catalogs in Impromptu Administrator to design Reports.
• Updated Impromptu Catalog by adding tables and creating new joins.

Environment: ReportNet 1.1MR3, Cognos Impromptu 7.3, Power Play 7.3, Transformer 7.3, Oracle, SQL Server 2000, MS Access, WebSphere.

Confidential

Programmer Analyst

Responsibilities:

• Design techniques used arcview3.x , Arc / Info 7.x and Microsoft Access.
• Developed borough wise database of new York for the School Safety Project assigned by DOT new York
• Provided hardcopy maps to transportation engineers according to POI point of interest surveys.
• Specific function include working on GIS software and related database for mapping.
• GIS/RS-based and other data visualization techniques, including tabular, graphical, plan-view single and multi-theme maps, time-slice mapping, 3-dimensional visualizations.
• Automated Reports using scheduler for different intervals.
• Working knowledge of ARC/INFO and MapInfo.
• Familiar with GIS modeling languages

Environment:MS Access base DBGIS, RS, Statistical, and Other Computer Software ArcView GIS Spatial Analyst, Image Analyst by ERDAS, 3D Analyst, ArcWofE ArcSDM , ArcGIS, and SPANS/PCI.