We provide IT Staff Augmentation Services!

Erp Bi Report Developer Resume

Alameda, CA

PROFESSIONAL SUMMARY:

  • 7 years of experience in Data warehousing and Business Intelligence technologies along with data visualization using Tableau.
  • Expertise in Cognos7/8/10
  • Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports and Cognos reports.
  • Experienced working with OLAP Cubes
  • Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
  • Solid understanding of any RDBMS, Data warehousing concepts and data modeling concepts
  • Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
  • Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
  • Communicate effectively with colleagues and business users.

TECHNICAL SKILLS:

BI Tools: Cognos series 7 (Impromptu, IWR, Transformer),Cognos ReportNet 1.0/1.1MR*(Framework manager, Report Studio, Query Studio) Cognos Powerplay Transformer, Cognos 8 version 2\4 .1, Cognos 10.2.1, Tableau Desktop 7/8, Tableau Server

Big Data Training: PIG, HIVE, IMPALA

Programming skills: SQL, PL/SQL, MDX

Operating Systems: Windows 9X/00/XP, Window server 2003

Databases, Tools & Utilities: Teradata V2R5, Oracle 9i/8i, SQL server 2000 7.0, DB2, MS Access, SQL*Plus, SQL*Loader, Query Analyzer, ToadMarkup Languages: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

ERP BI Report Developer

Responsibilities:

  • Research, analyze, design and implement appropriate Cognos data packages and Cognos Reports for business users based on any outstanding / future requests
  • Maintain knowledge of client data models and data dictionary for the purpose of maintaining Cognos packages and enhancing user awareness of business data
  • Create and update Report Data column mapping to database tables and columns documentation
  • Maintain security of client data assets through the administration of Cognos features
  • Maintain proper security of Cognos Objects (Reports, Folders and Packages) within Cognos and implement data level security on reports to restrict data visible to users
  • Maintain the existing package(s) and suggest for ways of improving the performance and maintainability
  • Performance tuning of Cognos BI applications - both on reports, framework
  • Write, test, and deploy customized reports, queries, and event notification for the user’s community.
  • Expert creating drill through, master detail reports using Report Studio
  • Extensively worked with list, crosstab and graph reports
  • Created Bursting Invoice Reports
  • Collaborated with cross functional teams to gather and document BI requirements
  • Created reports as per the requirements of business users and trained users how to use it.
  • Modified and created a new package as per the requirement of a report in Framework Manager
  • Maintain existing Framework Manager packages and build new packages as per reporting needs
  • Update design and technical specification documents for on-going report modifications
  • Educate and provide knowledge transfer to report developers and business users on Cognos tool and best practices Development and deployment of BI solutions.
  • Work with Application team to identify performance bottlenecks and suggest improvement plans
  • Work with product vendors to provide application support and bug fixes as needed
  • Manage software upgrades, patches and back-up as needed
  • Provide weekly accomplishment/status report to management every week
  • Attend project and team meetings as requested
  • Developing reports against transactional data.
  • Worked with push and session reports.
  • Involved in designing report and validating the data against LN
  • Good knowledge of INFOR LN interface and data process
  • Tune up Cognos BI 10.2 production for better performance

Environment: SQL Server 2008, Cognos 10.2, Framework Manager, Report Studio, Query Studio, INFOR LN

Confidential

Technology Analyst

Responsibilities:

  • Worked as a Tableau developer/Analyst, Cognos developer
  • Designed, developed, deployed and support Tableau dashboards
  • Translated business requirements into sustainable and efficient visualizations and reporting
  • Experience creating visualization with chart, graphs, tree maps, and dashboard.
  • Experience in creating visualization using reference line, Action filters, parameters, table calculation
  • Maintained and managed Tableau driven dashboards
  • Created and maintained user and data security set up
  • Trained new users of Tableau and help improved the Tableau skills of existing users
  • Closely monitored and check the accuracy and completeness of data in Tableau
  • Engaged in team meeting, user meeting for the purpose of requirement gathering.
  • Document the business requirement and updated when needed.
  • Worked with team and user for testing and validating data.
  • Developing rich Interactive reports and dashboards integrating various reporting components from multiple sources
  • Worked with ETL team on report validation and monthly run.
  • Provide ad-hoc data and report requests - Cognos
  • Provided technical and business knowledge support to the teams.
  • Provided support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.
  • Perform troubleshoot on all Cognos helpdesk tickets and resolve all queries for content and prepare standard reports and ensure accuracy of same
  • Monitor work and ensure optimal utilization of all SQL scripts and documents all database requirements
  • Coordinate with data architecture and modeling team to design databases and prepare reports for same
  • Created and maintained Cognos Framework model and package.
  • Created and maintained Cognos Cube

Environment: Cognos 10.2.2, Framework Manager, Transformer, SQL Server, Tableau 9

Confidential, Alameda, CA

