We provide IT Staff Augmentation Services!

Sr.bi Consultant Resume

Washington, DC

SUMMARY:

  • Skilled Technology Professional with 12+ Years of experience with seven plus years of experience in managing and leading DW/BI efforts from requirements gathering to its implementation.
  • Extensively worked in various domains like Banking, Finance, Life Sciences, Retail and education.
  • Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach
  • Proficient with Cognos SDK, Framework Manager modeling, workspace, Analysis Studio and Report Studio
  • Designs enterprise wide Data modelling, Framework Manager models, OLAP and Multidimensional modelling
  • Designed and Developed BI reports, Dashboards, Active Reports and visualizations using Cognos, Tableau and MS BI Stack
  • Manages full system life cycle for BI projects including analysis and design, construction, testing and implementation
  • Drives toward documentation, standardization and automation of BI processes
  • System administration skills such as installation and configuration, IIS installation & management, performance tuning, troubleshooting, and configuring client software on Windows, UNIX, and Linux.
  • Experience in dealing with Apache Hadoop components like HDFS, MapReduce, HiveQL, HBase, Big Data and Big Data Analytics.
  • Identifies opportunities to improve efficiency, reduce cost, and reduce cycle time
  • Relies on experience, organization and judgment to plan and accomplish goals
  • Manages workload and achieve results with minimal supervision
  • Evaluate new tools and technologies and work on POCs as needed

TECHNICAL SKILLS:

BI Tools: Cognos Analytics, Cognos 10.2.2 BI, Cognos AdministrationCognos Power play and TransformerCognos Cube Designer, Cognos SDK, Tableau DesktopTableau Server, SSRS, BO, MSAS, Power BI

Languages: JavaScript, C++, SQL, SQL*Loader, PL/SQLUNIX Shell Scripting, Java2.0, HTML

RDBMS: Amazon Redshift, Oracle, MS SQL Server, DB2, Netezza, Teradata

ETL: Informatica, MS DTS

Environment: Windows 95/98/2000/NT, MS DOS and UNIX

Modelling Tools: Erwin, ER/Studio

Big Data: Hadoop, MapReduce, HDFS, Hive, NoSQL

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr.BI Consultant

Responsibilities:

  • Conducted/attended requirements definition meetings with end users and document system /business requirements
  • Worked on identifying and conducting detailed data analysis of different source systems.
  • Develop an in - depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
  • Designed and developed mappings using informatica powercenter using various sources such as csv file, SQL Server Database.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Developed data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control .
  • Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
  • Given demos for end users and interacted with them to understand the requirements

Environment: Tableau Desktop, Tableau Server, Informatica, Oracle10g, SQL Server, JavaScript, Erwin

Confidential, Cambridge, MA

Sr.BI Consultant

Responsibilities:

  • Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts .
  • Install and configure IBM Cognos 10.2.2 software on servers (multiple environments).
  • Produced standard reports for various business needs using best approach and fine-tuned the performance based on the users need.
  • Design, develop, and implemented dynamic cubes using IBM Cognos Cube Designer.
  • Delivered multiple projects with challenging design and timelines.
  • Given demos for end users and interacted with them to understand the requirements.
  • Designed and developed mappings using informatica powercenter using various sources such as csv file, Salesforce.
  • Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • Designed and developed Data model, Cognos framework modelling and dashboard reports, Active Reports.
  • Implemented best practices in role playing dimensions and row level security at the model level.
  • Implemented different functionalities for dashboard like having tabs, bursting, and security using report studio and workspace.
  • Analyzed underlying data, defined data sources, and designed approach for dynamic cubes.
  • Develop reports, dynamic dashboards using Tableau 9 for quick reviews to be presented to Business and IT users.
  • Developed POCs by building reports and dashboards using Tableau 9 to demonstrate quick wins.
  • Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
  • Created advanced analysis like forecasting and trending analysis.
  • Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
  • Used JavaScript API for advanced filtering and utility functions.

Environment: IBM Cognos 11, IBM Cognos 10.2.2 BI, IBM Cognos Cube Designer, Tableau Desktop, Tableau Server, Oracle10g, Informatica, JavaScript, Erwin, Hadoop

Confidential, Chelmsford, MA

Sr.BI Consultant

Responsibilities:

  • Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts .
  • Performed installation, configuration and upgrade.
  • Worked on writing stored procedures and complex sql queries.
  • Delivered multiple projects with challenging design and timelines.
  • Given demos for end users and interacted with them to understand the requirements.
  • Created Mapplets, reusable transformations and used them in different mappings.
  • Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
  • Designed and developed Data model, Cognos framework modelling and dashboard reports, Standard Reports.
  • Dimensional Modeling using Cognos Transformer Design, Build and Automate the Cube Build Process.
  • Implemented best practices in role playing dimensions and row level security at the model level.
  • Implemented different functionalities for dashboard like having tabs, bursting, and security using report studio and workspace.
  • Develop reports, dynamic dashboards using Tableau 9 for quick reviews to be presented to Business and IT users.
  • Created advanced analysis like forecasting and trending analysis.
  • Trained and provided support to the users.
  • Migrated thousands of reports from cognos 8.4 to cognos 10.21.
  • Provided UAT support and writing cube operation manual.
  • Provided technical guidance to junior developers

Environment: IBM Cognos 10.2 BI, Tableau Desktop, Tableau Server, Oracle10g, Cognos Powerplay and Transformer, OBIEE 11g, Informatica, JavaScript, Erwin

Confidential

Senior Technical Specialist/Architect

Responsibilities:

  • Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
  • Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
  • Designed and implemented DMR for multidimensional analysis of relational data which enables the user to slice and dice the data and also drill up and drill down behavior.
  • Implemented model based entitlements based out of stored procedure and defined joins across different dimensions to enable the data level security.
  • Worked on integrating Cognos with java application using sdk for running and archiving reports for different submissions.
  • Implemented customized URL's to launch adhoc templates using business Insight advanced to enable the users to build their own adhoc reports.
  • Implemented Dynamic filtering, Dynamic sorting, Javascript to concatenate multiple prompt values to input stored procedure.
  • Implemented enhanced functionality collapsible hierarchy using Javascript that expands reports on different columns with better layouts.
  • Produced standard reports for various business needs using best approach and fine tuned the performance based on the users need.
  • Supported SIT and UAT phases and provided quick fixes and deployed the code from one environment to another.
  • Worked on universe designer and involved in BO to cognos coversion .
  • Cognos administrative activities like Deploying codes to different environments, setting up access levels, Customizing the portal (Skinning), Single sign on with Java application
  • Created Query Prompts, Developed Prompt pages and Conditional Variables.
  • Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos Enterprise Planning,Cognos SDK, Oracle10g, Cognos 10 Powerplay and Transformer, Business Objects, Javascript

Confidential, Washington DC

Cognos Consultant

Responsibilities:

  • Cognos 10 installation and configured IIS, content store (Sql server database), security (namespaces), webserver setup. Followed best practices in configuring the server and setting up the environment.
  • Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
  • Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
  • Created custom views in framework manager to give multi dimensional analysis on their relational database.
  • Created multidimensional model using transformer based on calculated measures and budget system taxonomy and published a cube package based on that.
  • Applied row level security to restrict users from accessing data based on their entitlement.
  • Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.
  • Created model based calculations, filters and various relationships to make it feasible for the report authors.
  • Created complex crosstab reports based out of cube and parametrized for different dimensions using Report Studio, Analysis studio.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Scheduled, Monitored and Controlled access by creating groups, roles etc. using Cognos Connection.
  • Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
  • Scheduled and Bursted Reports on weekly, monthly basis.
  • Developed reports using Analysis Studio. and explored drill behaviors.
  • Worked on Javascript in implementing various functionality includes freezing panes across row and column wise.
  • Cognos administrative activities like Deploying codes to different environments, setting up access levels, Customizing the portal (Skinning), Single sign on with dot net application.
  • Tuned the reports which were running for more than ten minutes to 3 minutes.
  • Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for SQL Server2k databases.
  • Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Environment: Cognos 8.4(Report Studio, Analysis Studio), Cognos Connection, Framework Manager, Cognos SDK, SQL Server, SSRS

Confidential, Newark NJ

Cognos Consultant

Responsibilities:

  • Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
  • Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
  • Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
  • Built models containing query subjects, query items, and namespaces and analyzed model with Model Advisor.
  • Applied row level security to restrict users from accessing data based on their entitlement.
  • Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.
  • Created model based calculations, filters and various relationships to make it feasible for the report authors.
  • Created complex reports using Report Studio, Analysis studio.
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts (Pie Charts, Column Charts, Bar Charts, Line Charts), Drill through Reports and Master Detail Reports using Report Studio.
  • Built Customized Charts like age analysis and trending, Enhanced Report Layouts
  • Created prompts, Calculations, Conditions, Filters using Report Studio.
  • Created Query Prompts, Developed Prompt pages and Conditional Variables.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Scheduled, Monitored and Controlled access by creating groups, roles etc. using Cognos Connection.
  • Created shortcuts to Reports in Cognos Connection
  • Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
  • Scheduled and Bursted Reports on weekly, monthly basis.
  • Developed reports using Analysis Studio.
  • Created Drill down / Drill Up reports using Analysis Studio.
  • Worked on Javascript in implementing various functionality
  • Deployed packages, folders and content store from a development environment to test and then to production environments.
  • Fine tuned SQL queries and reports for performance.
  • Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, SQL Server2k databases.
  • Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos SDK, SQL Server, SSRS

Confidential, New York NY

Cognos Consultant

Responsibilities:

  • Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
  • Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
  • Created Models using star schemas and snowflake schemas, Packages using Framework Manager. Published and managed packages.
  • Built models containing query subjects, query items, and namespaces and analyzed model with Model Advisor.
  • Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.
  • Created Ad-hoc reports using Query Studio.
  • Created complex and dashboard reports using Report Studio.
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts (Pie Charts, Column Charts, Bar Charts, Line Charts), Drill through Reports and Master Detail Reports, Dashboards, using Report Studio.
  • Customized Charts, Enhanced Report Layouts
  • Created prompts, Calculations, Conditions, Filters using Report Studio.
  • Created Query Prompts, Developed Prompt pages and Conditional Variables.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Scheduled, Monitored and Controlled access by creating groups, roles etc. using Cognos Connection.
  • Created shortcuts to Reports in Cognos Connection
  • Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
  • Involved in Migration of Cognos 8.2 version reports to Cognos 8.4.1 version.
  • Scheduled and Bursted Reports on weekly, monthly basis.
  • Developed reports using Analysis Studio.
  • Created Models and cubes using Power Play Transformer.
  • Customizing cube content with views (Suppress, Cloak, Filter, Summarize)
  • Creation of multiple cubes and cube groups.
  • Created Drill down / Drill Up reports using Analysis Studio.
  • Created Excel and PowerPoint templates using Cognos Go Office to embed refreshable reports within these templates.
  • Worked on SDK for automating the report deployment, customizing cognos portal and applying security.
  • Worked on Javascript in implementing various functionality
  • Deployed packages, folders and content store from a development environment to test and then to production environments.
  • Fine tuned SQL queries and reports for performance.
  • Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, Netezza.
  • Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Worked with Cognos tech support team to resolve various issues.

Environment: Cognos 10, Cognos Suite 8.4(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, Cognos VVM), Cognos SDK, Toad 8, Oracle10g, Netezza, IBM DB2, Cognos 8.4 Powerplay and Transformer, Javascript,Microstrategy

Confidential, Irving TX

Business Intelligence/ Report Developer

Responsibilities:

  • Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
  • Built models containing query subjects, query items, and namespaces from imported metadata.
  • Created Ad-hoc reports using Query Studio.
  • Created dashboard reports using Report Studio.
  • Migrated cognos ReportNet version reports to cognos 8.2 version.
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
  • Created prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
  • Created Query Prompts, Developing Prompt pages and Conditional Variables.
  • Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
  • Scheduled Reports on weekly basis.
  • Creating the Cubes based on the requirements and creating the drill through reports for the cubes
  • Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through Developed Combine Filter, User-Defined Filters, Custom ranking using Analysis Studio
  • Created Drill down / Drill Up reports using Analysis Studio
  • Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
  • Tuning the performance of the Cognos Cubes and publishing Cubes on to the Powerplay Enterprise Server.
  • Closely worked with data warehouse designers to refine data and metadata.

Environment: Cognos Suite 8.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager), Cognos SDK, Cognos PowerPlay7.3, Cognos Transformer7.3, Teradata, Windows 2000, Business Objects

Confidential

Indi Cognos Developer

Responsibilities:

  • Worked on the Framework Manager to develop the Models.
  • Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
  • Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
  • Created reports in Query Studio and Report Studio.
  • Planned and Created professional reports in Report Studio.
  • Schedule, Monitor and Control access by creating groups, roles etc. using Cognos Connection.
  • Created Folders to store conditions, calculations, and catalog prompts.
  • Publishing Cubes and Impromptu Web Reports on to the server.
  • Using Configuration Manager to setup the components.
  • Demonstrating End users, how to use upfront and Cognos Cubes.
  • Monitoring the daily cube builds and reports.
  • Created reports using Cognos Impromptu, Transformer, Power Play, Power Prompts and Visualizer.
  • Designed, developed, and tested Power cubes and deployed them in to production.
  • Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
  • Worked on Cognos Security Administration to Create, Maintain and Restrict the Users.
  • Created Reports, list prompts and drills through reports.
  • Creation of Model definition, calculated measures, multiple cubes and cube groups in Power Play Transformer.
  • Uploading the Data Changes and application to the Production and Staging environments.
  • Involved in Data mapping between multiple data transaction systems. Database triggers, Sequences, Indexes and fact tables were widely used in providing data integration and security.

Environment: Report Net 1.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), CognosImpromptu 7.3/7.1/7.0/6.0, CognosPowerplay 7.3/7.1/7.0/6.0, Cognos Transformer 7.3/7.1, SQL Server 2000 and 2005, Cognos Visualizer 7.3/7.1, SQL Query Analyzer, SQL Enterprise Manager, IWR, Unix, Windows 2003.

Confidential

Developer

Responsibilities:

  • Creation of Model Definition Using Transformer.
  • Created the catalogs for the users and managing & testing of catalogs with Cognos Impromptu.
  • Created the reports for sales of the different products for different regions and demands for future forecasting.
  • Created Models based on the dimensions, levels and measures required for the analysis.
  • Used MS Analysis to build multidimensional cubes and used it in Metrics analysis to build graphs and charts of sales data.
  • Involved in performing Administrative tasks like user authentication, creating new users for the cube.
  • Pivoting, Drill Down, slice and dice and filtering operations done for all OLAP applications.
  • Involved in creating IWR to publish reports on a web.
  • Performance tuning- tuned power cubes to reduce calc time and partitioned cubes.
  • Creation of standard filters, calculations, prompts and conditions in catalog.
  • Exception highlighting. Created Reports, list prompts and drill through reports.
  • Customizing cube content with views (Suppress, Cloak, Filter, Summarize)
  • Creation of multiple cubes and cube groups.
  • Creating and Publish IWR Reports.
  • Configuring and Maintenance of Report Administration, Server Administration and Ticket server.
  • Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using MS DTS ETL tool.
  • Developed ETL mappings, transformations, Packages using MS DTS.
  • Maintained stored definitions, transformation rules and targets definitions using repository Manager.

Environment: MS-SQL Server 7.0/2000, Cognos Impromptu7.0, MS DTS, MS Analysis Services, IWR, MS-OLAP Services and Windows NT, Cognos ReportNet

Hire Now