SUMMARY:

9 years of comprehensive experience in design, development and deployment of Data warehouse & reporting solutions while ensuring effective timeline management and delivery. Dynamic professional with customer - focus, has worked on up-scaling Data warehouse implementations to cater to changing analytic and decision-making needs of business.

TECHNICAL SKILLS:

• Tableau v2018.x, v10.x, v9 & v8 - Tableau Desktop, Tableau Server, Tableau Public and Tableau Prep
• IBM Cognos BI 10.2/10.1/8.4/8.2 - Framework Manager, Transformers and Cubes, Report Studio, Cognos Administration, Cognos Configuration & Security, Analysis Studio, Query Studio, Workspace Advanced, IBM Cognos Adaptive Warehouse, IBM Cognos Workforce Performance Analytics, Cognos Connection
• SAP BI - Data Services Designer, Information Design Tool, Webi, QWAS, HANA
• Oracle
• SQL Server, T-SQL
• Amazon Redshift, Postgres SQL
• Informatica - Work flow Manager, Powercenter Designer, Work flow Monitor
• Data Modeling, Data warehouse methodologies, Star Schema
• Python programming (self-learning)

CORE COMPETENCIES:

• Comprehensive Business Intelligence Solutions Development
• Implementing Real-time Reporting Solutions
• Dashboard Design and Story Building
• Dimensional & Relational Modeling
• Application Development, Testing and Administration
• Requirement Gathering and Design

EXPERIENCE:

Confidential

Sr. Tableau/SQL Developer

Tools: Tableau 10.3, SAP BODS, Oracle, SQL Server

Responsibilities:

• Creating tableau dashboards as per business requirements
• Data modelling and implementing the business logic in SQL Server
• Understanding requirements and creating the high-level design
• Determining the data flow strategy and design.

Confidential

Tableau Developer

Tools: Tableau 10.3/10.5, SAP HANA

Responsibilities:

• Creating tableau dashboards as per business requirements
• Designing a summarized version of the dashboard for the tableau mobile platform
• Understanding requirements and creating the high-level design
• Determining the data flow strategy and data modelling.
• Received quarterly employee appreciation award shared with the team

Confidential

Tableau Developer

Tools: Tableau 10.1/10.2, SAP HANA

Responsibilities:

• Creating tableau dashboards as per business requirements
• Designing a summarized version of the dashboard for the tableau mobile platform
• Understanding requirements and creating the high-level design
• Determining the data flow strategy and data modelling.
• Received quarterly employee appreciation award shared with the team

Confidential

Data Analyst

Tools: Tableau 10.1, Amazon Redshift, Postgres SQL, Oracle, MS SQL Server, AWS Platform

Responsibilities:

• Creating tableau dashboards as per business requirements
• Understanding requirements and creating the high-level design
• Determining the data flow strategy and integration of various heterogeneous data sources.
• Data modelling and creation of star schema
• Creating SQL scripts to enable data extraction and cleansing.

Confidential

Technical Consultant

BI Tools: IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS

Responsibilities:

• Defined scenarios influencing the business and customer experience in the process.
• Converted these scenarios into requirements and HLD.
• Requirement gathering, brainstorming, logic building to tackle the changes required at the Data warehouse end in order to maintain seamless User Experience.
• Transitioned the HR Data Marts onto the new standards.
• Extensive testing and production deployment of code changes.
• Mentored team members and subordinates to ensure effective delivery of agreements.
• Directed quality assurance (QA) efforts to maximize customer satisfaction and minimize bugs/errors.
• Highly appreciated by client for robust design and successful production deployment.

Technical Consultant

Confidential

BI Tools: IBM Cognos BI 8.4, IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS

Responsibilities:

• Installation and migration of Cognos Version 8.4 to 10.2.2 on the new servers.
• Prepared Impact Analysis and mitigation plan for server migration task as well as Cognos version upgrade.
• Migration of application from one set of windows server to a set of new servers as it had reached end-of-life.
• Coordinated with IBM team and raised PMRs for glitches faced with 10.2 version functionality and applied fix packs accordingly.
• Thorough testing of complete distributed architecture and migration of the Data warehouse on newer version.
• Received recognition for the team’s performance from client post production sign off.

Technical Consultant

Confidential

BI Tools: IBM Cognos BI 8.4, IBM Cognos BI 10.2.2, Informatica Powercenter v8, Oracle 10g, IIS

Responsibilities:

• Translated business goals, feature concepts and customer needs into prioritized product requirements and use cases, and then to technical specifications and prepared High Level Design & Scope of proposed application.
• Developing the FM models to cater to the report developer needs.
• Building Transformer OLAP Cubes to cater to the Business Analyst’s needs.
• Providing training to end users on Cognos Connection and Analysis Studio use.
• Implementing enhancements and adding additional features to the existing application, in order to improve performance & enhance customer experience.
• Managed and delivered a project from start to finish for building a data mart for the Training function of the client organization using IBM Cognos BI Adaptive Warehouse.
• Responsible for End-to-End implementation and worked single-handedly on the entire SDLC for this project.
• Build the data model & reports using Oracle ERP as the source, Cognos WFPA for model design and Cognos BI for reporting & security.
• Achieved customer delight through earnest efforts. Successful go-live and a fully functional bug-free application currently being used by the client to report and influence business decisions on their Training Vertical.

Confidential

Developer

Responsibilities:

• Developed Report Studio reports using Cognos 8.4 BI Suite.
• Worked with Business team to obtain detailed technical requirements.
• Responsible for design, coding, testing & documentation for reports.
• Performed code reviews and functional testing of reports.