SUMMARY:

• Total IT: 13+ years of experience in the analysis, design, development and implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies.
• Business Intelligence: 10+ 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
• Data Warehouse: 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.
• Data Modeling: 7 years of experience in Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin,
• Business System Analyst: 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.
• Database: 10 years of experience in Oracle, DB2, MS SQL Server, (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), 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, sqoopDimensional 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: Visual Basic 6, PL/SQL, HTML, ASP, VBscript, Java, TOAD, MS Front Page, Apache Web Server

PROFESSIONAL EXPERIENCE:

Confidential,San Rafael,CA

Business Intelligence

Responsibilities:

• Analyzing BRD to design datawarehousing components.
• Design and Develop Bo Universe - objects, Class and Business 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 in corporate 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.
• Involved in migration of BO XI to BO 4.2 .
• 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, Salesforce, RedShift

Confidential,San Jose,CA

Business Intelligence

• 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

Confidential, San Francisco,CA

Business Intelligence and Data warehousing Architect

• 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

Business Intelligence 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.
• Created Stored procedure transformations to populate targets based on business requirements.
• 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.
• Worked as an IT support to solve issues/tickets related to Business Objects/Crystal reports
• Trained Power Users/Managers to create reports in Webi and provided on-going production support for Business Objects End users.

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 complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• 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 V2R5, Informatica PowerCenter 8.0/7.1.2, Oracle 10g/9i, vb.Net, UNIX (IBM AIX 5.1, Sun Solaris 8), PL/SQL, MS Access, Windows XP

Confidential,Plano,Texas

Informatica Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Copied/Exported/Imported the mappings/sessions/worklets/workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX Script.
• Designed Universe by creating the Business Objects Data Model Updating the existing Universe and Linking Universes to the Master Universe.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Developing Production Reports using Business Objects 6.5 and developing Various Report formats including Standard reports and Master/Detail Reports.
• Created complex Stored Procedures and Views to be used in the reports
• Administration of Business Objects like users, groups using Supervisor Component.

Environment: Informatica, Business Objects, Web Intelligence Server, Business Objects Designer, Supervisor, ZABO, Informatica, Oracle 9i, PL/SQL Info View, SQL Server 7.0, UNIX.

Confidential

ETL Developer

Responsibilities:

• Gathered and analyzed requirements from potential data sources.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the Database.
• 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).
• Worked with other team members and performed the knowledge transfer.
• 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.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

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

Confidential

Informatica and Business Objects Developer

• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Resolved loops, contexts and checking the Integrity of the Universes and making available to the users.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Created regular reports and templates for users and posted on the web and scheduled to Broadcast Agent server.
• Resolved loops, contexts and checking the Integrity of the Universes and making available to the users.

Environment: Informatica, Business Objects (Supervisor, Designer, Reporter), Info view, WebI, ZABO,, Oracle DB, TOAD, PL/SQL, Windows NT, UNIX.