Sandip Chandrakant Kaskar

B.E (Information Technology)

Address:

B8-304,

Park Infinia, Bhekrai Nagar

Contact:

(M) +91-702*******

(M) +91-702*******

Near SP Infocity, Dist: Haveli,

Pune, Maharashtra, 412308

Email Address:

acttfc@r.postjobfree.com

Professional Summary

Over 9.5 years of experience in the area of datawarehousing and reporting applications. Also involved in implementation of proof of concepts for prospective clients.

●Core expertise in Oracle 9i/10g/11g.

●Extensive experience in Axiom Controller View 7.1.1/8.1.1/9.7.2

●Experience in UNIX shell scripting.

●Overall 3+ years in financial services industry with broad experience in Investment banking companies including Barclays Bank, Credit-Suisse.

●Extensive experience in regulatory reporting.

●Extensive experience in Business Objects XI – Desktop Intelligence and Designer Tool.

●Extensive experience in Actuate e-Reporting Designing/Administration and has experience of migration of Actuate 7 to 9.

●Proficient in designing relational database model and implementation as per business requirements.

●Experience in SDLC development projects.

●Ability to work independently in a team and lead a team. Working as a Associate Project Manager leading a team of 18 members in current project.

●Excellent Inter-personal and communication skills gained through interaction with technical and Business Teams with various clients.

Technical & Functional Skills

Key Skills:

Requirement gathering, Application Development, Project Management, Test Planning and Execution, Data Analysis, Defect Management, Quality Assurance, Migration, Methodologies: Agile

Industries:

Investment banking, Media and Publishing

Languages:

SQL, PL/SQL, Shell Scripting

Databases:

Oracle 9i/10g/11g, MS Access

Tools:

Toad for Oracle, AXIOM Controller View, Actuate e-report Designer 7/9 and Business Objects XI, Informatica Powercenter 8/9.1

Platforms:

UNIX AIX 5, Windows XP & 2000, Mac OS

Other Tools:

Microsoft Project Planning, Microsoft Visio, Microsoft Office, Microsoft Visual SourceSafe

Trainings & Certifications

●Oracle Certified Associate

●Actuate Certified Professional

●AXIOM Certified Professional

Professional Experience

1.Cognizant Technology Solutions

Client Overview:

Barclays is a British multinational banking and financial services company headquartered in London. It is a universal bank with operations in retail, wholesale and investment banking, as well as wealth management, mortgage lending and credit cards. It has operations in over 50 countries and territories and has around 48 million customers.

MAJOR PROJECT DETAILS

AXIOM US Group - Regulatory reporting

Project Overview:

AXIOM US Group is the regulatory reporting project of Barclays, which provides investment banking, securities services, wealth management and asset management in India to Indian corporate as well as to multi-national companies looking to build their presence in the Indian market.

The project is being executed as per Cognizant’s onsite-offsite model. Herein the COGNIZANT New York onsite team will be responsible for the primary support during US working hours and the offshore team shall be doing the off-office hour’s support, development and maintenance.

This project involves designing, development and implementation of complete suite of regulatory reports on top of data warehousing model at the backend. Thousands of users like regulators are the recipient of these reports.

Responsibilities

Creating designs based on functional requirement provided by client

Coding required components in AXIOM like data source, portfolio, aggregation, tabular reports, freeform reports, shorthand, data model, calendar, workflow etc.

Worked as Developer, Developer Lead, and Solution Designer for Finance and Operations Regulatory Reporting.

AXIOM Controller View Application Designing, Technology end to end implementation, Team mentoring, Delivery planning.

Active Interaction with Business Users, Regulators, External Vendors and Internal Infrastructure.

Liaising in end to end SDLC. (Requirement Gathering, Planning, Development, SIT/UAT, User Sign-off, Release Management and Production Support).

Defining end to end Technical Architecture for regulatory reporting application using AXIOM Controller View.

Interacting with business users for requirement understanding, SIT/UAT verification, and production deployment and regularly verifying production reports.

Development effort estimation. High level and Low level design diagram.

Mentoring and guiding team in their implementation cycle of developing regulatory reports using AXIOM, Java, UNIX, Shell Scripting, AUTOSYS

