Objective:
To obtain a position as a Software Developer and be part of innovative and service oriented organization where my knowledge, communication skills and creativity can be applied for the growth of organization.

Education:

• Master of Science in Computer Science
• Bachelors of Engineering in Computer Science Engineering

Summary:

• Over 6 years of IT experience in Software Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies.
• Expertise in the functional and technical areas of SAP BI with full cycle implementations
• Worked on Business Objects by Building Universes, WEBI Reports, Crystal Reports, Xcelsius dashboards using BI services
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Used Stored Procedure Data Provider for frequently running tasks.
• Good experience in creating SAP BW/BI components like Info objects, Info cubes, Info source, Multi providers, ODS objects, Transfer structure, Transfer rules, Update rules and Info package.
• Extensively worked on Performance tuning for Improving data loading and query performance by maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes.
• Involved in Extracting the data from R/3 to BI, Loading and Monitoring
• Created Queries having Filters, Free Characteristics, Exceptions and conditions, Variables, Restricted Key Figures and Calculated Key Figures.
• Good experience in Process Chains creation to automate loading of all Master and Transaction data in background and sending mails in case of error.
• Worked on all kind of Transport activities (Transporting of info cubes, ODS, Queries etc) from BW - Dev to BW-PROD and R/3 Dev to R/3 QA
• Involved in extracting data from SAP R/3 and flat file.
• Experience in Data modeling using InfoCube, MultiProvider, ODS, Transfer rules, Update rules, InfoSet, InfoSources, DataSources, Transfer Routines, Update Routines and Start Routines.
• Experience in construction of customized InfoObjects, InfoCubes, RemoteCubes, and ODS/DSO objects
• Designed and developed queries for reporting using BEx Analyzer, Query Designer and Web Application Designer
• Developed Update and Transfer Routines in BW to implement business rules and conversions while extracting data from R/3
• Expertise and intensively worked on SAP BW Security and Authorizations
• Expert in creating Process Chains for Automation of process and better Performance
• Extensive experience in Business Intelligence tools with complete life Cycle Implementations of Business Objects XI 3.1/XIR2/6.5.
• Provided 24X7 Production support to the users.
• Experienced in Training & Supporting End-Users.
• Excellent communication, team and interpersonal skills.

Technical Skills:

• ERP: SAP BI 7.0, BW 3.x, SAP R/3 ECC 6.0/ 5.0
• Business Intelligence: Business Objects XIR3.1/R2/XI/6.5,Crystal Reports 2008/ XI,Informatica PowerCenter
• Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000, Teradata, Sybase, MS Access.
• Programming: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL,
• Operating Systems: MS-DOS, Windows 95/98/2000/NT/XP/Vista, Linux, UNIX, SUN Solaris
• Tools: Rational Clear Case, Rational Clear Quest, Visio 2003, Visual Source Safe, HP Quality Center 10.00, Test Director, TOAD, PL/SQL Developer, CVS,Autosys, DB Visualizer,MS Access,Remedy

Professional Experience:

Confidential , Owings Mills, MD Mar'12- Till Date
SAP BI/BO consultant
T. Rowe Price investment management firm offering individuals and institutions around the world investment management guidance and expertise.The T. Rowe Price investment approach strives to achieve superior performance but is always mindful of the risks incurred relative to the potential rewards. Our consistent investment philosophy helps mitigate unfavorable changes and takes advantage of favorable ones.
Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Created various Local and Global Variables & Scheduled, monitored and fixed the errors of the jobs.
• Extensively worked with Basic Cubes, Dsos, Info objects, Data sources and Process Chains.
• Involved in Installing and Customizing the Business Content Objects.
• Activated and modified standard extractors as per Business Requirement
• Created Generic extractors in Project System Module as per Business requirement
• Involved in standard master data source enhancement
• Experience in Extracting data from SAP R/3 Source systems.
• Improved data loading and query performance by compression, aggregates, indexes and rollups onto Info cubes.
• Maintained routines for required objects.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Monitoring of Master Data and Transaction Data uploads via process chain
• Actively involved in Rectification of Load failure Errors like Master Data Loads and Transactional load
• Involved in validating data consistency in reporting with Data Target against PSA after loading them to data targets.
• Maintained all backend objects - PSA, ODS, Master Data, Cubes, Multi-Providers, Info Packages, Process Chains, Info Objects, Info Sources, update rules, transfer rules & Source Systems including enhancements and customization.
• Involved in creation of Transformation and DTP (data transfer process).
• Involved in defining queries using Filters, Variables, Conditions and Exceptions, Restricted and calculated Key Figures in BEx Analyzer to facilitate data analysis
• Involved in the Transportation of the objects.
• Involved in the designing of Queries on Info Cubes and on ODS
• Created with the application specific and generic data extractors in Logistics.
• Managed over 4000 users and 50 user groups.
• Created new server groups and added multiple servers to handle the load and work efficiently.
• Worked with SAP Technical Support to troubleshoot various Deployment and performance issues.
• Worked with DBA's and System Administrators to back-up the repository and database and scheduled daily and weekly back-ups for both environment and repository.
• Member of the Production Support team and provided 24*7 support to keep the environment up and running and continuously monitor, tune and upgrade the environment.

Environment: SAP BW 2.1C/ 3.0 B, SAP R/3, DB2, Web Application Server, Business Objects 3.1/XIR2,Oracle,PL/SQL

Confidential, Washington, D.C Aug'11- Mar'12
SAP BI/BO Consultant

