ASIM RABBANI

* ********** **,

East Brunswick, NJ 08816

732-***-****

acr4xz@r.postjobfree.com

SUMMARY

Talented solution provider with over 15 years of experience.

Strong communication skills. Excellent team player.

Strong analytical skills coupled with an ability to identify critical areas.

Full System Development Life Cycle experience. Strong Object-oriented analysis and design approach. Ability to adopt operationally and technically best solutions for business needs.

Leadership skills include ability to lead and motivate co-workers, creative problem-solving and solution-oriented work style. Ability to improvise when situation demands.

Able to do multi-tasking and coordination between different groups.

Proven ability to effectively communicate with clients from requirement analyses to system delivery.

Ability to learn and adopt emerging technologies at a fast pace.

PROFILE

15+ Years of IT experience in Analysis, Design and Development of Client - Server and Web based Business Intelligence and Data Warehousing applications.

Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.

Expertise in Business Objects XI 3.1/3.0/XI R2/6.x/5.x ( Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Xcelsius,Central Management Console and Business Objects Administration, Live Office and QaaWS)

Experience in full life cycle gathering requirements, documentation, developing, designing, implementing, testing and deploying BI Solutions.

Extensive Experience in migration of Business Objects Universes and reports to newer versions.

Extensive database architecture and design skills of working on high performance solutions in large corporate environments.

Experience in Xcelsius to create dashboards using Live Office and QaaWS.

Adept Designing/Developing the Business Objects Universes, Ad-hoc/ Canned Reports, Complex Reports using predefined conditions.

Experience in creating reports and accessing queries using Business Objects Query Builder, Web application Designer.

Experienced in conducting design sessions to evolve System Specifications and Test Plans with the ability to handle training sessions and documentation.

Experience in installation, administration and upgrading versions of BO both client and server products.

Successfully applied fix pack and Service Pack patches on the Enterprise servers.

Involved in review meetings with Project Managers, Developers and Business Associates during Project Planning, Coordination and implementing various QA methodologies.

Hands on experience in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical data modeling.

Proficient with various RDBMS technologies including Oracle 11g/9i/8i, MS SQL 2012/2008/2005, DB2, Teradata and MS Access.

Working knowledge on Migration tools: Import Wizard, Publishing Wizard, Report Conversion tool.

Experience in writing Transact SQL, SQL Sybase, stored procedures, functions, packages, data base triggers, exception handlers, Cursors.

Worked as a team player with proven problem solving skills as well as independently with excellent communication and Interpersonal skills.

Knowledge on advanced modeling concepts including Analytic Views, Attribute Views, Hierarchies, Creating Restricted & Calculated Columns, Filter Operations, Variables, Creating Calculation Views in SAP HANA.

TECHINCAL SKILLS

OLAP/DSS Tools : Business Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, BO SDK, Crystal Reports, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web Intelligence, Webi Rich client, Report Conversion Tool, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Performance Manager, Crystal reports Enterprise, Auditor, Crystal Report Explorer, Dashboard manager, Tomcat 4.0.6, SAP Portal

RDBMS : Oracle 11g/9i/8i/7, MS SQL Server 2000, 2005, 2008R2, 2012, DB2, MS-Access, Teradata, SAP HANA.

Utility Tools : Erwin 4.1/4.0, Toad 8.5.1 and SQL Navigator 4.1, Developer 2008

Languages : C#, C++, UNIX Shell Scripting, XML, SQL, T-SQL, PL/SQL.

Operating Systems : Sun Solaris, UNIX, Windows 2003/XP/NT/Vista/7/2000/98/95

Products: SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Business Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, Microsoft Office

Middleware : Web logic 10.1, 10.3g

WORK HISTORY

03. 2015 - PRESENT TD BANK – MT LAUREL NJ

Strategic Business Intelligence/Reporting Consultant

TD is consolidating recent acquisitions. As such, the Commercial Delivery unit of Information Management is given the task to convert, modify and enhance various Business Reports housed in the customized BO Portal called PORTICO. Job responsibilities include:

Attend requirements gathering meetings and developing detailed design documents. Working on BRD and solution design documents.

Implement/modify HANA views using SAP HANA Studio and connect via HDBODBC2.0 to create Crystal Reports.

