Project Sales
Resume:
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:
************@*****.***
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