PRIYANKA CHANDRA

Email:ac8qok@r.postjobfree.com

Cell Phone # 404-***-****

Professional Summary:

Over 12 years of experience in Information Technology and a wide range of progressive experience in leading projects, providing design, analysis, development, documentation, coding and implementation of the business technology solutions.

9+ years of strong working experience in IBM Cognos 8.3, 8.4, 10.2.1, 10.2.2 and 11.0.10 Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Event studio, Cognos connection.

Experience with Microsoft BI Suite (SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI).

Extensively used Report Studio for creating complex crosstab, list report, Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, Conditionally Formatted reports, Active Reports, Visualization report using Charts and RAVE, Interactive HTML Reports and Interactive Active Reports.

Expertise in dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

Experience in migration process between different versions of Cognos.

Worked with Different Databases like DB2, Oracle 11g, SQL Sever, Azure and database tool like SQL Server 3.2.20.09, Toad, MS Access and SQL Server Management Studio (SSMS).

Expertise in T-SQL and PLSQL for data extraction or data analysis.

Experience with stories and defect tracking using ALM, TFS and JIRA.

Possess Excellent Communication & Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills.

Hands on experience in developing reports in Tableau 8.3 and Qlikview.

Data Modeling with ERwin 9.6.

Repository Management using TortoiseSVN.

Technical Skills:

Business Intelligence Tool : Cognos 8.3/8.4/10.2.1/10.2.2/11.0.10 BI tools (Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection, Workspace Advance), Framework Manager, PowerPlay Transformer, Access Manager, Scheduler, Tableau 8.3, Microsoft BI Suite (SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI)

Data Modelling Tool: ERWin 9.6

Databases : DB2, Oracle 11g, SQL Server, Azure

Applications : Sharepoint, ALM 12.01, TFS, JIRA

Tools: Mantis, Eclipse, RAD, Microsoft Office, Visual Studio, SQL Developer 3.2.20.09, Toad, Dreamweaver, Tomcat, Macros, MS Access, SQL Server Management Studio (SSMS)

Languages : Java, C, C++, T-SQL, PLSQL, DAX, MDX

Web Technologies : HTML, JavaScript, CSS, jsp.

Repository Management : TortoiseSVN

Operating Systems : Linux/Windows NT/2000/XP/Windows 2007

Software Development Methodology : Agile, Waterfall, Iterative.

PROFESSIONAL EXPERIENCE:

APCO (EasyCare) (Sr. Business System Analyst Business Intelligence)

July 2018 - Till Date

Support the design, development and QA of EDW with existing and new system and database. Analyze the data in EDW. Support the reports and cubes build from EDW.

RESPONSIBILITIES:

Support Design, development and QA the Enterprise Data Warehouse.

Analyze the data flowing through EDW in Excel Power Pivot and SSMS.

Track the development and defects on JIRA.

Design and develop cubes to support reporting in SSAS.

Design and develop Excel format reports using SSRS.

Design and develop visual reports using Power BI.

Explore and implement the Row Level Security for data on cubes and reports.

Tools: Microsoft Suite (SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI Reporting), SQL Server and Azure database, JIRA.

General Motors Inc. (Lead BI Developer/Report Developer) May 2014 - July 2018

Global Purchasing and Supply Chain -: Lead multiple onsite and offsite project team of 7+ developers. Worked on Inbound and Outbound Logistics reporting, After Sales Reporting, Containers and Parts Tracking system Reporting, Supply Operations Reporting.

RESPONSIBILITIES:

Develop complex list, crosstab, conditionally formatted, drill through Reports, Interactive Active and Interactive HTML Reports, visualization reports using charts and RAVE, parameterized reports using IBM Cognos 10.2.1/10.2.2/11.0.10

Lead multiple onsite and offsite project team of 7+ developers.

Interact with business and BA’s to get the requirements and use ALM (Application Lifecycle Management)/TFS to view and track requirements and defects.

Develop dynamic and static reports, dashboards, framework models, complex conditionally visible and formatted reports and prompt pages using variables, parameterized, cascaded report filters, reports using custom reporting SQL.

Create Framework model and publish reporting packages for Reporting as well as Self Serve reporting package for Workspace Advance.

Develop triggers in Cognos to notify in instance of system failures.

Create reporting scripts in Oracle 11g using SQL Developer 3.2.20.09.

Create scripts for data extraction or data analysis.

Highly involved in production deployments.

Worked on software development methodology Agile, Waterfall and Iterative.

Hands-on experience in creating visual reports and dashboards with Tableau 8.3 and Power BI Reporting tool.

Data Modeling with ERwin 9.6.

Repository Management using TortoiseSVN.

Tools: Cognos 10.2.1/10.2.2/11.0.10, Oracle 11g, SQL Developer 3.2.20.09, Tableau 8.3, Power BI, ALM 12.01, TFS, ERwin 9.6, Tortoise SVN.

Blue Cross Blue Shield of South Carolina (Cognos Developer/Financial Analyst 2)

June 2010 – May 2014

Employer: Blue Cross Blue Shield of South Carolina October 2013 – May 2014

Employer: TM Floyd & Company June 2010 – October 2013

I have worked on Asset Management Reporting and Financial Reporting.

RESPONSIBILITIES:

Designed and develop Cognos reports using List, Crosstab, Chart, Drill through, Bursted, conditionally formatted, master-detail reports/

Created Dashboards to present critical company data in a single report.

Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Created reports using MS Access, MS Excel, Visual Basic and Macros.

Deploy reports to Production.

Migrated reports from Cognos 8.4 to Cognos 10.2.

Designed database to track the activities on Asset Management applications and tables.

Tools: Cognos 8.3/8.4/10.2, MS Access, MS Excel, Macros, HTML, jsp, Visual Basic, DB2, SQL Server

Celtic Cross Holdings Inc. (Software Engineer) 08/2009 – 06/2010

MINDTREE Pune India (Software QA Engineer) 03/2009 – 08/2009

CNBC / IBN Mumbai India (Software QA Engineer) 07/2007 – 03/2009

Knowledge Object (Intern Software Tester) 05/2006 – 05/2007

Education:

Bachelor of Engineering (Electronics & Communication) - Rajiv Gandhi Technical University, Bhopal(M.P) India

Certification:

IBM Certified Designer - Cognos 10 BI Reports

Trainings:

IBM Cognos 8 BI Report Studio: Author Professional Reports Fundamentals (V8.4)

IBM Cognos 8 BI Report Studio: Author Professional Reports Advance (V8.4)

Java Desktop Technologies (training) - Vedisoft Bhopal India

References: Available upon request

Immigration status: US Citizen

Contact this candidate