CAREER HIGHLIGHTS

• Worked on report optimization and instead of running time of 2 hours we were able to get report in 30 minutes.
• Created reports that helped to acquire new projects
• Helped other teams in fixing the issues and saved time and money for the client
• JIRA is an issue tracking application. Migrated JIRA to BO reporting for corporate governance
• Studied, Work load Estimation as per SDLC of CMMI Level 3 and helped company to achieve the CMMI Level 3 Certification

TECHNICAL SKILLS

Programming Languages: PL/SQL, SQL, C, Shell Scripting (Korn, Bourne) Database: Oracle 8i, Oracle 9i, Oracle 7, Sybase 11, SQL Server 7.0, SQL Server 6.5, MVS DB2, MS Access Data Warehousing: Informatica - PowerMartv5.1/4.7, Power Center v5.1/1.7, Business Objects 6.0, Business Objects 5.1.4 / 3.x, Designer, Business Objects XI Rel2, Supervisor, Broadcast Agent, Web Intelligence 2.6, Web Administrator,OBIEE, Zabo, Data Modeling, Data Design – both entity relationship and star-schema Case Tools:Erwin v3.5.2 Methodologies: Ralph Kimball, Bill Inmon  Internet Technologies: Java, Swings, JSP, Servlets, JDBC, Oracle thin drivers, JDBC-ODBC bridge, RMI, PL/SQL, HTML, DHTML, JavaScript, JSP1.0 Other Tools: Java Web Server 1.1.3, Java Web Server 2.0, Visual Symantec Café 2.5, FrontPage98  Platforms: UNIX (Solaris, AIX, HP-UX), Windows NT Server

WORK EXPERIENCE  Confidential, New York, NY Jan 2012– Present Confidential is publically traded American multinational banking and financial services corporation with over 5700 banking centers and 282000 employees, servicing 57 million customers; Confidential is the second largest bank in the nation and the 5th largest company in the U.S.

Business Objects Developer

• Use of Designer Module to implement Universe, linkages between tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies 
• Exported universes to repositories; produced reports for various portfolios using Web Intelligence.
• Involved in developmental Support and gave training to the users.
• Wrote SQL, Stored Procedures, Informatica ETL mappings and workflow. 
• Actively work with Reporter, Designer Query Panel and Data Provider and used Informatica Designer to develop Mappings and maplets; use Informatica Workflow manager to develop sessions and workflows.
• Use of Filters and Conditions, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Aid with report optimization and maintenance
• Manage End User Training and System Documentation.

ACHIEVEMENTS

• Techno Functional Analysis including understanding of data Model.
• Writing SQL queries for Data Analysis.
• Read/ Write capability of Stored procedures and any other ETL tools such as Informatica 8.1
• Writing /Understanding and Translating FRD’s based on user requirements to write Technical Documents.
• Produce detail documentation for each steps in SDLC as worked based on CMMI and SOX Compliance for Audit purpose.

TECHNOLOGIES

• Business Objects XI R2, Designer, WEBI, SQL Server 2005, PL/SQL, Informatica 8.1, ETL

Confidential, New York, NYSept 2008 – Jan 2012 Confidential is a Swiss financial services company that has over $1.2 trillion in assets, employees over 48000 people and has operations in more than 50 countries.

Business Analyst / Business Objects Developer