Developing reports using AXIOM objects i.e. DataSource, DataModel, ModifyModel, Portfolio, Aggregation, Shorthand, Tabular Report, Freeform Report, and Enterprise Calendar.

Helping Report Analyst in Straight Adjustment, Complex Adjustments, Validation Clearance, etc.

Handling of SDLC throughout requirement, estimation, implementing, testing, and deployment.

Developing AUTOSYS scheduler for automation; UNIX scripts for file validations, Workflow execution.

Resource assignation and hiring at offshore

Involvement with Client and Business to grab new project for COGNIZANT

Encourage client to adopt latest technologies in on-going project

Onsite – offshore resource rotation

Generate Project status report and customer satisfaction report, share the same with COGNIZANT and Client

Extensive experience in developing of PL-SQL scripts – procedures, View’s, Functions, Packages.

Extensive experience in developing of shell scripts in UNIX.

Environment

Oracle 10g/11g

AIX Unix 5.2/5.3

AXIOM Controller View version 9.7.2

AUTOSYS

Major Projects

AXIOM upgrade from 8.1 to 9.7.2

Location

Offshore (Hinjewadi, Pune)

Team Size

15

Duration

6 Months (June 2015 – till date)

2.Wipro Technologies (April 2014 – June 2015)

Client Overview:

Credit Suisse Group AG is a Switzerland-based multinational financial services holding company headquartered in Zürich that operates the Credit Suisse Bank and other financial services investments. The company is organized as a stock corporation with four divisions: Investment Banking, Private Banking, Asset Management, and a Shared Services Group that provides marketing and support to the other three divisions.

MAJOR PROJECT DETAILS

AXIOM US Group - Regulatory reporting

Project Overview:

AXIOM US Group is the data warehousing project of Credit Suisse Group, which provides investment banking, securities services, wealth management and asset management in India to Indian corporate as well as to multi-national companies looking to build their presence in the Indian market.

The project is being executed as per WIPRO’s onsite-offsite model. Herein the WIPRO Singapore onsite team will be responsible for the primary support during US working hours and the offshore team shall be doing the off-office hour’s support, development and maintenance.

This project involves designing, development and implementation of complete suite of regulatory reports on top of data warehousing model at the backend. Thousands of users like regulators are the recipient of these reports.

Responsibilities

Creating designs based on functional requirement provided by client

Coding required components in AXIOM like data source, portfolio, aggregation, tabular reports, freeform reports, shorthand, data model, calendar, workflow etc.

Resource assignation and hiring at offshore

Involvement with Client and Business to grab new project for WIPRO

Encourage client to adopt latest technologies in on-going project

Onsite – offshore resource rotation

Generate Project status report and customer satisfaction report, share the same with WIPRO and Client

Extensive experience in developing of PL-SQL scripts – procedures, View’s, Functions, Packages.

Extensive experience in developing of shell scripts in UNIX.

Environment

Oracle 10g/11g

AIX Unix 5.2/5.3

AXIOM Controller View version 8.1.1/9.7.2

Designation

Technical Lead and Offshore coordinator

Location

Offshore (Hinjewadi, Pune)

Team Size

14

Duration

1 Year and 2 Months (April 2014 – June 2015)

3.HCL Technologies/HCL America (June 2006 – March 2014)

Client Overview:

Pearson is an international media company with world-leading businesses in education, business information and consumer publishing. With 37,000 employees based in more than 60 countries, Pearson aim to serve the citizens of our brain-based economy wherever and whenever they are learning - old or young, at home or school or work, in any pursuit, anywhere. Pearson has consolidated its business under 3 key businesses, that is Education Business under Pearson Education; Business Information under Financial Times and Consumer Publishing business under Penguin. Pearson is listed on the London and New York stock exchanges.

Team overview:

Business Intelligence Group is the data warehousing project of Pearson Technology Group (PTG), which is the nerve centre for storing and making that critical and sensitive business data visible to various business users. This critical and sensitive data is received from various publishing groups within Pearson Education (PE). Using data warehousing technologies, it is then cleansed and transformed for consistency based on various business rules incorporated and distributed to different downstream applications (“Data Marts”), which are logical subsets of the complete data warehouse. End users refer to these applications and derive insightful information for their analytical needs though advanced analytical reporting tools.

The project is being executed as per HCL’s onsite-offsite model. Herein the HCL onsite team will be responsible for the primary support during US working hours and the offshore team shall be doing the off-office hour’s support, development and maintenance.

This project involves designing, development and implementation of complete suite of business objects reports on top of datawarehousing model at the backend. Thousands of users are the recipient of these reports and has access to reproduce this information on ad-hoc reports by their own to validate the results using business objects universe.

MAJOR PROJECT DETAILS

Business Intelligence Group – Implementation of Global DataMart

Project Overview:

Global Data Mart (GDM) is a core application used to process the sales for all titles sold by Pearson’s 26 subsidiaries around the world (except sales of titles sold by Pearson’s US subsidiary). GDM enables business users from subsidiaries, International corporate, International finance and Sales functions to analyze and monitor indigenous and derivative title sales. Sales data for US and Canada titles from GDM is then fed to the International Data Mart (IDM). IDM processes this data and in turn feeds it to a Royalty System (used by US royalty department) in the form of electronic files, which uses this data for calculation of royalty-payout to authors.

GDM application uses Oracle as the back-end. At the front-end, it uses a web application created in VB/ASP. This is used by subsidiaries to upload their respective Sales, Title and Bill of Material (BOM) data. It is also utilized by business users for processing of records lying in suspense.

Responsibilities

Meeting with client at onsite.

Onsite – Offshore co-ordination

Client billing and project margin/cost reporting

Resource assignation and hiring at onshore

Involvement with Client and Business to grab new project for HCL

Encourage client to adopt latest technologies in ongoing project

Onsite – offshore resource rotation

Generate Project status report and customer satisfaction report, share the same with HCL and Client

Extensive experience in developing of PL-SQL scripts – procedures, View’s, Functions, Packages.

Extensive experience in developing Business Objects Universe and reports.

Extensive experience in developing of shell scripts in UNIX.

Hands on experience in Informatica Powerceter Designer

Following the Polaris Documentation for regular QMF tickets.

Doing weekly internal audit for SOX adherence as defined by the client.

Environment

Oracle 10g/11g

AIX Unix 5.2/5.3

Business Objects XI/XIR2

Designation

Associate Project Manager, Technical Lead and Onsite/Offshore coordinator

Location

Onshore (New Jersey, USA)

Team Size

18

Duration

1 Year 7 Months (April 2012 – till date)

Business Intelligence Group - Analytic Reporting on Corporate Data Warehousing and Canned Report Creation

Project Overview:

The Clinical Assessment business unit needs to have sales revenue query and reporting within the Corporate Data warehouse/Business Objects tool NOT tied to the specific invoice transaction, as currently configured. Regions and territories for tracking CA Sales revenue needs to be defined on the day of query by region and territory, defined by geographic parameters (state, counties within a state, group of states and/or counties of a state, etc.)

With this project using Business Objects tool, CA business unit wants to establish and maintain in CDW Sales Territory/Sales Personnel structure to allow Business self-service reporting. Such structure will also be used as a backbone for prebuilt (canned) reporting suite.

Responsibilities

Extensive experience in developing of PL-SQL scripts – procedures, View’s, Functions, Packages.

Extensive experience in developing Business Objects Universe and reports.

Extensive experience in developing of shell scripts in UNIX.

Using remedy tool for Change Management (CMC).

Monitoring of Daily/Weekly/Monthly Unix jobs and provided quick fix in case of failures.

Following the Polaris Documentation for regular QMF tickets.

Doing weekly internal audit for SOX adherence as defined by the client.

Environment

Oracle 9i/10g/11g

AIX Unix 5.1/5.2

Business Objects XI

Designation

Lead Engineer, Technical Lead and Onsite/Offshore coordinator

Location

Offshore (Noida, India)

Team Size

8

Duration

1 Year 5 Months (Oct 2010 – Mar 2012)

Proof of Concept for Migration of Actuate Reports to Business Objects Reports

Aim was to replace Actuate reports with Business Objects reports as Actuate license fee was too higher than Business Objects. Challenge here was to replace everything without touching existing functionality as well as look & feel of thousands of Actuate reports which business is familiar from last 5 years.

Responsibilities

• Gather all technical details regarding these two different reporting tools.

