I am results-oriented Techno Functional Business Analyst/Business Intelligence professional with exceptional problem solving skills in complex highly integrated Software Development/data warehousing environments.Extensive experience in developing and managing the reporting requirements and working as a liaison with both business stakeholders and technical resources. Proven ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.

Extensive Knowledge in Business and Technology solutions. Information Technology Specialist with over 12 years experience in business analysis, data management, development and delivery of Business solutions. In depth knowledge and experience with all aspects of business analysis (BA) and business intelligence (BI).

Strong background in technical account management and project management with the capability to manage design and deliver of all components of a Software Development/ business intelligence solution. Strong experience with structured methodologies for the analysis, design, development, testing and deployment of Business applications

Strong data analyst and report design skills withtwo utility industries experience like Telecommunication (Bell Canada) and Oil & Gas (Enbridge Gas distribution). Implemented Consumer Wireline Dashboard for a major Telecommunication company. Extensive experience in multidimensional analysis managed reporting ad-hoc reporting data visualizations notifications/alerts and Dashboard

Knowledge of change management based on ITIL principles.Strong development experience with major BI tools and Oracle 8i/9i/10g/11g, SQL, PL/SQL, Views, Functions, Stored Procedures, Packages and Tables. Experience with data warehousing elements including star schema, snowflake schema, and cube design, dimensional and aggregative designs.

Experience in Writing moderately complex test plans for assigned projects. Maintained record of test progress, documents test results, prepared reports and presented results as appropriate. Possess good communication skills, both oral and written in order to clearly and effectively convey issues, reports, and other deliverables to stakeholders. Experienced in Unit Testing (UT), System Integration Testing (SIT), and User Acceptance Test (UAT).Experience in developing, performance monitoring and tuning of reports. Full project life cycle implementation experience.

Technical Skills

• SAP BOBJ( Business Objects Business Intelligence Platform) :XI 3.X/ XI R2 (Designer, Desktop Intelligence, Web Intelligence), Infoview, Crystal Reports X.0, and Xcelsius 2008/BOBj Dashboard
• ERP: SAP R/3 4.6b/4.6C, Business Warehouse SAP BW 3.5, Business Intelligence SAP ECC6 BI 7.0
• Modules: FI and CO
• Tools: Business Explorer Tools (BEX), Web Application Designer, Query Designer, Analyzer
• Cognos: V8.3 (Report Studio, Query Studio, Framework Manager, Transformer), Cognos Series7 v.7.3.MR3 (PowerPlay Enterprise Server, PowerPlay Transformer, Impromptu, Impromptu Web Reports and Upfront)
• ETL Tools: Informatica Power Center 7.X/8.1.1.Business Objects Data Integrator (BODI)
• Data Modeling Tools: CA Erwin 4.x
• Databases: Oracle 11g/10g, 9i/8i, MS SQL Server 2005/2000/7.0, and DB2
• Framework: .NET and J2EE.
• Applications & Tools: MS Project, MS Visio, MS Office, SQL*Plus, TOAD, ABAP, Java, GoldMine 6.X (CRM), Business Vision (Accounting), COBOL, Access VBA, Excel
• Web Tools: JSP, Java Beans, HTML, XML, Java Script, CSS, MS Office, HTML, DHTML
• Hardware: IBM compatible, Mainframe Digital Vax 6310
• Operating Systems: Windows NT 4.0, Windows 2000/XP, AIX UNIX, and Vax VMS

Experience:

Confidential, ON June 2010- to date Client: Confidential,NY
Role: Project Manager / Business Analyst
Project:ArtScroll is similar like Amazon an Online retailer of books, software, music and games along with electronics, toys, apparel, sports, tools, and general home and garden items for Judaica.
Role: My role is to manage requirement, design and deliver of all components of a Software Developmentforthe Legacy application into the new platform. Develop requirements specifications. Develop impact and preliminary analyses, and participate actively in their implementation. Participate in development projects as advisor in the area of business and systems use. Support account managers and clients in their decision-making by carrying out research, analyses and recommendations. Track business needs during development phases. Observe the standards and procedures established by the project office. Develop testing strategies and verification scenarios. Managing offshore team.
Client: Confidential, Toronto, ON
Project: Universal Asset Health Review (UAHR)
Role: Analyzing and designing the Reporting requirement for UAHR of EGD. Participated in requirement gathering and JAD session for design of the physical and Dimensional model of Universal Asset Health Review (UAHR).Analyzed and designed the reporting requirement, Prepared SAP BOBJ Universe design documents for UAHR.Analyzed and Designed the OLAP requirement Document for UAHR. Reviewed the ETL scripts and wrote the test cases for ETL Batch Jobs. Analyzed and Design requirement of the ETL Jobs and Job Sequences for Source to staging Data Extraction. Proposed the different design of the Architecture based on Materialized View and SAP BW and BOBJ by using Current license requirements of EGD for AHR. Conduct meeting with DBA teams to set up the Source Data Extraction, Development, Testing and production Environments.