Working on the commercial business banking (CBB) Universe to enhance and merge the features.

Extensively worked on BW reporting using BEx Analyzer, BEx Query Designer, BEx Broadcaster using Calculated Key Figures, Restricted Key Figures, Structures, Variables, Aggregations, Exceptions, Conditions and Customer Exits for calculating the YTD and MTD Values.

Created WSDLs using Query As A Web Service (Qaaws) from different Data sources and implemented WSDLs into Dashboards.

Modifying around 70 Crystal Reports to use different data sources.

Create T-SQL procedures for bulk inserts. Use TRY CATCH exception handling.

Building new Webi reports based on existing and new universes.

Design Business Views for cascading Dynamic Prompts.

Publish reports through CMC (Central Management Console) and scheduling/export the reports in different Formats.

02. 2014 – 03. 2015 EXPRESS SCRIPTS INC. (ESI), FRANKLIN LAKES NJ

Lead BI/BO Developer/Crystal Report Developer

At ESI, I was part of the Systems Retirement Project after the acquisition of Medco by ESI. It’s a huge warehouse/archival project to preserve years of data for legal and reporting requirements. Multiple applications were transitioned to the new F15 platform and the historic data was being archived using IBM OPTIM. BO reporting was mostly against OPTIM data sources using Attunity Connect. Job responsibilities included:

Gathering Requirements and developing detailed design documents. Working on BRD and solution design documents, test case documents and UAT documents.

Participated in end-user trainings.

Support and administration of BI back-end operations to ensure data is successfully extracted from source systems.

Worked on Business Objects using Universe designer (UDT/IDT), Webi, Crystal Reports and Dashboard reporting.

Defined security models with row level data security, role based security etc. in Business Objects Universes and Central Management Console (CMC)

Regular use of publishing wizard to migrate reports and repository objects.

Used Business Objects Lifecycle Manager (LCM) for promotion and Version Control.

Extensively work with BO Classes, Objects, in the Universe, Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.

Work with the DBA to create aggregate tables and materialized views to improve query performance by cutting down on the size of the result set at the data provider level.

Designed Business Views for cascading Dynamic Prompts.

Published Reports through CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Use Remedy reports to manage team tasks and project status.

03.2013 – 01.2014 COLUMBIA UNIVERSITY IT (CUIT), NY

Lead Crystal Reports/BI/BO Developer/Solution Architect

At the Enterprise Business Intelligence Solutions (EBIS), a division of Columbia University IT (CUIT), I work with the Business Objects Team. The team comprises of two report developers, a universe developer and a BO Admin. The goal of the EBIS is to conform to the BI best practices while providing quality business decision and support services. Job responsibilities include:

Gathering Requirements and developing detailed design documents through user collaboration.

Use aggregates, compression, and partitioning techniques to improve data load and query performance.

Report performance enhancement using stored procedures and PL/SQL packages. Tuned queries using Partitioning and summarized and intersect tables.

Worked on Business Objects using Universe designer, Web-I, Crystal Reports and Dashboard reporting

Defined security models with row level data security, role based security etc. in Business Objects Universes and Central Management Console (CMC)

Regular use of Import Wizard to migrate reports and repository objects.

Used Business Objects Lifecycle Manager (LCM) for promotion and Version Control.

Worked on Business Objects using Universe design and Dashboard reporting

Worked in Web Elements to build customized parameter pages and interactive Crystal Reports.

Designed Business Views for cascading Dynamic Prompts.

Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.

Created Publications for up to 50K reports per month for dynamic and enterprise recipients.

Assign tasks to the team members and hold weekly status meetings.

Use Service-Now reports to manage team tasks and project status.

04.2010 – 02.2013 NEW YORK LIFE INSURANCE COMPANY, NYC, NY

SAP BI/BO Developer/Solution Architect

At the Business Intelligence Competency Center (BICC), a division of Corporate Data Warehouse (CDW), I work with the BI TOOLs Team. The goal of the BICC is to conform to the BI best practices while providing quality business decision support services. My role, as in any financial institution, is diversified and challenging. Here are the job duties:

Actively interact and schedule meetings with the business users to gather the reporting requirements, perform gap analysis and developed design documents.

Use aggregates, compression, and partitioning techniques to improve data load and query performance.

