Manager Data Analyst

Pallavi Gupta

BI Consultant

Email ID – adjyrd@r.postjobfree.com

Contact No - 609-***-****

PROFESSIONAL SUMMARY

●Over 10 years of professional experience in Information Technology with Software Design, Development, Business Analysis, Testing, Datawarehouse Concepts and Business Intelligence Applications using Cognos.

●Over 5 years of Tableau development/Analyst experience including designing, developing reports and dashboards.

●Strong knowledge in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Development, Implementation, Testing and Distributed applications.

●Excellent experience in Cognos8.4, Cognos10.1, Cognos10.2.1, Cognos Analytics 11 and Tableau 10.X.

●Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data warehousing concepts, Data Marts and Dimensional modeling Star schema and Snowflake schema using Framework Manager in Cognos.

●Extensive report writing experience using Cognos Report studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Workspace Advanced, Framework Manager and Cube designer.

●Expertise in requirement gathering, Analysis, Design, Development, Deployment, Testing and support of rich interactive compelling Dashboards, Workbooks and stories using Tableau.

●Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.

●Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.

●Good experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.

●Experienced in creating Quick Table Calculations, Static and Dynamic sets, Parameters and Level of Detail using advanced logical and statistical functions in Tableau Desktop.

●Experienced in URL Actions, passing parameters from Tableau to web applications.

●Strong Client interaction, understanding business applications, analytical, troubleshooting data and technical issues and problem-solving capabilities.

●Proficient in writing SQL queries for Reporting, Data Analysis, ETL validations and support Ad-hoc business requests.

●Conducted & managed daily agile sprints with teams sizes over 5.

●Used Scrum Agile Methodology in the project (Daily Scrum Meeting, Planning Poker, Sprint Backlog)

Technical Skills:

Tools

Cognos Analytics, Cognos10, Cognos 8.4, BI Framework Manager, Powerplay Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace and Cognos Workspace Advance, Tableau, Cube designer, TOAD, JIRA, Microsoft office.

Languages

HTML

Databases

Oracle 10g/11g, Microsoft SQL Server, DB2

Client: Citi Bank – Edison (Citi offsite) June 2018 – Aug 2019

Project: CTO Dashboard

Role: Sr. Cognos Developer/ Tableau Developer/Data Analyst (Onshore-offshore coordinator)

Responsibilities:

●Worked directly with the Line of Business to gather requirements, identify KPIs, performed gap analysis, prepared project plan and solution documents, and worked with offshore to ensure delivery of product within tight deadlines.

●Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos server.

●Implemented Star Schema Grouping and Dimension Hierarchy (DMR) in Cognos Framework Manager Model.

●Implemented Framework manager security for Data access, Object level access and Package access.

●Extensively designed and developed complex reports and dashboards using Cognos Analytics.

●Strong Complex Report skills - Drill-Through, Multi-prompt Reports, Dashboards, Summary Reports, Burst Reports, Ad-hoc reporting, Active Reports and Advanced report writing in Cognos.

●Excellent in use of Iframes for parameterized HTML URL’s for calling one Cognos report inside another Report.

●Proficient in writing SQL Queries as the input to create reports in Report Studio and testing of the reports.

●Excellent in report performance tuning, database tuning and Model tuning.

●Implemented row level Cognos Security in the report studio.

●Created new Cognos security groups and roles in Cognos Connection.

●Scheduling and refreshing of reports in Cognos Connection.

●Providing production Support and resolved maintenance issues.

●Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.

●Have extensively worked in AGILE environment by participating in daily stand up meetings, and Sprint planning at the end of every Sprint.

Client: Bank of America – Hopewell, NJ May 2013–May 2018

Project: Data Quality Analysis and Reporting

Role: Sr. Cognos Developer/Tableau Developer/Data Analyst – Onshore Lead

Responsibilities:

●Collaborate with business and development teams to understand and aid our customers in establishing and achieving their goals.

●Responsible for Report migration and packages from Cognos 10.X to Cognos Analytics.

●Excellent skills in creation of List Reports, Grouped Reports, cross tab Reports, Drill Through, Multi Page Reports, Repeater reports, Master-Detail Reports and Ad-hoc Reports using Cognos.

●Experience working with Sliders, Data Cards, Drop Down Menus, Radio Buttons, Tab Controls, Prompts, Filters, Conditional Formatting in Active reports.

●Involved in Cognos Security, user roles and groups in 3-tier environment and administered the Cognos Access manager user access, adding new users and modifying the existing user access.

●Scheduling of reports in Cognos Connection and distribution via email.

●Experience in Cube Creation using Cube designer.

●Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.

●Strong Experience on Tableau Desktop, Tableau Reader, Tableau Server and Tableau Online.

●Highly proficient in building, publishing complex interactive reports, analytical dashboards report, scheduling and refreshing to Tableau server.

●Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

●Experience with creating action filters, parameters, groups, and calculated sets for preparing dashboards and worksheets in Tableau.

●Created Tableau dashboards with KPIs having Line charts, Heat Maps, Scatterplots, Bar Charts, Symbol maps, Maps Text table, tree maps, Stacked Bar charts.

●Use of Joins, Cross Database Joins, Blends to extract data in Tableau.

●Use of Custom SQL in Tableau to get the required data and testing of reports.

●Perform routine maintenance support, and troubleshoot reported issues as well as determine root causes, and implement counter measures.

Client: TCS Mumbai Mar 2010 – Apr 2013

Project: Trimatrix – Malad, Mumbai (India)

Role: Cognos Developer

Responsibilities:

●Responsible for migration of Cognos 8 reports to Cognos 10.X version.

●Modeled and published packages in Framework Manager, and Cubes in transformer.

●Experienced in creating different types of security models using framework Manager.

●Developed complex metrics report related to compliance.

●Extensive use of Conditional Formatting, Graphical reports, Drill through reports, Drill down Reports, Master Detail Reports, List Reports, Crosstab Reports and Burst Reports in Cognos.

●Created query prompts, calculations, filters, prompt pages, Conditional Variables and Page Break.

●Customized data by adding Filters, prompts, Calculations, Summaries and Functions using Report studio.

●Writing of SQL queries for testing of the reports.

●Scheduled reports in Cognos Connection based on the reports to run daily, weekly, or monthly basis.

●Performance tuning of various Cognos Reports and Models.

●User Group, Roles creation in Cognos Connection to implement security.

Contact this candidate