SUMMARY

• IT Experience: Over 10 years of strong professional IT experience with OLTP, OLAP Data Warehousing and Business Intelligence experience using Big Data, Hadoop, Hive, HBASE, Thor, Roxie, ECL, Sqoop, Confidential Business Objects XIR4.0/XIR3.1/XIR2/6.X/5.X, Crystal Reports v 7.5/8.5/9/10/XIR2/2008/XIR3.1, Crystal Reports, Crystal Xcelsius, SSRS, SSIS, SSAS, Teradata Reporting, COGNOS, Informatica Power Mart and Informatica Power Center.
• Around 3 years of experience working directly in the research and consulting team of Confidential Business Objects London UK
• Experience working on Confidential HANA, Confidential BW, Confidential FICO, Confidential HR and Design Studio 1.2/1.3/1.6/1.6 SP1
• Experience working on customized Confidential Supply Chain, Oracle Supply Chain and procurement and spend analytics
• OBIEE: Worked extensively in the analysis and development of Data warehousing applications using OBIEE 10.1.3.x.
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Database: 9 years of experience in Vertica, Netezza, Oracle 10g/9i/8i, MS SQL Server 2000/2005, Xml, Sybase SQL Server, DB2, MS Access 2000/97/7.0,Teradata,Vertica and MS Excel. Experience working with SQL, T-SQL, PL/SQL scripts, views, indexes, stored procedures and other components of database applications.
• Data modeling: 6+ years of experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Health Care (Pharmacy), Investment Banking and Insurance using ERWIN Good Confidential Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs).
• Confidential HANA: Experience working on HANA modeling, attribute, calculation view, analytic view, creating of constant columns, hierarchies, managing Attribute mapping and building HANA models. Worked on ABAP Transports and processes in conjunction with HANA. Confidential HANA planning, sizing,implementation, installation and upgrade, managing Confidential HANA Cluster, scale up and scale out appliance.
• Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI Jobs.
• Strong ETL experience includes extraction of source data, Data profiling, Transformations and testing data quality using Data Integrator and Data Quality.
• Informatica: 6 years of experience in loading huge amount of data into data warehouse using ETL tools like Informatica, DTS and SSIS. Development of mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Expression, Look up (connected and unconnected), aggregate, Update Strategy, Joiner, Filter and Router.
• Data Services: 3+ years of experience on Business Objects data services 4.0, Troubleshooting data issues, Develop Mappings and transformations, Performance Tuning, Building Data Integratorand calling web services, support operations during testing.
• Worked on BODS/BODI Extraction, load and transformation processes.
• BO Architect/Admin: experience in BO Installation, Creating Repository, adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes.
• Worked on migrating Business Objects from earlier versions to Version XIR2. Extensively used the import wizard in moving reports and universes from lover version of BO to higher version like from 5.x to 6.5 and from 6.5 to XI, XI R2, XI 3.1 and XI 4.0.
• Develop reports using SQL Server Reporting Services
• Experience Working with MS Office Suite (Word, Excel, Access and PowerPoint skills).
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Experience working on Confidential HANA 1.0 and hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experience working on Big Data technologies like Map Reduce, Thor, Roxie and HPCC systems.
• Experience of working on TIBCO Spotfire Visualizations, TIBCO Designer, Web Player, Statistical Services and TIBCO Reports.
• Experience of managing the projects on the Enterprise Data warehouse level as a Project Manager
• Experience on Qlikview, Tableau and Spotfire dashboards

TECHNICAL SKILLS

Business Intelligence: Confidential Business Objects XI4.0/XI3.1/XI R2/XI/ 6.5/6.1/6.0/5.1 , Informatica Data Analyzer (PA 8) & Power Analyzer 5.X/4.X, Xcelsius, COGNOS, OBIEE, TIBCO Spotfire BI Tools, Qlikview, Tableau and SSRS.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing, Investment Banking and Life Sciences Domain knowledge.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer and Visio

ETL: Informatica Power Center 9.0/8.1/8.0/7.1.2 , Power Mart 6.2/5.1.1, Workflow Manager, Work flow Monitor, ETL, SQL*Plus, SQL*Loader, Confidential Business Objects Data Services 3.1/ Data Integrator XIR2, Data Quality XIR2, Data Insight XIR2, Confidential Net Weaver.

Databases: Oracle10g/9i/8i/8.0/7.x,MS SQL Server 2005/2000/7.0/6.0 , Sybase 12.x/11.x, MS Access, Netezza, Vertica.

Programming: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, VB.net, C, C++.

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior BI Architect

Responsibilities:

• Understanding the current client’s requirement and existing environment in terms of data and architecture
• Preparing the Team Charter, Project Plans, work breakdown structure, Cost Estimation
• Working as a Scrum Master in the Agile environment
• Suggested the Hadoop landscape and strategies to extract the data into HDP from Confidential and Non Confidential source systems like SQL Server, Custom Database and Oracle
• Involved in extraction of data from Confidential Supply Chain through Confidential ECC or Confidential BW/BI using Sqoop
• Worked on Oracle Procurement and Spend, HR and ERP functional applications
• Loading data into Hive and building the schemas in Hive
• Working on Hbase on Hadoop cluster
• Working on connectivity between analytical tools like Spotfire with Hadoop cluster through JDBC connectivity
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Involved in developing the roadmap for the Hadoop integration in the organizational landscape and fixing any open issues in order to stabilize both the environments before integration.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Working with Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Working on Confidential functional model and SSIS packages in order to show the comparison in terms of large dataset and performance between Hadoop and Confidential landscape and how Hadoop can be leveraged along with the current Confidential Landscape of the client.
• Working on Talend ETL packages and integrated it with the Hadoop platform
• Responsible for the correct data modeling and successful transfer of data to data lake
• Built and working on HUEY, end to end data provisioning tool in Hadoop environment
• Built and working on validation tool for automated validation of source data with the target data
• Worked on security aspect of Spotfire
• Working on Ranger and Ambari on Hadoop for infrastructure and cluster security related works and issues
• Working on performance and load balancing scenarios and issues
• Working on Data Governance using Falcon in HDP

Environment: SQL Server 2008, Oracle 11g, Data Modeling, Business Intelligence, UNIX, HDP 2.X, Big Data, Hive, Hbase, Phoenix, Sqoop, Spotfire, Ambari, Ranger, Falcon, Oozie, Flume, SSIS, SSAS,SSRS, DB Visualizer.

Confidential, Atlanta, GA

Senior BI/Data Architect

Responsibilities:

• Understanding the current client’s requirement and existing environment in terms of data and architecture
• Preparing the Team Charter, Project Plans, work breakdown structure, Cost Estimation
• Worked as a Scrum Master in the Agile environment
• Primarily working on Big Data projects for Oil and Gas, Financial and auditing clients/companies
• Suggested the Hadoop landscape and strategies to extract the data into HDP from Confidential and Non Confidential source systems like SQL Server, Custom Database and Oracle
• Involved in extraction of data from Confidential Supply Chain through Confidential ECC or Confidential BW/BI using Sqoop
• Worked on Oracle Procurement and Spend, HR and ERP functional applications
• Loaded data into Hive and building the schemas in Hive
• Worked on Hbase on Hadoop cluster
• Worked on connectivity between various analytical tools like Business objects, Tableau, Spotfire with Hadoop cluster through Phoenix, JDBC connectivity
• Worked on Design Studio, Lumira and Design studio analysis
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Involved in developing the roadmap for the Hadoop integration in the organizational landscape and fixing any open issues in order to stabilize both the environments before integration.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Worked with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Worked on Confidential HANA modeling and Confidential BW, BEX queries and BEX reporting in order to show the comparison in terms of large dataset and performance between Hadoop and Confidential landscape and how Hadoop can be leveraged along with the current Confidential Landscape of the client.
• Responsible for the correct data modeling and successful transfer of data to HANA
• Installed, architected and administered the Tableau server and desktop environment
• Created the dashboards on Tableau and Spotfire
• Worked on Vertica integration with Kafka and leveraging Vertica as the data consumer for Kafka
• Worked on performance tuning and Big data platform for Vertica

Environment: Confidential BO4.1, SQL Server 2008, Oracle 11g, Data Modeling, Business Intelligence, UNIX, Tableau, Confidential BODS 4.1, Informatica 9.0.1, Confidential HANA 1.X, HDP 2.X, Big Data, Hive, Hbase, Phoenix, Sqoop, Spotfire, Tableau, AWS, SSIS, SSAS,SSRS,, DB Visualizer, Vertica, Kafka, Design Studio 1.6 SP1, Lumira.

Confidential, Englewood, CO

Senior BI/Data Architect

Responsibilities:

• Involved in Integration of ETL and reporting services after Confidential acquired Hughes
• In this integration currently analyzing the current BI and analytical tools used by these companies.
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Involved in developing the roadmap for this integration and fixing any open issues in order to stabilize both the environments before integration.
• Worked on Oracle and Confidential Supply chain functional applications to extract the data and accordingly do the modeling and analytics
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Responsible for the correct data modeling and successful transfer of data to HANA
• Understanding the Business requirements convert them into Blueprint
• Created the Design Documents for the HANA Models
• Essential Configurations for Confidential ECC Accelerations using Confidential HANA
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA Define the Reporting Layouts
• Translate the Business KPIs for Dashboards Define the dashboard Layouts in Tableau
• Worked on Design Studio and it’s integration with Mobile, OLAP and Dashboards
• Worked on Lumira and Design Studio
• Confidential HANA planning, sizing,implementation, installation and upgrade, managing Confidential HANA Cluster, scale up and scale out appliance.
• Defining the Metadata Import process
• Identify Attribute measures, Hierarchies
• Creation of Package
• Design Creation of HANA Attributes views
• Design Creation of HANA Analytic views
• Design Creation of HANA Calculation views
• Managing Attribute Mapping
• Creation of Constant columns
• Working on unstructured data, converting relational to non-relational database.
• Involved in extraction of data from RDBMS using Sqoop
• Loaded data into Hive and building the schemas in Hive
• Worked on Hbase on Hadoop cluster
• Worked on connectivity between various analytical tools like Business objects, Tableau, Spotfire with Hadoop cluster through Phoenix, JDBC connectivity
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Involved in developing the roadmap for the Hadoop integration in the organizational landscape and fixing any open issues in order to stabilize both the environments before integration.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Worked with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Worked on Big Data technologies like Map Reduce, ECL, Thor and Roxie.
• Installed Tableau and architected the Tableau server environment
• Created the dashboards on Tableau and Spotfire

Environment: Confidential BOXIR3.1, SQL Server 2008, Oracle 11g, Data Modeling, Business Intelligence, UNIX, Tableau, OBIEE11g, DAC, Confidential BODS XIR3.1, Informatica 9.0.1, Confidential HANA, Teradata, Big Data, HDP 2.X, Big Data, Hive, Hbase, Phoenix, Sqoop, Tableau, Spotfire, Design Studio 1.6 SP1, Lumira

Confidential, Chicago

Senior Data/BI/Technical Architect

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Upgrade, Testing, Reporting, Go-live and Post Go-live support.
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Created many complex and customized reports for specific business requirements and also involved in new features of Confidential BI security like Analysis authorization.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Hierarchies are implemented to support drill down reports.
• Several complexes-cross tab reports and sub-reports are published using Crystal Reports and Business Objects Reporting.
• Xcelsius dashboards are created on top of crystal reports and live office.
• Did the upgrade from BOXIR2 to BO 4.1 involving landscaping and architecting the new BO servers in different environments, load balancing setting up the authentication, migrating and upgrading the security and BOXIR2 content like universes, reports and dashboards to BO4.1.
• Did the upgrade from BOXI1 to BO 4.1 involving landscaping and architecting the new BO servers in different environments, load balancing setting up the authentication, migrating and upgrading the security and BOXI1 content like universes, reports and dashboards to BO4.1.
• As Business Objects Admin configured the BO 4.1 servers in cluster and did load balancing
• Designed and configured the security on BO 4.1 as per the user BO landscape.
• Did the migration of the reports, universes, Crystal reports and other BO objects from BOXI to BO4.1
• Setup the authentication for the servers in LDAP.
• Mentored the team handling BO administration to carry out day to day operations.
• Did troubleshooting of BO Admin related issues like server timeouts, issues in bouncing of the servers, cache problems
• Created BIAR files on regular basis for the backup and recovery.
• As a POC created the dashboards in Tableau, Spot fire and Xcelsius
• Installed Tableau and architected the Tableau server environment
• Created the dashboards on Tableau
• Confidential HANA planning, sizing,implementation, installation and upgrade, managing Confidential HANA Cluster, scale up and scale out appliance.
• Worked on Teradata ETL processes like BTEQ,TPT LOAD Operators
• Worked on Teradata queries, extraction of data along with the Unix shell scripting

Environment: Confidential BO4.1, Teradata, SQL Server, Oracle 10g R2, Data Modeling, Business Intelligence, UNIX,BO Admin, CCM, Tableau, Spotfire, Xcelsius, Lumira, BO Explorer, CMC,HANA1.0 SP7,Design Studio 1.2

Confidential, Atlanta

BI Lead/Technical Architect

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Did the upgrade from BOXI1 to BO 4.1 involving landscaping and architecting the new BO servers in different environments, load balancing setting up the authentication, migrating and upgrading the security and BOXI1 content like universes, reports and dashboards to BO4.1.
• As Business Objects Admin configured the BO 4.1 servers in cluster and did load balancing
• Designed and configured the security on BO 4.1 as per the user BO landscape.
• Did the migration of the reports, universes, Crystal reports and other BO objects from BOXI to BO4.1
• Worked on OBIEE 11g and DAC leveraging highly customized Oracle Supply Chain analytics
• Worked on Oracle Procurement and Spend, HR and ERP functional applications
• Setup the authentication for the servers in LDAP.
• Mentored the team handling BO administration to carry out day to day operations.
• Did troubleshooting of BO Admin related issues like server timeouts, issues in bouncing of the servers, cache problems
• Worked on Teradata ETL processes like BTEQ,TPT LOAD Operators
• Worked on Teradata queries, extraction of data along with the Unix shell scripting
• Worked with Confidential Business Objects Data services Extraction, Transformation and Load team in gathering required data tables and resolving data issues if any.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Involved working with content models, attributes and measures, hierarchies.
• Monitoring and troubleshooting data loads.
• Worked on data flows, jobs and workflows for auditing and data loads in BODS 4.0
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc
• Created the dashboards on Tableau

Environment: Business Objects 3.1,Business Objects 4.0, Web Intelligence, Crystal Reports BOXIR3.1,Web Intelligence 4.0, Universe Designer, Oracle 10g,BODS4.0,Informatica 9.0, Confidential HANA 1.X,BODS 4.1,BO Admin, CMC, CCM, Tableau, Teradata.

Confidential, Atlanta

BI Lead/Information Architect

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.
• Imparted training to the End Users and team members.
• Designed and Document Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Developed reports by using advanced functionalities like data sets, proc, Data tracking, listing report, summary report, Custom SQL Confidential Report level.
• Worked on Teradata ETL processes like BTEQ,TPT LOAD Operators
• Worked on Teradata queries, extraction of data along with the Unix shell scripting
• Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, percentage reports, Prompts using SSRS.
• Responsible for migration of Reports to various cycles of the Environment - Dev to Test and from Test to Production.
• Interacted with Business Team in gathering their business requirements to prepare high- level User/System roadmap for the migration from Confidential BOXIR3.5 to Confidential BO4.0.
• Involved in analysis and recommendations on Universes, Reports, Dashboards and security model for the upgrade.
• Prepared high level documentation for upgrade strategy, conversion strategy and validation strategy to be used during the upgrade/migration process to Confidential BO4.0.
• Prepared high level strategy and recommendations to cleanse and fine tune existing universes before the upgrade by making the universes stable and robust and this can be done by setting the proper joins and cardinalities, Classes, Objects and Condition Objects so that the upgrade should be smooth.
• Prepared strategy on optimizing the existing universes using Aggregate tables in the universes for the query optimization process and Designer Functions like @Prompt, @Select, @Where to create and define condition objects and prompts required to generate reports.
• In depth analysis of the universe, reports, dashboards and security model to forecast any issues which can come in during the upgrade or after the upgrade and the strategy for troubleshooting the same.
• Involved in preparation of roadmap for migration and conversion of universes form UNV to UNX in IDT tool of Confidential BO 4.0.
• Enhanced and fixed the existing WebI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the Info view.
• Responsible for migration of BO Objects (Universes, Reports) to various cycles of the Environment - Dev to Test and from Test to Production.
• Managed all CMC content including reports, universes, folders, scheduling and Business Objects application and content access levels.
• Worked on couple of Crystal reports migration from version 2008 to Confidential BO 4.0.
• Prepared all the required high level documentation like component inventory, impact analysis document, Business Objects best practices and roadmap for upgrade.
• Participated in regular status meetings with co-developers and Manager to discuss the progress of the assignment.
• Performed unit testing of the universes, reports, dashboards and involved in UAT Confidential all stages.
• Involved in effort estimation, status reporting, team management, Project Management and onshore-offshore project co-ordination.
• Imparted trainings to team members whenever required.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Involved working with content models, attributes and measures, hierarchies.
• Monitoring and troubleshooting data loads.
• Worked on data flows, jobs and workflows for auditing and data loads in BODS 4.0
• Responsible for data modeling and building the framework model.
• Did the POC for Tableau, Spotfire and Xcelsius dashboards.

Environment: Confidential HANA 1.0, BODS 4.0, Confidential HANA 1.x, Business Objects 3.1,Business Objects 4.0, Web Intelligence, Crystal Reports BOXIR3.1,Web Intelligence 4.0, Universe Designer, Oracle 10g, Teradata, Confidential BO IDT 4.0,Spotfire,Tableau.

Confidential, New York

BI Lead/Information Architect

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Worked as per HIPPA and CDC regulations.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects.
• Used Aggregate tables in the universes for the query optimization process and Designer Functions like @Prompt, @Select, @Where to create and define condition objects and prompts required to generate reports.
• Developed WebI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the Info view.
• Managed all CMC content including reports, universes, folders, scheduling and Business Objects application and content access levels.
• Worked on couple of Crystal reports migration from version 7.5 to XIR3.1.
• Extensively worked on Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Created various filters Confidential both Universe and report levels.
• Worked with Confidential Business Objects Data services Extraction, Transformation and Load team in gathering required data tables and resolving data issues if any.
• Worked on SSRS reports and migrated the reports to Crystal Reports.
• Participated in regular status meetings with co-developers and Manager to discuss the progress of the assignment.
• Performed unit testing of the reports and involved in UAT Confidential all stages.
• Responsible for data modeling and building the framework model.
• Involved in effort estimation, status reporting, team management, Project Management and onshore-offshore project co-ordination.
• Worked as the Software configuration coordinator and defect prevention coordinator in the project.
• Imparted trainings to team members whenever required.
• Experience working on Vertica database which includes performance tuning, creating the queries, installation, maintenance and connecting it to different data sources.

Environment: Business Objects 3.1,Business Objects 4.0, Web Intelligence, Crystal Reports BOXIR3.1,Web Intelligence 4.0, Universe Designer, Oracle 10g,BODS4.0,Informatica 9.0, Vertica, Qlikview, ERWIN,TIBCO Spotfire, SSRS.

Confidential, Atlanta

Business Intelligence Lead /BO Architect

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.
• Worked as per HIPPA and CDC regulations.
• Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Deski, Web I and Dashboards based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
• Analysed the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Implemented Data Cleansing, Transformation Scripts to ensure the successful execution of the data loading processes.
• Used ETL extraction, transformation and loading data from heterogeneous source systems.
• Performance tuned Business Objects Data Integrator ETL real time jobs to improve efficiency.
• Created and maintained Metric oriented measures in the universe
• Performed complex transforms in dataflow using Data Services.
• Setup the connection between universe and dashboard manager in the PCM
• Attached the calendars, alerts, and analytics to full fill the performance tracking.
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Extensively worked on Unix Shell Scripting.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Confidential BO Data Integrator and Data Services.
• Managed data skew, Netezza default environment settings and database objects.
• Good experience in mentoring the BO development teams.
• Managed the team of 10 people on the basis of onshore-offshore model.

Environment: Business Objects 3.1, Web Intelligence, Crystal Xcelsius 2008, Crystal Reports, Oracle, BODI XR3.1, Qlikview and BODS.

Confidential

BI Lead/Data Architect

Responsibilities:

• Participated in project planning sessions with project managers and Team members to analyze business requirements and outline the proposed solution as Business Analyst.
• Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Deski, Web I and Dashboards based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
• Analysed the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checked the integrity.
• Implemented Data Cleansing, Transformation Scripts to ensure the successful execution of the data loading processes.
• Used ETL extraction, transformation and loading data from heterogeneous source systems.
• Performance tuned Business Objects Data Integrator ETL real time jobs to improve efficiency.
• Worked on Qlikview dashboards.
• Worked on SSRS reports and migrated the reports to Crystal Reports.
• Performed complex transforms in dataflow using Data Services.
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Extensively worked on Unix Shell Scripting.
• Designed organizational summary dashboards in Xcelsius.
• Created and migrated the Crystal Reports.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Centre.
• Managed data skew, Netezza default environment settings and database objects.
• Good experience in mentoring the BO development teams.
• Generated reports and design visualizations on TIBCO Spotfire.
• Used Multi filtering, drilling functionality on the TIBCO visualizations and reports.
• Used the statistical services like S+ on TIBCO analytics.
• Used in memory computing feature of TIBCO Spotfire.

Environment: Business Objects 3.1, Business Objects 4.0, Web Intelligence BOXIR3.1,Web Intelligence 4.0, Universe Designer, Crystal Xcelsius 2008,Crystal Reports, Netezza, Informatica 8.5,TIBCO SPOTFIRE 4.0,Qlikview,SSRS.

Confidential

BI Lead/Solution Architect

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects.
• Used Aggregate tables in the universes for the query optimization process and Designer Functions like @Prompt, @Select, @Where to create and define condition objects and prompts required to generate reports.
• Developed WebI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL Confidential Report level.
• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the Info view.
• Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, percentage reports, Prompts using Web Intelligence.
• Created Analytics, Metrics, Calendars and Dashboards using Business Objects Performance Management.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Responsible for migration of BO Objects(Universes, Reports) to various cycles of the Enviroment - Dev to Test and from Test to Production.
• Designed Universes by creating prompts, queries and applied Contexts and Aliases to remove loops.
• Created new classes & User Objects in designing the Universes, Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Managed all CMC content including reports, universes, folders, scheduling and Business Objects application and content access levels.
• Extensively worked on Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Did the upgrade from BOXI1 to BO 4.1 involving landscaping and architecting the new BO servers in different environments, load balancing setting up the authentication, migrating and upgrading the security and BOXI1 content like universes, reports and dashboards to BO4.1.
• As Business Objects Admin configured the BO 4.1 servers in cluster and did load balancing
• Designed and configured the security on BO 4.1 as per the user BO landscape.
• Did the migration of the reports, universes, Crystal reports and other BO objects from BOXI to BO4.1
• Setup the authentication for the servers in LDAP.
• Mentored the team handling BO administration to carry out day to day operations.
• Did troubleshooting of BO Admin related issues like server timeouts, issues in bouncing of the servers, cache problems
• Created BIAR files on regular basis for the backup and recovery.
• Worked with Informatica ETL team in gathering required data tables and resolving data issues if any
• Participated in regular status meetings with co-developers and Manager to discuss the progress of the assignment.
• Performed unit testing of the reports and involved in UAT Confidential all stages.
• Responsible for data modeling and building the framework model.
• Involved in effort estimation, status reporting, team management, Project Management and onshore-offshore project co-ordination.
• Worked on Confidential Supply Chain components
• Worked as the Software configuration coordinator and defect prevention coordinator in the project.
• Imparted trainings to team members whenever required.

Environment: Legacy versions of BO 5.x/6.5.x,Business Objects XIR2/XIR3.1.X,BO4.0.x, Web Intelligence, Performance Management XIR2, Universe Designer, Oracle 9i, Teradata, Sybase, Informatica 7.5, Crystal Xcelsius dashboard, BO Admin, CCM, CMC.

Confidential, CA

BO Consultant

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Created Different Universes for separate reporting requirements which run against Oracle 9i Database.
• Created classes and objects and gave business names and logically grouped them together.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies.
• Used different business objects @functions like @select, @where, @prompt, Hierarchies, custom LOV’s.
• Created Full Client reports using different Data providers like Oracle, MS-Excel, and MS-SQL server.
• Extensively used slice and dice for generating master/detail and tabular reports.
• Created Reports from Excel files using Business Objects through Personal data files.
• Strong working knowledge of Business Objects Web Intelligence, Full Client.
• Well versed in Business Objects with experience in Supervisor, Designer, Reporter, BCA Server Web Intelligence 2.5/2.6.1/6.0 , and Info view, Application Foundation, Dashboards, Auditor and Schema Design.

Environment: Business Objects 6.5, COGNOS,Oracle 9i, PL/SQL, UNIX AIX 5.1.