SUMMARY:

• Over 13 years of experience in the IT industry having experience in Snowflake, ODI, INFORMATICA, OBIEE, OBIA, and Power BI.
• Experience includes analysis, design, development, implementation, deployment and maintenance of business intelligence and data warehousing applications using Snowflake, OBIEE, OBIA and Informatica, ODI and DAC (Data warehouse Console).
• Excellent knowledge of Data Warehousing Concepts.
• Expertise in architecture, design and operation of large - scale data and analytics solutions on Snowflake Cloud
• Experience in ETL pipelines in and out of data warehouses using Snowflakes SnowSQL to Extract, Load and Transform data. Writing SQL queries against Snowflake.
• Expertise and excellent understanding of Snowflake with other data processing and reporting technologies.
• Played key role in MigratingTeradataobjects intoSnowflakeenvironment.
• Experience in buildingSnow pipe, Data Sharing, Databases, Schemas and Tablestructures.
• Experience in using SnowflakeCloneandTime Travel.
• Experience in data architecture technologies across cloud platforms e.g. Amazon AWS, Microsoft Azure, OpenStack, etc.
• Experience in Microsoft Azure cloud components like Azure data factory (ADF), Azure blobs and azure data lakes and azure data bricks
• Experience in extracting the data from azure blobs to the snowflake.
• Experience in extracting the data from azure data factory.
• Good understanding of Azure Databricks platform and can build data analytics solutions to support the required performance & scale
• Expertise in creating and configuring Oracle BI repository.
• Expertise in developing Physical layer, BMM Layer and Presentation layer in RPD.
• Proficient in creating and managing Dashboards, Reports and Answers.
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users.
• Expertise in configuration and integration of BI publisher with BI Answers and BI Server. BI Publisher reports development; render the same via BI Dashboards.
• Exposure on maintaining confidentiality as per Health Insurance Portability and Accountability Act (HIPPA).
• Closely worked with different insurance payers Medicare, Medicaid, Commercial payers like Blue Cross BlueShield, Highmark, and Care first to understand business nature
• Expertise in Design and Developing reports by using Hyperion Essbase cubes.
• Expert in ODI 12c/11g setup, Master Repository, Work Repository,
• Expertise in creating Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked onODIknowledge modules (LKM, IKM, CKM, RKM, JKM and SKM).
• Extensive Knowledge on Informatica PowerCenter 9.x/8.x/7.x (ETL) for Extract, Transform and Loading of data from multiple data sources to Target Tables.
• Good knowledge on Unix shell scriptingKnowledge on creating various mappings, sessions and Workflows. Knowledge on implementing end to end OBIA pre-built; all analytics 7.9.6.3.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements.
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
• Very good experience in SQL and PLSQL.
• Experience in various Business Domains like Manufacturing, Finance, Insurance, Healthcare and Telecom.
• Experience on performance Tuning by implementing aggregate tables, materialized views, table partitions, indexes and managing cache.

TECHNICAL SKILLS:

BI: OBIEE, OTBI, OBIA, BI Publisher, TABLEAU, Power BI, Smart View, SSRS, Hyperion (FRS), Cognos

ETL: ODI, Informatica, Data stage, SSIS

Database: Oracle, SQL Server, DB2, Tera Data and NoSQL, Hyperion Essbase

Operating Systems: Windows 2000, XP, NT, UNIX, MS DOS

Languages: VB, C#, Java Core and R

Cloud: Microsoft Azure, SQL Azure, AWS, EC2, Red shift, S3, RDS, EMR

Web Technologies: HTML, CSS, ASP.Net.

Scripting: Java script, VB Script, Python, Shell Scripting

Tools: & Utilities: Microsoft visual Studio, VSS, TFS, SVN, ACCUREV, Eclipse, Toad

Modeling: Kimball, Inmon, Data Vault (Hub & Spoke), Hybrid

Cloud Data warehouse: Snowflake

PROFESSIONAL EXPERIENCE:

Confidential

Snowflake Engineer

Responsibilities:

• Collaborated with the Functional Team and stakeholders to bring form and clarity to a multitude of data sources, enabling data to be displayed in a meaningful, analytic manner.
• Developing ETL pipelines in and out of data warehouse using Snowflake, SnowSQL Writing SQL queries against Snowflake
• Loaded real time streaming data using Snow pipe to Snowflake
• Created streams and tasks
• Implemented the functions and procedures in snowflake
• Extensively worked on Scale out, Scale up and scale down scenarios of Snowflake
• Created users and groups in Snowflake.
• Involved in the enhancement of the existing logic in the procedures.
• Expertise in the deployment of the code from lower to higher environments using GitHub.

