SUMMARY:

• Over 13 years of experience working with Business Intelligence, Informatica, Big Data on Oracle, SQL Server, Netezza and RedShift Databases.
• Over 5 Years of experience designing and developing ETL and BI Enterprise solutions for various corporates
• Expertise in identification of business and data requirements, converting them into conceptual and logical data models.
• Knowledge of Hadoop Stack, Data Warehouse/Data mining principles, architecture and development in multi - terabyte scale environments.
• Well versed with Agile and SCRUM methodologies.
• Expertise on working with AWS and Azure Cloud Environments.
• Expertise in designing techniques like Snowflake Schemas, Star Schema, fact and dimension tables, logical and physical modeling.
• Experienced in data ingestion, processing and ETL design/development/deployment.
• Developed Data Migration Plans using Informatica Power Center and BI environments.
• Experienced in developing Informatica process, architecture design, debugging, performance tuning of mappings, sessions and workflows
• Expertise in complex SQL Query writing skills and experience working with Data Warehouses, Data Marts and relational databases.
• Extensive experience in analysis, design, development, implementation, deployment and maintenance of Business Intelligence applications.
• Expertise in Developing Data Visualization, Data Driven reports and Drill Reporting solutions using Microsoft Power BI, MicroStrategy, Tableau, Business Objects.
• Experienced in Hadoop Map-Reduce Job Scheduler paradigms, Apache Spark, Kafka, Hive, Flume, Sqoop, Oozie and NoSQL database like HBase and MongoDB.
• Extensive experience as Oracle Database Developer and performance/tuning and optimization.
• Experience in working with AWS Redshift Database Configuration, Creating Tables, Views, Indexes and Tuning Queries.

TECHNICAL SKILLS:

Hadoop/Big Data Technologies: HDFS, Map Reduce, Pig, HBase, Hive, Spark, Kafka, Sqoop and Flume and HP Haven

Operating Systems: Windows XP/2000/NT, Linux and Solaris.

Scripting Languages: Perl and Java.

Programming Languages: SQL and PL/SQL.

Database: Oracle 11g/10g/9i, SQL Server, Netezza, Amazon Redshift and MySQL

IDE/Tools: IntelliJ Idea 5.1, Toad and SQL Developer.

DWBI Tools: Microsoft Power BI, Tableau, QlikView, Business Objects and Cognos.

ETL Tools: Informatica 9.x and CloverETL

Cloud Environments: AWS, Microsoft Azure and HP Cloud

PROFESSIONAL EXPERIENCE:

Confidential, CA

Informatica and BI Architect

Responsibilities:

• Gather Business Requirements to design Informatica ETL Workflows and Mappings
• Working on Informatica Architecture to develop new 21CF Jobs and migration of existing ETL Jobs to AWS environment.
• Performance tuning of the SQL’s used by ETL and Reports on Redshift database.
• Migrate ETL Jobs to connect to new Salesforce source DB as the exiting application environment has been moved to Salesforce from oracle.
• Designing ETL workaround for Redshift as direct load from Application Database is slower than expected.
• Determine the AWS Cluster size based on ETL Jobs, load and resources demand to run the processes.
• Design MicroStrategy Architecture and develop New Visualization for the business Team.
• Working on designing the Tableau reports to provide Business Dashboards to monthly and Yearly analysis.
• Schedule Informatica Workflows with Autosys utility and deploy on AWS.

Confidential

Responsibilities:

• Performing Requirements gathering from Business Analysts, Clients and Admin Users for Designing logical and physical data model for the EDW Migration and upgrades
• Preparing Migration Document for EDW Applications that is getting migrated to AWS Environment.
• Tune ETL Loads and MicroStrategy Report queries to run on par with Netezza.
• Developing copy utility Scripts to load files to AWS
• Migrating Informatica mappings and make sessions full Push down compatible
• Designing Amazon Redshift DB objects for right Compression and performance using intelligent sort keys
• Working on admin activities like Cluster maintenance for long running Queries.
• Working on Workload management users and groups maintenance
• Performance tuning of Queries on Redshift Environment.
• Work with AWS Environment to develop AWS EMR cluster for Developing Spark Solution, push data to data lake in Amazon S3.
• Analyze data using Databricks and develop Tableau reports.

Confidential

Responsibilities:

• Gather Requirements from Business and IT users to develop the Logical and Physical data model for Fox Media Cloud.
• Analyze data from larger Data sets to extract data from various Fox Business Sources (Stores, Amazon, Theatrical, TV,).
• Architect EDW Process and ETL design for Confidential
• Responsible for providing Mapping documents with logic involved to load the data using Informatica for Confidential Application.
• Developed Complex Informatica Mappings, session and workflows required to load EDW.
• Work with web services to get data parsed and moved to the EDW database.
• Create Tables, Views, Sequences and Procedures in SQL Server and SQL DW.
• Working on MicroStrategy Design and Development of Reports based on the requirements gathered from different Business Users and Technical team.’
• Scheduled Informatica Workflows with Autosys utility and deploy on AWS.
• Working on Microsoft Power BI solution to generate Data Visualization and Drill Reports for top level management.
• Develop data driven Reports and Dashboards required for daily, weekly, monthly and Yearly Business growth Visualization and Analytics.
• Responsible for providing complex SQL queries and Views for the ETL process to pull data based on the need.

Environment: IBM Netezza, Amazon AWS, Redshift, SQL Server, Informatica 10.1, 9.5.x, 9.6.x, MicroStrategy 10, Microsoft Power BI and Microsoft Azure.

Confidential, Irvine, CA

Lead Informatica and BI Consultant

Responsibilities:

• Interacted with business analysts, client services to gather business requirements and translate them to technical specifications.
• Participated in the technical design discussions and prepared ETL high level technical design documents.
• Responsible for analysis of source to target mapping and prepared functional and technical design documents.
• Designed complex transformations like Source Qualifier, Expression, Router, Joiner, Lookup, Update and Sequence Generator using the power center designer.
• Created complex Informatica mappings using transformations to extract, transform and load DataMart.
• Wrote complex PL/SQL scripts to load data into target.
• Created Data model using Microsoft Visio.
• Scheduled Informatica Workflows with Autosys utility and deploy on AWS.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Performed performance tuning of Informatica Transformations
• Utilized Business Objects Designer to prepare Universes from the warehouse database.
• Designed reporting solutions such as cubes, reports and dashboards and guide reporting team in building and reviewing those.
• Supported development teams during UAT/PROD deployments and bug fixes
• Developed POC on Migration to CloverETL and QlikView for Next generation product development.
• Created CloverETL graphs to call Web Services to populate security data in target

Environment: MySQL 6.2, Informatica 9.5.1, CloverETL 4.0, Business Objects XI 4.1 and QlikView 11 and Microsoft Visio.

Confidential

ETL Developer/Lead BI Analyst

Responsibilities:

• Responsible for Developing Informatica ETL Jobs for extracting date from Various HP Cloud and Network applications
• Interacted with Customers and Developed Complex Informatica Mappings, session and workflows required to load to the DW.
• Worked in capacity of BI Solution Architect and was responsible for entire BI Solution Architecture including Data Model for the data mart, Database design, ETL and reporting system.
• Interacted with business users and project stakeholders to translate the requirements into functional and technical specifications to create universe.
• Translated the systems requirements into software design documentation.
• Planned, designed and shaped the new generation reporting platform using Hive, QlikView and Business Objects.
• Developed formalized solution to migrate the existing indigenous reports and database tools to new generation platform.
• Analyzed data coming from different Cloud management solutions (ECC, Storage essentials, Network Insite, Storage Automation etc.) and created the Schema.
• Involved in Service Oriented Architecture (SOA) to migrate data using data service layer that reduced ETL load and improved data integrity, data security and mitigated risks.
• Led a team of BI/DBA/ETL Developers in development of BO Universe and reporting.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Designed and developed QlikView dashboards for Operations and Marketing business groups.
• Designed, developed and presented Dashboards, ad-hoc reports, KPI Metrics, trending reports, historical reports with slice/dice across various categories etc., to validate the idea of new generation reporting platform to the business users and key decision makers.
• Trained the team with BO and Big Data Integration and reports generation.

Environment: Informatica 9, Business Object XI4.1, QlikView 9, MySQL, SQL Server and Oracle.

Project: HP Service Health Reporter (EDW Development/Upgrade)

Lead Business Intelligence Analyst

Responsibilities:

• Analyzed and built data warehouse for Jupiter (SEi) Release.
• Designed data model (dimensions and facts).
• Designed, developed and monitored the logical/physical data marts, data base objects (like tables, indexes, procedures, packages, functions, etc.); performed data analysis via SQLs, data cleansing.
• Participated in customer requirements gathering and designed Business Objects Universe.
• Led Team of BI developers in developing and delivering the Release.
• Conducted daily Scum meetings and worked on delivering the release.
• Interacted with team members and provided the requirements and BO Universe and Webi reports.
• Worked on complex relations and resolved loops and traps in Business Objects Universe.
• Participated in model design and implementation.
• Handled database changes for SE product new device support.
• Worked on database backup related changes and migration changes.
• Interacted with customers and resolved issues.
• Trained clients to create custom reports using Webi Drag and Drop feature.

Environment: Oracle 11g, Informatica 8.1, Business Objects XI 4.0, Universe, Webi Reports and Dashboards.