Developer Data

Yogesh Shinde Flat No. B-***, Kool Homes, Behind

Maratha Mandir, Near Chandani Chowk,

Bavdhan, Pune, Maharashtra - 411021.

adcxsk@r.postjobfree.com / LinkedIn Mobile:+91-959*******/986******* Professional Synopsis

16+ years of experience in Software Development with technical expertise in Front-End (UI), Database as well as Reports.

Expertise in SQL Server (2000/2008-R2/2016), TSQL, SSIS, SSRS, Crystal Reports (8.5), VB6.0, MS-Access (97/2000), VSS, TFS, SVN. Knowledge of C#, VB.Net.

Knowledge of Data Analysis using R, Excel, SQL, PowerBI & Tableau.

Worked on all phases of the software life cycle, Product Implementation as well as Production Support.

Highly motivated and enthusiastic team player with the ability to communicate effectively at all levels of the organization.

Strong Problem Solving & Technical Skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs.

Expertise in Banking and Financial, Property & Asset Management and Hotel Management domain.

Experience in working with large systems that are complex and data-intense.

Expertise in Performance Tuning and Optimization of databases.

Worked with Business Analyst, QA Analyst, Build Masters, Release Engineers, DBA, and other team members to resolve defects.

Excellent Verbal and Written communication skills.

The Experience of Leading a Team of 6 members.

Knowledge of Azure SQL Database.

Had been to onsite –USA – 2010/2013/2016. Australia – 2019. Technical Skills

Databases SQL Server (2000/2008-R2/2016), MS-Access (97/2000). ETL Tools DTS, SSIS.

Analytic Tools R, Excel.

Front-End VB6.0, C#, VB.Net.

Internet Technologies COM.

Languages T-SQL.

Report Tools Crystal Reports (8.5), SSRS.

Web technologies ASP.Net 3.5.

Educational Details

B.E. Mechanical with first class from Walchand Government College of Engineering, Sangli, Shivaji University, Kolhapur, Maharashtra, India.

Organizational Strengths

Very strong understanding of the complete Software Development Life Cycle (SDLC) and Project Processes & Tools maintaining coding standards.

Coordination with onsite coordinators.

An effective communicator with honed people management, interpersonal, analytical, relationship management and problem-solving skills.

Insightful knowledge of business process analysis, performance measurement, and quality.

Maintaining different build versions of the software product, and ensuring smooth deployments on the development, staging and production environments.

Highly motivated and enthusiastic team player with the ability to communicate effectively at all levels of the organization.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs. Projects Handled (In reverse chronological order)

Project Name

Client

YARDI – VOYAGER.

Goodman(Australia).

Organization Assetsoft Consulting Pvt Ltd., Pune, Maharashtra, India. www.Assetsoft.biz Position Sr. Technical Consultant.

Synopsis Primarily, this is a web-based Property Management Product developed for US and Europe clients including Residential, Affordable, Tax-Credit, Commercial, Office, Industrial, Retail, Military and other types of properties. Voyager includes over 100 standard reports, accompanied by a variety of flexible reporting options with automatic drill-down from summary reports to the underlying detail. Reports can be automatically exported to Word, Excel, HTML or RTF with a single click of the mouse.

Technology

Used

Back End: SQL-Server 2014, TSQL. TFS. Reporting Tool: SSRS. Analytic Tools: R & Excel.

Domain Property Management.

Role Played

Performance improvement of the Portfolio Analytics Report.

Mentoring team members for SSRS & Queries.

Data Modelling(ER Diagram) for Database.

Data Science POC - Designing Churn Model.

Duration Jun 2019 – Till Date Team Size 8

Project Name

Client

VIRTUOX

VirtuOx(The world’s largest home diagnostic provider) Organization LogicalDNA, Pune, Maharashtra, India. www.LogicalDNA.com Position Database Specialist

Synopsis VirtuOx, Inc. is a privately held medical technology services company that provides diagnostic tools and services that enable a variety of healthcare organizations and professionals in diagnosing and treating Respiratory diseases through vertically integrated platforms, products, and services. VirtuOx platforms include a Medicare-approved Joint Commission Approved Independent Diagnostic Testing Facility (IDTF) that assists in the diagnosis and qualification of treatment options for Sleep Disorder Breathing and Respiratory Diseases at the home. Technology

Used

Front End: C#. Back End: SQL-Server 2016, TSQL. SVN. Reporting Tool: SSRS. Analytic Tools: R & Excel.

Domain Health Care.

Role Played

Analyzing the Data to find out patterns, trends.

Played an important role in implementing new SSRS Reports for new requirements as well as modifying existing SSRS Reports.

Analyzing the queries and optimizing those to boost the performance.

Performing Database activities like Index Rebuild, Back-up, and Restoring Back-up.

Duration Sep 2017 – Mar 2019 Team Size 7

Project Name PHOENIX

Organization HerbaLife, Bengaluru, Karnataka, India. www.HerbaLife.com Position Sr. SQL Developer

