We provide IT Staff Augmentation Services!

Bi & Data Warehousing Consultant Resume

Summary:

  • Over 7+ years of experience in Data Warehousing, Data Analysis, Metadata Repositories, Data Migration, Data Mining, Distributed Databases Design, Data Cleansing, Enterprise Business Intelligence, Reporting, multiple Confidential Processes and all phases (Full Life Cycle) of software application development and CDH 5.X admin. I have realized valuable hands - on experience working on various DWH Projects implementing, Analytics Solutions using various reporting tools like OBIEE, Confidential and SSRS, Confidential Tools for various Service and Banking applications (BFSI), Wealth Management Systems (WMS), Retail Banking and commercial Banking modules. I have excellent understanding of system development life cycle and has proven project management skills. I am self-motivated, team-oriented individual with strong ability to merge and coordinate with other team members in the respective work environments.
  • 2+ years of experience using OBIEE 11.1.1/11.1.5
  • Experience in Repository Administration tasks like creating Repository, User groups, Users and managing users by setting up their privileges and profiles.
  • Experience in OBIEE Server Administration Tool, OBIEE Answers, Dashboards, iBots and Delivers.
  • 3+ years of experience using tools such as Informatica Confidential Center 8.6/9.1/9.5
  • Worked extensively on Informatica Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer) Workflow Manager/Monitor and Repository Manager
  • Strong experience in Data modeling (conceptual, relational, dimensional, architectural, physical), Data Cleansing, Decision Support Systems (DSS), physical and logical data design.
  • Strong expertise in developing Informatica Transformations, Reusable Transformations, Mappings, Mapplets, Sessions, Tasks, Workflows and Worklets.
  • Experience in designing and developing complex mappings applying varied transformation logic such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected lookups, Sequence Generator, Rank, Update Strategy, Stored Procedure, External Procedure, XML Source Qualifier, Normalizer.
  • Designing, implementing and maintaining Confidential process using Data parallelism layouts, Meta Data management, Metadata Catalog management including creation of Metadata Catalog Creation, adding tables into catalogs, deletion of catalogs.
  • Worked in improving performances by tuning of Informatica Mappings, Transformations, and Sessions.
  • 6+ years of expertise in Database Management Systems
  • Experience in Oracle 10g/11g R2, SQL Server 2005, 2008 and 2012, UDB DB2, TOAD, Stored Procedures, PL/SQL, MS SQL.
  • Skilled communicator, ability to convey technical information at all levels, analytical thinker and excellent problem identification and solving capability.
  • 3+ years of experience using Confidential 10.1.1/10.2.1
  • Deft in BI- Confidential involving analysis, design, development, testing, migration, debugging and run time analysis in-depth understanding of mapping client's requirements, custom designing Confidential solutions & troubleshooting for complex Information Systems Management.
  • Expertise in Confidential 10.1 & 10.2.1 Architecture Concepts, Actuate, Work Process Architecture Concepts, An ardent analyst with a flair for adapting quickly to dynamic business environments and resolving complex business issues; deft in interacting with clients, understanding current business processes, gathering new business user requirements.

Technical Skills:

Data Warehouse Tools: Informatica 8.6/9.1/9.5, Datastage 8.5/9

BI Tools: Confidential 10.1/10.2, OBIEE 10g/ 11/1.1/11.1.5 , SPLUNK 6,SAP BO 4.X, SPSS 14/16

Operating Systems: UNIX, Read hat Linux, Cent OS Linux Windows

Languages: C Basics, Java Basics, Python 3.1, SQL, PL/SQL.

Databases: Oracle 10g, 11g, Teradata, MS-SQL 2008

Web Tools: HTML, XML

Big Data: Hadoop 2.x, CDH 5.X

Scripting Language: Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

BI & Data Warehousing Consultant

Environment: CDH 5.X, Azure

Responsibilities:

  • Complete Hadoop cluster administrator of 35 nodes(4 master Nodes(2 name nodes 2 resource managers) 1 edge node and 30 data nodes/node managers
  • Cluster on azure with 35 nodes cluster for production and 10 node cluster for staging environment.
  • Monitoring the cluster using cloud
  • Performed the Benchmark tests like Confidential
  • Daily health check activities like resources availability like Confidential, Memory, Confidential disk capacity, hue users count, jobs killed and failed in hue, long running applications, monitoring heap size of NM and RM,
  • Monitoringtheservices(NN,RM,Zookeeper,NodeManager,HiveServer,WebHCat Server, HUE, JobHistroy Server, base Master and Region Servers) having good health, if not troubleshooting the services .
  • Admin tasks like commissioning/decommissioning, Balancing, Benchmarking and performance tuning the cluster.
  • Monitor and act upon dead/decommissioned nodes and failure of cluster nodes .
  • Performing Cluster metrics on weekly basis.
  • Attended the boot camps.
  • Hadoop support for customer 24/7

Confidential

BI & Data Warehousing Consultant

Environment: Confidential 10.2.1, SQL Server 2008, Informatica 9.5, .Net

Responsibilities:

  • Replacing desktop application with web application.
  • Build tool to automate the complete file processing and incentive calculations.
  • Build a robust, centralized & controlled Decision support platform to measure Customer & Product profitability against different dimensions (Product, Customer, Confidential & Regions etc)
  • Develop product specific data model to scale up easily or to in corporate regulatory changes easily
  • Build spread sheet reports in specific format as customer was expecting
  • Providing alerts to users base on the key information
  • Focused on complete Wealth management products along with the Confidential Commercial, Retail, Private client services and Trust
  • Build logical dimensional model in Confidential FM
  • Build security and authorization for the 30 users based on their role
  • Build building blocks - Confidential BI for Reports and Dashboards
  • Involved in requirements analysis, designing, developing, testing, and deployment.
  • Reviewed Business Requirement Documents from users, assessed the requirements functionally and translated business requirements into technical solutions.
  • Worked with business analysts to identify and understand source systems Created high level design documents for new requirements interacting with the users
  • Defined and documented the technical architecture of the data warehouse, including the physical components and their functionality.
  • Helped in creating new dimensional data models according to requirements.
  • Involved in defect resolution during QA/UAT testing.
  • Actively involved in deployment and post release support.
  • Migrating Confidential form oracle into Confidential Hadoop Big data.

Confidential

Responsibilities:

  • Identified the fields that needs to be reported from .Net Application as per the requirements and data mapped those fields.
  • Created Confidential design documents as per the requirements and high level design document.
  • Created new customized mappings to move data from Siebel Application database to Analytics Warehouse and modified the current existing customized mappings as per the requirements.
  • Extensively used various transformations like Lookup, Source Qualifier, Expression, Update Strategy, Joiner transformations to build mappings.
  • Used Post and Pre session commands to call scripts which Drop, recreate indexes, run reorg and run stats on the warehouse table which was loaded.
  • Used Post session success commands to invoke the next workflow automatically without having to actually kickoff next workflow manually.
  • Extensively involved in pre and post deployment tasks which involved monitoring Confidential, disabling and enabling the Auxiliary mappings for tables which were force extracted and coordinating with DBA for Reorg and Database backups.
  • Involved in User Requirements Gathering.
  • Developed various Confidential Standard & Dashboard Reports for calculating Travel & Expenses.
  • Designed Data Model to satisfy the User Report requirements.
  • Involved in Detailed Documentations / Client Calls / Web ex Sessions.
  • Involved in setting up Confidential DEV / UAT / Production environments.
  • Designed Data Model in Frame work Manager to satisfy the user's requirements.
  • Used Informatica Powercenter to populate the Data Warehouse from the WMS system and other sources.
  • Performed Confidential using Informatica to create Datamarts as per the business requirements.
  • Analyzed the data elements for Forecast and Quota facts and their corresponding dimensions.
  • Customized the Physical, Business, and Presentation Layer of the repository.
  • Developed various kinds of List, Cross Tab, and Chart and Dashboard report using Confidential 8.4 & Confidential 10.
  • Scheduling the reports based on the clients requirements using IBM Confidential Connection.
  • Developed Various Dashboards Finance, Impact, Helpdesk, Sales Dashboards.
  • Understanding the existing stored procedures and migrated all the existing stored procedures to various List, Crosstab, and Chart reports using Confidential .
  • Handling complete Datacenter Migration.
  • Designed Transformer Cubes in Confidential 10.
  • Involved in Setting up the Confidential and DB environment offshore and onsite.
  • Involved in gathering the requirements and documented the requirements gathered.
  • Designed the data models in Frame work manager based on the client's requirements.
  • Involved in supporting the existing Reports
  • Involved in training the team at Onsite

Confidential

Lead Developer/ Data Analyst

Environment: SQL Server, Oracle 11g, Informatica 9.5

Responsibilities:

  • As a part of the Confidential my responsibilities included Production support which involved resolving the existing production issues and monitoring the nightly jobs.
  • Worked with business analysts to analyze the existing production defects and come up with solutions to cleanse the corrupted data.
  • Involved in interacting with the business analysts, end users to find and fix the discrepancies in production data.
  • Acted as liaison between the business users and developers to address the Production issues in a phased manner.
  • Decided on the scope of OM release systematically and communicated to the business users of the projected items for the release.
  • Involved in addressing the Production alerts and promptly addressing the open tickets to solve the issues.
  • Involved in rigorous Unit testing, integration testing of the mappings developed and moved the mapping into the prod environment.
  • Extensively used various transformations like lookup, update, filter, router, joiner transformations and SQL override to filter the data coming from the source.
  • Involved in fine-tuning the Confidential mapping by studying the session logs and coming up with a better strategy to deal with bottlenecks such as time involved in building the cache.
  • Involved in developing and deploying the cron jobs to create temporary tables, which will be used, by analysts and developers to test their code.
  • Wrote complex SQL queries to test the data in production for analysis by business analysts and to cleanse the corrupted data.
  • Extensively used TOAD to fine-tune the SQL using EXPLAIN PLAN and Oracle hints.
  • Involved in meetings with application developers to identify database performance bottlenecks to help fine-tune the database to improve the query performance.
  • Implemented CVS to maintain a copy of changes that are made to the code.

Confidential

Informatica Developer

Environment: Confidential 10.1.2, DB2, Informatica, Windows 7,SQL Developer

Responsibilities:

  • Involved in User Requirements Gathering.
  • Developed various Confidential Standard & Dashboard Reports for calculating Travel & Expenses.
  • Designed Data Model to satisfy the User Report requirements.
  • Involved in Detailed Documentations / Client Calls / Web ex Sessions.
  • Involved in setting up Confidential DEV / UAT / Production environments.
  • Designed Data Model in Frame work Manager to satisfy the user's requirements.
  • Used Informatica Powercenter to populate the Data Warehouse from the ERP system and other sources.
  • Performed Confidential using Informatica to create Datamarts as per the business requirements.
  • Analyzed the data elements for Forecast and Quota facts and their corresponding dimensions.
  • Customized the Physical, Business, and Presentation Layer of the repository.
  • Developed various kinds of List, Cross Tab, and Chart and Dashboard report using Confidential 8.4 & Confidential 10.
  • Scheduling the reports based on the clients requirements using IBM Confidential Connection.
  • Developed Various Dashboards Finance, Impact, Helpdesk, Sales Dashboards.
  • Understanding the existing stored procedures and migrated all the existing stored procedures to various List, Crosstab, and Chart reports using Confidential .
  • Handling complete Datacenter Migration.
  • Designed Transformer Cubes in Confidential 10.
  • Involved in Setting up the Confidential and DB2 environment offshore and onsite.
  • Involved in gathering the requirements and documented the requirements gathered.
  • Designed the data models in Frame work manager based on the client's requirements.
  • Involved in supporting the existing Reports
  • Involved in training the team at Onsite

Confidential

Data warehouse Developer

Environment: OBIEE 11g, Oracle 11g, Informatica 9.1, Windows 7

Responsibilities:

  • Performed the Incremental Confidential process to populate the Data Warehouse
  • Gathered client’s requirements and performed gap analysis on the OTB Business models to identify the gap.
  • Proposed Business Model performed Dimension modeling, Identified Fact tables & Measures, Identified Dimension Tables to store business attributes, Identified Aggregate tables & their definitions.
  • Created and modified OTB reusable mapplets and transformations to be used in mappings.
  • Developed Informatica mappings for populating aggregate tables.
  • Modified the existing workflows for refresh load using image tables.
  • Worked on the transformations like Expression, External Procedure, Router, Sequence Generator, Aggregator, Filter, Joiner, and Lookup.
  • Created Workflows to execute tasks such as sessions, e-mail notifications and shell commands.
  • Fine-tuned mappings and transformations to address the performance issues.
  • Coordinated with OLTP/Enterprise DW team for data mapping.
  • Created and modified the Business Models as per the client’s requirements
  • Created and configured Siebel Analytics tables.
  • Built Repository at 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) and Presentation layer level (create presentation catalogs).
  • Worked on Siebel Answers to create the reports and used Filters.

Confidential

Data Warehouse Developer / Database Administrator

Environment: Informatica, Erwin 4.0, SQL, PL/SQL, OBIEE 11.1.1

Responsibilities:

  • Involved in data modeling using Designer for the data warehousing application as per business requirements using ERwin.
  • Used Informatica to extract data from various Operational systems, External systems and Staging area.
  • Performed various Informatica administrative tasks and managed Informatica repository.
  • Addressed critical areas of impact in terms of performance, data integrity, runtime errors, user interface, application maintenance and development.
  • Created source to target mappings, mapplets according to business requirements.
  • Worked on the transformations like Source Qualifier, Expression, External Procedure, Router, Sequence Generator, Aggregator, Filter, Joiner, and Lookup.
  • Worked on performance tuning of various mappings and session to identify and remove the bottle necks.
  • Used join transformation to extract data from different data sources.
  • Used Informatica server manager to create, schedule, execute and monitor sessions and batches.
  • Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
  • Enforced database integrity using primary keys and foreign keys.
  • Created PL/SQL functions to facilitate business functions and calculations.
  • Created Oracle database with normalization rules and migrated legacy database data by using SQL Loader.
  • Involved in developing Front and Back end Activities to upload client’s information into main database.
  • Extensively wrote triggers for Data construction, Data validation and Transfer of data in the database.
  • Database synchronization done by creating Remote Stored Procedures which are stored at customer’s database and calling them from host database by using Distributed database links.
  • Developed triggers for calling remote stored procedures.
  • Reviewed database design and suggested changes in primary keys and indexes for more efficient querying.
  • Concepts like Stored Procedures, Packages, Functions, and Triggers are implemented.
  • Developed PL/SQL Libraries and Object Libraries.

Hire Now