Summary:

Over 11 years of focused IT experience in Data Warehousing, Database designing, Development of Business Intelligence Applications, System Implementation, Migration Maintenance Quality Assurance ISO 9001 and SEI CMM 5 across various business domains like Health Care, Media, Banking Finance, Insurance and Manufacturing

Sound 7 years of Development Admin experience with Cognos tools 10.1/8.3 Suite - Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Business Insight/Workspace Advanced, Active Reports, Adaptive Warehouse AW , Adaptive Analytics , TM1 Web, Data Manager, Cognos EP Series 7.x Impromptu, Impromptu Web Reports, PowerPlay Transformer, ReportNet 1.1 MR3, Access Manager, Upfront

Certified Cognos 10/8 Administrator, Report Developer and Metadata Modeler Framework Manager

Expertise in modeling with Cognos Framework Manager/ Transformer Importing source and establishing relationships, implementing Data Abstract Layers for Ad-Hoc and dimensional/DMR model reporting, creating/publishing Packages/model for OLAP Cubes

Extensive experience of 6 years in designing and developing data marts/warehouse using Informatica PowerCenter tools viz. Designer Source Analyzer, Mapping Designer, Warehouse Designer / Workflow Manager

Expertise in designing ETL load flows, jobs using Cognos Data Manager to populate data marts

Hands-on solid experience with Cognos Adaptive Warehouse packages/models and configuring data flows to be used in conjunction with Adaptive Analytics AA reports/analysis

Expertise in developing catalogs and reports including IWR using Cognos Impromptu

Worked extensively on RDBMS: Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000 including SSIS/SSAS

Sound knowledge of SQL, PL/SQL, T-SQL , Unix Shell Scripting and Windows batch scripts

Experience as Team Leader on BI platform and onsite/offshore co-ordination

Trained on Cognos 10.1 by IBM. Also trained on Cognos ReportNet 1.1/ PowerPlay 7.0 by SQLSTAR International Cognos Inc. Training Partners

Proficient in understanding business processes / requirements and translating them into technical implementation

Rich experience in all stages of SDLC/Agile including requirements gathering, designing documenting architecture, detailed client-server, development, testing, implementation and post-implementation support and following Quality Assurance ISO 9001 and SEI CMM 5 processes

A Team Player with good communication, analytical, verbal and writing skills

Work Experience:

Confidential

Role: Lead BI-DW Business Intelligence- Data Warehouse Developer

Description:

Blue Cross Blue Shield BCBS Texas is one of the 39 independently operating health insurance companies under the BCBSA umbrella. It represents the nation's oldest and largest family of health benefits companies and BCBS brands are most recognized in the health insurance industry.

Enterprise Dashboard Reporting is one of the enterprise level initiatives which cater to a Single-Sign On web-based reporting architecture, in an Agile environment, available to executive business groups, application users and BI focused teams. It has been developed to put forth Cognos as a seamless reporting architecture which can support multi users concurrent reporting and Operational / Marketing / Sales / Financial data needs.

Numerous Cognos Framework packages interfacing with a range of data sources including ERPs, SalesForce, SQL Server, Oracle, Oracle e-business suite and Teradata etc. are housed on Cognos 8.3 servers in a distributed gateways and dispatchers environment. Multi user groups with different levels of access and privileges are set supporting adhoc, online and scheduled reporting needs. Reporting system initially got upgraded to Cognos 8.3 from ReportNet, then to 10.1 and now to Cognos 10.2 upgrade in process

Technology

