SUMMARY

• 12+ Years of Extensive experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• 10+ Years of Business Intelligence and data warehousing Experience
• 3+ Years of Big Data implementation Experience
• 10 Years of ETL and Database Experience
• 7 Years of Business System Analyst Experience
• Extensive experience in the analysis, design, development and implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies.
• 0+ years of experience with complete life cycle implementations using Business Objects XIR3, Dashboard Manager, Web Intelligence, SAP BO BI 4.2, Tableau, ClickView, Micro strategy, OBIEE
• 10 years of experience in ETL using, Informatica Power Center, FACT Tables, Dimension Tables, Star Schema Modeling, OLTP, OLAP, MS SQL Server, MS Access, DataStage, ERwin, Data Integrator, Big Data, Hadoop, Hive.
• 7 years of experience in Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin,
• 7 years of experience full project life cycle implementation (Requirements gathering to production phase).
• Developed Project Schedule, Use Cases, Business Process using UML 2.0, MS Visio, MS Project, Oracle Designer 10g/9i.
• 10 years of experience in Oracle, DB2, MS SQL Server, SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, TOAD.

TECHNICAL SKILLS

Business Intelligence: SAP BO BI, BOBJ, Business Objects XIR3, Web Intelligence, Designer, Supervisor, SSAS, SSIS, SAP HANA, microstrategy, Business Objects Reporting, Xcelsius, XI R3, Data Integrator, Clickstream, Tableau, Qlikview, SAS, OBIEE.

Data warehousing: Informatica Power Center,, Repository Manager, Designer, Data Stage, Erwin, Salesforce, Big data, Hadoop, Hive, oozie, sqoop, Dimensional

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin.

Databases: Oracle11g, NO-SQL Hbase, SQL Server, PL/SQL, Crystal, TOAD, Microsoft Access, EPIC Chronicle, Clarity, Teradata

Programming/Web Technologies: SQL, PL/SQL, HTML, ASP, VBscript, Java, TOAD, MS Front Page, Apache Web Server, Visual Basic, Python

Environment: Windows NT, Unix, Linux, JIRA

PROFESSIONAL EXPERIENCE

Confidential, San Rafael, CA

Business Intelligence and Data warehousing Analyst

Responsibilities:

• Analyzing BRD to design datawarehousing components.
• Design and Develop Bo Universe - objects, Class and Business semantic layer
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Developed mappings between multiple sources such as Teradata, flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created UNIX shell script to transport flat files from different ordering systems to the ETL server.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Moved all crawl data flat files generated from various retailers to HDFS for further processing.
• Written the Apache PIG scripts to process the HDFS data.
• Created Hive tables to store the processed results in a tabular format.
• Developed the sqoop scripts in order to make the interaction between Pig and MySQL Database.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures.
• Developed Tableau data visualization, reports, dashboards including several graphical representation
• Utilized Tableau server to publish and share the reports with the business users.
• Involved in migration of BO XI to BO 4.2 .
• Worked on object oriented programming (OOP) concepts using Python
• Analyzed the data by performing Hive queries in Hadoop ecosystem.
• Working with Query & Reporting team to analyze, design and construct reports from data warehouse using Business Objects.
• Design semantic layer data model with accurate definitions and joins in BO Universe
• Developing Tableau dashboards
• Validate source data is consistent with data mappings
• Design,Development of reports for Business users for analytical and dashboard reporting

Environment: Informatica PowerCenter, Teradata, Oracle 11g, SAP BO BI, Business Objects, BO 4.2, SAP HANA, Hadoop, Hive, HBase, Sqoop, oozie, Denodo, Tableau, Qlikview, UNIX, TOAD, RedShift, Python

Confidential, San Jose, CA

Business Intelligence and Data warehousing Lead

Responsibilities:

• Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification and Created Facts and Dimension Tables.
• Developed various ETL Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Validate source data is consistent with data mappings
• Analysed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Working with Business users to analyze, design and construct Business Objects Universe.
• Design semantic layer data model with accurate definitions and joins

Environment: Teradata, Informatica Power Center, SAP BO BI, Business Objects, SAP HANA, Oracle EBS, ER/Studio, microstrategy, PL/SQL, TOAD, OBIEE, Salesforce, Python

Confidential, San Francisco, CA

BI and Data warehousing Architect

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Used Informatica Designer to create, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power Center, Business Objects XI R2, Erwin 7.2, SAS, PL/SQL, Crystal Enterprise XI R2, Oracle 10g, TOAD

Confidential, Pleasanton, CA

BI and Data warehousing Architect

Responsibilities:

• Involved in Requirements gathering, build of the Data Warehouse and Design of Data mart using Star Schema.
• Writing specifications and requirements for the reporting and Analysis Platform.
• Developed various Mappings, and Transformations for data marts and Data warehouse.
• Developed ETL transformations to populate targets based on business requirements data sets.
• Involved in design, development of ETL solution, data architecture for staging and datamarts.

Environment: Informatica Power Center, Business Objects XI R2 (Designer, CMC, CCM, Supervisor, BO Full Client, Web Intelligence, Dashboard Manager ), Crystal Enterprise XI R2, Oracle, OBIEE, SQL Server, TOAD, Teradata, SQL Assistance, PL/SQL, EPIC Chronicle, Clarity

Confidential, Union City, CA

Business Intelligence and Data warehousing Analyst

Responsibilities:

• Involved in full project life cycle implementation (Requirements gathering to production phase).
• Interviewed users and management to determine specific reporting needs.
• Managed the software life cycle, documented code, tested, maintain versions and implement reports.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created Universe, Classes, Objects, Measure Objects, Conditions and Joins to create dashboard visualization and reports.
• Design ETL, experience building Informatica repositories, mappings, mapplets, sessions/batches, transformations with Informatica Power Center.
• Created the reports in Business Objects using functionalities Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail, Formulas, multiple data provider and combining objects etc.
• Created different kinds of corporate reports such as revenue reports, sales reports, planning reports, forecast report and so on.
• Worked as BO admin, creating and maintaining users using CMC. Scheduled jobs using CMC. Created
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.
• Created waterfall charts using Live Office and xcelsius.
• Experience creating/managing Business Objects Universe.
• Used Dashboard Manager and Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the data presentation.

Environment: Business Objects 6.5, XI R2 (Designer, CMC, CCM, Supervisor, BO Full Client, Web Intelligence, Dashboard Manager ), Crystal Reports XI R2, Oracle 10g/9i, SQL Server 2005 (SQL Server Management Studio),TOAD, Data Integrator, Informatica PowerCenter 8.0/7.1.2, PL/SQL, MS Office 2003, Windows XP, Salesforce

Confidential, San Francisco, CA

Business Intelligence and Data warehousing System Analyst

Responsibilities:

• Created technical specifications as per the technical and business requirements.
• Wrote stored procedures in Oracle 10g and SQL Server 2005 using TOAD and SQL Server Management Studio.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.
• Tested reports for data consistency, tested Universe table joins, contexts, defects in reports/fixed the defects in reports.
• Involved in resolving the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Design ETL, experience building Informatica repositories, mappings,mapplets, sessions/batches, transformations with Informatica Power Center.
• Extensive experience in Data Analysis, Data mapping And Data migration - Involved in All stages of Data migration
• Extensive Data base development experience includes Oracle 8i, Oracle 9i, Oracle 10G, SQL, PL/SQL; Query Optimization, Performance Tuning, Trouble shooting, Packages, Stored Procedures, Functions, Views, Triggers and Export/Import Utilities.
• Installed and configured Business Objects suite, Creating Repository, creating users and user groups and assigning privileges.
• Designed and developed universes based on the user requirements for reporting generation.
• experience creating Business Objects Webi reports.

Environment: Business Objects XI R2 (Designer, CMC, CCM, Supervisor, BO Full Client, Web Intelligence), Crystal Reports XI R2, Siebel 6/7, Oracle 10g/9i, SQL Server 2005 (SQL Server Management Studio),TOAD, Informatica PowerCenter 8.0/7.1.2, PL/SQL, MS Office 2003, Microsoft Access,Visio, Windows XP, Live Office, VB.net., Lotus Notes.

Confidential, Sturtevant, WI

Business Intelligence and Data warehousing Lead

Responsibilities:

• Involved in full project life cycle implementation (Requirements gathering to production phase).
• Documented business requirements, developed test cases and tracking projects through to successful implementation.
• Write ETL specifications and mapping, transformations documents
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Experience creating/managing Business Objects Universe.
• Involved in extensive testing of universes and reports during version migration of business objects from 6.5 to XIR2.
• Migration of content from the 6.5 system to XI R2 using the Import Wizard. Involved in migration and deployment of the universes and reports across multiple domains.
• Conversion of Desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using Business Objects XI R2.
• Developing complex universes by using advanced features like aggregate aware, Conditions and hierarchies.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.

Environment: Informatica Power Center, Business Objects (Designer, CMC, CCM, Supervisor, BO Full Client, Web Intelligence), Oracle DB, TOAD, PL/SQL, MS Access,, DataStage, Unix shell scripting

Confidential, Plano, Texas

Business Intelligence and Data warehousing Lead

Responsibilities:

• Responsible for gathering the business requirements, analyzing requirements and in documentation and used UML for detailed design specifications.
• Developed and modified reports in Versions Business Objects XI R1 & R2.
• Experience creating/managing Business Objects Universe.
• experience creating Business Objects Webi reports.
• Design, and implement ETL solutions
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Extensively used Crystal Xcelsius to improve Dashboards and Scorecard presentation.
• Installation and Configuration of Business Objects XI along with performance manager.
• Involved in the installation of Business Objects repository, User creations, and implementation of security features and management of the repository.
• Worked extensively on modules Supervisor, Designer, Info view, Web Intelligence and Broadcast agent in Business Objects.
• Scheduled and monitored reports in WEBI to other Users/Developers/Power Users.

Environment: Business Objects XI R2, 6.5 (Designer, CMC, CCM, Supervisor, Administrator, BO Full Client, Web Intelligence, Broad Cast Agent, Publisher), IBM DB2 UDB 8.0/7.0, SQL Server 2000, Teradata, Informatica PowerCenter 8.0/7.1.2, Oracle 10g/9i, vb.Net, UNIX PL/SQL, MS Access, Windows XP

Confidential

ETL Developer

Responsibilities:

• Gathered and analyzed requirements from potential data sources.
• Designed ETL specification documents for all the projects.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Created Universes, Classes and Objects for management system based on the warehouse schema.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created Ad hoc Reports using Full Client in Business Objects.
• Developed various full client and thin client reports using Business Objects and Web Intelligence.
• Used Informatica designer for developing mappings, transformations, which includes aggregation, Updating, lookup, and summation.

Environment: Informatica Power Center, Business Objects (Full Client, Designer, Webi, Supervisor), Info View, Web Intelligence, Oracle DBMS, SQL Server, DB2 .