PROFESSIONAL SUMMARY:

• 8 Years of overall IT experience with strong BI reporting expertise in Cognos, BO and MSBI
• More than 5 years of experience in Cognos 8 BI tools using Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer
• 2 Year of experience in Business Objects tools using Universe Designer, Web Intelligence, Desktop Intelligence, Import wizard, LCM, CMC and Xcelsius
• 1 year of experience in MSBI tools using Power pivot and SSAS Tabular
• Creating reports in Cognos 10, 8 using Report Studio, Query Studio, Analysis Studio, Metric Studio, and Business Insight, Creating and publishing Relational & DMR packages using Framework Manager, cubes using Cognos Transformers and scheduled reports in Cognos Connection
• Built models containing query subjects, query items, and namespaces from imported metadata, Ensuring clear query paths by resolving ambiguous relationships (Role - playing dimensions, loops, reflexive and recursive)
• Created Multidimensional models in Cognos transformer using Framework Manager Packages, using IQDs
• Created reports in BO XI3 using Desktop Intelligence and Web Intelligence tools, scheduled reports in Info View, and built universes in Universe Designer
• Experience in resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, and Aggregate Awareness in SAP Business Objects Designer.
• Expertise in using CMC (Central Management console) for security, administrative needs, Applying Universe Access Restrictions, Linking Universes, and Managing Universes.
• Experience in creating and publishing Universes using BO Universe Designer, handled security using CMC, setting up Events for scheduling reports using triggers
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports using Report Studio and Query Studio. Working experience with different date functions in Report studio.
• Worked on filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users
• Created Dashboard reports, drill through reports, and drill up/down reports using cubes as a data source in Cognos report studio.
• Worked on dimensions, measure objects, hierarchies in WEBI, Worked on Alerts (conditional formatting), Drill down and Dynamic Visibility in BO reports.
• Experienced in developing Dashboard Reports using Portlet pages, Report studio in Cognos 8, Business Insight, active reports in Cognos 10 and BO Xcelsius
• Created SSAS Tabular models using SQL Server Data Tools and Deployed models, created reports using Excel PowerPivot
• Worked on calculated members, calculated measures using DAX formulas, setting up date dimension, date hierarchy in SSAS Tabular model and deploying Tabular models and scheduling them for daily refresh. Worked on connecting to data source, importing data, creating power pivot, filters and slicers and publishing to SharePoint
• Strong understanding of dimensional modelling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user
• Proficient in all phases of Data warehousing concepts, and experience in dimensional modelling using Star Schema and Snow-flake Schemas
• Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2005 and MS Access
• Strong experience in client interaction and understanding business application, business data flow and data relations from them, coordinate with offshore team and delivered projects on time
• Strong commitment towards responsibilities assigned and strong analysing skills, Good Interpersonal skills
• Exposure to Qlik View Reporting

TECHNICAL SKILLS:

Business Intelligence: Cognos 10 BI Tools (Report Studio, Query Studio, Metrics Studio, Powerplay Studio, Event Studio, Framework Manager, Cognos Transformer, Cognos Connection, Powerplay Enterprise Server and Access Manager), Business Objects (Web Intelligence, Desktop Intelligence, Universe Designer, Info View and Content Management Server), MSBI (Power Pivot, SSAS Tabular)

Databases: Oracle, SQL Server, MS Access

Programming: SQL, T-SQL/PLSQL, HTML, VBA, ASP .NET

Tools: MS Word, Excel, Power point and Visio, Toad11

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

BI consultant

Responsibilities:

• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Generated various List reports, Grouped Reports, Cross tab Reports, Drill Down and Drill through reports using Business Objects XI R3
• Created various analytics dashboards using MSBI PowerPivot, models using SSAS Tabular
• Created Universes using Universe Designer, Resolved loops, chasm and fan traps using contexts, aliases and integrity checks
• Involved in trouble shooting of various reporting errors
• Developed Xcelsius presentations/visualizations for Monthly Sales Analysis
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports
• Scheduled various reports in Info View and monitor the jobs
• Wrote detailed level documentation for reports and universe design
• Gathered and Analysed requirements from Users and Business Community
• Converted business and data requirement into functional and ad hoc data models
• Created website and Dashboards using HTML and ASP.Net
• Created Tables, Views, Stored Procedures, Synonyms using Oracle PL/SQL

Confidential, Hartford, CT

BI Consultant

Responsibilities:

• Created the reports using Cognos Report studio functionality's like Queries, Slice and Dice, Drill Down, Drill through, Cross Tab, Master Detail etc.
• Generated various List reports, Grouped Reports, Cross tab Reports, Drill Down and Drill through reports using Cognos Report studio
• Created adhoc reports using Query Studio, metric studio
• Created cubes using Transformers and created analysis reports using Analysis Studio and Powerplay Studio
• Created various relational, DMR models using Framework manager and generated IQDs
• Resolved Loops using shortcuts and Aliases
• Used Cognos Event Studio to report runs and notifications
• Involved in trouble shooting of various reporting errors
• Created Dashboards using Business Insight, Cognos Portlets
• Scheduled reports in Cognos Connections and monitoring the reports
• Wrote detailed level documentation for reports and model design
• Gathered and Analysed requirements from Users and Business Community
• Converted business and data requirement into functional and ad hoc data models

Confidential, Houston, TX

BI consultant

Responsibilities:

• Created the reports using Cognos Report studio functionality's like Queries, Slice and Dice, Drill Down, Drill through, Cross Tab, Master Detail etc.
• Generated various List reports, Grouped Reports, Cross tab Reports, Drill Down and Drill through reports using Cognos Report studio
• Created adhoc reports using Query Studio, metric studio
• Created cubes using SSAS and published the reports and users make use of them using Excel.
• Created various relational, DMR models using Framework manager
• Resolved Loops using shortcuts and Aliases
• Used Cognos Event Studio to report runs and notifications
• Involved in trouble shooting of various reporting errors
• Created Dashboards using Cognos Portlets
• Scheduled reports in Cognos Connections and monitoring the reports
• Wrote detailed level documentation for reports and model design
• Gathered and Analysed requirements from Users and Business Community
• Converted business and data requirement into functional and ad hoc data models

Confidential

Sr. Analyst

Responsibilities:

• Customer Communication.
• Offshore coordination & prioritization of work
• Issue resolution & progress monitoring
• Data quality management
• Process Analysis, Documentation & Reengineering
• Scheduling and monitoring Day-to-Day activities of the data feeds
• Reducing manual work by creating macros for regular activities

Confidential

Developer

Responsibilities:

• Customer & End User Communication
• Requirement Gathering and Analysis of the requirement
• Preparing Development specification
• Coding based on development specification
• Developed and Enhanced the above applications using VBA, Excel macros
• Creation of Databases, Triggers, Stored Procedures and Views
• Creation and Maintenance of DTS/SSIS packages
• Preparing & Testing System Test Cases
• Preparing UAT Test Cases
• Scheduling and monitoring Day-to-Day activities of the projects
• Handling production support work

Confidential

Developer

Responsibilities:

• Customer Communication.
• Requirement Gathering and Analysis of the requirement.
• Customization of PROMPT tool based on Customer specification.
• Validations and overseeing the Quality procedures related to the projects and programs.
• System Testing for New .Net application.