Confidential,Toronto, ON,Aug 2008 – Jun 2010
Role:Worked on analysis, modeling and reporting. Gathered reports requirements and designed Universe and reports document according to Business Requirements. Participated for the construction, testing and implementation of the Extract, Transform, and Load (ETL) components as well as maintaining technical documentation. Used Designer Module to create Prompts and Quires parse the object, apply Context and Alias table to remove cyclic Dependencies.Extensively used Calculation Context, Variables, Filters, Conditions, Break, Sorting, Drill Down, Slice and Dice, Master/Detail, Cross Tab, Charts and Alerts for creating Reports.Documented the approach to extract, transform and Load data from non-sap source systems.

Confidential,Toronto, ON, Oct 2007 – July 2008
Project: Consumer Wireline Dashboard Client: Confidential,
Role:Implemented the executive Dashboard. Designed and developed the Functional Documents of FWFM (Federated Work Force Management) is an application that manages technician field visit workload in Bell Canada. Orders from SODB and NSC-Hub are sent to FWFM where the work to complete the order is analyzed and scheduled to the technician best suited to the job. The application manages workload for all wire line technicians and assigns for optimum productivity and results. Involved in Consumer Wireline Order Tracking SRS (System Requirement Specifications) meetings
Projects: New Agent Code (NAC) Client: Confidential,
Role:In my project of implementing the New Agent Code (NAC), from Analysis to User Acceptance Test (UAT), I handled and completed all the phases of the project successfully on time. Analyzed and reviewed 2000 Report and 20 OLAP Cube of business intelligence unit in detail and created a detail report for the changes. Implemented the changes, performed UAT and prepared documentation.

Project: Save Offer Revamp Client: Confidential,
Role:Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution. Analyzed and developed the reports requirement for save offer, call usage, RMA (Returned Merchandise Authorization – Bell application, etc) for Save Offer Revamp project.

Confidential,Toronto, ON, Jul 2006 - Aug 2007
Role: Analyzed business-reporting requirements and verified whether DW design supports reporting requirements. Involved in gathering business requirements and designing Cognos Report applications. Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs. Designed and implemented cleansing strategy before the data is loaded into a staging area

Confidential,Toronto, ON, Dec 2004 – Jun 2006
Role: Gathered reports requirements and designed catalog and reports according to Business Requirements. Implemented GoldMine (CRM) for client’s customization. Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Reports. Generated various reports on Daily, Weekly, Monthly and Yearly basis. Supported UAT while users are testing the reports.

Confidential, Toronto, ON, MAY 2001 – Nov 2004
Role:Set up a unique IT consulting and training project (Work and Study) for foreign trained professional immigrants and new university / college Graduates that best fit for the Canadian market needs. From lease negotiations in core financial district of downtown of Toronto to daily business operation, involved in all business development activities including executive-level accountability for P&L, budgeting, cost control, strategic partnering, business development, recruiting, team building, and OEM relations
Setup and managed the leads Generation / Sales Departments and track record for Qualified Leads and sales. Discovered co-op opportunities effective application of dynamic B2B, corporate and end user sales talents. Trained and placed new university graduates and new immigrants back into their professions. Set up, Managed and Involved in Development of e-Commerce solutions for clients.

Confidential,Torrance, CA, May 2000 – Mar 2001
Clients:Confidential,Dallas, TX
Project: TradeMatrix and ContentExchange Single-Sign-on. The SSO Capability will allow the user to Login to TM and seamlessly Transaction to CX without a separate Login.
Role:Involved in the initial design of developing Data Warehouse physical model. Developed ETL procedures to ensure conformity, data integrity, and compliance to standards. Defined fact tables and dimensions. Developed PL/SQL stored procedures and packages to load the data into the Data Mart
Client:Confidential, Torrance, CA
Project: Auction site EzBid Conversion of Auction Site from Page Scripts to jsp

Confidential, MI, March 1999 – April 2000
US based consulting company provide consulting services to various clients in North America
Role: Involved in gathering business requirements and designing Cognos Report applications. Analyzed business-reporting requirements and verified whether DW design supports reporting requirements. Involved in data structure design, data conversion in batch run mode and in-house consultation and requirement analysis.

Confidential,Sep 97- Jan 1999
Summary: Federal Bureau of Statistics deals with Socio-economic surveys (i.e. Population Census, Agricultural Census, and livestock census)
Role:Analyzed the data collected by survey team, defined input and outputs of the system. As an integral member of the execution of the various socio-economic surveys such as (Population Census, Agricultural Census, Live Stock Census, Farm machinery Census etc) Conduct by UNO contributed to the design, development, and implementation and testing of data integration work. Involved in all aspects (i.e. Data entry, Data Validation, data mining, Reporting).Created reports and reporting environments for data from legacy applications. Design and development experience of data migration (from vax-6000-310 mainframe flat files into oracle database by using SQL*loader), data synchronization and data consolidation. Managed Backup using tape unit TA79 and Optical disk drive RV20

Education

Master of Administrative Sciences
Management Information System (MIS)