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