Cognos 10.1/8.3/ReportNet, PowerPlay, IWR / Impromptu Catalogs, Adaptive Warehouse, Data Manager, Adaptive Analytics, TM1, Maximo 6.2, MS SQL 2012/2008/2005 SSIS/T-SQL, SQL, Informatica 9.1, Cognos SDK, JavaScript, Cognos 10.1 Business Insight/Workspace Advanced, Upgrade Manager, Agile methodology

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, Report/ETL specifications and updating the team about developments
• Designed Complex Cognos Framework/reporting models spanning states/security
• Designed Cognos reporting models using Framework Manager and deployed packages to the Cognos8 Servers
• Data Modeling ER and dimensional involving tables/ indexes/ triggers/ procedures/ functions for Enterprise Reporting
• Implemented Star/Snowflake Schema and Dimensional Hierarchy in the models
• New Cognos 8/10 installations/maintenance optimizations using Cognos Best Practices
• Developed ETL load flows and data integration processes/jobs using Informatica, SSIS, T-SQL procedures, monitoring load runs and ensuring target marts are populated correctly
• Developed Enterprise Dashboard reports/portlets using 10.1/8.3 Report/channeling/ SDK/ JavaScript techniques. Currently working on upgrading the reports to Cognos 10.2
• Developed Dashboards, Scorecards, KPI multi-level, List, Cross tab, drill through, master-detail, charts which involved Multiple Prompts, Filters, multi-page, multi-query and Burst Reports, Active Reports using Cognos BI studios, Business Insight , JavaScript
• Extensively created Drill-through reports with Summary Charts , Detail List/Crosstab depictions
• Developed internal IT usage, SLA tickets reports for upper management review
• Instrumental in the upgrade to Cognos 8.3 from ReportNet. Modified reports XML, SDK, JavaScript for 10.1 compatibility for the recent upgrade initiatives to Cognos 10.1 and then to 10.2
• Used Sales Force Producers and SAP Brokers data dictionary to configure and populate Adaptive Warehouse models source/target/warehouse for the Slice-n-Dice of Brokers/IVR data through Adaptive Analytics reports
• Assisted in a streamlined process to migrate reporting systems from Cognos ReportNet 1.1 to Cognos 8.3 across different environments DEV/QA/PRODUCTION
• Created User Groups, Roles, Capabilities to implement Cognos Security
• Designed and developed Cognos Power cubes using Power play Transformer
• Created several Underwriter Workflow management tracking reports sourcing Maximo Work Order Module
• Assisted users/team members in troubleshooting reports and trained the users in creating Adhoc reports using Query Studio/Analysis Studio
• Developed TM1 cubes and TI Turbo Integrator processes/rules: Broker Units, Plan Allocations, Revenue by Accounts, Membership Counts, planning/forecasts models as part of Actuarial Reporting Systems support. Used TM1 Widgets into Business Insight Dashboards.
• Good exposure to Cognos TM1 Web Executive Viewer, Contributor
• Involved with upgrade of Benefit Malls producers reports from Impromptu/IWR to ReportNet/Cognos 8
• Re-designing Impromptu catalogs to Cognos FM Models
• Experience with Hadoop, Map-reduce to bring about portfolio migration of ad-hoc reporting system extracts. POC Proof-of-Concept outlining Mongo for performance benefits
• Configuration of Single-Sign On properties / Security parameters on Cognos servers and interface with an outside Web portal E-Sales
• Leading a team of 3-5 developers BI / ETL for the development and deployment activities in Agile development environment

Confidential

Role: Sr. Cognos Developer/Admin

Description:

This initiative required around 90 Access reports to be converted into Cognos 8.3 reports as the rental software application gets an upgrade from db2/Access to progress/Cognos.

Technology

Cognos 8.3, MS Access, DB2, Progress, Maximo 4.1.1

Responsibilities:

• Configuration of Cognos 8.3 stand-alone servers DEV/PROD
• Managing user groups, security and availability of the Cognos connection portal from intranet and external applications
• Detailed analysis of current production Access reports and DB2 tables/data
• Developed complex reports including List, Cross tab, drill through, master-detail, charts which involved Multiple Prompts, Filters, multi-page, multi-query and Burst Reports using Cognos BI tools , JavaScript
• Developed multiple operational reports tracking Inventory/Assets through Maximo

Confidential

Role: Sr. Cognos / BI-DW Developer

Description:

Viacom is a leading global entertainment content company and it operates through television, motion pictures and a wide range of digital media. Adsales system is the core of revenue matrix and spans across 70 of the overall business model. BI Reporting system provides complex yet centralized, strategic and operational reports to the Financial and Business Strategy groups of Adsales system. There are several modules transactional territories of BI Reporting viz. Proposal making, Deal Management, Billing, Inventory and Forecast modules. There are several multi-platform data marts designed and maintained for these modules. ETL process comprises loading these data marts from the transactional systems through SQL Server DTS, Oracle PL/SQL and Unix/Windows batch scripts.

Thereafter several reports including dashboards, drill-through List/Cross-tabs are sourced from the data marts to provide business reports using Cognos BI tools. Multidimensional data cubes are developed to enable a wide range of OLAP functionality. The system also got migrated/ upgraded from Cognos ReportNet 1.1 MR3 to Cognos 8.2, along with Demographic data IWR reports.

Technology

