EXPERIENCE SUMMARY:

• Over 12 years of experience in gathering Business Requirements, assessing, designing and implementing Business Intelligence Information & analytical solutions.
• Proficient background in providing end - to-end business intelligence solution by Configuring Metadata & Building Analytics Repository, Dimensional model design, Building business models, Generating reports, and Creating Interactive, insightful Business Intelligence Dashboards using Tableau and Oracle Business Intelligence 11g.
• Experience in creating clean and user friendly Tableau dashboards, perform testing, and develop user guides
• Work with project leads and stakeholders to understand data needs of the business
• Translate business objectives into actionable analysis and own end-to-end analytics, and effectively communicate complex analytics to a broader audience in writing and presentation formats.
• Implement proofs-of-concept for reporting and analytical requirements. This will include aggregating data from multiple databases / tools and developing reports in BI tools such as Tableau and OBIEE.
• Strong background in Analysis, Design, Development, Implementation of Data Warehousing in ETL. Worked extensively in developing ETL for supporting Data Extraction, Transformation and Loading using Informatica Power Center and knowledge in Alteryx.
• Leading and developing multiple teams to deliver and innovate to solve challenging business problems.
• Understanding and mastering technologies and environments as well as the specific client and their business needs.
• Vast experience in Business & Data Analytics
• Well versed with visualization techniques
• Hands-on experience in creating user-friendly charts and dashboards
• Data optimization techniques
• Capable of undertaking and implement Strategic Initiatives
• Root Cause Analysis
• Ad-hoc Analysis and Reporting
• Getting things done in timely manner
• Good knowledge on Relational Database
• Efficient in interacting with Global stakeholders
• Strong written and verbal skills
• Ability to manage Time and Productivity
• Attention to detail

TECHNICAL SKILLS:

• Tableau Desktop and Server
• OBIEE 11g
• Informatica PowerCenter
• Teradata
• Oracle
• Knowledge in Big Data, Python
• Windows and Unix commands

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

Data + BI Consultant

Responsibilities:

• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Participated in Post implementation reviews for project with all Stakeholders.
• Designed and developed dashboards using Tableau Desktop for Business executives.
• Used Calculated Fields, Action filters, URL Actions, Parameters in tableau as per business requirement.
• Created drill down reports yearly to weekly reports in Tableau Desktop.
• Created multiple KPI reports in Tableau Desktop based on achievements as per requirement.
• Created reports using multiple data sources by implementing data blending in Tableau Desktop and created different reports like bars and pie charts, line charts, drill down and other formats in generating the reports.
• Used Calculated Fields, Action filters, URL Actions, Parameters in tableau as per business requirement.
• Implemented Performance Steps to improve Tableau Dashboards Performance.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other features.

Confidential

IT Engineer

Responsibilities:

• Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Participated in Post implementation reviews for project with all Stakeholders.
• Designed and developed of various dashboards using Tableau Desktop for Business Leaders.
• Created drill down reports yearly to weekly reports in Tableau Desktop.
• Created multiple KPI reports in Tableau Desktop based on achievements as per requirement.
• Implementation experience and good knowledge of SAP HANA.
• Consuming SAP HANA views in business layer and have proven experience with Tableau reporting.
• Created reports using multiple data sources by implementing data blending in Tableau Desktop and created different reports like bars and pie charts, line charts, drill down and other formats in generating the reports.
• Used Calculated Fields, Action filters, URL Actions, Parameters in tableau as per business requirement.
• Worked on Scheduling data extracts in Tableau Server.
• Configured Tableau Server to use Active Directory authentication so that user when sign in to the server, their user name and password is verified through Active Directory.
• Implemented Performance Steps to improve Tableau Server Performance.
• Used JavaScript API to embed Tableau Visualizations into the web applications.
• Involved in troubleshooting the issues in Tableau Server.
• Handling admin activities like User Management, Scheduling the Extracts.
• Design the data model and implement the business logic to present to customer using OBIEE RPD.
• Reduced the number of reports using Column Selectors and View Selectors in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other features.
• Configuring iBOTs to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Interacted with the Business users to understand the user requirements, issues, layout, and look and feel of the application to be developed.
• End to End testing during the development and also for version upgrade.
• Troubleshoot Production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency.
• Participated in LDM sessions to make sure the objects meet the business requirements.
• Perform troubleshoot on all ETL processes and resolve issues effectively.
• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using Informatica.
• Responsible for creating complex mappings according to business requirements, which can are scheduled thru Dollar Universe.

Environment: Tableau, OBIEE, Informatica, Teradata, Oracle, Unix, Dollar U, PVCS, Unica, Kintana.

Confidential

Software Engineer

Responsibilities:

• Evolving Strategies for Extraction, Transformation, Conditioning and Loading of data from various Heterogeneous Data Sources into Data Warehouses using Informatica Power Centre.
• Developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Involved in designing of ETL specs, stage tables and ETL strategy.
• Involved in analyzing and importing source tables from the respective databases and flat files.
• Creating Mappings, Sessions, workflows for extracting the data from various source systems like relational databases, flat files and load data in to the data warehouse.
• Involved in the Unit testing to validate the target data as well the mappings and workflows to make sure they are following the standards.
• Also worked with QA team during test cycles, take ownership of the bugs raised by them and resolve the same to give the deliverables back.
• Created the job chains according to the enhancements and run the chain using Cronacle.
• Involved in preparing the BTEQ scripts.
• Prepared the MD120, the migration document to guide the migration team to migrate the enhanced objects from Dev to QA and QA to Prod as well.
• Prepared the Teradata Performance Document which includes Collect Stats, Explain plan and Validation Scripts.
• Taking ownership of the migration requests and giving Co-ordination to DBA and BI Migration teams.
• Contributed in Impact Analysis during the enhancements in case of common dimensions.
• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements