LiveCareer-Resume

senior consultant resume example with 10+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Summary

Around 17 years of experience in IT as senior developer, Technical Lead, BI Analyst specializing in core Cognos Analytics/BI, Power BI, Informatica development and supporting TM1 Application. Expert level experience in developing Data Warehousing/BI applications using Cognos BI, Power BI and ETL tools with deep understanding of business domains such as Banking, Retail, Health care, health insurance and manufacturing sectors.

Skills

TECHNICAL SKILLS

Functional

Business Requirements Analysis and Process mapping

Data Modeling

Logical Model, Conceptual Model, Physical Model, Star-Schema Modeling, Snowflake Schema, FACT & Dimension, OLAP, HOLAP, MOLAP and ROLAP

BI Tools

IBM Cognos BI Analytics/10.2.1/8.x(Cognos Connection, Framework Manager, Report Studio, Powerplay Transformer, Query Studio, Analysis Studio, Cognos Workspace, Cognos Workspace Advanced, Event Studio, Drill-Through Definitions and Active Reports).

Cognos TM1: Web forms, Templates, TI Processes, Rules and Perspectives and SAS

Visualization Tool: Power BI and Tableau 8.x

ETL Tools: Informatica7.2

Operating Systems: DOS, WindowsXP/2000/NT/98/Linux/Unix

Languages: SQL, PL/SQL, C, C++ and Java

Databases: Teradata 12.0, Oracle10g/9i/8i, SQLServer2005/2000/6.5, DB2 & MS Access

Change Management Tools: Service Now

Certifications:

Cognos Impromptu Product User Certification

Cognos Impromptu Product Professional

PowerPlay Product Professional Version 2

Cognos Report Net 1.1 Product User

Experience
Senior Consultant, 02/2017 to Current
Trc Companies, Inc.Gainesville, FL,

Cognos /Power BI Developer

Client: Highmark Health Solutions Pittsburgh, PA

HMHS reporting application is a solution that has reports on Health/Medical data to support client operations (Highmark, IBC, BCBSMN, BCBSNT and BCBSWY etc.) systems for ECS/HIBS/Sales (DCM)/ICIS/PSAR /Claims/OPIS applications. These reporting solutions have a series of (Summary and Detailed) reports with automated calculations for Health data.

Responsibilities:

· Responsibility to build a reporting platform per requirement from customers.

· Involved in gathering the requirements and took it from white board to implement reports using Cognos.

· Created appropriate models in FM and created reports out of it using Report studio.

· Response in identifying data for decisional BI reporting and worked on POCs for WY and NT

· Response in creating metadata from different data sources

· Response in delivering complete reporting application to business

· Involved in complete data analysis in terms of reporting requirement perspective.

· Converted complex SQLs which are having thousands of lines of SQL codes into Cognos reports.

· Converted SAS dataset into Cognos reports

· Used recently introduced Power BI to create self - service BI capabilities and used tabular models

· Responsible for building reports in Power BI from the Scratch

· Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests

· Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries

· Experience with Power BI stacks like, Power Query, Power Map, Power Pivot, and Power View

· Worked with both live and import data into Power BI for creating reports and good working knowledge of power Bi gateway and service

· Preparation of Unit test results before moving reports to UAT and provided support to UAT and supporting production migrations.

Environment: IBM Cognos Analytics/COGNOS 10.2.1 (Framework Manager, Report Studio, Query Studio, Event Studio), POWER BI, Oracle, Teradata, DB2, SAS, and SQL server.

Data Warehousing Analyst , 09/2015 to 01/2017
Gantec Publishing SolutionsCity, STATE,

Client: Huntington National Banking, Columbus, OH Aug’2016 to Jan 2017

Goal of this project is to develop a composite BI report to capture contact and response history based on offers that is provided by bank and campaign treatment detail from real time campaigns.

Responsibilities: -

· As a senior Developer, responsible for the end-to-end BI development and support activities

· Involved in gathering the requirements and created technical design documents

· Creation of Data sources, User Classes based on data classification and Functional Ids with DB roles to read data from EDW

· Created appropriate models in FM and Created Reports using Report Studio and Ad- Hoc reports using Query Studio

· Response in identifying data for decisional BI reporting

· Response in creating metadata from different data sources

· Extensively worked on performance issues with queries and reports and worked in enhancement of existing reports and report bug fixes per the user request

· Extensively worked on performance issues with queries and reports and worked in enhancement of existing reports and report bug fixes per the user request

Environment: Oracle 13.8, Cognos 10.2.1(Framework Manager, Report Studio, Powerplay Transformer, Cube Designer and Query Studio)

