We provide IT Staff Augmentation Services!

Informati And Bi Architect Resume

CA

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

Informatica and BI Architect

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

Informatica and BI Architect

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.

Hire Now