SUMMARY

• Over 10 years of IT experience in Architecting Solutions with Technical Expertise in Business Intelligence (BI) and Data Warehousing (DWH).
• Experience in solution crafting/architecture, analysis, design, development and testing process.
• Expert Solution guidance for design, install, configure, and develop Cognos Applications (Cognos 10.x/8 BI Stack, Planning, Cognos 10 TM1 Suite).
• Architecting Solutions for Project and defining approach and ensuring the delivery with Quality for ETL, BI Dashboard, OLAP, Metadata and Report Solutions.
• Experience in Administration and configuration of IBM Cognos Application Servers, Content Manager, Gateway, and Transformer in Windows virtual server environments.
• Experience in designing Cognos Portal, Dashboards, Cubes (Transformer, Dynamic), Active Reports, Charts, and Scorecards.
• Experience in Cognos migration 7.x, ReportNet, 8.x and 10.x environments.
• Exposure and Experience in Informatica PC 9.x/7.x/5.x and exposure to MM & Business Glossary, Data Quality, Knowledge of CDC, Real - time ETL, Batch ETL, Data Discovery.
• Exposure to Data Management (Governance, Master Data, Meta Data, Data Quality, Unstructured Data, Audit & Compliance).
• Exposure to Data Quality techniques (Data Profiling, Cleansing, Quality Management, and Auditing)
• Understanding of Data Warehousing (DWLC) & Software Development Life Cycle (SDLC), ETL process, and Dimensional Modeling.
• Experience in building POC’s, Swim Lanes, RACI for business process, driving/managing Onsite/offshore teams.
• Exposure to SAP ECC, BW (BEx Analyzer, Query Designer, Solman, and modules HR, AP, AR, COPA.
• Trizetto Facets 4.71/5.01 Architecture, Siebel CRM, VB scripts, Unix Shell scripts and automating the Informatica process.
• In-depth understanding of star schema & snowflake schema, fact & dimension tables, physical & logical data modeling.
• Experienced in query tuning of relational databases Oracle, DB2 and SQL Server (T-SQL) and exposure to Hadoop.
• Has the ability to work as a mentor, team member or as an individual to set priorities, plan/organize, and carry out multiple tasks in an efficient manner and confident in serving the best results.

TECHNICAL SKILLS

Methodologies: Agile/scrum, RUP, Waterfall, UML & Business/Data Modeling

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis.

Business Tools: MS Visio, MS Project, MS Access, MS Office Suite, SharePoint, RTM (Requirements Traceability Matrix), JIRA

OS: Windows XP/ 2000/2003/2008/ NT Server, Linux, Solaris, AIX, MS-DOS, Mac OS X.

Application Servers: WebSphere, WebLogic

Web Servers: Apache HTTP Server, Apache Tomcat, IIS, Oracle WebLogic Server

ERP Tools: SAP ECC, SAP BW, BEx Analyzer, Query Designer, PeopleSoft HR, Finance

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server6.x/7.x/2000/2005, DB2 UDB 9.5/9.1/8.2/400, Vertica

DB Tools/Utilities: Oracle Developer 2000, SQL* Loader, App Dynamics, Oracle Enterprise Manager, Statspack, AWR

Modeling Tools: Erwin 7.x/ 4.5.2/ 3.5.2, Oracle Designer 2000

ETL Tools: IBM DataStage 8.x/QS/IA/BG, Informatica PC/MM/BG/IDQ 9.5.1/8.6/7.1.3/6. x/5.x, SSIS

OLAP Tools: Cognos PowerPlay 10/7.x, Oracle Reports 9i/6i

BI Tools: Cognos 10.x/8.4/8.3, CRN 1.1 MR4, Cognos Suite 7, Cognos 10 FM/TX/CD/MM/RS/QS/AS/ES/MS/PPS/DQA/BW/BWA/LCM/CC, Cognos Office, BOBJ, Tableau

Languages: C, C++, VB, Java, SQL, PL/SQL, Shell Scripting

OS: Windows XP/ 2000/2003/2008/ NT Server, Linux, Solaris, AIX, MS-DOS, Mac OS X.

Web Development: HTML, DHTML, Macromedia (Flash MX 2004, Dream weaver), MS-FrontPage, IIS

Other Tools: TOAD, DB2 Control Center, Composite, Telnet, PuTTy, AWK, Meta Manager

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Cognos Lead/BI Architect

Responsibilities:

• Leading BI team for getting sign off on Work Request Process.
• Prepared Swim lanes for defining business process and standards for future process improvements as part of Work request for project.
• Prepared documentation based on development and QA validation for each Tool involved.
• Top Down inventory
• Top down Inventory (Reporting back to Batch Process) to help Data Stewards as part of process improvement.
• Analyzed and build Custom Metadata mapper for supporting Business Glossary and Metadata thereby gaining End to End Lineage for re-defining the process.
• Analyzed & Populated Informatica Metadata & Business Glossary for current BI Models.
• Analyzed, Developed and Linked Tidal Jobs with SSIS Packages, Cognos elements, SAS Programs
• Involved in Solution Improvement meetings for BI Cognos process.
• Analyzed current Cognos Models and involved in Rationalizing Multiple models to build one Enterprise BI Model moving forward thereby saving & cutting down Client expenditure by at least 10%.
• Analyzed part of the current ongoing process and given inputs/pointed the current Reporting (Dashboards, Scorecards, Reports) to the new Rationalized Models as part of POC.
• Analyzed the Tidal batch process, SSIS Loading process for ODS, EDW, Reporting Database with discussions with DBA’s as to have clarity on data.
• Validated Business Requirements for gaps, analyzed data scenarios for wrong calculations in current Cognos Reports from Prod.
• Suggested best practices and Standards for future BICOE implementation after thoroughly understanding the current state.
• Worked on Model Analysis, Model Testing and documenting of Cognos Framework Models and suggested maintaining versions using VSS Tool.
• Reviewed plan, training agenda, and documentation for 500 Query Studio Users.
• Pushing down aggregate functions and view data can be made ready before report execution rather than at run time.
• Analyzed SAS Programs from report flow to source programs and to Database schemas affected for Domestic Models.

Environment: Cognos 10.2.1, FM, RS, QS, AS, Business Workspace, Informatica 9.5.1 PC, MM, Meta Configurator, IDQ, Vertica, MS SQL Server 2012, SSIS, Oracle 11g, MS Visio, CA Erwin, Tidal

Confidential, Rochester, NY

Sr. Cognos/BI Architect

Responsibilities:

• Involved in Solution Design meetings for HPXR Reporting.
• Involved in weekly status meetings on current Model issues, SR’s, tickets raised and weekly agenda for Modeling, Reports, and Training for users across Central NY (CNY) and Western New York (WNY).
• Analyzed part of the current ongoing process and given inputs/suggestions to the current Reporting and Modeling process.
• Analyzed the Informatica Loading process for Reporting Database as to have clarity on data.
• Gathered Business Requirements, analyzed data scenarios, build; unit tested, and migrated Self Service Cognos Reports from DEV to QA.
• Analyzed the Extended Reporting Models for Tier data based on different loads like HPXR and EDW.
• Analyzed Facets Monthly Claims Maintenance data for the building Active Report for the Information Management user team.
• Suggested and implemented Modeling, Reporting Best Practices.
• Handled Service Requests for the team and conducted discussions with Sales & Operations Business and Functional Users as part of the validation process.
• Worked on Analysis, Model, and Design, Testing and documenting of Cognos Framework and Transformer Models and maintaining versions using VSS Tool.
• Analyzed and built EGR Transformer Model and Multi-dimensional Power Play Cubes for Dashboard purpose.
• POC on Dynamic Cube, Active Report, Audit Report Process, Claim ER Report Process, RAVE Visualizations in 10.2.1 Active report.
• Used Java Code for prompt selections and default display for reports in report Studio.
• Developed Performance Oriented Solutions for MedImpact, Medicare, HCR, Self Service, Dual Enrollment, Audit Drill Through Reports and analyzed Siebel data into Cognos.
• Validating Reports output to match on par with Facets Claims.
• Tested Reports and Models after Cognos upgrade from 10.1 to 10.1.1 and 10.2.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Reviewed plan, training agenda, and documentation for 1000 Query Studio Users.

Environment: Cognos 10.2, FM, CD, DQA, TX, RS, QS, AS, Business Workspace, Siebel 8.1.1.8 CRM, MS SQL Server 2008, Composite, Facets 5.01/4.71, Oracle 11g, SQL Developer 9.06, Informatica 9.x, Win2K, and UNIX.

Confidential, Lansing, MI

Sr. Cognos Consultant/Architect

Responsibilities:

• Provided vision, lead, develop, implement, maintain and administer Cognos BI throughout the life cycle of the projects such as Key Finance, EBSP HR, OPB etc.
• Analyzed the current ongoing process and given inputs/suggestions on moving forward like using Cubes, Implementing DMR, usage of DQM and what the infrastructure supports.
• Involved in migration of Cognos versions from 8.4 and10 environments using Life Cycle Manager.
• Guided, design involvement, Tested a pilot implementation for DQM for future Dynamic Cubes Environment.
• Provided inputs on Cognos Portal Security for Dev, Test, and Prod environments.
• Provided a POC for new Active Reports Dashboard.
• Provided POC on pilot TM1 Process.
• Solutions to different bottle necks (report performance, modeling issues), suggesting and implementing best practices in the Cognos environment.
• Worked on Analysis, Model, Design, Integration, Development, Testing (Unit, Integration, UAT) and documenting of Cognos Models.
• Analyzing the reporting specifications and giving inputs to the Business Team on Report Specification.
• Involved in group meetings on current issues, DSR’s, tickets raised and weekly agenda for Cognos Modeling.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Involved in meetings with ETL team on implementing Data Stage Business Glossary.
• Conducted testing on Budget, Finance, and HR Reports for different runtimes, monitor performance for various specifications.
• Reviewed training agenda and documentation for 350 Query Studio Users across MSU campus.

Environment: Cognos 10.x, CC, FM, RS, QS, TX, AS, Cognos Workspace, Cognos Workspace Advanced, Cognos Planning, Analyst, Contributor, KFS Finance, SAP ECC, SAP HR, Oracle 11g, SQL Developer 1.5.5, Data Stage 8.x, Non-Transport Migration Tool, Win2K, and UNIX.

Confidential, Auburn Hills, MI

Sr. Cognos Consultant/ Architect

Responsibilities:

• Worked on Analysis, Design, Integration, Development, Testing (Unit, Integration, UAT) and documenting of Models, Cognos Dashboard, Reports.
• Involved in SAP-Cognos integration issues with the team to resolve issues and have smooth reporting.
• Conducted Team meetings and prepared workflow, notes on handling how Legacy data can be brought into Cognos along with SAP data and build reports out of it.
• Provided inputs on Cognos integration to Confidential In-house-Portal.
• Developed FM Models from BEx Query and Models involving Legacy and SAP data.
• Analyzing BW technical documents and preparing Cognos Reporting Documents.
• Worked on Building report prototypes, unit testing strategy.
• Ensured Quality of Enterprise Dashboard, Cognos reports involving data from AP, AR, and COPA.
• Reviewed strategy on building Adhoc Reports for Business Users.
• Crafted a plan, training agenda and access limitation for Power users.
• Involved in analyzing Cognos integration to CAPSPIN portal.

Environment: Cognos 10.1.1, FM, RS, QS, AS, SAP Business Explorer 7.X, Analyzer, Report Designer, Query Designer, SAP ECC, DB2 UDB, Data Stage 8.x, Mainframe DB2, DB2 Connect Control Center, Win2K, and UNIX.

Confidential

Responsibilities:

• Conducted Team meetings and verified data can be brought into Cognos and model it and build reports.
• Maintaining the offshore team and be a facilitator to the Business Team and make sure the required solution is achieved.
• Prepare Model for report needs; build Test cases and Unit Test the reports.
• Prepare the Dashboard and troubleshoot for better performance and burst it to required users.
• Migrate Business Objects reports into Cognos 10.
• Analyze the compatibility and issues.
• Document the process and maintain versions of code for Backup purposes.

Environment: Cognos 10.1.1, FM, RS, QS, AS, BOBJ, DB2, DB2 Connect Control Center, Win2K, and UNIX.

Confidential, Warren, MI

Sr. Cognos Consultant

Responsibilities:

• Analyzed GPSC documents on Cognos BI Area.
• Prepared presentations on Cognos End-to-End Monitoring.
• Analyzed Mars Incident Analysis Errors on identifying ITIL process and streamlining errors types.
• Worked on VOC Issues in GM VOC Cognos Portal Dashboards.

Environment: Data Stage 8.x, Cognos 8.4/10.x, FM, RS, QS, AS, Oracle 10g, Oracle SQL Developer, DB2 UDB, DB2 Connect Control Center, Win2K, UNIX.

Confidential, New York, NY

Lead Cognos & DW Consultant

Responsibilities:

• Built and Lead the Cognos BI Team for Credit Risk and multi tasked sharing some duties.
• Studied the Current environment by doing gap analysis and suggested changes to the current environment.
• Participated in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Extensively worked in table design, creating the ETL functional mapping documents.
• Develop ETL jobs using the Data Stage 8.1, write oracle Pl/Sql scripts, and UNIX shell scripts as per the functional and technical specs provided by the client.
• Designed complex DataStage Jobs, sequences and tuned them for better performance.
• Responsible for preparing ETL Documentation for the developed processes.
• Extract data from different source systems (Flat files, Oracle DB) move them into the warehouse and mart.
• Responsible for preparing Unit test cases and validating the data as per the business rules.
• Involved in preparing Integration test cases, UAT test cases and involved in UAT testing.
• Involved in tuning many Oracle scripts and other ETL processes used in this project.
• Created reusable metadata in Framework Manager.
• Developed time dimension by determinants to specify the levels of granularity.
• Created Presentation View identifying conformed and non-conformed dimensions.
• Created User Accounts for business users, set security and user access for business users and developers in Framework Manager
• Developed model with multiple OLAP data sources in Framework Manager.
• Developed statement style reports and advanced crosstabs.
• Created MOLAP Cubes achieving faster query performance by multidimensional indexing, optimized storage and caching.
• Created model and thereby Power Cubes and added security in Cognos 8.4 Transformer.
• Published cubes from existing queries for sub-second response times and additional OLAP exploration.
• Created reports based on Query Relationships and distributed reports through Bursting.
• Developed Dashboards in Report Studio for CARM.
• Created reports involving dynamic sorting, dynamic grouping, conditional formatting, blocks, HTML items and hyperlinks.
• Involved in deployment of various report packages between various stages such as Development, Integration, QA and Production.
• Tuning of Report queries for better performance.
• Ensured the Quality of the Delivery and smoothly handled the process for timebound, scalable, hassle free solutions.

Environment: DataStage 8.x/7.x, Cognos 8.x, Oracle 10g, DB2 8.x, UNIX, AutoSys, DB2 Control Center, HP Quality Center 10, Win2K.

Confidential, Scranton, PA

Data Warehouse /Cognos Consultant

Responsibilities:

• Gathered reports requirements with Business Users and converted them in to project documentation.
• Developed Framework Manager Models.
• Used Cognos Connection to create and manage data sources, administer reports as well as ReportNet Server.
• Published the packages to development, test and production servers.
• Developed standard templates, charts, drill through reports, master detail reports in Report Studio
• Created reports involving dynamic sorting, dynamic grouping, conditional formatting, blocks, HTML items and hyperlinks.
• Developed Dashboards Report for BMO projects for identifying the performance of teams over the the current year and quarterly.
• Developed Dashboard reports for ET Domain which included A&H, IB, Investments, and International.
• Developed various mappings with multiple sources, targets, transformations and mapplets using Power Center Designer.
• Imported various sources, targets, and transformations using Informatica Power Center - Server, Server Manager, Repository Manager and Designer.
• Created reusable transformations, mapplets, worklets for mappings and workflows.
• Wrote PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Created metadata objects like source definitions, target definitions and built equivalent database objects with proper indexing.

Environment: Cognos Report Net: 1.1 (MR3)/Cognos 8.0 FM, RS, QS, Cognos 7.3, Access Manager, Oracle 9i, Informatica 7.X, Mercury ITG, Toad, Win2K, UNIX

Confidential, Detroit, MI

DW Informatica/BI Cognos Consultant

Responsibilities:

• Monitored the Informatica daily load and troubleshoot the failed mappings.
• Populated ETL from sources FF, Oracle, DB2/400 into Staging, DWH and Marts.
• Developed and maintained Slowly Changing Dimension (SCD’s, Both Type 1, 2 & 3) and Fact Tables in Informatica.
• Tuning Informatica mappings for bottlenecks and achieve better performance.
• Created DMR (Dimensional Meta Data modeling using Relational Database) models (Drill up, Drill down levels like PowerPlay) in FM for Analysis Studio.
• Used PowerPlay cubes as data sources in importing into Frame work Manager and created Models, Packages for Analysis Studio.
• Developed Dashboard report using List, crosstab, gauges, maps for monitoring the School System on Constellations, Attendance, MEAP, MIP, TeraNova based on School year & months.
• Worked on complex reports in Cognos ReportNet using Prompts and Tabular Sets.
• Created PowerPlay Cubes using PowerPlay Transformer.
• Published report’s to Upfront from Impromptu and Power Play using Impromptu Web Reports (IWR) and PowerPlay Enterprise Server (PPES).
• Involved in data modeling and design of data warehouse in star schema methodology with conformed and granular dimensions and FACT tables.
• Analyzed existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Worked on the student details files which consist of data provided by the 3rd party sources and internal systems like GearUp and Online Phonics.
• Used batch jobs for moving data for Renaissance from Oracle database.
• Worked on tuning of the databases Oracle and MS SQL Server.

Environment: Cognos 8.1.2/ Cognos Report Net: 1.1 (MR3) FM, AS, RS, QS, Cognos 7.3, Oracle 8i, DB2/AS400, MS SQL Server, Informatica 7.X, 5.X, PuTTy, File Net, Toad, Win2K, and UNIX

Confidential, Nashville, TN

Data Warehouse/Cognos Consultant

Responsibilities:

• Created Catalogs using Impromptu Administration, users and user classes in Access Manager, Assigned privileges to users and User groups on Impromptu Web Reports and Power Cubes
• Implemented security in Catalogs by defining filters on user class to control data access to the tables.
• Worked on Cross tab reports, drill-through reports with filters, Calculations, Predefined Conditions, Prompts, Groups, Association, Sort, Summarizing data, Functions, Styles, linked-sub reports and sub reports (Complex reports).
• Created IQD’s in Impromptu and used the query definitions as data sources for creating the model and cube in PowerPlay Transformer.
• Created drill-through from Cube to Impromptu and Impromptu-to-Impromptu.
• Created hot files and Snapshots to use in business presentations.
• Published IWR and cubes on upfront using Cognos Server Administration tool.
• Organized accessed data sources into transformer models, dimensional maps and developed Power-Cubes, which can be changed in many ways to slice and dice and drill-through data for further multi-dimensional analysis.
• Developed Power Cubes and developed PP reports in PowerPlay for Windows.

Environment: Cognos 5.x/6.x/7.x, Impromptu, PPT, PP for Windows/Excel, PPES, IWR Server, Access Mgr, Upfront, Informatica 5.x, Oracle7/8i, SQLserver2000, Windows NT/2000 and Unix.

Confidential, Dayton, OH

Research Teaching Assistant

Responsibilities:

• Research on Non-Linear 2nd Order BVP and Differential Equations.
• Monitoring Math Lab for students issues on Mat Lab and Maple software's
• Tutoring Students for Doubt sessions on 100, 200 and 300 level courses.
• Grading for Tests and Assignments, Lab Sessions and assisting Professors.
• Conducting School wide internal mandatory tests as part of Program Requirements.
• Involvement in Math Symposium, Seminar's in Math club, Organizing Math Picnics.

Environment: Mat Lab, Maple, MTH courses, Boundary Value Problems, Differential Equations