Used BI Broadcasting services for the distribution (Print & Email) of exception reports to key business users

Created Webi reports and Crystal reports over OLAP universes and created Inventory accuracy Dashboards using Xcelsius/Crystal Dashboards. Create what-if scenarios for the Market Opportunity Analysis.

Worked on BW reporting using BEx Query Designer.

Work with the DBA to create aggregate tables and materialized views to improve query performance by cutting down on the size of the result set at the data provider level.

06.2008 – 04.2010 AT&T LABS, MIDDLETOWN, NJ

Web BI/BO Developer/Architect

At AT&T, I worked on Capacity Management and Performance Management Reporting wherein the data is loaded in Daytona and then Oracle 10g database which serves as the source for the Crystal Reports V XI R2. This database is daily updated so as to have the most current data. The reports are then published onto the Business Objects Enterprise to share it with the other report developers and with the Testing team. The reports are then checked out after UAT.

Designed reports in Crystal reports XI V R2 against Oracle 10g database containing RCT tables and views.

Worked with Business Analysts in finalizing the data requirements.

Created Views, Synonyms and Store Procedures which is used as a data source for designing reports.

Used Grouping, Summaries, Parameters, Hyperlinks, Custom functions, Formula fields, etc.

Extensively used advance features of Business Objects Enterprise like OpenDoc for Passing Parameters to other reports and also to call one report from other.

Created Dynamic prompts using Business View Manager.

Also shared the Custom functions created with other developers using Repository and Enterprise Explorer.

Published reports in development and UAT environments for business analysts and testing team to test these reports in Enterprise and then check out.

Involved in Tuning and improving the performance of reports.

10.2007 – 06.2008 CITIGROUP INFORMATION SERVICES, NEW YORK

Senior BI/BO Developer

Part of Financial Data Analytics team: Collection and reporting of time sensitive global financial information for Citi Knowledge System (CKS).

Worked with Business Analysts on finalizing the requirements and in creating BRS/SRS documents

Worked on Oracle BI Applications. Dashboards and Scoreboards. Exposure to the General Lager and Accounts Payable module.

Administered Business Objects Enterprise, Central Management Console(CMC)

Designed few Universes so that database underlying complexity is hidden from programmers.

Designed crystal reports based on Oracle tables/oracle stored procedures

Extensively used Oracle functions in creating PL/SQL procedure and have also used different in-built functions in Crystal reports formula editor

Published reports in different development and UAT environments for business analysts to test these reports in Enterprise and sign off

Created Views, Stored Procedures and Functions Using SQL, PL/SQL

Used charts, grouping, and summary and optimized reports performance.

08.2002 – 10.2007 NYC DEPARTMENT OF EDUCATION, NEW YORK

Senior Analyst Programmer/Architect

Worked as a Business Analysts gathering requirements, functional specifications, building test cases and other project relates documents

Performed User Administration like managing User Rights and maintained Global Level, Folder Level and Object Level security

Manipulating data through various presentation styles such as Bar charts, Pie Charts and Line graphs. Converted Reports created in MS SQL Server (SSRS) to Crystal Reports.

Implemented Cross tab Reports and Sub Reports

Designed and developed various types of Reports (Pivot, Tabular, Chart Reports)

Periodical Scheduling for Reports to run automatically. Complicated reports have been generated using store procedures

Responsible to make sure Email, FTP, and Unmanaged Disk options of scheduling are always up and running. Performing evaluation and testing to plan migration to SQL Server 2005.

Database development including DTS packages and Triggers within the database where most business policies have been implemented.

Strong knowledge of Cognos reporting which is currently used to run fiscal reports from Financial Management System. Received hands-on training from Cognos Corporation and plan to employ Cognos for reports from CTS database.

EDUCATION

Bachelors of Science (B.Sc.) Electronics Engineering with Honors from University of Engineering and Technology, Lahore, Pakistan with major in Communications.

Training in Transient Network Analysis in CESI Italy.

Post-Graduate Diploma in "Software Engineering" With Distinction

QUALIFICATIONS

Brain bench Certified Reports Designer for Crystal Reports XI

Brain bench Certified Programmer for PL/SQL RDBMS Concepts

Brain bench Certified for C#

Brain bench Certified for ASP.NET

Contact this candidate