Cognos 8.2, Cognos ReportNet 1.1 MR3, PowerPlay, Cognos IWR / Impromptu, SDK , Oracle 10g/9i, SQL, Oracle PL/SQL, SQL Server DTS, SSRS, Windows Batch Programs, Toad

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, Report/ETL specifications
• Involved in Technical design architecture of Cognos reporting environments 8.2/ReportNet
• Supported Data Modeling ER and dimensional involving tables/indexes/ triggers/ synonyms/procedures/functions/partitioning for Adsales data marts
• Designed Cognos reporting models using Framework Manager and deployed packages to the Cognos8 Servers
• Implemented Star/Snowflake Schema and Dimensional Hierarchy in the models
• Developed Dashboards, List, Cross tab, drill through, master-detail, charts which involved Multiple Prompts, Filters, multi-page, multi-query and Burst Reports using Cognos BI tools , JavaScript
• Assisted in a streamlined process to migrate reporting systems from Cognos ReportNet 1.1 to Cognos 8.2 across different environments DEV/QA/PRODUCTION
• New Cognos 8 installations/maintenance optimizations using Cognos Best Practices
• Created User Groups, Roles, Capabilities to implement Cognos Security
• Designed and developed Cognos Power cubes using Power play Transformer
• Created data abstract views like database layer and business layers for role-based reporting. Developed custom prompts burst reports for different user groups
• Designed and developed batch scripts to automate Cube builds/Manage data sources/reports, landing pages using SDK Java
• Involved with upgrade of Auxiliary reports from Impromptu/IWR to ReportNet
• Re-designing Impromptu catalogs to ReportNet FM Models
• Assisted users/team members in troubleshooting reports and trained the users in creating Adhoc reports using Query Studio/Analysis Studio
• Performance tuning of complex reports
• Content Store reporting by querying underlying metadata tables
• Debugging reports for failures and data errors
• Export/Import of Reports across different environments Prod, QA, Dev
• Developed ETL load flow using DTS, Oracle PL/SQL procedures
• Developed certain business reports using SQL Server Reporting Services SSRS
• Co-coordinating a team of 3 developers 1 onsite/ 2 offshore
• Unit System testing of the Adsales BI Reporting system
• Managed software releases after each stage of the testing and defect removal
• Created, updated and maintained reports technical documentation

Confidential

Role: Informatica- DW Developer

Description:

AUM Assets under Management data mart is an enterprise repository of Banking - Deposit and Loan Accounts, which houses the entire customer transaction history for an enterprise wide reporting of balance and revenue information providing consistent data across all business applications and geographic locations and leverages management to make informed and well timed strategic business decisions. The data mart is loaded through a number of scheduled workflows extracting information through multiple sources Relational and File . The capability of Informatica as an ETL tool is completely realized in the system implementation. The system also got migrated/ upgraded from Informatica 7.1.3 to Informatica 8.1.1. Several business reports are developed using Siebel Analytics.

Technology

Informatica PowerCenter 7.1.3/8.1.1, Oracle 10g/9i, SQL, Oracle PL/SQL, Windows Batch Programming, PL/SQL Developer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica PowerCenter
• Analyzed business requirements to create system design, ETL and report specifications
• Migration/Upgrade from Informatica 7.1.3 to Informatica 8.1.1
• Determined informatica developer set up policies and procedures with request form, etc. grant rights and access, provide client tools and DB contacts
• Deployed Informatica workflows and mappings from one environment to another
• Technical design, development and debugging of Informatica mappings/mapplets, sessions, worklets/workflows
• Used relational sources and flat files to populate the data mart
• Debugging ETL loads for failures and data errors
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables
• Scheduling Informatica workflows for automation and monitoring load flow
• Used Debugger to test the mappings and fix them
• Export/Import of Mappings/Workflows across different environments Prod, QA, Dev
• Metadata reporting by querying underlying Informatica repository tables
• Responsible for Creating business solutions for Incremental and Full loads
• Modification of ETL tasks for Performance benefits

Confidential

Role: Database Testing Lead

Description:

The insurance policy data is first captured into an application product AQS/Advantage and then loaded to an operational data store CLDR. CLDR Commercial Lines Data Repository is designed to feed data to EDR Enterprise Data Repository for the business reporting needs. CLDR gets loaded from AQS/Advantage, a leading insurance product, accessible to a number of insurance agents, underwriters and end-users. The integrator module of AQS/Advantage generates a policy xml file as a policy gets recorded. The policy details, its various terms and the ISO data are produced in the xml file, which in turn is loaded into SQL Server

