PROFESSIONAL SUMMARY:

• Over 10 plus years of professional work experience in Analysis, Design, Development, Testing, Business Intelligence, Data Warehouse /Data Mart design and implementation of client server applications.
• Extensive experience as a MS SQL Server Developer 2012/2008 (R2/R1)/2005/2000/SSRS/SSIS in various Industries like finance and banking and utility
• Strong experience using SAP BI 4.0/Business Objects XIR3/XIR2/6.5 with extensive experience in Universe Designer, Report creation using Desktop Intelligence & Web Intelligence and, Central Management Console, Data Stage.
• Proficient in created reports using SSRS and SAP Business Objects XIR3/Business Objects XI R2
• Experience in building Universes, retrieving data using Universes, Personal data files, and created reports using the SAP Web Intelligence
• Experience in working with creating Data warehouse using SSIS ETL Functions and related OLAP tools
• Experience in working with Microsoft PowerPoint, Visio, Word, Excel and Outlook, Lotus Notes
• Strong experience with the creation of Universes using the Information Designer Tool R4
• Strong experience publishing and distributing Business Objects reports via the BI Launch Pad R4 (InfoView).
• Knowledge in data warehouse concept and star schema
• Looking for committed, stable employment with a long - term vision

SKILL:

• SAP Information Design Tool 4.0, Universe Design Tool
• SAP Web Intelligence Rich Client, SAP Web Intelligence Java Interface
• SAP BI Launch Pad, Central Management Console, Query as a Web Service
• Business Objects XIR2, XIR3
• Oracle SQL/PLSQL, SQL *Plus, Oracle SQL Developer
• Toad
• Data Warehousing
• Tableau 9.0
• Data Loader

PROFESSIONAL EXPERIENCE:

SQL Server Developer and Salesforce Admin

Confidential, New York, NY

Responsibilities:

• Attended the meetings set up by supervisor, managers, co-workers and myself.
• Supported to EU and executives, production support
• Troubleshoot and resolved various issue
• Installed, setup and configured SQL Server
• Used SQL Serve Import and Export wizard to pull the data from excel files as source file.
• Downloaded the data from DB2 database to SQL Server using stored procedure
• Wrote complex SQL queries to join, analyze, and extract data from various data sources in compliance with department needs. Extracts contained data from internal systems and outside vendors that was imported for analytics purposes.
• Designed and implemented SSIS packages, supported by stored procedures and user-defined functions, to extract customer information for monthly surveying. Optimized packages and increased marketing potential of extracts through ongoing communication with department staff.
• Imported data from the New York City Department of Buildings and utilized corresponding data dictionaries to selectively filter the data. Combined the resulting data set with customer records using stored procedures to validate and update customer building information.
• Gained a strong understanding of the services provided by various energy efficiency programs. Used this knowledge to ensure all related tasks were completed with the goals of each program in mind.
• Provided Production support.
• Analysis design developed, code and implement data request.
• Imported/Exported the data from SQL server from/to .csv and excel format using Sql Server import and export Wizard.
• Downloaded the data, using open query, from DB2 to SQL Server
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Created the table, setup primary and foreign key, join the multiple tables.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Develop Deploy and Monitor SSIS Packages using Autosys.
• Using the windows Batch file to schedule a SSIS Jobs on Autosys.
• Loading data directly from Oracle Environment to SQL Server Using Oracle connector Attunity.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split and Derived column etc.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Experience in creating different type of reports like ad-hoc reports, parameterized reports, dashboard reports, drill through report, and drilldown reports by using MS reporting services (SSRS).
• Scheduled report and exported in PDF format.
• Provided documentation of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures for automating tasks.
• Created automated routines and Developed, monitor and supported daily and nightly ETL processes
• Supported various ETL packages developed in SSIS, which run both daily and nightly; take initiative in enhancing packages or troubleshooting packages when errors occur (daily and nightly)
• Managed the full life cycle of BI projects: interviewed customers; capture and document requirements; analyzed and validated data needs; designed and developed the end reporting solution; managed the implementation; tested and trained users.
• Created user and added to the profile
• Uploaded CSV files to Salesforce from SQL Server
• Added new users the profile
• Uploaded the data using data loader in Salesforce and then Initiated background processing of imported Project records
• After the processing the Project records, used Reports to generates the customize the reports.
• Created the tableau group on SQL Server and granted permission to publish on the tableau server
• Attended periodic meeting, Trained users and co-workers
• Setup and configured FTP client
• Provided help desk and technical support

Business Intelligence Developer

Confidential, Alexandria, VA

Responsibilities:

• Daily every morning checked the “schedule daily reports”
• Approved schedule Corporate planning Tool DAILY REPORTS, every report schedule every day, checked the current date on which the report is scheduled
• Then open Production report portal(client report portal), and validated the reports
• Attended the meetings set up by supervisor, managers, co-workers and myself.
• Multitasked on various project, Tested the reports, sent result via email to test lead, cc’d Developer
• Scheduled UAT folder report instances
• Weekly ran the schedule report and changed the parameters
• Developed reports using Universe design, Information Design, Web Intelligence, and Dashboard
• Supported to EU and executives, production support and resolved various issue
• Developed SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split and Derived column etc.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Installed, Setup, Configured SAP Client tool like SAP BI R4 Information Design Tool.
• Administered Business Objects security, groups, and users created user and in CMC and in inhouse security application and added folder
• Reset the password in PROD, TEST and In DEV environment, after validating the user and new employee.
• Reset the password for the User, team member, in EWD security app and then in CMC and tested and sent information via email to user checked the status of the instance in CMC
• Deleted failed instances.
• Created the new user
• Created universes using the Information Designer Tool R4
• Chasm trap, Fan trap, and Loops, resolved joins short cut join, Outer join, Theta Join
• Ran the integrity check, and fix the errors like join, cardinality, Expression
• Added alias table and made the necessary join and test the integrity check.
• Created number of standard reports and queries based on the existing classes/objects
• Created date prompt
• Modified the existing report according to the reporting requirements
• Produced Reports and exported to Excel based on the user requirements
• Filtering data using subquery, combined query prompt, and Input controls
• Ranking data using database ranking
• Enhancing the presentation of the reports
• Organizing the data with section, breaks and sorts
• Merging the data from dimension using various data source
• Migration from 3.0 to 4.1
• Relational UNV converted to UNX
• OLAP UNV re-created in UNX
• Involved in Upgrading SAP Business Objects Enterprise to SAP BI 4.0
• Migrated Universe/Reports from R3 to SAP BI R4
• Used Upgrade management tool
• Tested report manually
• Exported the report from Launchpad portal and PTO report to PDF and compared the report, found the defect and reported to test lead.
• Tested all the report in BI Launchpad portal VS Confidential report portal
• Involved in regression testing, checked the release case status, used the module portal, BO universe, ETL, Regression and scenarios, calculate total, passed cases and failed cases and remaining cases.
• Compare the values with old report
• Checked all the investments, compare investment with the old one with new one, checked epm id, project #, project name
• Listed project name, empls id, and project code should not be in the new report of the section D.
• Tested reports in BI Launchpad production environment in UAT testing
• Involved in Unit testing, Regression testing of the report
• Ran the web intelligence reports, exported to pdf version
• Scheduled the report
• Refreshed the report and Ran the query
• Scheduled the investments in production UAT folder report instances
• Dashboard creation using tableau version 9.0
• Integrated QAAWS with Xcelsius as universe designer data provider
• Published and distributed Business Objects reports via the BI Launch Pad R4 (Former Info View)
• Used remedy as ticketing system to track the tickets created the incident

Environment: SAP BI R4.0 sp5, (BI Launch Pad, Web Intelligence, Central Management Console, Information Design Tool) Oracle 11g, Oracle SQL Developer, MS Office 2013, Windows 7, Remedy 7.1, Enterprise Data Warehouse Security App, SQL Server/SSIS 2008

IT Applications Analyst (BI Developer)

Confidential, New Jersey, NY

Responsibilities:

• SAP Business Objects XI 4.1 - Universe design, Information Design, WebI, Dashboard
• SAP Business Objects BI 4.1 (Information Design Tool 4.1, WEBI Rich Client)
• Supported to EU and executives, production support
• Troubleshoot and resolved various issue
• Installed, Setup, Configured SAP Client tool like SAP BI R4 Information Design Tool.
• Administered Business Objects security, groups, and users
• Created universes using the Information Designer Tool R4
• Chasm trap, Fan trap, and Loops, resolved joins
• Short cut join, Outer join, Theta Join
• Developed Hierarchies to support drill down reports used @functions like @select, @prompt, @where, @variable, and @Aggregate Aware
• Index Awareness
• Created number of standard reports and queries based on the existing classes/objects
• Produced Reports and exported to Excel based on the user requirements
• Filtering data using subquery, combined query prompt, and Input controls
• Ranking data using database ranking
• Enhancing the presentation of the reports
• Organizing the data with section, breaks and sorts
• Merging the data from dimension using various data source
• Migrated Reports and Universe from 3.0 to 4.1 using upgrade management tool.
• Relational UNV converted to UNX and OLAP UNV re-created in UNX
• Involved in Upgrading SAP Business Objects Enterprise to SAP BI 4.0
• Tested all the report after migrating to SAP WEBI using SQL script in TOAD
• Used Free hand SQL script to run the query
• Created tables, Views, joins and used union, minus, intersect
• Tuned and optimize the query using indexing
• Build the query based on right outer, left outer and full outer join
• Used nested query for complex report
• Optimized and tuned Universes and reports
• Integrated QAAWS with Xcelsius as universe designer data provider
• Published and distributed Business Objects reports via the BI Launch Pad R4 (Former InfoView)

