Candidates About

Pallavi Gupta

PROFESSIONAL SUMMARY

●      Having 7+ years of professional experience in Sales and Financial Industry with Software Design, Development, Analysis, Testing, Datawarehouse and Business Intelligence Applications.

●      Excellent experience in Cognos 8.4 ,Cognos 10.1, Cognos 10.2.1 and Tableau 10.3

●      Extensive experience in Cognos Report studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Workspace Advanced, Framework Manager and Powerplay transformer.

●      Working knowledge of SAP Business Objects - Analysis, Modeling, Design, reports development and dashboard analytics.

●      Extensive experience in Transformer model design and Powerplay cube building.

●      Strong Complex Reporting skills - Drill-Through, Dashboards, Summary Reports, Burst Reports, Ad-hoc reporting and Advanced report authoring.

●      Utilized Best Practices and Proven Methodology in modelling data, Cognos , Tableau and other BI development processes.

●      Experience in Active reports which made offline analytics easy to get portable business intelligence.

●      Implemented parametrized HTML URL’s for calling one Cognos report inside another Cognos Report.

●      Written SQL Queries to conduct Unit testing for various reports.

●      Extensive experience on production support and troubleshoot/test issues with existing reports.

●      Strong experience with Client interaction, understanding business applications, business data flow and data relations.

●      Created dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver data insights.

●      Worked with different databases like Oracle 9i/10g/11g.

Technical Skills:

BI Tools

Cognos 8.4,10.1,10.2.1 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace and Cognos Workspace Advance, Tableau 9.0,Powerplay transformer.

Databases

Oracle 9i/10g/11g

Client: Bank of America                                                                                   May 2013 – Till Date

Project: Data Quality Analysis and Reporting

Role: Sr. Cognos Developer/Tableau Developer

Responsibilities:

●      Involved in full development life cycle (SDLC) with Cognos from developing business requirements to QA and production environment.

●      Analyzed and converted business requirements to technical specifications.

●      Created Packages and DMR Models in Framework Manager by importing metadata from various sources with use of data modeling.

●      Developed Reports using Analysis Studio, Query Studio, Report Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance and Active Report.

●      Extensively worked with Sliders, Data Cards, Drop Down Menus, Radio Buttons and Tab Controls.

●      Generated various List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, Drill -Through Reports and Ad hoc Reports.

●      Customized data by adding Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.

●      Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.

●      Created complex reports in Report Studio such as Conditional formatting, Dashboards and drill through reports.

●      Used Event Studio which triggered a set of daily jobs.

●      Implemented Security at Object Level, Data Level and Package Level in Framework Manager.

●      Scheduled the reports in Cognos Connection and distributed them via mail.

●      Troubleshooting the existing Framework models.

·         Migrated reports from Cognos 10.1 to Cognos 10.2.1.

·         Worked closely with business power users to create reports/dashboards using Cognos Workspace and Workspace advanced.

·         Converted SQL based reports to use the FM.

·         Extensive use of HTML iframes to call Cognos Reports.

·         Created various reports using packages published from cubes.

·         Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

·         Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data

·         Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

·         Involved in System Testing and created test cases for different reports.

Client: TCS Mumbai                                                                                         Mar 2010 – Apr 2013

Project: Trimatrix

Role: Cognos Developer

Responsibilities:

●      Involved in Development, Testing, Deployment and scheduling of reports.

●      Documented the complete production process and Framework Model Designs.

●      Designed DMR data models and published packages using Framework Manager.

●      Scheduling reports using event studio.

●      Created User Groups, Roles in Cognos Connection to implement the Security Features.

●      Data validation of reports using query studio, framework manager and report studio.

●      Portal page development with HTML references to report views.

●      Security setup with folder structure organization and usage specify group security setup.

●      Performance tuning of Cognos Reports, FM model.

●      Involved in Strategic Planning for Cognos Framework Model.

●      Organized the metadata as per the requirement in folders and namespaces in Framework Manager.

●      Used Framework Manager to build models containing query subjects,

query items and namespaces from imported metadata, create packages and publish packages to the Server.

●      Built models containing query subjects, query items, and namespaces from imported metadata.

●      Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.

●      Developing standard reports, Charts, Drill through reports, Master Detail Reports using Report Studio and ad hoc reports in Query Studio and Analysis Studio.

●      Created list reports, cross tab reports, chart reports using Report Studio.

●      Developed Drill Through and Drill Down Report.

●      Created query prompts, calculations, conditions & filters, prompt pages, using Report Studio for several reports.

●      Created complex reports using conditional formatting.

●      Scheduling and distributing reports through Schedule Management in Cognos Connection.