• Creation of Demo reports to check the feasibility to achieve the target

• Providing the estimates and resource requirement

• Demonstration of PoC to the client.

Environment

Actuate e-Report Designer, Business Objects XI, Oracle 9i

Designation

Lead Engineer

Location

Onshore (New Jersey, USA)

Team Size

3

Duration

3 months (July 2010 – Sep 2010)

Business Intelligence Group – Operational Support to application called Corporate DataWarehouse and Kinder Garden to 12 Datamart (CDW and K12DM)

Project Overview:

Corporate Data Warehouse (CDW) is primarily used as an operational data store which transforms data and feed to downstream systems. CDW is the central distribution point for all SAP 5.1 data. The other sources for CDW data is from PEUOPS, STAR & MDR. It contains data related to Customer, Product, Orders, Billing and Purchase Orders. All the transformations are done on CDW in order to achieve consistency. Transformed data is then fed to downstream systems.

Key Features:

●Gets periodical (daily, weekly, monthly, quarterly, bi-annually) data from SAP (Products, Customer, Inventory, Billing, Orders, Purchase Requests and Purchase Orders for K12 products), MDR (demographic data from Market Data Research), STAR (Sales Territory Assignment and Reassignment) and PEUOPS (Sales, Billing, Product, Territory Assignment, Cross Claims and Unshipped Titles)

●The data is summarized at various levels to support the business community (downstream feeds).

●CDW serves as the data source for Actuate reports used by the Sales force and business community.

Responsibilities

Handling the daily activities, as user reports a problem, I do the quick analysis and if it seems an issue, open a tracker - Interact with customer for input for replicating the problem.

Coordination with cross team.

After fix of the issue, testing of the issue and its impact on existing functionality.

Point of contact for any change in the production. Handling change management.

Environment

Oracle 9i

Actuate9 E-report Designer

AIX Unix 5.1/5.2

Business Objects XI

Designation

Software Engineer, Lead Engineer

Team size

9

Location

Offshore (Noida, India) / Onsite (New Jersey, USA)

Duration

4 Years (June 2006 – June 2010)

OTHER WORK DETAILS

Business Intelligence Group – Migration and Upgrade Activities

Project Overview:

1.Involved in Oracle 9i to 10g Upgrade

2.Extensive experience in Actuate upgrade from 7 to 9 and then 9 to 11

3.Extensive experience in Informatica Upgrade from 8 to 9.1

4.Extensive experience in migration of oracle database 11gR2 from native machine to cloud machine.

Responsibilities

Check for latest upgrades available in Market and encourage client to upgrade to the latest version

Learn new features introduced in newly upgraded version

Meeting with DBA, Software Support team to understand the process and benefits of upgrade

Touch base with Software team to get the licensing done and software purchase for client

Setup the development environment to install new upgraded software or for migration

Install the software in development environment

Replicate production environment

Perform the all kinds of testing

Share the daily results with Client

Raise issues with Software support team if there are any bugs/problems

Perform the upgrade in production

Compare the performance and share stats with client

Use newly added features in production environment

Environment

Oracle 9i/10g/11g

AIX Unix 5.2

Informatica Powercenter 8/9.1

Actuate e-report designer 7/9/11

Designation

Technical Lead, Associate Project Manager

Team size

2

Duration

9 Months (Runs in parallel during Project lifecycle)

Educational Qualifications

Exam/ Degree

Board /University

Institute

Year of Passing

Bachelor Of Engineering in Information Technology

Shivaji University

Walchand College of Engineering, Sangli, Maharashtra

2006

Diploma in Computer Technology

Mumbai University

Shreeram Polytechnic, Airoli, Navi Mumbai, Maharashtra

2003

Secondary

Mumbai University

Prakalpa Vidyalaya, Bhatsanagar, Thane, Maharashtra

2000

Personal Details

Birth Date : 26th Sep, 1984

Languages Known : English, Hindi and Marathi

Preferred Location : Pune, India and anywhere outside India

Passport Details

Name : Sandip Chandrakant Kaskar

Passport : Available

Visa details : Travelled twice on L1-B to USA and currently in India with H1B (Expired on Oct 2014 but in cap since utilized only for 2.5 years) and valid B1 VISA

Contact this candidate