Environment: SAP BI R4, SAP BOXIR3, BI Launch Pad, SAP Webi Rich client xir3, Web Intelligence, CMC, Oracle 10g, MS Office 2007, Xcelsius 2008, Query as a Web Service, Excel 2007, and Windows 7, TOAD.

Confidential, Stamford, CT

Sr. Business Objects Developer

Responsibilities:

• Design and modified existing Universe.
• Set up Aggregate Awareness and Index awareness for faster performance of the reports.
• Experienced creating reporting universes and data repositories and configuring BO software to meet end user reporting needs
• Created Universe with Classes, Objects and Condition objects
• Developed Hierarchies to support drill down reports
• Full client reporting designs and Development
• Experience with custom prompt development, Filters, Rank, Sorts, Slice and Dice, Crosstab, Charts, Master Detail, Alerter, Drill, hierarchies
• Used different data sources like Personal Data files, stored procedure, freehand SQL and Universe.
• Web Intelligence report Design and Construction from scratch and existing.
• Work with business users, Business analyst, DBA to design Web intelligence reports.
• In depth knowledge of the Business Objects architecture and Web Intelligence reporting
• Work with report structure- Java report panel and Create complex reports and report specifications.
• Used functions formula and functions like Aggregate, date and time, character, Document, Data Provider, logical, Numeric, Miscellaneous.
• Used Query technique like combination Query, Union, Minus, Intersect Query and used In, ForAll, ForEach, Context, Where operators.
• Work with sorts, filters, ranks, Breaks, Alerter, Drilling, create charts, and cross tab reports. Created formulas, cascaded dynamic prompts and variables.
• Create user, groups, folders and setup rights & privileges on it and setup row/object level security.
• Installation of Business objects xir2.
• Migration 6.5 to XIR2
• Migrated more than 150 reports from 6.5 full client and web intelligence reports to XIR2 environment
• Test all the report after migrating to xir2 environment.
• Used Rational Clear Case for Version Control, Create, Move, and Apply labels
• Check in-Check out, Version Tree, Find checkouts and Check in.
• Created views, Synonyms and wrote procedure in Oracle 10g.
• Level 3 production support
• Trained users and mentor juniors and database developer better to interface with business objects suite XIR2
• Used Confidential application IT Governance to create packages and package line to promote/ re-promote the Universes from Dev to UAT and UAT TO PROD

Environment: BOXIR2/6.5, Web Intelligence, Desktop Intelligence, Supervisor/CMC, Oracle 10g, Toad 8.5, Clear case, IT Governance, MS Office 2003, Windows XP.

Confidential, MI

Business Object XIR2 Developer

Tools: BOXIR2, Oracle 10g, Informatica Power Center 7.1, Windows 2000

Responsibilities:

• Installed and Configured Business Objects XIR2 on Windows
• Strong experience designing hierarchical reports, dashboards and drill-down Cross-Tab reports development and tuning in Oracle
• Created User and Groups and assigned security, settings and rights through CMC
• Created Security approach and design document
• Defined and designing a security design in XIR2.
• Involved in migration of repository to BOXIR2
• Web Intelligence (WEBI) and full client experience
• Central Management Console (CMC).
• Business Objects Enterprise Framework experience.
• Educated and trained users on Business Objects XIR2
• Documented reports & universe specifications and design
• Performance Management and Capacity Planning
• Designed, implemented, distributing, and maintaining universes.
• Tuning universes and reports for better performance
• Create Dashboards, complex reports, and migration strategies.
• Designed Universes, Classes, and Objects using Business Objects Designer, BOXIR2
• Report creation: Calculations, Variables, Drill Downs, and Slice & Dice.
• Defining project scope and pre-sales support
• Designs, develops and implements mappings/transformations based on source-to-target specifications
• Provides design input to the data integration architecture.
• Assists in defining Inoformatica 7.1 ETL development standards and conventions
• Assists in defining metadata that needs to be captured for each transformation process
• Performs monitoring and tuning of Inoformatica 7.1 ETL jobs
• Provides operational support to production Inoformatica 7.1 ETL processes and code on an as-needed basis
• Extracting data for multi-dimensional analysis
• Business Objects XIR2 experience with filters, user objects, variables, and stored procedures
• Experience with Cardinalities, contexts, Joins, and Aliases to resolve loops and verify the integrity of the universes.

Confidential, NJ

Oracle Developer

Responsibilities:

• Perform applications development, programming, and support using Remedy, SQL*Plus, and PL/SQL in relational database environment
• Design processes to enhance Oracle related performance items
• Wrote PL/SQL packages to implement the logic of Bills of Material based on the sales orders and to implement the logic of Production Monitoring based on the inventory control using Dynamic SQL
• Involved in Database design and modified database design to increase performance and usability.
• Developed Stored Procedures implementing the business logic
• Developing, database triggers.
• Migrating and creating new databases.
• Involved in the Database design and maintaining database security, and tuning
• Developed reports using Business object facility

Environment: Oracle8i, Pl/SQL, Erwin 4.5, Toad, Windows NT, UNIX, Shell Scripting.