Technology

MS SQL Server 2005, Informatica 7.1.3, SQL, T-SQL, XML, MS Office

Responsibilities:

• Played a key role in Data verification/testing for CLDR
• Interacting with Subject Matter Expert/ Business Analysts for Data mapping from legacy systems to CLDR through Entity Relationship diagrams
• Testing of the CLDR data loaded from policy AQS XML
• Developed stored procedures/functions using T-SQL for the CLDR data testing
• Developed a QA process for the test strategy and the test plan
• Draft/execution of the test cases. Published naming conventions
• Monitoring, assigning and closure of defects in Defect Tracking System

Confidential

Role: Informatica-DW/ Cognos Developer

Description:

Data is loaded from the Oracle financial tables/EBS into the Oracle data warehouse, SCM Enterprise Data Store EDS , and various business reports broadly categorized for the respective Service Centers are developed using Cognos ReportNet. Oracle EBS/SCM supplies buyers, commodity managers, and executives common spend data for analysis across various centers namely Financial Service Center FSC , European Shared Service Center ESSC , CSPS, and ProCard.

Technology

Informatica 5.1, Cognos ReportNet / Impromptu, SQL, UNIX Shell Scripts, Oracle PL/SQL, Toad

Responsibilities:

• Involved in the enhancements of the Enterprise Data Store EDS and SCM Data Mart
• Understanding business processes / requirements and translating them into technical requirements
• Technical design, development and debugging of Informatica mappings/ mapplets, sessions, worklets/ workflows
• Supported Star Schema models, Business Data Layers, Data Sources in Cognos ReportNet Framework Manager
• Assisted Cognos reports development such as List reports, Cross Tab reports and Drill Through Reports
• Conversion of Impromptu reports to ReportNet
• Performing roll up and group testing of the data
• Developed Unix C-Shell scripts for file validations
• Maintained stored procedures and packages using Oracle PL/SQL

Confidential

Role: SQR Reports / ETL-DW Developer

Description:

In Blue Chip data mart system, the dealers and the sales offices will be submitting sales and inventory data to FTP site in prescribed file formats comma delimited on a daily basis. This data needs to be uploaded into the Oracle data warehouse. The reporting requirements were to drill the potential dealers and the competitors for the Blue Chip program.

Technology

SQR, SQL, Oracle 9i, PL/SQL, Unix Shell scripts, ERWIN 2.2, Maestro Scheduler, Toad

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing and rollout to the field user and support for production environment
• Involved in interacting with the business community to understand their reporting requirements
• Involved in the design of GIBC data mart and OLAP enhancements of the system
• Worked with Business Users to model Fact and Dimension Tables
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time
• Developed Blue Chip reports using SQR
• Scheduling batch reports, queue them in a job
• Unit and System testing of the Business Reports

Confidential

Role: ETL-DW Developer

Description:

Project streamlining data flows to directly feed the integrated data warehouse. The ETL process loads a variety of information into the data warehouse on a daily basis. Information pertaining to sales invoice details , orders, customer master, product master, GL adjustments, cash call and plan are fed from Oracle 11i Apps, SAP and NONERP or NONSAP flat files. The loads are either incremental or full.

The complete ETL functionality is realized using Oracle PL/SQL and Unix scripts. Project also involved enhancements to dimensional design of the OLAP model.

Technology

SQL, Oracle 8i, PL/SQL, HP-UX, Unix Shell scripts, Toad

Responsibilities:

• Extensively interacted with business users and involved in requirement gathering, prototyping, ETL load flow design
• Extensively worked on SQL, Oracle PL/SQL, Query performance tuning
• Maintained and developed the ETL load-flows for the source systems data extractions, data transformations, data staging, movement and aggregation
• Developed Oracle packages for implementing business logic
• Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases
• Created materialized views to increase the query performance for summary tables
• Managing Database Objects tables/views/packages/indexes across different environments Production, Dev or QA
• Prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.

Confidential

Role: Programmer

Description:

AMR system was designed to automatically collect the meter reading from households using VB6 front-end and telephone line interfaces and micro-controllers.

Technology

SQL, Oracle 8i, PL/SQL, VB6, Assembly Programming Microprocessor

Responsibilities:

• Database design and creation of database objects like tables/procedures/triggers
• Creating front-end for AMR users using VB6
• Implementing business logic through stored procedures and assembly language
• Involved in writing project documentation