Synopsis Phoenix system calculates and processes distributor compensation, taxes and payments as per the marketing plan and local statutory requirements. Its core activities are calculating monthly Royalty and Production Bonus and issuing Payments on-time. All the Discounts, Commissions, Production Bonus, Volume Points, Royalty Override are calculated / Validated in this system. Technology

Used

Front End: C#. Back End: SQL-Server 2008-R2, TSQL. Vault & TFS. ETL: SSIS. Reporting Tool: Crystal Report & SSRS.

Domain Health Care / MLM.

Role Played

Played a crucial role in implementing changes suggested by the Federal Trade Commission (FTC) within a short span of time.

Handled monthly Royalty Override (RO) Process and provided Prod support.

Developed new reports in SSRS /converted Existing Crystal Reports into SSRS. Developed/Modified Crystal reports as per requirement.

Developed / Modified Stored-Procedures required for resolving Production Issues. Performance Tuning, Query Optimization.

Duration Feb 2013 – Apr 2017 Team Size 12

Project Name CAPITAL MARKET – COSTBASIS.

Client JPMC, Wells Fargo, UBS, Credit Agricole, FirstTrust, OptionExpresss, TradeStation, David Lerner, Ameriprise, MF, USBI.

Organization SunGard (now part of FIS), Pune, Maharashtra, India. www.SunGard.com Position Specialist - Product Development.

Product

Synopsis

Cost Basis is a robust tax lot accounting engine that provides systematic calculations of both realized and unrealized gain loss information; and Compliance Plus, a tax reporting information service from Stream Wall Street Concepts

(formerly known as Wall Street Concepts).

This highly scalable solution offers automatic processing of cost basis calculations, including corporate actions and exercises, and wash sales, which are processed in either real-time or in an overnight batch process. Technology

Used

Front End: C#. Back End: SQL-Server2008-R2, TSQL. Visual Source Safe (VSS) Subversion Client (SVN). ETL: SSIS. Reporting Tool: SSRS. Domain Finance

Role Played

Played a crucial role while implementing IRS Regulation (1099B Reports).

Leading a team, Guiding & mentoring newly joined resources and helping them to resolve their functional/technical queries.

Communicating with BU regarding queries/updates.

Worked on crucial Production Issues and giving an estimation for those issues.

Developed/modified Stored-Procedures required for resolving Production Issues. Performance Tuning, Query Optimization, Resolving Dead-Locks. Duration Jan 2010 – Feb 2013 Team Size 12

Organizations

From Date To Date Organization Designation

11-Jun-2019 Till Date

Assetsoft Consulting Pvt Ltd., Pune,

Maharashtra, India

www.Assetsoft.biz

Sr. Technical

Consultant

06-Sep-2017 01-Mar-2019

LogicalDNA, Pune, Maharashtra, India

www.LogicalDNA.com

Database Specialist

11-Feb-2013 13-Apr-2017

HerbaLife, Bengaluru, Karnataka, India

www.HerbaLife.com

Sr. SQL Developer

11-May-2006 06-Feb-2013

SunGard(now part of FIS), Pune,

Maharashtra, India

www.SunGard.com

Specialist

15-Sep-2005 09-May-2006

Yardi Software India Pvt Ltd, Pune,

Maharashtra, India

www.Yardi.com

Programmer

01-Jun-2004 09-Sep-2005

Manorama Software, Kolhapur,

Maharashtra, India

www.ManoramaSoft.com

Software Developer

01-Oct-2003 31-May-2004

Nexus, Kolhapur, Maharashtra, India

www.NexusInfosys.co.in

VB 6.0 Programmer

01-Oct-2002 29-Sep-2003

Drishti~Cone, Kolhapur, Maharashtra,

India

Software Professional

Personal Profile

Date of Birth 25th October 1978.

Material Status and Gender Married, Male.

Languages Known English, Hindi, Marathi.

Passport

Visa

U0036160 (Till Oct-2029)

US: B1-B2 (Till 10-Feb-2020).

AU: Business(600) (Till Nov 2020)

Alternate Contact No.(Spouse) +91-990**-***** / +91-911**-*****. GitHub Profile https://github.com/ShindeYog

Project Name ADAPTIV DATA-MIGRATION

Client ABN AMRO Bank

Organization SunGard (now part of FIS), Pune, Maharashtra, India. www.SunGard.com Position Senior Software Engineer

Product

Synopsis

Adaptiv is a real-time, 24/7 credit risk management and control solution for global banks, covering both the Trading and Wholesale banking books used to make business-critical decisions. Adaptiv is a business tool that meets the regulatory needs for risk management and reporting today. Role Played

Developed Views / Stored-Procedures / Functions required for importing the data from the existing system as per Rules were given by ABN-AMRO Bank.

Developed Migration scripts to implement business logic to import for CTK to Adaptiv, testing scripts by applying many test cases to check the migrated data into Adaptiv and reconciliation scripts.

Ensured data mapping from an existing system to new, thus ensuring nothing is missed out and ensured that default values for additional columns are set.

Involved in various activities like data cleansing, client review & dry run.

Created Delivery documents such as migration report, supporting files, etc. sent to the bank after each migration

Duration Aug 2006 – Sep 2007 Team Size 3

Contact this candidate