We provide IT Staff Augmentation Services!

Business Analytics Specialist Resume

Houston, TX

SUMMARY

Solutions - oriented and highly analytical candidate with extensive experience in the design, development, and management of Business Intelligence solutions. Successful history of effectively leading teams, implementing systems, and directing key initiatives. Strong business knowledge in Oil & Gas, Healthcare and Finance domains.

AREAS OF EXPERTISE

  • Database management
  • Business Intelligence solutions
  • Data Analytics
  • SQL/Java Programming
  • SAP PS & PPM
  • Strong verbal communication
  • Highly proficient in Cognos, Tableau and Microsoft Power BI reporting tools

TECHNICAL SKILLS

Business Intelligence Tools: IBM Cognos v8, 10.x, 11 Analytics (Framework Manager, Report/Query/Analysis/PowerPlay/Metric Studios, Dynamic Query Analyzer, Lifecycle Manger, SDK, Motio CI/ PI), Tableau v8.x/9.x, Microsoft Power BI

Database/ETL Tools: IBM DB2/Microsoft SQL Server 2014, 2016/ Oracle 10, 11G/ Curam, Talend ETL, SQL Server Integration Services (SSIS), Informatica, Data Stage, Toad Data Modeler

Languages: SQL, PL/SQL, Javascript, R, Python, Shell Scripting

Operating systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Business Analytics Specialist

Responsibilities:

  • Lead the organization wide reporting initiative to implement a business intelligence solution
  • Conducted meetings with business stakeholders, clients and director level members for requirements gathering and presented various solutions using best practices
  • Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources
  • Created Microsoft Excel dashboards and reports on monthly basis analyzing key performance indicators
  • Managed Power BI Portal - Data / User management and set up data gateway refresh
  • Created executive dashboards that shows the current project and portfolio status using Power BI / Tableau
  • Created and implemented a data warehousing solution using the open source software Talend ETL
  • Prepared ETL mapping documents for Data Migration to and from the production environment
  • Scheduled jobs using Talend Administration Console ( Confidential )
  • Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.
  • Managed testing cycles, including test plan creation, development of scripts and co-ordination of user acceptance testing
  • Assisted with SAP Project Systems and Portfolio Management implementation and training

Confidential, Houston, TX

Lead Cognos Developer

Responsibilities:

  • Created list, crosstab, chart, drill-through, and master detail reports incorporating various prompt types, filters, and business calculations
  • Interacted with the Business users and Analysts for gathering project requirements and prepare detailed design specs
  • Trained users on creating ad-hoc reports and running custom created reports
  • Created reports using Tabular SQL against the source system for monitoring data loads
  • Developed Relational and Dimensionally modelled relational (DMR) models in Framework Manager
  • Created events in Event Studio to trigger report runs and bursts after database refresh
  • Worked on report bursting for project cost, O&M groups to streamline report delivery process
  • Created views and stored procedures for importing data into framework manager
  • Involved in Performance Tuning of Reports to reduce execution time
  • Created burst and multilingual reports using Report Studio
  • Customized reports using Javascript in HTML objects to dynamically change the behavior of prompts in Report studio
  • Managed the development and release activities and the administration of Devtrack Issue tracker
  • Assisted with Enterprise Project and Portfolio Management software (EcoSys) implementation
  • Created technical documentation for the Framework Manager model, including design approach and architectural overview
  • Assisted and worked with Data Stage ETL developers to make sure that model being developed is according to the business requirements
  • Lead the Support team while migrating and installing new versions of Cognos
  • Worked with offshore steady state team for day to day production issues

Confidential, Jefferson City, MO

Sr. Cognos Administrator

Responsibilities:

  • Developed and maintained Cognos reports and content using Report, Query, Analysis and Event studios
  • Interacted with Business users for requirement gathering and created documented report requirements
  • Used Framework Manager to build relational models, packages and published to Cognos Connection
  • Developed standard templates, dashboard reports, charts, drill through, master-detail and conditional formatting reports using Report Studio
  • Created packages to suit the business needs and to improve the performance of reports by defining filters, adding calculations and performing SQL turning on the model/report level using DB2
  • Coded stored procedures and SQL scripts to load and update data tables
  • Designed and implemented various Materialized views in DB2 to use in Cognos Reporting
  • Deployed Reports, Packages and Folders from one environment to another
  • Maintained Cognos server environment, including portal and security administration
  • Implemented Cognos 10.1 to 10.2.1 upgrade
  • Involved with installation, configuration, migration and testing of all objects in multiple environments

Confidential

Cognos Specialist

Responsibilities:

  • Developed various crosstab, list and chart reports using Report studio 10.1
  • Participated in requirement gathering sessions with project managers and assisted the business user community with capturing and articulating their reporting needs
  • Involved in ETL Mapping team discussions to solve the issues in mapping documents and design
  • Utilized various agile methodology tools such as MKS and JIRA
  • Developed complex Framework Manager models, created virtual Star Schemas and applied object level, data level and package level securities using Active Directory
  • Manually modified the SQL to write complicated reports using join/union objects in Report studio
  • Worked with QA and Testing teams for all testing activities and produced the status updates
  • Developed complex SQL queries using TOAD DB2 and Teradata to validate reports and measure the performance

Confidential

Cognos Consultant

Responsibilities:

  • Extensively used Cognos 10 to create simple/complex Dashboards and reports
  • Used SQL experience to troubleshoot query performance issues
  • Used Integrated Development Environment (IDE) to develop reports, maintain versions, and manage access
  • Worked with business experts to develop the reports and design mockups
  • Migrated existing Crystal Reports to Cognos 10
  • Trained business users to develop/use reports using Report Studio/Query Studio
  • Created SSIS packages to load custom queries into the database

Confidential

BI Developer

Responsibilities:

  • Created various complex reports in report studio including drill down reports from DMR modeled Framework model
  • Created executive Dashboards to present critical company data
  • Used Cognos SDK to customize the Cognos connection Portal.
  • Migrated reports and catalogs from Cognos series 7.1 to Cognos series 8.4 and then 10
  • Manually wrote SQL in Report Studio to tune and write complicated reports.
  • Developed various Framework Manager models and analyzed those models in analysis studio
  • Involved in building complex cubes using PowerPlay Transformer and optimizing the cube creation
  • Gathered and analyzed business requirements from users and business community
  • Used advanced features such as conditional formatting and variables in generating multi-page reports
  • Converted reports from Microstrategy to Cognos 8.4

Hire Now