SUMMARY

• Business/Systems Analyst with expertise in Data Analysis, Data profiling, Data mapping, Data Quality, Data Capture, Data Integrity, Data modeling, Data querying, Data extraction, Data Transformation and Data Loading . Worked with various data sources like Oracle, Teradata, Essbase, SQL Server, DB2, MS - Access and Flat Files.
• Project experience includes working directly with the Business users to better understand tasks and reporting needs. Self-motivated, quick learner and strong problem solving skills.
• Experienced as Database Analyst in Database Management Systems.
• 10+ Yrs of expertise in Relational database systems & other ODBC compliance Data sources.
• 10+ Yrs of experience in EDW (Enterprise Data Warehouse) Architecture, data analysis, data profiling, and data mapping etc.,
• 6+ Yrs experience in Data warehousing Design, ODS operations.
• 8+ Yrs experience in Business Intelligence Analytics.
• Excellent knowledge of Health Care, Financial and Mortgage business domains.
• Good Knowledge of Facets, CMS, DHHS, HIPPA, ICD, CHIP, SOX compliance procedures & Regulations.
• Health Insurance (Claims, Providers, Membership, Pricing & Reimbursement, Workflow, Billing, Commissions, Blue Card model, Blue ITS Processing (Host - Home)), HIPAA regulations, EDI 4010/5010, Health care reform / PPACA, ICD-10, National programs.
• Trizetto Facets 4.3/4.71/5.01 Architecture, Siebel CRM, VB scripts, Unix Shell scripts and automating the Informatica process.
• Good knowledge of NIEM, FIX, SWIFT, ebXML, XML standards and procedures.
• Good Knowledge of FI, FX, CD and other related financial products.
• Experience in all phases of the Software Development Life Cycle (SDLC) - Analysis, design, development, testing and maintenance.
• Worked in teams with large and small sizes successfully by supporting the team members in research, analysis, implementation, development and production.
• Strong analytical, technical, communication and interpersonal skills.
• Self-motivated, quick learner, team player, independent, accountable & problem solver.

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, Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), RTM (Requirements Traceability Matrix), JIRA, Oracle Primavera, OpenProj/ProjectLibre

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

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 , TeraData

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, Informatica Power Center 8.6/7.1.3/6. x/5.x

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, Micro Strategy, SSRS, BOBJ, SAP BW 3.5, Motio PI

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.

Application Servers: WebSphere, WebLogic, ColdFusion

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

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, Apparo, Accelatis Ascension Suite, Integration Control Suite, BI360

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr. DWBI/Cognos Consultant/Data Architect

Responsibilities:

• Analyzed the Informatica Loading process for Reporting Database as to have clarity on data.
• Gathered Business Requirements, analyzed data scenarios, build; unit tested, migrated Informatica Mappings and Sales Self Service Cognos Reports from DEV to QA and PROD.
• Analyse and design Reporting Database, ODS, EDW for Payer Data.
• Load and maintain mappings in DEV, QA, UAT, PROD, Pilot and Sandbox.
• Troubleshooting Source, Target, Session performance Issues
• Handling Repository Configuration, Folder Structure, and Security.
• Unix utilities-awk, grep, sed, vi,
• Analyse and involved in recommending CDC to lower the Production runtime from 18hours to 14hours.
• Analyzed part of the current ongoing process and given inputs/suggestions to the current Reporting and Modeling process.
• Analyzed the Extended Reporting Models for Tier data based on different loads like HPXR and EDW.
• Handled Service Requests for the team and conducted discussions with Sales & Operations Business and Functional Users as part of the validation process.
• Assisted peers in analysis and build interactive Cognos Active Report Dashboard for Rating Team and Sales Managers using different SSRS Reports covering Medical, Dental, Vision data with interactive column selection and bursting capabilities.
• Analyzed Facets Monthly Claims Maintenance data for the building Active Report for the Information Management user team.
• 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 Cube for Dashboard purpose.
• 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).
• Used Java Code for prompt selections and default display for reports in report Studio.
• Analysis & Solutions for Audit Drill Through Reports, MedImpact, Medicare, HCR, Self Service, Dual Enrollment, Siebel data into Cognos.
• Validating Reports with data from Reports to match for Facets Claims.
• Implementing Modeling, Reporting Best Practices.
• 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, Facets 5.01/4.71, Oracle 11g, SQL Developer 9.06, Informatica 9.x, Win2K, and UNIX.

Confidential, Lansing, MI

Sr. BI/Cognos Consultant

Responsibilities:

• Understanding Project Plan, Timelines, gather Requirement document, preparing HLD, LLD, test Cases
• Analyse, Design, Troubleshoot HR DataStage Jobs for better performance.
• Loading Staging
• Setup Business Glossary by working with Data Stewards, ETL and BI admins thereby saving design time and cost for reporting team.
• Involved in Migrating Jobs between DEV, QA, UAT, PROD.
• Involved in upgrade from 8.x to 9.x
• 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.
• Solutions to different bottle necks (report performance, modeling issues), implementing best practices in the Cognos environment.
• Shared inputs in Budgeting process for new development and managed Reporting Team
• Worked on Analysis, Model, and Design, Testing and documenting of Cognos Framework and Transformer Models and maintaining versions using CVS Tool.
• Build DMR Model prototype to compare it with Finance Cube to check performance and report run time.
• Analyzing the reporting specifications and giving inputs to the Business Team on Report Specification.
• Worked on HR Payroll Models (OMPA Actions, Cost Distribution, and Labor Distribution) and Finance Models (GL, PETS, CAM, CA, and PURAP) during design, unit testing, functional testing, moving to QA on integration issues with the team to resolve issues and have smooth reporting.
• Involved in group meetings on current Model issues, DSR’s, tickets raised and weekly agenda for Cognos Modeling
• Tested Budget, Finance, and HR Reports for runtime, performance and for specifications.
• Answer Business User tool Training Questions, Reviewed plan, training agenda, and documentation for 250 Query Studio Users.
• Collected ARM forms and review on who needs what type of access for Query Studio users.

Environment: Cognos 10.1.1, FM, RS, QS, AS, KFS Finance, SAP ECC, SAP HR, Oracle 11g, SQL Developer 1.5.5, Data Stage 8.x, 9.x, Non-Transport Migration Tool, Win2K, and UNIX.

Confidential, Auburn Hills, MI

Sr. Cognos Consultant

Responsibilities:

• Worked on Analysis, Design, Integration, Development, Testing (Unit, Integration, UAT) and documenting of Cognos Reports.
• Analyzing BW technical documents and preparing Cognos Reporting Documents.
• Worked on SAP-Cognos integration issues with the team to resolve issues and have smooth reporting.
• Conducting meetings and preparing presentations, notes on handling how Legacy data can be brought into Cognos along with SAP data and build reports out of it.
• Developed FM Models from BEx Query and Models involving Legacy and SAP data.
• Worked on Building reports, unit testing them by comparing Cognos output with BEx Output and doing Integration testing and verifying business see right data.
• Worked on Cognos reports involving data from AP, AR, and COPA.
• Worked on building Adhoc Reports for Business Users.
• Prepared 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, 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, St. Paul

Sr. BI/Cognos Consultant

Responsibilities:

• Studied the current environment from Architecture point of view and suggested changes for long-term implementations on the current ongoing process such as use of ETL, reporting database and Cognos 8.4 Virtual View Manager.
• Provided effort estimates for the new Cognos BI process on tax reclaims, income and design of executive dashboard.
• Worked with business analysts on requirement gathering & design on custody products based on the mockups & data mapping docs.
• Worked with SME & Data Architects on code validations.
• Developed the Executive Dashboard Report in Report Studio as we are having issues building scorecard in Cognos 8.4 Metric Studio.
• Modified the SQL query for referencing it for in various data elements and calculations.
• Developed complex reports involving multiple report, prompt pages and queries.
• Developed reports and bursted the report output to business users in Report Studio.
• Formatted reports using padding, borders and multiple features to fit in the Cross Tabs and referenced Bar Charts, Pie Charts.
• Developed & modified the Report Views for business users to add comments in PDF & HTML.
• Checked & validated SQL after referencing data in multiple databases Oracle & DB2.
• Worked with on-site/ offshore model of team and delivered.

Environment: DataStage 8.x, Cognos 8.4/10.x, FM, RS, QS, AS, MS, Metric Manager, SDK, Oracle 10g, Oracle SQL Developer, DB2 UDB, DB2 Visualizer 7.5.1, DB2 Connect Control Center, Win2K, UNIX.

Confidential, New York, NY

Cognos & DW Consultant

Responsibilities:

• 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.

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

Senior Certified 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

Data Warehouse/Cognos Consultant

Responsibilities:

• 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.
• Implemented Slowly Changing Dimension (SCD’s, Both Type 1 & 2) in Informatica.
• 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, Toad, Win2K, and UNIX

Confidential, Dayton, OH

Research Teaching Assistant

Responsibilities:

• esearch 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

Confidential

Intern/Oracle Developer

Responsibilities:

• Was involved in gathering the business requirements of the system
• Designed and developed Forms and reports using Oracle Developer 2000
• Involved in analyzing and designing of the Oracle database tables.
• Coded User-defined procedures and functions using SQL and PL/SQL.
• Production Support, which involves solving user problems.
• Reviews of change requests handled by other team members.
• Communication with the client via mails and also teleconferencing.

Environment: Oracle 7.3, SQL* Loader, Oracle Developer 2000, UNIX, PL/SQL.