• Created Specification Documents for data sourcing; Loans, Derivatives and Secured Financing products through the strategic infrastructure for Basel II Parallel Run
• Analyzed data quality for the level 1 database for Mexico and South America entities; validated and quantified balance differences between the General Ledger and Opera databases
• Calculated Exposure at Default for different financial products like loans, receivables and off balance sheet products
• Utilized an Agile methodologiesto improve overall software development process
• Implemented a usage model and an initial domain model in order to identify and gather high-level requirements
• Conducted Model Storming Sessions on a just in time basis to solve problems arising in the software development and managed Capital Quality Testing; performed user-acceptance testing (UAT), generate V&E reports, created overrides in the system and test defects to improve data quality through Quality Center
• Developed test scenarios and managed testing processes including regression testing, system testing, integration testing, end to end testing, functional testing, backend testing and front end testing and gathered requirements from users on weekly basis
• Create Functional Requirement Documents based on BRD / Adhoc requirements gathered from user
• Coordination on daily basis with Build and QA Team for each monthly deliverables
• Wrote SQL and Stored Procedures for complex BI Reports
• Developed Universe, Reports as per User Requirements and created Database views, using hints if required for Reports
• Oversaw User Validation and Sign off; manage End user Training and Documentation
• Burst Creation, Schedule and Distribution of Reports in Info burst
• Reports and Universes Migration from BO 6.5 to BO XI R2

ACHIEVEMENTS

• Reports were optimised and they took 30 minutes instead of 2 hours they used to take to run.
• Created reports that helped toacquire new projects.
• Helped other teams in fixing the issues and saved time and money for the client.

TECHNOLOGIES

• Business Objects 5.1,BO XI R2, Web Intelligence XI, Designer, Oracle 9.1, PL/SQL, Oracle

Confidential, New York, NY Mar 2007 – Sept 2008  Confidential, the world’s largest bank, manages $2.67 trillion in assets, employees over 200000and has presence in 87 countries worldwide.

Business Analyst /BI Lead

• Requirements gathering from Users on weekly basis
• Create Functional Requirement Documents based on BRD / Adhoc requirements gathered from user
• Developed Universe and Reports as per User Requirements
• Creation of Databaseviews using hints for Reports
• User Validation and Sign off
• End user Training and Documentation
• Burst Creation, Schedule and Distribution of Reports in Info burst
• Reports and Universes Migration from BO 5.1 to BO XI R2

ACHIEVEMENTS

• JIRA is an issue tracking application. Migrated JIRA to BO reporting for corporate governance
• Studied, Work load Estimation as per SDLC of CMMI Level 3

TECHNOLOGIES

• Business Objects 5.1,BO XI R2, Web Intelligence XI, Designer, Oracle 9.1, PL/SQL, SQL Server 2000

Confidential, New York, NY Sept 2004 – Mar 2007 Confidential operate as an integrated bank, combining our strengths and expertise in Credit Suissethree global divisions, Private Banking, Investment Banking and Asset Management, to offer our clients advisory services and customized products. Credit Suisse has 550 offices in 50 countries with 48,200 employees.

Business Objects Developer

• Use of Designer Module to implement Universe, linkages between tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Exported universes to repositories; produced reports for various portfolios using Web Intelligence
• Involved in developmental Support and trained users
• Wrote SQL, Stored Procedures, Informatica ETL mappings and workflow
• Actively work with Reporter, Designer Query Panel and Data Provider
• Actively use Informatica Designer to develop Mappings and maplets; use Informatica Workflow manager to develop sessions and workflows
• Use of Filters and Conditions, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Aid with report optimization and maintenance
• Manage End User Training and System Documentation
• Used Visual Basic Macros to interact with Tabs within reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Used Visual Basic Macros to interact with Tabs within reports
• Helping in maintenance work related to reports
• Provided End User Training and System Documentation

ACHIEVEMENTS

• Worked on so many different roles of Data Warehousing even being Business Objects Developer.
• Worked on $500 million project and was part of 400 plus people.

TECHNOLOGIES

• Business Objects 6.0, Business Objects 6.5, Web Intelligence 2.6.2, Designer, Oracle 9.1, PL/SQL, Informatica 7.1.1,Unix, MS Visio 2000

Confidential, DeerField IL Jan 2004 – Sept 2004 Confidential, with 8300 locations, 247000 employees and revenues over $72 Billion dollars is the largest drug retail chain in North America.

Business Objects Developer

• Exported universes to repositories; produced reports for various portfolios using Web Intelligence
• Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Involved in production Support and gave training to the users
• Wrote SQL queries for Data Analysis
• Use of Reporter, Designer Query Panel and Data Provider
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Helping in maintenance work related to reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Used Visual Basic Macros to interact with Tabs within reports
• Helping in maintenance work related to reports
• Developed End User Training and System Documentation
• Exhaustive reporting in Excel and Business Objects 5.1 based on data analysis
• Translated FRD\'s into technical documents

ACHIEVEMENTS

• Created report for Walgreens to know the sales of all individual items in particular medicine

TECHNOLOGIES

• Business Objects 5.1.2, Web Intelligence 2.6.2, Designer, Oracle 9.1, PL/SQL, DB2

Confidential, Northfiled, IL Jun 2003 – Dec 2003 Confidential is a multinational food and beverage conglomerate that markets brands in more than 170 countries; Kraft’s recent revenues topped $54 Billion.

Business Objects Developer:

• Exported universes to repositories; produced reports for various portfolios using Web Intelligence
• Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Involved in production Support and gave training to the users
• Wrote SQL queries for Data Analysis
• Use of Reporter, Designer Query Panel and Data Provider
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Helping in maintenance work related to reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Used Visual Basic Macros to interact with Tabs within reports
• Helping in maintenance work related to reports
• Developed End User Training and System Documentation
• Exhaustive reporting in Excel and Business Objects 5.1 based on data analysis.
• Translated FRD\'s into technical documents

TECHNOLOGIES

• Business Objects 5.1.2, Web Intelligence 2.6.2, Designer, Oracle 9.1, PL/SQL, DB2

Confidential, Dallas TX May 2003 – Jun 2003 Confidential is a privately held travel technology company that provides airlines and travel agencies SAS solutions; Sabre also owns several travel related brands including Travelocity, employees over 9000 people and recently reported revenues over $2.8 billion

Business Objects Developer

• Use Reporter, Designer Query Panel and Data Provider, Filters and Conditions
• Created reports for various Portfolios using the Universes as the main Data Providers; created web based reports using Web Intelligence
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Helping in maintenance and testing work related to reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies 
• Used Visual Basic Macros to interact with Tabs within reports
• Involved in development of JSP using Weblogic5.1
• Developed End User Training and System Documentation

TECHNOLOGIES

• Business Objects 5.1.2, Web Intelligence 2.6.2, Designer, Teradata 7.0, PL/SQL, Weblogic 5.1

Confidential, Chicago IL Aug 2002 – May 2003  Confidential is a publically traded international financial services company that employees over 12000 people, has a presence in 12 countries and recently reported revenues over $3 Billion; Northern Trust was recently recognized as the ‘World’s most admired bank’.

Business Objects Developer

• Use of Designer Module to implement Universe, linkages between tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Exported universes to repositories;produced reports for various portfolios using Web Intelligence
• Worked on ZABO
• Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula’s etc.
• Involved in production Support and gave training to the users
• Wrote SQL and Stored Procedures
• Use of Reporter, Designer Query Panel and Data Provider
• Involved in implementation of mail merge functionality
• Use of Filters and Conditions, Slice and Dice
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting
• Helping in maintenance work related to reports
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies
• Used Visual Basic Macros to interact with Tabs within reports
• Helping in maintenance work related to reports
• Involved in development of JSP and EJB using Weblogic5.1
• End User Training and System Documentation

TECHNOLOGIES

• Business Objects 5.1.2, Web Intelligence 2.6.2, Designer, Sybase 11.x, PL/SQL, UNIX, Weblogic 5.1

EDUCATION

• Bachelor of Engineering

CERTIFICATIONS

• Java Sun Certification 2.0, SP3058240
• BrainBench Certified Java2.0 Programmer

MISCELLANEOUS:

• Regular participant in 10k and 5k runs.
• Played volleyball in High school and won interschool trophy.