SUMMARY

• Having 10 years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including 7+ years in Business Objects (BOBJ), iDashboard, and experienced as Database Developer using MS SQL Server(T - SQL) and Oracle PL/SQL
• Experience in Healthcare, O&G, Finance, Banking & Insurance Domains for top clients
• Expertise in Business Object XI3, MS SQL Server, iDashboard (Dashboard Reporting)
• Experienced in querying, creation and maintenance of database objects, stored procedures, T-SQL, dynamic SQL and including stored Packages, Procedures, Functions, Triggers etc
• Having good experience in dealing with Client Partners, team management and handling issues
• Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Functional specifications writing, Use Case development and Organizational skills
• Having good experience in data profiling of legacy and new systems using extensive use of SQL
• Extensively worked on Business/End-user support, production support experience and BO Metadata
• Quick learner of client domain, process and current IT systems
• Experience interacting with Business users to analyze the Business Process requirements and transforming them into project documentation, universe specification, report specification and issuing out the deliverables.
• Unit, integration, performance testing and Participated in design reviews and reconciliation
• Good exposure in production support, ticket handling for reports in timely manner
• Extensive experience in defining and implementing reporting requirements and validation
• Worked extensively with Dimensional database modeling, Data migration
• Experience on Star Schemas, Snowflake Schemas, Fact tables, Dimension tables design
• Experience in creating Business Object XI3/ iDashboard in developing standard, graphical, formula based, drill-down, sub-reports, cross-tab.
• Expertise in Universe designing, linking, Developing and generating complex, adhoc, dashboard reports, business views, list of values along with user acceptance test and data accuracy test
• Expertise in iDashboards - enterprise dashboard business intelligence
• Experience in using various data providers for retrieving data and creating simple and complex reports in Webi, Deski, UDT

TECHNICAL SKILLS

Business Intelligence: Business Objects XI3, iDashboard 6

Back End: MS SQL Server (TSQL), Oracle (PL/SQL)

Investment Banking ERP: Eagle Investment System (STAR & PACE)

Operating Systems: Windows 98/NT/2000/2003/XP, UNIX

Packages: MS Office, MS Project

Designing Tools, Modeling Tools: MS Visio

Other Exposure: Business Objects XI 4.0, Xcelsius, Live Office, Teradata

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

Senior Business Object XIR3 Lead Developer and Data Integration Consultant

Environment: Business Object XIR3 Report Developer, Oracle ERP R2, SyteLine ERP 6, MS-SQL 2008

Responsibilities:

• Gap Analysis for Oracle ERP conversion on DWH/ Universe and existing reporting flow
• Data consolidation, integration and transformation design to maintain consistency for data flown from new oracle ERP System by designing data mapping are business rules
• Gap analysis for reporting data fallout with new ERP conversion on DWH, Universe and Business Object reports
• Prepared report inventory for each report and its source to classify conversion impact on each report
• Analyzing legacy ERP System for AP, AR, GL (Finance Module) in-order to define data extract definition/mapping, creating data extract queries
• Similarly, defining data gap required to keep reporting up and running for Oracle ERP to backfeed to legacy system
• Written Stored Procedures, Functions to process and convert/ load data into Legacy Databases.
• Updated the existing Universe by adding new tables, classes, objects, predefined conditions and prompts as per reporting needs.
• Create custom LOVs (List of Values) and custom Hierarchies for drilling down to lower levels in the reports.
• Create/ Modify the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Added parameters, special fields, formulae and used multiple data sources to create the reports by modifying data pointers to accommodate new setoff tables populated Oracle ERP data.
• Building test cases for report, universe
• Building stored procedure to cleans, transform and load data into legacy standard from Oracle ERP.
• Seamless coordination between business owners and technical team and set up plans and timelines

Confidential, Milwaukee, WI

Senior Business Objects Developer, iDashboard Developer and BI Consultant

Environment: Business Objects XI3 (Designer, Web Intelligence), iDashboard 6, Informatica (Data Integrator), Cognos, Teradata, MS SQL Server 2008, T-SQL

Responsibilities:

• Extensively worked on WEBI reports
• Requirements gathering, Analysis, Designing, Technical documents preparation
• Created Dimensional Data Model for New Business from Operational Data Sources.
• Created with Business Objects repositories and universes
• Migrated documents from a development to a production environment
• Extensively worked on Universe creation and inserted new tables, created joins created more than 500 objects, filters
• Created a wide variety of advanced reports of varying complexity including slice and dice, drill down, linked, cross tab, multiple data-providers, multiple table/section and master detail type reports
• Created Sub-Reports and established link between main report and sub-reports in Deski and WebI reports
• Having good experience in resolving issues with data source connections
• Done analysis on existing system and prepared Migration Impact Analysis document
• Prepared migration Technical documents, Process, Checklist documents
• Finalized functional design specifications for iDashboard reports
• Designed and developed iDashboard reports
• Prepared test cases, execute tests, and document results for the iDashboard reports
• Imported data from Excel sheet and created pie-charts, bar charts and gauge using iDashboard
• Used the universes, stored procedures as source for business objects querying, analysis and reporting
• Extensively worked in SQL querying, SQL server management, SQL query analyzer
• Extensively worked on production support, end user training and help doc’s development
• Involved in Unit, integration, performance testing, test cases preparation and design reviews
• Integration of various source systems from EDW to capture America’s Sales data into SQL Server Report Data Mart
• Worked closely with business in requirement analysis, build feed definitions (S2T Mappings), creating SQL Server Datamodel for target, build source qualifier queries to pull the data from EDW.
• Seamless coordination with various business stakeholders and development team
• Systematic replacement of BOXi Report into more user friends and visual reporting dashboard application that replace legacy CIT Reporting application by defining/ implementing Informatica workflows to automate data feed from EDW to bring data into SQL Server 2005 database
• Rolling-out testing mechanism between Informatica mappings output and Business SOT for quicker response on validation and provided client Cognos Production Reports, SQL Queries with different business perspective and the validation tracker to have quicker turnaround time for business sign-off
• Build dashboard reporting cube and build SQL Server scripts which is used to integrate with iDashboard for dashboard reporting

Confidential, Kansas City, KS

Senior Business Object Developer

Environment: Business Objects XI3 (Designer, Web Intelligence), Oracle 10g, SQL, PL/SQL, Visio

Responsibilities:

• Involved in Requirements gathering, Analysis, Designing, Technical documents preparation
• Interact with the Business users and gather the requirements.
• Assigning the tasks to offshore team members and helping them to complete it.
• Exported the Universe to the Repository using designer for users to develop their own personal reports.
• Support the development and production environment.
• Business objects universes were modified based on the modification of oracle database.
• New reports were created based on the business requirements in Business objects and iDashboard reports
• Business Views were used in creation of new reports.
• Trained the new users on Business objects reports usage.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the Universe.
• Involved in Creation of Alerters with various conditions.
• Created Dashboards using Dashboard Manager.
• Developed ad hoc and full client reports using deski and webi.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Used Informatica ETL to load flatfiles data into target database(Oracle)
• Documentation of requirements and solutions.
• Test the created reports and Universe
• End User Training and System Documentation

Confidential

Business Object Webi Report Developer, Eagle PACE Developer

Environment: Business Object XiR3, Eagle Investment System 7x/8x, Oracle 9i, SQL Server 2008, SQL, PL/SQL, Visio, PERL

Responsibilities:

• Understanding the business specifications and create worksheet document
• Writing store procedure using TSQL and PL/SQL for loaders & Exporters for the feeds viz. (Security, Price, Cash, Position, Cash Activity, Cash Balance, Trade, Entity and others) for various Reference Data Sources like Bloomberg, Moody, S&P, CRD etc.
• Worked on various assignments of requirement analysis & Implementation of loaders & Exporters, OLAP Reports and Business Objects Report as per the requirements
• Customization and implementation of WEBI reports and unit testing as per the client requirement Using functional specs provided by the Eagle Business Analysts with sample data validations
• Worked in a Business Object Report production support role where in typical issues have been intelligently resolved.
• Report development based on multiple data sources, drill down capabilities, linked reports, graphical reports, cross-tab) by using WEBI, DESKI.
• Developed several complex Webi Reports (include multiple groupings, drilldowns, parameter fields, running totals, conditional display of groups, sub-reports, cross-tabs, Merging the dimensions, Master-Detail, Graphs).
• Preparing inventory of reports, usage, sample in-order to retire or club multiple Business Objects reports according recent usage in order to minimize no. of used reports and future maintenance
• Convert/Migrate PACE-OLAP and Advance Reports to new Business Object Webi Report as per the standard design layout and validate with sample data before release to next business analysts
• Convert/Migrate Legacy Deski Reports to new Business Object Webi Report as per the standard design layout and validate with sample data before release to next business analysts
• Preparing test cases, performing unit & integration testing
• Preparation of Migration Document and Source code version control
• Extensively worked on production support, end user training and help doc’s development
• Done Unit, integration, performance testing, test cases preparation
• Conducted training session on “Control M Scheduler” for Eagle CoE

Confidential

Business Object Report Developer, Eagle PACE Developer

Environment: Eagle Investment System 7x/8x, SQL Server 2000, Visio, Business Objects Enterprise XIR2

Responsibilities:

• As a Programmer Analyst and Designer involved in requirement analysis of the scope of the project by walking through audio files of onsite requirement gathering process & preparing questionnaires & tracking of open items
• Onsite coordination through draft documentation of Macro Level Study, Customer Requirement Specification & Functional Specification, Report Layout in areas of ARM, SRM, Pace & Pricing Center
• Integration of Bloomberg Terminal Access via Eagle PACE Data Exchanger for file communication.
• Analyze the vendor data format and map it to the existing Eagle PACE database documenting in the functional specifications
• Identify and document the field level validations to be performed on the input data. Additionally introduce the calculations for the necessary derived fields
• Defining Composite Security Rule to create Best of Breed/ Golden Copy Data as per Investment Type, Region etc, by setting up the vendor hierarchy rules
• Create business rules to validate & enrich the best-of-breed data
• Generate an event matrix for loading, processing and publishing data
• Define functionality of searching scrubbed security and correcting it via respective panel by customizing Eagle supplied Security Panels
• Releasing and distributing the cleansed reference data to the various downstream systems, by designing the exporter (ETL) where reporting not fits
• Involved in analysis and development of Business Objects Reports
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi-dimensional analysis of database using Business Objects XiR2 for technical and sales departments
• Worked with @functions including @aggregate aware, select and prompts to overcome database integration issues.
• Organized data in the reports by using Filters, Sorting, Ranking and Highlighted data with Alerter
• Exported universes to the repository for making resources to the users
• Formatted the reports as per the users requirement using all facilities in Business Objects.
• Created different types of reports like master/detail, cross tab and chart.
• Extensively used calculations, changing displays and alerts in reports
• Created monthly, quarterly and yearly reports for management team

Confidential

PL/SQL Developer

Environment: Oracle 8i -PL/SQL, Master Craft, QPP, Jolt, Solaris UNIX, Tuxedo, iPlanet Web Server

Responsibilities:

• Calculate daily NAV based on Unit Capital Movement
• Fund Transfer through various scheme accounts towards Investor or Agent payment Against various services
• Marking of Recovery against extra payment made through services
• Marking of Recovery Receipt for extra payment from Investor/ Agents
• Generation of Refund Orders for dues pending with AMC of the Investor
• Instruct fund manager about fund transfer date (Post Dated Instrument Date) depending upon the bank agreement.
• Development of new requirements as per Client’s specification
• Development of new PL/SQL batches against various requirements
• Generation of flat files to report mfund-payout; which exported to SAP- Accounting module at AMC
• Writing of data loading & flat file generation batches using Loader script (ETL) & UTL FILE package
• Maintenance of existing batches & changes against with new requirements
• Preparation of LLD, HLD & various possible test conditions& review of impact against new changes

Confidential

PL/SQL Developer and Team Lead

Environment: Oracle 9i PL/SQL, Fox-Pro, JSP, Jasper iReport

Responsibilities:

• Development of new requirements as per Client’s specifications
• Client interaction & Requirement Gathering
• Coordination with NSDL, CDSL, and BSE & NSE for requirement of flat file formats
• Design of Business Process Document & User Requirement Specification Document
• Form Prototype Designing, design of Technical Document& client side revive
• Design & Implementation of Business Logic, designing of database
• Writing PL/SQL, Data Loading Script for loading DEA, BSE, NSE, and CDSL. NSDL etc using UTL FILE & SQL Loader
• Implementation of business logic & generation of PL/SQL scripts for Report Designing
• Implementation of Basis of Allotment Process of distributing shares by Lottery System
• Reconciliation under Technical & Manual Rejection
• Generate Flat Files: NSDL Corporate Action, Warrant Orders, Refund Orders, and Share Certificates etc.

Confidential

ASP and MS SQL Server Developer

Environment: Microsoft ASP 3.0, Java Script, IIS, MS SQL Server 2000

Responsibilities:

• Form Prototype Designing, Creating Database, writing Stored Procedure/T-SQL
• Development of ASP forms, creating help file / manuals & technical documentation

Confidential

Junior ASP and MS SQL Server Developer

Environment: Microsoft ASP 3.0, Java Script, IIS, MS SQL Server 2000

Responsibilities:

• Form Prototype Designing, Creating Database, writing Stored Procedure/T-SQL
• Development of ASP forms, creating help file / manuals & technical documentation