SUMMARY

• Eleven years of experience working and leading projects in Business Intelligence and Analytics, Datawarehousing and Data Management space for Refinery, Banking, Health Insurance, Health Delivery,, and Manufacturing verticals.
• Experience in SDLC with agile software development framework using Scrum.
• Experience in Project planning, managing and delivering project in tight timelines.
• Experience in Resource planning, estimation of work, man hours and employee allocation for projects.
• Expert in BO Universe creation/modification/migration over operational data store tables and data warehouse tables.
• Expert in creating business reports using Web Intelligence and have excellent knowledge in creating complex, multi - pass, and sub queries, advanced chart and report formatting.
• Experience in optimization of slow performing WEBI reports to increase performance and efficiency.
• Creative in designing dashboards in Tableau and Dashboard Designer (Xcelsius).
• Experience in creating interactive and highly formatted Crystal Reports by extracting data from multiple sources, applying functionalities like Combined Queries, Sub-reports, Formulas, etc.
• Working knowledge in SAS programming and reporting.
• Experience in implementing Business Objects solution on top of SAP systems like SAP BW/ECC.
• Working experience in Data Modeling using Erwin.
• Experience in Database development and Production projects involving Oracle, Sybase, DB2 UDB and Teradata.
• Experience in writing efficient SQL statements, PL/SQL stored procedures, Functions, Packages, database triggers and cursors.
• Involved in large volume data migration to Enterprise Data Warehouse using PL/SQL, UNIX scripts and SQL*Loader.
• Implemented Packages (Stored Procedures, Functions, Cursors, Triggers), Data Cleansing, Transformation Scripts and necessary test plans to ensure the successful execution of the data loading processes.
• Experience in designing and implementing new Security model for BI 4 systems and modifying/maintaining as per business needs.
• Hands on migration experience from project planning and Implementation from end to end for migration of BO XI R2 to BI4, and also migration knowledge from BO 3.1 to BI4 and older version BO 5.1.x to XI R2.
• Extensive experience in using Central Management Console (CMC) to import reports and executable code, schedule them, maintain histories of the output, manage users and user groups, and assign security rights.
• Experience in Installation, configuration, monitoring and administration of Business Objects BI 4, BO 3.1/3.0, XI R2 servers in a clustered environment.
• Worked on 3rd Level Support role to resolve incidents in timely manner.
• Knowledge of JSP, Java Scripting, Java, JDBC and Web technologies.
• Debugging errors is my pleasure.
• Strong analytical, problem solving and crisis management capabilities.
• Excellent communication and interpersonal skills. Fast and self-studying learner of new and required technologies.

TECHNICAL SKILLS

BI/Analytics Tools: SAS 9.3/9.2/9.1, Xcelcius 2008, Crystal Reports 2008/XI, Tableau 8.0, Business Objects (SAP BI 4.1/4.0/3.1/XI R2/6.5/5.0.x), Desktop Intelligence, Web Intelligence, BI Launch Pad/Info View, Universe Designer, Information Design tool (IDT), Life Cycle Manager, Universe Builder, CMC, CMS, Report Conversion Tool, Upgrade Management Tool/Import Wizard

Tools: SQL*LOADER, OEM, DB ARTISAN, Lotus Notes, CA Unicenter, Quest STAT, SVN, PVCS Version Manager, TOAD, ERwin Data Modeler, IBM Rational Rose Modeler, Microsoft Visio

Languages: SQL, PL/SQL, Pro*C/C++, C, C++, Java2.0, JDBC, JSP, Shell Programming, AWK

Databases: Oracle8i/9i/10g/11g, Microsoft SQL Server 7.0/2000, IBM DB2, FoxPro

Operating Systems: Windows 2008/2003/2000/ NT/XP/7, UNIX (SOLARIS 8/9, HP-UX 10.2/11) Linux (SUSE, Redhat, Debian)

Web Technologies: HTML, DHTML, XML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr BI/BO Developer

Responsibilities:

• Meet business members to understand the business requirements. Design technical solution that addresses the business needs.
• Demonstrate the capabilities of the Business Objects platform to groups of people. Clearly articulate the functionality and advantages of the platform.
• Build new complex Crystal reports to address the new report request.
• Provide production support on defects or change requests of the existing Crystal reports to address the enhancement requirements/missing functionality.
• Modify/Update Universe to accommodate new requirements for Enterprise Risk management Project.
• Modify Business Objects Dashboard to accommodate the new requirements for Enterprise Risk Management Project.
• Created Objects, Predefined Conditions, Joins in the UNX Universe.
• Worked with Hana tables in Building Universe.
• Involved in migrating Universes and Reports from Dev to QA hands on and coordinate the migration from Dev to Prod with Basis team.
• Build reports both from OLTP and OLAP data sources.
• Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
• Build new Webi reports against IDT Universe and also against BEX Queries as required.
• Unit test the changes and document the changes in User stories. Get approvals from business for the changes.
• Coordinate the rollout changes into production environment with service requests, after getting sign off from the managers in the change requests.
• Leverage SAP best practices and methods. Write documentation to support the implementation of best practices.

Environment: SAP BI 7.4, SQL Server, Oracle 10.2g, SQL, SAP Business Objects 4.1, WEBI, BI Launch Pad/Info View, Designer, Crystal Reports 2011/2013, Windows 7.

Confidential, Plano, TX

Lead BI Developer

Responsibilities:

• Meet stake holders/technical members to understand the requirements. Design/apply the technical solution that addresses the business requirements.
• Identify, plan and assign appropriate tasks to the team members.
• Work with various LOB data analyst and get input and scope for the changes as required.
• Identify and Implement LIFT changes for COAF ( Confidential Auto Finance) Reports.
• Analyze and Implement the LIFT changes in SAS Jobs.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports.
• Creating tables through SAS job to use the data to be presented in the report.
• Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
• Creating reports using sub reports developed parameterized reports and created charts.
• Implement LIFT changes to Webi Reports and Crystal reports.
• Creating new Universe based on the business requirements to develop new reports.
• Created Objects, Predefined Conditions, Joins in the Universe. Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe.
• Identify Universes if LIFT changes needs to be implemented in them and make the changes as needed.
• Unit test the changes and document the changes in User stories. Get approvals from the data analyst of the impacted LOB.
• Roll the updates/changes into production environment with change orders, after getting sign off from the managers in the change order business process steps.
• Do post implementation validation on the Production reports changes and get signoff on the changes from data analyst for that particular LOB.

Environment: ORACLE 11g, SQL Server, Teradata, SQL, SAP Business Objects BI 4.1/BO 3.1, WEBI, BI Launch Pad/Info View, Designer, Crystal Reports 2011/2008, SAS 9.3, UNIX, Windows 7/XP.

Confidential, Spectrum Health, Grand Rapids, MI

Lead BO / Database Developer/BO Admin

Responsibilities:

• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Interact with Data Modelers and ETL members to get the data models and tables as required for the project, if needed get changes to the data model.
• Hands on involvement in many new Universe design/creation for various projects.
• Involved in creation of new webi reports that are required for the project.
• Worked on BO XIR2 to BI4 migration project, studied scope and future needs for the BO system, study the current system landscape, system resources needed, identifying Risks and Issues. Prepared the initial project plan with new system architecture, prototyping the solution in Play env and provided Project manger the steps that need to be followed. Identified teams that the needs to be involved, the effort required from each team and the steps they perform, in what sequence the tasks needs to be performed, prepare test cases for each step to validate the tasks completed. Did setup the new BI4 servers for Dev and Test. Prepared detailed documentation for the BI4 environment setup. SSO was implemented in BI4.
• Prototyped BI4 security model that was envisioned by the team, and documented the steps.
• Worked in about eleven projects, build nine new universes, built lots of new Webi reports, Xcelcius and tableau dashboards.
• Worked on a lot of support tickets/incidents.
• Build new Universes over operational data store tables and Data warehouse tables (Star, Snowflake schema).
• Created many complex reports which derives data from more than one data providers/Universes for example AMISYS reports.
• Worked on projects to study Impact from source table changes and did Impact analysis and remediation for example Facets 4.7 upgrade project.
• Experience in creating interactive and highly formatted Crystal Reports by extracting data from multiple sources, applying functionalities like Combined Queries, Sub-reports, Formulas, etc.
• Worked in CMC for various tasks from user accounts to scheduling reports to system maintenance tasks.
• Involved in the migration of reports, universes, security and other objects from one environment to another as needed.
• Resolved loops, Chasm and fan traps using aliases, contexts, short cut joins whichever is appropriate and checked the Integrity of the Universes.
• Improved the retrieval time of queries using index values instead of name values by applying primary and foreign key index awareness.
• Built reports utilizing Web Intelligence advanced functions (@prompt, @where, @select etc.), formulas, and formatting.
• Performed various functionalities on the reports like Filters, Ranking, Controls, Data Tracking, Conditional formatting/Alerts, Breaks and Sorts.
• Involved in the Facets to Oracle Project, built Triggers and modified existing Perl script, Worked on Packages, stored procedures, functions.

Environment: ORACLE 11g/9i, SQL, PL/SQL, SQL*Plus, Business Objects SAP BI 4/BO 3.1/XI R2, WEBI, BI Launch Pad/Info View, Designer, Information Design Tool, Crystal reports 2008, Xcelcius, Tableau 8.0, CMC, CMS, Upgrade Management Tool/Import Wizard, Trizetto Facets 5.1/4.7, CCMS 4, Cactus, Cerner, Quest Toad, SVN, UNIX, Windows 2008/7/XP.

Confidential, Ann Arbor, MI

Sr. Database/ Business Objects Developer

Responsibilities:

• Involved in many BO Universe Design/modifications according to the new requirements using the best practices of the industry.
• Created universe classes, objects, complex measure objects, prompts, pre-defined conditions.
• Responsible for Resolving Loops using Aliases and Contexts to remove the cyclic dependencies and also resolved Fan Trap and Chasm Traps.
• Took care in the Universe modifications for fields that have changed field name or length works with the old reports and test the old reports are compatible for the modified universes.
• Did extensive testing of the universe changes in the DEV environment, again tested it in the TEST environment.
• Migrated/Converted over 100 DeskI reports from 5.1.6 to XI R2 to web intelligence report.
• Created many complex reports which derives data from more than one data providers/Universes.
• Corrected all reporting issues including context errors, and multivalue errors after the migration.
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports.
• Developed/modified PL/SQL Stored Procedures, Functions, Packages to implement business rules into the application.
• Written Procedures to Load Data into data warehouse system from Staging Tables.
• Developed various Complex Queries, Views for Generating Reports.
• Developed packages, procedure and functions for complex Reports.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Developed and Tested applications for loading financial data into database tables.
• Fine-tuned the logic in Procedures, Functions for optimum performance.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Perform analysis of key requirements and transfer knowledge accordingly to the end users.
• Involved in writing/modifying SQR so that the SQR’s extract data from the OLTP PeopleSoft system for the Oracle DW system.
• Migrated the SQR’s to production using Quest STAT tool.
• Involved in performance tuning of various Queries and SQR’s that take long time to run.
• Modified existing SQR’s and SQC’s to in corporate and implement the changes. Analyzed the production problems in SQR’s and implemented workable solution.

Environment: ORACLE 10G/9i, SQL, PL/SQL, SQL*Plus, SQL*Loader, SQR, Business Objects XI R2/XI/6.5.x/5.1.x PeopleSoft 9.x/8.x, Quest STAT, Lotus Notes, CA Unicenter, AIX UNIX, Windows XP.

Confidential

Database/Application Developer

Responsibilities:

• Analyzing enhancement requests.
• Revitalizing application, implementing the necessary changes.
• Unit testing and document the findings.
• System testing to determine the impact for code changes, did regression testing was responsible for all Phases of application development including requirement gathering.
• Testing and integration with other Applications.
• Inventory valuation: this includes raw material and the finished product inventory.
• Product Status: this gives the status of the product/item in manufacturing process for use of the management and supervisors.
• Analyzed all business functionality related to back end database interfaces.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per design documents.
• Analyzed and designed tables based on small and large database transactions.
• Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
• Preparation of the Test Cases and involvement in Unit Testing and System integration testing and responsible for solving the TI’s found in production environment testing.
• Responsible for performing code reviews.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Creation of Change Requests for bimonthly changes movements.
• Also responsible for writing test plan documents and unit testing for the application modules.
• Involved in creating stored Procedures for Crystal reports for the BI team.

Environment: Oracle 8i, SQL*Plus, C, Pro *C, C#, ASP.NET, Java, JRUN 2.3, WinRunner 7, QTP, QA, HP-UNIX 10.2, Windows 2000

Confidential

Database/Application Developer

Responsibilities:

• Involved in Analysis and Design of the new requirements document.
• Coding, Unit Testing.
• Preparation of test plan, test cases, System testing, Client interaction.
• Involved in the development, collecting the data and store the same centrally, generated from the weighing system at the company’s meat processing plant and Reports/summary are generated.
• Developed part of the code in Pro*C to dynamically load the info into the database from an application coded mostly in C.
• Build backend application in PL/SQL programs as per the business needs.

Environment: C, Pro* C, SQL, PL/SQL, SQL*Plus, JAVA, Oracle 8i, ASP.NET, VB.NET, Business Objects, Linux, Windows NT

Confidential

Database/Application developer

Responsibilities:

• Involved in coding, Unit Testing and preparation of test plans.
• Preparation of test plan, test cases, System testing
• Involved in developing the new eRFQ (Request for Quotation) system
• This included UML designing using Together J, the system is developed using Entity EJB for the database classes, Session EJB for control classes and JSP for the presentation layer
• Involved in developing and revitalization of several internet applications of PQMD (Product Quotation management) group using NAS/NAB/Java platform
• Revitalization of Supplier Net involved changing the entire look and feel as well as porting to the new framework
• Responsible for support, Monitoring, Scheduling various Batch programs/jobs
• Involved in Data modeling and data normalization
• Creation of Database objects (Schema creation, Tables, Indexes, Triggers, Functions, Procedures, Sequences, Role allocation) and sizing of Database Objects
• Involved in extensive PL/SQL programming/debugging, shell scripting for daily downloads and automation of jobs

Environment: Java, PL/SQL, HTML, JSP, WinRunner 7, JRUN 2.3, QA, NAS/B 4, NES 3.6, Oracle 8.0, Windows NT 4.0, Solaris UNIX

Confidential

Database Developer

Responsibilities:

• Analyze the requirements and Design the optimal solution.
• Involved in coding, Unit Testing preparation of test plan
• Prepare test cases and System testing strategy
• This project will allow users of IBS to enter the data related to performance of their applications
• For this, a tool “data Input” will be used in which the users are presented with interactive forms in which the necessary details on the various aspects such as the tests performed on the application will be taken
• The details thus taken will be stored in the database for retrieval
• Fine tuned application logic for better performance Developed complex queries, functions, store procedures and triggers using PL/SQL
• Tuned frequently used SQL Statements and PL/SQL Blocks and increased performance by passing appropriate HINTS.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Created ERD (Entity Relationship Diagram)
• Designed and developed backend PL/SQL packages in the database layer, stored procedures, functions and triggers.
• Built Java frontend forms and screens.

Environment: Java, PL/SQL, Oracle 8i, Perl, HP UNIX 10.2

Confidential

Database Developer/QA

Responsibilities:

• Involved in testing for the development lifecycle of the product.
• Involved in the preparation of test plan, test cases and system testing.
• Created various database objects in Oracle like PL/SQL Stored Procedures, Functions, Triggers and Packages for backend objects
• Created and tested PL/SQL blocks and UNIX shell scripts.
• Tuned SQL Queries and Stored PL/SQL blocks to optimize the database performance by reducing Full table scans and minimizing I/O entry/exit using Explain Plans and Oracle Hints.
• Created the indexes on columns to optimize the response time of queries and stored procedures.

Environment: Java, XML, Winrunner 7, Oracle 8i, SQL, PL/SQL, SQL*Loader and Toad, Sybase, UNIX/Linux, Windows NT