Cognos BI/TM1 Developer Sep’2015 to Jul’2016

USAA, San Antonio, TX

Goal of this project is to provide an integrated driver-based market, workforce, and finance tool which generates directionally correct outcomes to support the planning processes leading up to Strategic and Operational Planning and it has facilitated additional processes which include expense escalation, risk management stress scenarios, and sensitivity/efficiency analysis.

Responsibilities: -

· Assist analysis and troubleshooting source data which is feed to TM1 cubes from Cognos Planning Analyst and User Input CSV files by investigating TI script and TM1 rules

· Use TM1 Perspectives for Excel to slice the cube data for various data analysis

· Assist monthly forecast data refresh

· Maintain user security across the TM1 models in Architect

· Work with spread sheets and made available through TM1 web

· Assign several aliases and attributes to different elements and applied various formats for measure in the dimension and worked with subsets and TM1 cube views

· Good at excel in writing complex calculations, Pivot, V-look up etc

Environment: IBM Cognos BI 10.2.1, IBM Cognos TM1 9.5.2, TM1 Architect, Web, Perspective and Cognos Planning Analyst 10.1.1

Assistant Consultant, 02/2011 to 09/2015
TATA Consultancy ServicesCity, STATE,

CITI Bank, Irving, TX

Cognos Technical Lead

Project I: RACO Apollo Reporting - Sep’2013 to Sep’2015

Objective of this project is to create a usable data repository for RACO (Risk and Credit Operations) to track CITI card applications receipts, Approvals and the Decisions made the applications and the entire lifecycle of the application starting from its receipt till final decision.

Responsibilities: -

· Gathered requirements from financial analysts, field managers and translated them into business requirements

· Created high level and low-level design and presented walkthrough for approval

· Coordinated and managed offshore team located in India on daily basis

· Developed Cognos Framework Manager Model and packages for metadata layer using Cognos best practices

· Created dashboards and reports using Report studio and used MDX

· Created DMR models in framework manager in order to create multidimensional reports in analysis studio and report studio

· Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level

· Developed Cube based solutions for multi-dimensional analysis including Dynamic cubes

· Involved in performance tuning activities

· Identified subject’s areas for reporting and ad-hoc query purposes

· Prepare a unit test plan and SQL scripts that will cover all the functionalities and logics and run those in Quality center

· Assist in implementation of the Cognos objects to the production environment

· Used Service Now (Ticket Management Tool) for Request tickets, incident tickets, Change management, etc

· Plan and scheduled the report to run at desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using Autosys tool

· Provided user training to basic and advanced users and supported any adhoc requests

Environment: Cognos 10.2.1/8.4 BI (Framework Manager, Report Studio, Powerplay Transformer, Cube Designer and Query Studio) and Teradata 12.0

Project II: Portfolio Review and Cohort Reporting Feb’2011 to Aug’2013

Portfolio Review Cube provides a comprehensive view of key metrics for CITI Brands portfolio analytics and it tracks the monthly data and provides comparison across the months and the portfolios. Portfolio review cohort cube was created to track customer behavior, revenue opportunities and proactive risk avoidance on a cohort basis (Freezing of accounts on a quarterly basis and tracking changes for 36 months)

Responsibilities: -

· Developed the models using Framework Manager

· Created dashboards and reports using Report studio and developed partition-based cubes solutions using Cognos Transformer

· Created cube views to support Ad-hoc data requests

· Optimized the reports and their queries to improve the report performance

· Assist in implementation of the Cognos objects to the production environment

Environment: Teradata 12.0, Cognos 10.2.1/8.4 BI (Framework Manager, Report Studio, Powerplay Transformer, Cube Designer and Query Studio)

Mascon Global Limited Senior Software Engineer Aug’2009 to Jan’2011

Deemsysinc Programmer Analyst August 2008 to July 2009

Satyam Computer Services Band S2 January 2005 to August 2008

Pace Automation Ltd Software Engineer December 2002 January 2005

Clients: Mckinsey, DuPont, Sony, Unilever, Citigroup, Standard

Charted Bank and Best &co

Education and Training
Master of Science: Computer Applications, Expected in
Bharathidasan University - Tiruchirappalli,
GPA:
BBA: Business Administration, Expected in
Bharathidasan University - Tiruchirappalli,
GPA:
Websites, Portfolios, Profiles
  • linkedin.com/in/Jessica-Claire-154698106

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Bharathidasan University
  • Bharathidasan University

Job Titles Held:

  • Senior Consultant
  • Data Warehousing Analyst
  • Assistant Consultant

Degrees

  • Master of Science
  • BBA

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: