We provide IT Staff Augmentation Services!

Sr Bi Analyst/power Bi Developer/cognos Resume

SUMMARY

  • Accomplished Data warehouse Architect with over Eleven years of experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and Production.
  • Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions.
  • Dynamic, result - oriented, team player with a sound understanding of BI Architecture.
  • Excellent working knowledge in the ability to interpret and analyze customer requirements to develop and design new Reports/Dashboards.
  • Strong ability to think laterally to provide solutions, exercising independent judgment and decision-making in the diagnosis and resolution of problems.
  • Aggressive in identifying and solving inefficient operational processes.
  • Keenly focused on customer requirements and service levels that directly contribute to measurable results.

TECHNICAL SKILLS

  • Installation & Configuration of BI tools
  • Gathering the Requirements with Business users.
  • Migration and Upgrading.
  • Expertise in handling Administration tasks.
  • Design and Develop creative reports.
  • Building Power Play Cubes, Framework packages.
  • Design and Develop Dashboards.
  • Scheduling Cubes and Reports.
  • Application Documentation / End User Testing.
  • Production Support.
  • Performance tuning and optimization techniques.
  • Databases DB2, Oracle and SQL Server.
  • Project Management
  • Code Reviews.
  • Customer Requirements / Customer Focused.
  • Problem Resolution.
  • Collaborative / Innovative Leader - “Outside the Box” Thinker.
  • Excellent Interpersonal / Communication Skills.
  • Team Player and solo performer.
  • Meticulous Attention to Detail.
  • Proactive attitude.
  • Research and Analysis.
  • Travel Flexibility.

PROFESSIONAL EXPERIENCE

Confidential

Sr BI Analyst/Power BI Developer/Cognos

Responsibilities:

  • Converted Cognos dashboards to Power BI Visuals
  • Desgin and developed various analytical dashboard such as Executive, Resource Analysis,Call Center Analysis, Operations etc.
  • Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts,Pie Charts, slicers, Drilldown and drill through features
  • Expertise in writing complex DAX functions in Power BI
  • Extensively used SUM, SUMX, CALCULATE, PARALLELPERIOD, SAMEPERIODLASTYEAR, ALLEXCEPT, FILTER, SWITCH, DIVIDE, SELECTEDVALUE Functions to create calculated columns and measures.
  • Worked with Incremental Refresh, Power Query, Time-Intelligence functions to building forecast versus actual reports .
  • Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS), SSMS and SSDT
  • Developed Matrix and tabular reports by grouping and sorting rows.
  • Developed Customized reports using JavaScript
  • Build and maintain complex SQL queries for data analysis, data mining and data manipulation. Organize analytical data, ensure data quality and aggregate data for strategic reporting, Performance optimization on database solutions.
  • Performed leadership role in the design, build and deployment of executive-level dashboards and reports
  • Strong Knowledge on Power BI to import data from multiple sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
  • Interacted with Business and IT stakeholders to gather requirements and design and develop multi-dimensional cubes and tabular models as per industry standards to satisfy business requirements.
  • Installed and Configured Cognos Analytics on Dev, Qa and Prod environments
  • Performed Cognos Analytics Upgrades
  • Implemented 3rd Party CA to allow for SSL between components in IBM Cognos Analytics 11
  • Created user groups and roles for different access levels.
  • Implemented passthrough authentication for Cognos to access Databases
  • Developed Data Modules, Dimensional and Relational Framework Manager Models
  • Created FM Packages for SSAS data source connections
  • Integrated Cognos Analytics environment with Okta for centralized single sign on solution.
  • Configured and implemented Okta SSO with Cognos
  • Customize cognos portal and added new dashboard icons by writing Json script
  • Developed Test Plan, Test Cases and Test Scenarios for testing based on BRD.

Environment: Power BI,Tabular Editor, Cognos Analytics 11.1.6,SSAS,SSRS,SSIS,SSMS,Microsoft Azure Sql Database, Visual Studio 2017, Spotlight, Fiddler 4,Denodo 8.0, Informix, Cisco DB, Razor SQL, Jira and Service Now

Confidential - Charlotte, NC

Sr BI Analyst/Power BI Developer/Cognos

Responsibilities:

  • Used Agile Software development methodology in report development and defect solution. Join daily scrum call to update the status of development and defects.
  • Proficient in Coding in M-Language& Dax Calculations for Logical, Conditional, Time, Row level security in Power BI.
  • Worked in the data team providing end to end data needs throughout the organization and clients. Worked on large BI projects, including ETL processes related to Data-warehouse development (SQL Server 2012-2017/ SSIS), reports (SSRS), and data visualizations in Power BI.
  • Designed and Developed Power BI dashboards, functionally and aesthetically, based on business requirements develop and test complex Power BI dashboards independently.
  • Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS), SSMS and SSDT.
  • Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).
  • Used custom visuals, third party connectors, Power Query, Power Apps, CDS as part of Power BI project.
  • Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, Drilldown and drill through features.
  • Created DAX Queries to generate calculated columns and measures in Power BI.
  • Created Azure Blob Storage for Import/Export data to/from CSV File
  • Published Power BI Reports on Service and provided access in Web clients and mobile apps
  • Used Power BI report builder to publish paginated reports.
  • Performed monitoring, optimizing of dashboards/reports; troubleshooting dashboard/report problems and outages; scheduling upgrades
  • Served as the Reporting Development Lead responsible for Business Intelligence (BI) Reporting and Data Analytics for The Adecco General Staffing and Specialty Brands.
  • Provide senior technical guidance in the areas of Power BI/Cognos report development and Dashboards.
  • Managing the report developers and supporting the development team with Power BI model related changes.
  • Follow up with on-site coordinator for timely delivery of requirements.
  • Escalate issues to business/management in timely manner.
  • Offshore Review meetings and managing the workload between resources based on priorities.
  • Planning for handling the Production Incidents raised within the given timelines based on urgency to avoid business impact.
  • Working with business users and helping them in troubleshooting and resolving tickets/incidents opened in eService and Service Now.
  • Work with ETL and DBA team to understand dataflow, remove data discrepancies and modification/updating in data model.
  • Design documentation related to Power BI and Cognos projects implementation.
  • Performed day-to-day technical operations. This includes server maintenance, creating user groups and providing security, Installation and Configuration.

Environment: Power BI, Cognos 11 Suite, Oracle 11g, SQL Server,SSIS,SSMS,SSRS,SSAS, Actuate, eService, Service Now,Jira, Autosys.

Confidential - Columbus, OH

Sr Cognos Architect/Informatica Developer

Responsibilities:

  • Involved in gathering the Requirements with Business users and prepared Functional Requirement Specifications for report development.
  • Extensively worked on loading Dimensions and fact tables in a star schema.
  • Designed & Implemented SCD methodology including type 1 and type 2 changes to keep track of historical data.
  • Created mapping using various transformations like Source Qualifier, Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Update Strategy.
  • Participated in implementation and testing of various type 1 and type 2 dimensions.
  • Designed and built staging tables to restrict the data for Incremental loads.
  • Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
  • Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
  • Involved in Migration and Upgrading of Frame work models, power play cubes and Reports from series 7 to Cognos 8.4 and from Cognos 8 to Cognos 10.2.2.
  • Proficient in deploying Reports and Packages from one environment to other environments (export, import and Copy to Clipboard)
  • Expertise in handling Administration tasks like bursting and scheduling the reports.
  • Created Data Source Connections in Cognos Connection for new development.
  • Involved in creation and maintenance of BMC Control-M jobs that submit Cognos cube build scripts that perform automatic publishing of Power Play Cognos cubes providing version control.
  • Developed Transformer Models and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
  • Design and developed Relational and DMR Framework Manager Models with Physical layer, Logical Layer and Reporting Layer and published them to cognos portal for standard reporting and Adhoc Analysis.
  • Implemented the Security levels in Cognos framework Manager.
  • Converted 100+ Oracle Discoverer reports (an integrated Oracle product) to Cognos 10.2.2(JFS OIS enterprise reporting system).
  • Developed Child Care BI dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
  • Provided optimal customer support in troubleshooting and resolving the service tickets for ODJFS BIC Customer Service within sufficient timeframes.
  • Deployed the packages and reports from Development to Production.
  • Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
  • Resolved issues resulting from User Acceptance Testing (UAT).
  • Responsible for knowledge transfer, training and communication to end users and team members.

Environment: Informatica 9.1, Cognos Analytics 11, Cognos 10.2.2/10.1/8.4.1 Report Studio, Query Studio, Cognos Connection, Cognos Map Manager, Framework Manager, Power play Transformer, Cognos Scheduler, MotioPI, PL/SQL, IBM DB2, Oracle 11g/10g/9i/8i, TOAD, Unix, Flat Files, Shell Scripting, Quality Center & Control - M.

Confidential - Columbus, OH

Sr Informatica Developer

Responsibilities:

  • Collaborated with business analysts and technical team for requirement gathering and business analysis and prepared high-level design document to provide an overview of technical design specification system.
  • Analyzed the existing application physical data model and suggested changes to data Model based on the ETL and Referential Integrity gap requirements. Accommodated ETL Mappings according to Database Management change requests. Developed Data Quality architecture for ETL environment.
  • Worked with Shortcuts across Shared and Non Shared Folders, used Parameter files and Mapping Variables for Incremental Load.
  • Created User Defined functions, reusable transformations to be re-used during the development life cycle
  • Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults for the Data and Created folders, groups, users and assigned permissions and privileges to groups and users using the Informatica Repository Manager.
  • Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
  • Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
  • Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.
  • Designed and implemented CDC backup process for Mainframes. Designed data loading sequence and populated data into ODS, staging and warehouse with business rules following Data warehouse methodologies. Implemented SCD Type 1 and Type 2 to update the dimensional schema.
  • Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
  • Added enhancements such as mail functioning, success flag, pre and post session functions etc.
  • Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
  • Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
  • Responsible for best practices like naming conventions, Error Handling and Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
  • Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.
  • Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, Flat Files, AQT, Ultra Edit, UNIX Scripting, AIX, Windows XP.

Confidential

Sr Cognos Architect/Informatica Developer

Responsibilities:

  • Developed CFSR Performance Dashboard, dashboard provides maximum flexibility, as well as allows leaders to identify and monitor children for each permanency measure.
  • Worked on creating Data Warehouse for SACWIS in Ohio, using Infomatica.
  • Created adhoc reports, drill through and CFSR Metric Indicator reports based on user request.
  • Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.
  • Used Java scripts in HTML item to set the most current dates in the Dashboard reporting.
  • Used Cognos Connection as Web Portal to manage reports, develop prompt pages and conditional variables.
  • Set up the security at the package level, query subject level and query item level.
  • Created Query Prompts, Cascading Prompts, Calculations, Conditions and Filters.
  • Extensively worked on loading Dimensions and fact tables in a star schema.
  • Involved in the design and implementation of Bridge tables in a data warehouse.
  • Responsible for developing and testing ETL mappings for Fact Child Disability fact table and surrounding dimensions. This fact table tracks disability claims and the dimensions provide data groupings for federally required reports. The fact table is treated as type 2 with current flag and effective date ranges due to updates and deletes in the source schema.
  • Responsible for building bridge tables to implement many-to-many relationship between fact table and a dimension.
  • Analyzed source data and developed Fact Allegation table with supporting dimensions. This table tracks abuse allegations for the Department and vitally important for correct reporting.
  • Lead testing of various fact and dimensions tracking child foster care placements.
  • Participated in implementation and testing of various Type 1 and Type 2 dimensions.
  • Used the Workflow manager to create workflows, worklets and tasks.
  • Delivered and sign-off of deliverables pertaining to the Operations Data warehouse.
  • Prepared design documents, ETL data mapping and migration documents.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Cognos 8.4.1 Suite, Oracle 11i/10g, Quality Center.

Confidential - Cincinnati, OH

Sr Cognos Lead Admin/Architect

Responsibilities:

  • Installed and configured Cognos 8.4.1 Business Intelligence environment and performed knowledge transfer in support of this company’s evaluation of Cognos for its national rollout of new insurance products.
  • Consult and assist Sales and FID departments with the usage of Cognos Tools.
  • Monitoring daily cubes and Reports which are scheduled to run and Burst to users every morning before business day starts.
  • Externalized IQDS out of Cognos 8.4.1 Framework Packages to support Power play Cubes.
  • Created individual state reports for the FID department to give the ability to enhance their risk management capabilities by providing a visual depiction of FID’s experience and exposures on both countrywide and state maps.
  • Involved in setting up Groups/Roles to secure the models and packages (Data Level) using Access Manager.
  • Uploading Burst tables and run the reports and Burst them to Agents based on alpha sorts during Month End Processing.
  • Created High level design and analysis documents and set up a meeting with Business to get their approvals.

Environment: Cognos 8.4.1/8.3 Suite, Framework Manager, Power play Transformer, Oracle 11i/10g, TOAD, HTML, MS-Access, MS- Excel, Unix, AIX, Windows NT.

Confidential - Pleasanton, CA

Cognos Architect/Developer

Responsibilities:

  • Develop the HR Dashboards for the Kaiser Management of the HR activities and
  • Write BTEQ scripts in Teradata as part of ETL task to load the target systems
  • Designed National Dashboard reports on the critical performance metrics in the path toward Best Quality, Best Service, Most Affordable and the Best Place to Work which make up the KP Value Compass.
  • Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
  • Designed Multidimensional Model (IT Performance Measurement DMR) in Framework Manager used MDX functions for report generation.
  • Implemented security (Data Security, Object Security, Package Security) to the package based on user requirement.
  • Created Dashboard (National Dashboard, HR Dashboard and Hawaii Dashboard, NCAL Dashboard) reports for the IT department to check the performance of the IT employees.
  • Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.
  • Used Java scripts in HTML item to create run and reset buttons.

Environment: Cognos8.4 Suite, Oracle10g, Teradata Sql Assistant12.0, DB2, SqlServer2005, T-SQL, Analysis Services (SSAS), SQL Server Integration Services, Toad.

Hire Now