Confidential, Madison, Wisconsin

Sr. Snowflake Developer

Responsibilities:

• Extracting business logic, Identifying Entities and identifying measures/dimensions out from the existing data using Business Requirement Document and business users.
• Experience in ETL pipelines in and out of data warehouses using a combination of Python and Snowflakes SnowSQL to Extract, Load and Transform data, then writing SQL queries against Snowflake.
• Data moved from Netezza to Snowflake internal stage and then to Snowflake, with copy options.
• Excellent experience in integrating DBT cloud with Snowflake.
• Excellent experience Transforming the data in Snowflake into different models using DBT.
• Created roles and access level privileges and taken care of Snowflake Admin Activity end to end.
• Converted user defined views from Netezza to Snowflake compatibility.
• Worked on SnowSQL and Snowpipe, loaded data from heterogeneous sources to Snowflake
• Loaded real time streaming data using Snowpipe to Snowflake
• Extensively worked on Scaleout and Scale down scenarios of Snowflake
• Created users and groups in Snowflake.
• Created data sharing between two Snowflake accounts.
• Used the Microsoft Azure cloud.
• Extensively used to azure data bricks for streaming the data.
• Extracted the data from azure blobs to Snowflake
• Loaded the data from Azure data factory to Snowflake.
• Built python and SQL scripts for data processing in Snowflake
• Automated the Snowpipe to load the data from Azure cloud to Snowflake
• Enabled analytics teams and users into the Snowflake environment.

Environment: Snowflake, SQL server, Azure Cloud, Azure data factory, Azure blobs,DBT, SQL OBIEE 12C, ODI -12CPower BI, Window 2007 Server, Unix, Oracle (SQL/PLSQL)

Confidential, Arlington, Virginia

Snowflake Developer

Responsibilities:

• Created tables and views on Snowflake as per the business needs.
• Used Tab Jolt to run the load test against the views on tableau.
• Created reports on Meta base to see the Tableau impact on Snowflake in terms of cost.
• Participated in sprint planning meetings, worked closely with the manager on gathering the requirements.
• Designed and implemented efficient data pipelines (ETLs) in order to integrate data from a variety of sources into Data Warehouse.
• Developing ETL pipelines in and out of data warehouse using Snowflake, SnowSQL Writing SQL queries against Snowflake
• Performed data quality issue analysis using SnowSQL by building analytical warehouses on Snowflake.
• Implemented data intelligence solutions around Snowflake Data Warehouse.
• Perform various QA tasks if necessary.
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Developed different procedures, Packages and Scenarios as per requirement.
• Creating interfaces and mapping between source and target objects in interface.
• Created jobs parallel and serial using Load plans.
• Handled the ODI Agent with Load balancing features.
• Implemented Change Data Capture (CDC) feature ofODI to refresh the data in Enterprise Data Warehouse (EDW).
• Monitored the SQL/PLSQL load plans.
• Fixed the SQL/PLSQL loads whenever scheduled jobs are failed.
• Optimized the SQL/PLSQL jobs and redacted the jobs execution time.
• Performed Debugging and Tuning of mapping and sessions.

Environment: Snowflake, AWS, ODI -12C, SQL server, Oracle 12g (SQL/PLSQL)

Confidential

OBIEE Technical Lead

Responsibilities:

• Collaborated with the Functional Team and stakeholders to bring form and clarity to a multitude of data sources, enabling data to be displayed in a meaningful, analytic manner.
• Estimated work and timelines, split workload into components for individual work which resulted in providing effective and timely business and technical solutions to ensure Reports were delivered on time, adhering to high quality standards and meeting stakeholder expectations.
• Coordinates and assists the activities of the team to resolve issues in all areas and provide on time deliverables.
• Independently evaluate system impacts and produce technical requirement specifications from provided functional specifications.
• Architected OBIEE solution to analyze client reporting needs.
• Identifying key dimensions and measures for business performance, Developing Metadata Repository (.rpd) using Oracle BI Admin Tool.
• Created Oracle BI Answers requests, Interactive Dashboard Pages and Prompts.
• Involved in Reconciliation Process while testing loaded data with user reports.
• Involved in implementing different behaviors of security according to business requirements.

Environment: OBI EE 11G, OBI Apps 7.9.6.3, Informatica 7, DAC 7.9.6.3, Oracle 11G (SQL/PLSQL), Windows 2008 Server.

Confidential, San Jose, CA

Oracle BI & ODI Senior Developer

Responsibilities:

• Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data using Business Requirement Document.
• Integrating the new enhancements into the existing system.
• Development of new reports as per the Cisco business requirements which involves changes in the design of ETL and new DB object along with the reports
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Created and managed Dashboards, Reports and Answers.
• Developed, supported and maintained ETL processes using ODI.
• Customization to the Out of the Box objects provided by oracle.
• Extensively used Integrated Knowledge Module and Loading knowledge module in ODI Interfaces for extracting the data from different source
• Created ODI interfaces, functions, procedures, packages, variables, scenarios to migrate the data.
• Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules.
• Created SQL/PLSQL procedure in oracle database.
• Development of new reports as per the Cisco business requirements which involves changes in the design of ETL and new DB objects along with the reports.
• Performance tuned the ODI interfaces and optimized the knowledge modules to improve the functionality of the process
• Prepared the Test scenarios and Test cases documents and executed the test cases in ClearQuest.

Environment: OBIEE 11G, ODI -11g, Window 2007 Server, Agile, Oracle (SQL/PLSQL)

Confidential, New York, NY

OBIEE Technical Team Lead

Responsibilities:

• Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data using Business Requirement Document.
• Created RPD and Implemented different types of Schemas in the physical layer as per requirement.
• Created Logical Schemas, Logical measures and hierarchies in BMM layer in RPD.
• Implemented different Levels of Aggregate tables and define different aggregation content in LTS.
• Created Different types of Dimensional hierarchies. .
• Created different types of reports such as Pivot tables, Titles, Graphs and Filters etc. and prompts in answers and created the Different dashboards.
• Provided the Report Navigation and dashboard Navigations by using portal page navigations.
• Implemented usage tracking and created reports.
• Security configuration in web logic server and both at Repository level and Webcat level.
• Configuring and working With Oracle BI Scheduler, delivers, Publisher and configuring iBots.
• Created topologies (Data Server, Physical Architecture, Logical Architecture, Contexts) in ODI for Oracle databases and Files.
• Created ODI Models, Data stores, Projects, Package, Package, Variables, Scenarios, Functions, Mappings, Load Plans, Variables, Scenarios, Functions, Mappings, Load Plans.
• Responsible for Unit, System and Integration testing and performed data validation for all the reports that are generated.
• Enhancing performance by understanding when and how to leverage aggregate tables, materialized views, table partitions, indexes in Oracle database by using SQL/PLSQL queries and managing cache.

Environment: Oracle BI EE (11g), ODI 11g, Windows 2003, Oracle 11g (SQL/PLSQL)

Confidential, Bentonville, AR

Oracle BI Senior Consultant

Responsibilities:

• Participated in gathering the business requirements, analysis of source systems, design
• Suitable data model, and develop metadata for the Analytical Reporting.
• Created a repository and built the physical and logical star schemes.
• Used the Different Levels of Aggregate Dimensional tables and Aggregate Fact tables.
• Created Views and Alias tables in physical Layer.
• Created Dimensional hierarchies for Store, Calendar and Accounts tables.
• Created the new measurable columns in the BMM layer as per the Requirement.
• Created Different types of reports including Union and Merged and prompts in answers and created the Different dashboards.
• Implemented the Different types of Functions like rolling functions, aggregated functions and TopN functions in the Answers.
• Provided the Report Navigation and dashboard Navigations.
• Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views.
• Implemented Data Level and Object Level Securities.
• Implemented the caching.
• Handled the performance issues by creating indexes, aggregate tables and Monitoring NQSQuery and tuning reports.
• Peer review of code, testing, Monitoring NQSQuery and tuning reports.

Environment: Oracle BI EE 10g, Windows 2003, DB2

Confidential

Oracle BI Consultant

Responsibilities:

• Creating Repository and designing physical and logical star schema.
• Created measures and implemented formulas in the BMM layer.
• Implemented Security management for users, groups and web-groups.
• Set up an Analytics Multi-User Development environment (MUDE).
• Created different views of reports such as Pivot tables, Titles, Graphs and Filters etc. and created different dashboards.
• Creating reports and prompts in answers and creating dashboards and links for the reports.
• Configured iBots for report delivery.
• Creating ETL mappings and different kinds of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure and Update strategy.
• Created and used Reusable Transformations to improve maintainability of the Mappings.
• Created various Reusable and Non-Reusable tasks like Session.
• Responsible for monitoring sessions that are running, scheduled, completed and failed.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
• Responsible for Unit, System and Integration testing and performed data validation for all the reports that are generated.

Environment: Oracle BI EE 10g, Informatica, Windows 2003, Oracle 10g