Confidential is to protect human health and the environment.To enfore this they develop and Enforce Regulations, Give Grants, Study Environmental Issues, Teach People About the Environment.

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Standard templates are created for future Ad-hoc reporting needs.
• Creating standard full client reports and WEBI reports.
• Used the Import wizard to import existing user accounts, groups, categories, WEBI documents, universes, connections and universe restrictions to BO XI environment.
• Resolving loops using contexts and aliases to remove the cyclic dependencies.
• Generated Reports with Free hand SQL and Stored Procedures using Oracle 10g.
• Trained the Business Users in report creation and also new features of Business Objects XI.
• Created SAP BW/BI components like Info objects, Info cubes, Info source, Multi providers, ODS objects, Transfer structure, Transfer rules, Update rules and Info packages.
• Worked on Performance tuning for Improving data loading and query performance by maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes.
• Involved in Extracting the data from R/3 to BI, Loading (Full/Delta Up-Load) and Monitoring.
• Created Queries having Filters, Free Characteristics, Exceptions and conditions, Variables, Restricted Key Figures and Calculated Key Figures.
• Used transformations and have written transformation code in start routines.
• Used function modules in user exits for customer outbound contacts to populate Catalog requested/mailed information. Used user exit to bring in Dunning level information from AR into customer outbound information for segmentation purposes.
• Trained Power Users on creating reports using BEx Designer and its usage in BEx Analyzer.

Environment: SAP BI 7.0/3.x, SAP ECC 6.0/5.0, BEx, Business Objects 3.1/XIR2,Oracle,PL/SQL

Confidential, Herndon ,VA Nov'09 - July'11
SAP BI/BO consultant

Confidential is a government-sponsored enterprise chartered by Congress to keep money flowing to mortgage lenders, to help strengthen the U.S. housing and mortgage markets, and to support affordable homeownership. It is a national mortgage finance company they stand behind mortgage lenders - local and national banks, thrifts, credit unions, and other financial to securitize or buy the mortgage loans they originate, enabling them to replenish their funds so they can lend to other homeowners.

Responsibilities:

• Worked in a BW production support role with daily hands on support of production activities including system enhancements, break-fixes and end user support.
• Used Remedy to log tickets and solve the urgent user issues.
• Used Business Objects Designer to maintain Universes, identifying Measures, Details and other dimensional objects.
• Applied row level and object level securities on different groups and users.
• Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
• Resolved inconsistencies using aliases/contexts to maintain universe integrity and check for loops and traps including chasm trap and fan traps
• Worked on fixing PSA, perfomed logical partitioning of InfoCubes based on fiscal year
• Analyzed InfoCubes. Created and maintained Aggregates to improve query response time
• Loaded the data from R/3 to BW on a daily delta basis
• Maintained all backend objects - PSA, ODS, Master Data, Cubes, Multi-Providers, Info Packages, Process Chains, Info Objects, Info Sources, update rules, transfer rules & Source Systems including enhancements and customization.
• Involved in support by Monitoring and Developing strategies for daily/monthly/weekly and Quarter close data loads using Process Chains, events and scheduler.
• Converted InfoPackage groups to Process Chains and tested all the process chains in development, QA and production environment.
• Created Process Chains (both Master and Transaction Data) to schedule jobs in BW and integrated e-mail alerts in them to alert about load failures.
• Tested multiple scenarios using cube partitioning, compression, query modifications, and aggregates. Reduced the average runtime significantly
• Created and update the reports, user exists for Partitioned Cube
• Create and enhance workbooks and queries as required using BEx Analyzer & Query Designer (including calculated key figures, restricted key figures, cell editor, virtual characteristics / key figures).
• Created and updated Variations for Warner Home Video Actual and Budget Reports
• Also involved in up-gradation and testing of BI Accelerator 7.0.
• Involved in defining queries using Filters, Variables, Conditions and Exceptions, Restricted and calculated Key Figures in BEx Analyzer to facilitate data analysis
• Evaluate system performance, tune queries / reports for better performanceand scenarios.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.

Environment: SAP BI 7.0/3.x, SAP ECC 6.0/5.0, BEx,Business Objects 3.1/XIR2, Xcelsius 2008, Crystal Reports 2008,HP Quality center, Remedy,Life Cycle Manager,Import Wizard, DB2,Teradata,Unix,Windows AD, LDAP, IIS, Windows 2008 , Windows 2003, Oracle10g, Sybase

Confidential, DC Jan'09-Oct'09
Business Objects Developer

Confidential, is a corporation striving to deliver a high quality, safe, on-time rail passenger service that exceeds customer expectations. Learn all about Confidential here from every angle.

Responsibilities:

• Requirements Gathering and Business analysis
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers.
• Linked two universes sales and customer using kernel approach.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Created reports using WEBI, DESKI, full client.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.

Environment: Business Objects XIR2/6.5, WeBI , DESKI, SQL, PL/SQL, TOAD,DB2 , Windows 2003, ORACLE

Portforlio Management System Sep\'07 - Dec'08
Department of Computer Science, Confidential, kingsville, TX

Responsibilities:

• Involved in the designing and Building of SQL Queries
• Written SQL statements for retrieval of data and Involved in performance tuning.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Environment: MS SQL Server 2005, T-SQL

Gate Navigation System Jan\'07 - April'07
Hyderabd,India

• Developed a gate navigation system to monitor vehicle movements within and out of a particular organization unit by implementing a secure system
• Used Radio Frequency Identification card (RFID) for each user to map the identity of the driver
• Used VB .NET framework to program and Microsoft Access as database
• Followed the iterative approach in a timely manner
• Worked in a team of 5 and participated in all phases of software development life cycle including interaction with clients for requirement capture and analysis
• Conducted usability test and implemented Unit test cases designed by entire team
• Documented all the installation instructions regarding the tools used and user manual regarding the application being developed

Environment: VB.NET, Visual Studio and Windows XP Professional

Certifications:

• 070-431: Microsoft SQL Server 2005 - Implementation and Maintenance