Sr. BI Analyst/Developer

  • Installation and setup of Cognos BI 10.2 for production, development and QA environment with AD and ULTRIPRO HR software.
  • Worked with security set up in ULTRIPRO Cognos environment
  • Supporting end users \ group \ department for Cognos BI reports, FM models, DMR, Cubes and Reports create out of Cognos cube (Transformer).
  • Troubleshooting existing BI application (Cognos cubes and reports).
  • Development, QA and migration of Cognos Cube to production environment.
  • Worked on converting crystal report and Business Object reports into Cognos 10.2.1
  • Working knowledge of Cognos in ULTIPRO environment
  • Good understanding of ULTIPRO Software and used ULTIPRO Cognos Framework package to create reports.
  • Has a good knowledge of customization of ULTRIPRO homepage look and content
  • Has a good understanding of configuration of role based security, workflow and work events in ULTRIPRO
  • Validated the report data against the data entered in ULTIPRO for HR and Payroll reports
  • Involved in activities of the projects like information gathering, analyzing the information, documenting the function or business requirements and technical application development.
  • Performance tuning BI reports and dashboards.
  • Worked on the development of Dashboard reports for the Key Performance Indicator for the top management.
  • Created HR Metrics and dashboard in Cognos
  • Delivered reports to business team on timely manner.
  • Designed multiple dashboards for HR, helping them to convert from manual reporting.
  • Worked with Payroll, HR & Finance team to create BI report.
  • Created a met life interface report for executive.
  • Created Dashboard Portal for executive.
  • Created on demand and on fly reports.
  • Validating BI Cognos reports against database as well as Crystal Reports and Business Object reports and ULTIPRO
  • Mentoring and leading junior level Cognos developer.
  • Assigned the work to junior developers and tracked the status of project.
  • Provided presentation, training to the business user on how to use Cognos and create reports in Cognos.
  • Troubleshooting the issue in Cognos Environment.
  • Attending daily huddle meeting for the project status.
  • Converted Crystal report into Cognos report.
  • Created drill through reports.
  • Created Payroll Dashboard for the use of Payroll department.
  • Created an Employee and Headcount Cognos reports, Turnover report
  • Created employee earnings, deductions, benefits and other several reports with Cognos in ULTIPRO environment
  • Diversified report developed using report studio (invoice reporting, G/L reports, simple and complex dashboard reporting) several list and cross tab reports.
  • Created prompt pages using text prompts, value prompts, date prompts, and cascading prompts.

Environment: Cognos 10.2.1, SQL Server, Crystal Report, Business Object, Ultimate Software (ULTI PRO)

Confidential, Sunnyvale

BI Developer/Analyst

Responsibilities:

  • Worked on high priority request for Dashboard using Tableau 7.0., 8.1
  • Manage and develop reports and reporting/dashboard plans for various products.
  • Interface with executive and their associate along with group of engineers, leads, product managers and analysts to understand data and report \ views requirements.
  • Proactively communicate with various product/business/engineering teams for creating, modifying and fine-tuning KPIs/metrics/dimensions for existing, new and changing business/product needs.
  • Gather requirements from business units and translate them into technical solutions.
  • Wrote supporting functional specification and design documents.
  • Developed visually informative dashboards, customized reports based on business requirements.
  • Worked with live connection, data blending and data extract in Tableau.
  • Worked in a team and with offshore team during the project.
  • Recommended Dashboards per Tableau visualization features.
  • Created Workbooks and published in Tableau Server.
  • Created trending view to in corporate in dashboard.
  • Integrated a dashboard in a portal.
  • Created interactive dashboard using various function of tableau like Action filters etc.
  • Created views with quick filters, parameters and reference line.
  • Worked on performance tuning of the views/dashboards.
  • Created groups and set permission for Projects in Tableau.
  • Design, develop, test & launch new reports\dashboards into test & prod environment.
  • Ongoing support to application running in production & troubleshoot.
  • Ability to write efficient & custom SQL statements for reports, analyze data to identify for data inconsistencies and fix.
  • Worked with Teradata database and pull data to work on requirement.

Environment: Teradata, Tableau 7.0, 8.1/2

Confidential, San Francisco

Business Technology Consultant

Responsibilities:

  • Tune up Cognos BI 10.2 production for better performance integrated with AD
  • Installation and setup of Cognos BI 10.2 for development and QA environment with AD and MS SQL Server 2008 as Content Store
  • Worked as technical and functional member in BTC - IT
  • Research Collect, process and develop sales data into standardized reporting system (Report, Cubes, OLAP and Ad-hoc reporting).
  • Prepared and presented dashboard using Cognos report studio and Tableau.
  • Have prepared and demonstrated various Tableau Dashboards for Clients from disparate data sources.
  • Created Workbooks and published in Tableau Server.
  • Created groups and set permission for Projects in Tableau.
  • Analyze, design, implement, BI reporting solutions using Tableau.
  • Develop relevant functional and technical documentation.
  • Work with business users to translate requirements into data visualizations.
  • Perform ad hoc analysis to support business decisions
  • Interacting with Sales director and other executive to build decision support system \ application as per their requirement.
  • Created and loaded tables for reporting using standard SQL.
  • Write SQL statement to verify and troubleshoot report data, also read various type of SQL programing language like PL\SQL to understand and troubleshoot data issue.
  • Supporting end users \ group \ department for Cognos BI reports, FM models, DMR, Cubes and Reports create out of Cognos cube (Transformer).
  • Troubleshooting existing BI application (Cognos cubes and reports).
  • Fix high priority ticket as well as one day ticket fix (Urgent ticket).
  • Building BI application (Reports and OLAP cubes) on the fly on demand.
  • Interacting with users for their day to day need and support.
  • Migrating application to production and be on call 24*7 supports.
  • Work with users to troubleshoot system, model and report issues for TM1.
  • Write and maintain complex TM1 business rules to provide additional reporting and analysis capabilities

Environment: TM1, Cognos BI 8, Oracle, SQL Server, PeopleSoft, Hyperion, Teradata, Tableau

Hire Now