SUMMARY

• Confidential has over 13 years of total IT experience in Data warehousing, Bigdata (Hadoop, Hive), Business Intelligence tools (Oracle Analytics Cloud/OBIEE/Tableau/PowerBI/Birst) and ETL (Informatica/Talend).
• He has experience and technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and documentation.
• He has performed implementation of Data Warehousing and Oracle business Applications for Manufacturing, Financial, Supply Chain and Order management.
• Confidential has five years of Dimensional and Relational Data Modeling experience using Star Schema/Snowflake modeling, Fact and Dimension tables, and Physical and Logical data modeling.
• He has proficient multi - tasking abilities, and is an efficient and effective problem solver.
• He has excellent technical skills coupled with outstanding business sense.
• Confidential is an excellent communicator and expert at presenting highly technical concepts in easy-to-understand language, works well within a team and have a positive attitude and good team building skills, and a passion for learning new technologies.

TECHNICAL SKILLS

Operation Systems: Windows 2008/NT 4.0/98/95/ME/XP/Vista Pro/Win 7 Pro Windows 10, IBM AIX,HP Unix, Linux

Database Technologies: Oracle 11g/12C, MS SQL 7/ 2014, DB2 7.3.3/8i, Teradata, Sybase, HIVE, Impala.

Programming Languages: Java, T-SQL,Unix scripting

Software and Tools: Oracle Analytics Cloud, OBIEE 12c/11g, Informatica 9X,Informatica Developer 10.1, Informatica Big Data Management, Informatica Cloud, Talend, Oracle BI Applications 7.9.5/7.9.6. x, Hadoop,Spark 2.0,Cloudera Big data

Awareness: Tableau,Power BI, Birst, Salesforce Cloud - Administration, Amazon web services (EC2, S2 & SimpleDB)

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. Consultant/BI Cloud Architect

Responsibilities:

• Designed and configured new instance for Analytics on Oracle Cloud & configured high availability(cluster)
• Configured IP networks, IDCS and SSO on Oracle Cloud.
• Designed and Configured LBaaS, DBaaS for load balancing and metadata migration.
• Configured block storage and archive storage for compute and backup.
• Lift and Shift of Datamodel (RPD) and reports from On-Perm to OAC cloud.
• Integrated Microsoft ADFS with Oracle IDCS for Authentication/Authorization.
• Configured Usage tracking, Act As, Alerts and BI publisher for OAC cloud
• Created new reports/visualization using Oracle Data Visualization and configured machine learning (ML) and R scripts.
• Configured Mobile apps like Oracle BI, Day by Day and Synopsis.
• Converted PowerBI reports to DV reports to demonstrate the POC for migration.

Environment: Oracle Analytics Cloud 18.2.1., Oracle DBaaS, PaaS, Mobile Apps, Oracle Data Visualization, Machine Learning (ML) and R

Confidential

Responsibilities:

• Configured the Oracle analytics cloud(OAC) for Big data, BI Applications(BIAPPS) and Oracle DBaaS for internal projects/demo
• Refreshed the data and schema for the latest version of BIAPPS on premise DB and cloud DB(DBaaS)
• Troubleshoot and fixed the errors related to Big data cloud migration of the reports/dashboard.
• Configured the OAC(PaaS) to work with on premise database using Oracle remote data connector (RDC)
• Migrated Data from On-Perm DB to DBaaS using export and import utility.

Environment: OBIEE 12c, Oracle Database 12c, OAC, BI Application, Linux, Big data, Hadoop, Hive, ODI

Confidential, St Louis, MO

Responsibilities:

• Project management, requirements analysis, data and system architecture, dimensional data modeling, ETL development, performance tuning, data analysis, system testing and user training, operational management and report and dashboard development.
• Designed, developed the OBIEE solution for financial analytics to cater the requirements of CFO. Developed 30+ reports with complex metrics with summary, rolling and year over year comparisons.
• Responsible for designing the integrated solution for HFM data into OBIEE consisting of data model design, Process flow, development of ETL and BI reports.
• Designed and developed BI solution for New hires and turnaround metrics for HCM analytics. Developed new dashboard with charts, summary reports, detail reports and drilldown reports.
• Designed and developed Informatica jobs to handle complex logic for AMG project and Metrics to reduce the load on BI repository work.
• Upgraded OHADI 3.1 and OHF 7.0 compared and fixed all the issues related to upgrade in ETL and RPD
• Performance tuning using fact table partition, Index creation and ETL modifications.
• Used DAC and TIDAL to schedule and run the full incremental ETL loads and to schedule the Informatica jobs in Oracle Business Analytic Warehouse.

Environment: OBIEE 11g, Oracle Database, BI applications 7.9.6, DAC, Informatica 9.1, ServiceNow, Tidal, OHADI, Linux

Confidential

Big Data Developer

Responsibilities:

• Prioritizing business initiatives and coordinating across teams
• Performing comparative analysis of tools and making recommendations
• Analyzing and recommending data and storage formats - Avro, Parquet, flat files
• Designing automated processes for data ingestion
• Developing strategies for delta detection
• Designing Streamsets Data Collector pipelines to ingest data into Hadoop and destination tables
• Parameterizing pipelines and auto creating partitioned hive tables
• Utilizing Spark Data Frames and developing Pyspark code using python pandas dataframe for reading JSON files, applying transformations and ingesting into hive tables
• Developing full and incremental load strategies using Pyspark
• Running and monitoring Pyspark code in client and cluster modes
• Converting Pyspark scripts into Informatica BDM mappings
• Developing dynamic Informatica BDM mappings to ingest data and accommodate data drift
• Evaluating Informatica BDM’s support for engines such as Spark and Blaze and converting existing mappings with map reduce to utilize spark
• Evaluating Informatica’s smart executor as compared to manually assigning Hadoop engine for BDM mappings
• Writing Linux scripts to provided automated quality check on source files and hdfs directories
• Creating Tableau Visualizations
• Publishing Tableau Reports, Dashboards, Data sources in client server environment
• Developing Tableau Visualizations, sheets, dashboards, stories.

Environment: Cloudera Hadoop 5.8.5, Hive, Spark 1.6.0, Pyspark, Python 2.7, Streamsets 2.7.1, Informatica BDM 10.1.0, 10.1.1, Tableau 10.3.2, 10.4.0

Confidential, Woonsocket, RI

Responsibilities:

• Gathered user requirements, worked with developers to transform data in generic formats business process.
• Configured Security for users, dashboard and subject areas
• Designed and Development of ETL /DAC for custom asset management.
• Performed Code Migration and HIPAA Compliancy standards for the client specific requirements.
• Accessed and modified OOTB mappings as per the customer requirements.

Environment: OBIEE 11g, BI Apps 7.9.5, Informatica, DAC, Oracle Database 9i.

Confidential, Minneapolis, MN

Responsibilities:

• Installed and configured OBIEE 11g on Linux with cluster configuration for high availability
• Upgraded and Merged the Repository and Catalog to the BIAPPS 7.9.6.4. Version and worked on all the upgrade issues.
• Integrated OBIEE with Marketing Application
• Tested Segments, Lists and List formats
• Configured SSO, Usage Tracking and Scheduler for 11g.
• Configured Authorization using DB tables.
• Worked with Offshore team in resolving the report issues and validation of reports and dashboard.
• Resolved all the upgrade issues in reports, prompts and ibots.
• Trained the Users with new functionality of OBIEE 11g

Environment: OBIEE 11g, BI Publisher, DAC, Informatica, Oracle Database, SQL developer.