SUMMARY

• I am a highly accomplished Business Intelligence Architect and technology leader with a 11+ year career that spans data warehousing, business intelligence, and data engineering, Big Data Analytics, Semantic Layer Modeling.
• My background includes progressive business intelligence architect and technical roles at Confidential and Confidential where I leveraged my expertise in BI strategy, consulting, and ETL Solutions for multi - million dollar engagements with high-profile, billion-dollar Customers.
• Extensive hands-on experience and expertise with Universal Semantic Layer, Dimensional Modeling, OLAP modeling, Cognos,Tableau dashboarding, product testing, level-3 technical support, escalation management, and engineering/professional services. Notably, I am regarded as a Subject Matter Expert on all Atscale, Trifacta, Tableau & Cognos technologies due to my extensive experience in all phases of software and product development lifecycles.

AREAS OF EXPERTISE

• Tableau Analytics (Expert) AtScale Cube Modeling (Expert) OLAP Analysis & Modeling Dimensional Modeling Universal Semantic Layer Implementation/concepts Hadoop SQL ( Hive / Impala / Spark) Requirements Analysis Predictive Analysis Agile Methodology Solutions Architecture Consulting Product/Software Development & Testing Data Warehousing Tableau Design & Development ETL(Trifacta & Apteryx) Advanced SQL OLAP Architecture Application Development & Analysis SQL Server Advanced Excel-based Reporting Data Exploration

PROFESSIONAL EXPERIENCE

Confidential

Hadoop BI Consultant

Responsibilities:

• Helping customers build their use cases in AtScale.
• Identifying improvements and defining new features for the Atscale/Trifacta.
• Responsible for overall Metrics collection and reporting for the AtScale Internal Teams.
• Providing Tier 2 support for AtScale modelling, and BI tool interaction.
• Developing Tableau,Cognos Dashbaords using AtScale Semantic layer to accelerate the Hadoop Consumption
• Fraud Risk analytics with Data wrangling and Machine learning.
• SAS conversion using big data tools like Atscale/Trifacta.
• Scrum Master for Data sciences Center of Excellence.
• Evaluating various tools that help financial analytics
• Regulatory reporting (Basel III/HMDA) using Big Data, Tableau and Cognos.
• Managed offshore teams and programs in lead BI architect and Project Manager roles within large-scale BI and DW projects and programs.
• Understanding Reporting Requirements, Developed Cognos & Tableau Reports, Fix Production Tickets, Performance Tuning of the reports to make sure report execute with the specified benchmark, End to End deployment of the reports and Work closely with SME and Business to make sure reporting requirements are met.

Confidential

Cognos Developer

Responsibilities:

• As a Cognos Consultant, for this project, responsibilities are to evaluate and analyses the BI environment.
• Created a financial reports (Budgeting, forecasting) for postpaid and prepaid subscriptions
• Business Rule and Process turbo Integrator (TI) implementation
• Created reporting and dashboards with Confidential Cognos BI and multidimensional TM1 cubes
• Successfully upgraded Cognos Application from 8.3 to 10.2
• Working with SAP-BI team to understand the challenges towards reporting.
• Involved in ITIL process throughout the project.
• Maintain / Support transitioned BI applications via cyclical processes, and creation of new application cubes and FM Models, reports, etc.
• Review BI application support and maintenance processes for continuous improvements in efficiency and accuracy BI Responsibilities.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Data source Connections and Creating user and groups, handling the deployment of reports copying from development to production server and also handling the user permissions on the packages and folders
• Analyzing the specifications provided by the clients and Developing specification documents for reports
• Design and Developed the Framework Manager models using Relational tables and published the package to server.
• Designed Reports using most of the Report studio features (Conditional Formatting,

Confidential

Cognos Developer

Responsibilities:

• Understanding Supply Chain Data warehouse Shared Service Business Domain, Customer Policies & Standards
• Requirement gathering from business
• Coordinate/Liaise with UK-based Cognos team members for information sharing, business needs, development/maintenance/support needs, etc. via regular meetings.
• Follow structured development and documentation methodologies while delivering the requirements in a timely manner without compromising on quality. This includes preparation and maintenance of related functional/technical documentations.
• Maintain / Support transitioned BI applications via cyclical processes, and creation of new application cubes and FM Models, reports, etc.
• Review BI application support and maintenance processes for continuous improvements in efficiency and accuracy BI Responsibilities.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Data source Connections and Creating user and groups, handling the deployment of reports copying from development to production server and also handling the user permissions on the packages and folders
• Analyzing the specifications provided by the clients and Developing specification documents for reports
• Design and Developed the Framework Manager models using Relational tables and published the package to server.
• Designed Reports using most of the Report studio features (Conditional Formatting, Crosstab Space, Sections, page Breaks, Master-detail, Drill Through)
• Created cubes using Power play Transformer.
• Created Complex Reports in Report Studio.
• Created List Reports, Crosstab Reports, Dashboard Reports ad Drill - Through Reports
• Created Master and Detailed reports
• Created Cascading prompts and Worked with different prompts
• Created Conditional block and Bookmarks reports

Confidential

Cognos Developer

Responsibilities:

• Gathering and Understanding the requirements from the end users and preparing the Requirement Specification documents.
• Gathered requirements for MIS Reporting Project Initiation. Developed Framework Manager Modeling part
• Worked with clients threw net meetings sharing views and thoughts.
• Developed Cross tab, List, Conditional formatting reports.
• Involved in testing - unit level. And Integration testing
• Defined report standards as per the client requirements.
• Weekly Project Status Updates & live demos to the users
• Involved in Analysis, Development and Testing.
• Involved in preparation of designing documents and test cases documents.
• Created technical documents for users of all the reports.
• Get the requirement specification for the customers
• Designing, Constructing, Testing and Deploying the Framework Manager Models, Packages
• Created Complex Reports in Report Studio.
• Created List Reports, Crosstab Reports, Dashboard Reports ad Drill - Through Reports
• Used Conditional block and render variable while developing reports.

Confidential

Cognos Developer

Responsibilities:

• Gathering and Understanding the requirements from the end users and preparing the Requirement Specification documents.
• Participating in user meetings to analyze and prepare the reporting and analysis requirements of users
• Created models in Framework Manager
• Developed impromptu query definition (.iqd) files imported into transformer for creation of cubes.
• Identified the methods to improve the performance of the cubes by splitting the single data source into multi data sources
• Created multidimensional Cubes as per the Business requirements
• Defined Data Sources and their associated connections in Cognos Connection
• Published Power Play Cubes into Cognos environment
• Developed reports in report studio complex and simple
• Working with user Security throughout.
• Involved in Cognos SDK utility.
• Assisted in Single Sign on Activity
• Onsite UAT Support

Confidential

Cognos Developer

Responsibilities:

• Responsible to work with the Business Analysts and Business Users to capture report generation requirements.
• Adherence to SLA following Incident Management/Problem Management process
• On time delivery of changes with no or minimal defects without slippage to schedule.
• Adding/Deleting Project names to the report as per the User Requirement.
• Created models in Framework Manager
• Assisted in the OLAP technical documentation for the PFUK DW project
• Worked with cube groups and varying grains of data
• Created Drill through links reports to cubes.
• Involved in testing - unit level. And Integration testing
• Published Power Play Cubes into Cognos environment
• Developed reports in report studio and Query studio.
• Working with user Security throughout.
• Onsite UAT Support.
• Working to best practice