Niteen Shendye

acx3oj@r.postjobfree.com

508-***-****

Summary: With 19+ years of experience in developing a practical roadmap for an enterprise-wide BI/Data architecture and analytics platform on Unix/Mainframe/Windows. Expertise building state of the art databases with large data with a quick rending, multi-dimensional attributes, ETL, matrix and filters. Expertise in developing Healthcare (medical records, pharmacy/ hospital/ provider/ dental claims processing, NPI data, FDB/Medi-Span drug database, census) and Finance (Fund Accounting, Corporate actions, Order entry, Pricing Funds, Trade interfaces, Stock plan services, Unitised accounting) databses. Involved in defining the overall data architecture, including ETL processes, ODS, EDW and data marts. Collaborated with key business users to identify needs and opportunities for improved data management and delivery. Designed and developed state of the art J2EE/Python web systems showing Dashboards, KPIs, Trends, Graphs, Maps to understand the complex information with ease. Also developed web services to implement APIs. Involved in developing complex compliance reports for CMS that helps business users track the errors and report all the non-compliant data in a simplest way.

Involved in distributing documents, reports with security that prevented users from viewing unauthorized data. Proficient with client/server, J2EE, UNIX, mainframe and web development. Expertise in the project management, architecture, analysis, design, and development of secured, multilingual transactional and business intelligence software systems. Have completed Software Development Life Cycle & RDBMS Design & implementations.

Technical Environment

Databases: Oracle (15+ yrs), DB2 (12+ yrs), Sybase (5+ yrs), SQL server (12+ yrs), MySQL (2 yrs), AWS,

MongoDB

Data modeling tools: Embarcadero ER-Studio, Erwin

Operating Systems: Unix, Linux, Mainframe, Windows

Statistics: R

ETL: Informatica, SSIS, MQ

BI/Reporting tools: Tableau, Business Objects, Crystal Report, Excel, Brio, Actuate

Languages: Java/J2EE, .net, C++, Power Builder, Perl, Python, shell scrip

Frame work: SPRING, Struts2, Boot Strap

Technology: Middleware messaging products, MQ Series, SWIFT network

Platforms: Windows, Sun/Solaris, AIX, OS390

Project Management Tools

MS Projects, Visio, Excel

Professional Skills

- Project Management for complete System and BI Development Life Cycle

- Design BIG data warehouses (upto billion rows) with a performance tuning

- Prototype design alternatives

- Data transfer using Informatica, ODI, SSRS, MQ

- Participation in proposal development

- Installation, configuring, and performance tuning

- Involved with building APIs using SOA

- Report development and management for finance, healthcare in various sectors.

- Expert in building Web applications using J2EE/Stuts 2/SPRING/Boot Strap 2/.net/Jason/Jquery/Python

- Integration of applications from various platforms while ensuring integrity of architecture and design

- Project customization

- Manage technical expectations of customer

- Troubleshooting and support at client site

- Database tuning

- Migration from older version to the latest version

- Platform migration from (NT to Unix, Mainframe to Mainframe, Mainframe to Unix, etc.)

- Develop and support applications

Professional Achievements

Developed many large databases include operational databases, end-user databases, distributed databases, analytical databases, relational databases, hierarchical databases and database models.

Built a Massachusetts Healthcare Explorer portal (J2EE) that shows trends, reports, and dashboards for various state agencies.

Designed, developed and distributed many Healthcare/financial reports to many clients/state agencies.

Invited at Elvis Presley Park in TN to speed up the ticketing process due to database glitch.

Fine-tuned hundreds of process to deliver output in seconds.

Finished various projects before deadlines and within budget.

Education

Master’s Degree in Computer Science

Employment

University of Massachusetts Medical School - Shrewsbury, MA 2010–Present

Senior BI Architect, Data Management Services

Involved in building databases for Pharmaceutical, hospitals, medical claims warehouses to render high speed results with Terabyte data that could be used to present BI analytics.

Designed large healthcare databases with 10-20 years of healthcare claims (Pharmacy, medical, provider, Medicaid) databases with supporting national providers, census, drugs, and diagnostic codes healthcare databases.

Managed real-time, daily, weekly, monthly, yearly ETL data transfer.

Designed Operational Data source (normalized) and Reporting databases (de-normalized) for easy and quick rendering.

Fine-tuned some database procedures to render output from hours to minutes.

Involved in getting requirements from various state agencies to develop state of the art databases/analytics.

Used embarcadero ER-Studio for the designing data models.

Collaborated with PhD statisticians and physicians to develop advanced BI reporting which identifies patients at increased risk for falls based on statistical analysis of integrated dataset combining elder care nursing assessments, Medicaid claims, and US Census datasets.

Reports alerts case managers’ at-risk patients’ just-in-time for nurses to modify care plans and interventions based on the specific risk(s) identified for a patient.

Using these databases many multi years trend reports built with 100+ million rows (in each report) showing multi-dimensional attributes, matrix and filters, with outstanding rendering performance. Using Tableau / Business Objects / SSRS developed hundreds of reports.

Responsible for driving the BI architecture decisions including reporting tools, databases, building J2EE portal with built in SSO features.

Singlehandedly built a Massachusetts state health care explorer web portal in J2EE/Bootsrap2/O-Auth SSO/Python that grants a secured access to hundreds of clients to view, download and compare hundreds of reports. This portal uses all the encryptions, unique token security that would prevent unauthorized users to view the data. Oracle, SQL Server and MySQL

AWS database experience with (prototype) MS Sql, MySQL, Oracle.

Worked on proof of concept using MongoDB JASON databases.

Database tuning to enhance the performance of the data processing and reporting time from hours to minutes.

Fidelity Investments Jan.-Dec. 2009

Involved in designing (Erwin), modifying and fine tuning databases for various financial systems. Worked on 24X7 environment that supports international clients.

Also developed many reporting databases that are used to produce thousands of complex reports to 350+ clients through www.Fidelity.com.

Developed a reconciliation process for Fidelity operations and involved in building state-of-the-art databases and reports to distribute it to the internal users to verify the data integrity.

Coordinated development of new processes (e.g. workflow; inputs/outputs; roles/responsibilities); Led test planning and process simulations of new processes to clarify role/gaps of new product functionality; Coordinate development policies and procedures required to support new processes/product.

Relationship Management: Identified and influenced stakeholders to obtain support for the solution. Facilitated resolution of issues related to the product development process.

Excellent knowledge of Stocks, Bonds, Equity Derivatives and online trading.

Wellington Management Feb.–Dec. 2008

Senior Consultant: Data Architect Developer, BI Reporting

Involved in modifying and maintaining the Oracle hierarchical database that was getting updated 24X7 using MQ Messaging.

Developed a reconciliation process that compares millions of rows in less than a minute to show any incorrect trading or pricing information. The results were stored on the database for further analysis and emailed the critical reconciliation information to the support group every hour. Also built various reports using PERL on Unix and distributed them via email.

Produced complex reports that could get client current/historical information. System received pricing, trading information via IBM MQ messages that updated the database to get an updated investment picture.

Supported business group in order to build various complex reports and maintain the home grown reporting tool.

Investment-View is a centralized database that gets updated 24/7 from all over the world(via MQ real-time messaging). This database stored all the real time information about the individual holdings, trading, pricing, corporate actions, complex derivative definitions. As this database is used by compliance, client reporting, data marts, Fixed income portfolio management/UMA tools; it is required to keep IV in sync with all other databases.

Involved in analyzing and building this state-of-the-art Fixed Income/UMA database (for any client) that holds information about the holding for various instruments such as: Equity, Bonds, Futures, Swaps E.G. Currency, Credit Default Cds/Cdx, Interest Rate, Convertible Bonds, Options, Repurchase Agreements, Mutual Funds, Currency Forwards, Futures E.D Index Futures, Currency Futures, Interest Rate Futures Currency Options and many more.

Client managed portfolio was maintained within relational and hierarchical structure that will show client its holdings with all type of investments including complex derivatives. System keeps historical information to print the monthly, quarterly, yearly and current position.

Unix Solaris, Oracle 10/11g, Perl, Shell scripting, ETL, MQ, JAVA/J2EE, Eclipse.

Fidelity Investments (Brokerage) 1998–2007

Consultant/Technical Architect

Involved in designing (Erwin), modifying and fine tuning databases for various financial systems. Worked on 24X7 environment that supports international clients. (Developing/maintaining ODS (Operational data source) and Reporting databases).

Also developed many reporting databases that are used to produce thousands of complex reports to 350+ clients through www.Fidelity.com.

Designed, developed and managed various ETL feeds using Informatica and ODI.

Developed a reconciliation process for Fidelity operations and involved in building state-of-the-art databases and reports to distribute it to the internal users to verify the data integrity.

Fine-tuned many old queries to run with quick rendering. (redesign database structure and tune)

Led the development of cross-practice/business requirements. Determined client and organizational needs, systems and operations requirements, customer rollout requirements, legal/compliance implications, etc.

Drove the definition, analysis and transformation of business processes across Defined Contribution, Defined Benefit and Health & Welfare to support web development programs

Coordinated development of new processes (e.g. workflow; inputs/outputs; roles/responsibilities); Led test planning and process simulations of new processes to clarify role/gaps of new product functionality; Coordinate development policies and procedures required to support new processes/product.

Relationship Management: Identified and influenced stakeholders to obtain support for the solution. Facilitated resolution of issues related to the product development process.

Project Management: Created and utilized project-planning tools to ensure timely completion of development projects with a high degree of quality. Prioritized tasks appropriately; communicated issues to project manager.

Provided product subject matter expertise to support development of sponsor and participant collateral, internal communications & training, etc.

Took leadership/coordination role in testing process in order to ensure business needs were met.

Acted as the key business partner in defining new processes, and clarifying role of new technology solutions.

Excellent knowledge of Stocks, Bonds, Equity Derivatives and online trading.

Handled team of 8

Worked extensively on various aspects on Mutual fund accounting with a thorough knowledge of:

Fund Accounting

Corporate actions

Order entry

Pricing Funds

Trade interfaces

Unitised accounting

NAV distribution

Real time Trade interface

Built a network to receive real time trade interface from advisors and updated in-house system using a messaging product.

Process SWIFT/ISITC formatted messages into Invest One input format

Improved Feed Tracking, Alerting mechanism and Reporting

Develop error Alerting and Tracking tools

Implemented a complete reporting architecture using Brio/Hyperion/Cognos by Oracle Corp.

This architecture allows fidelity external users to login to Fidelity network (www.fidelity.com) and view 6000+ daily and 2000+ monthly report.

This architecture allows external users to view the pre-processed daily reports whereas internal users can produce real time reports.

Worked extensively on improving the performance tuning to complete cycle in 1/3 rd time.

Save forms and surveys data electronically

CESG Marketing group receives various user feedbacks and other forms. Built a process that will scan the forms/surveys data. This data is stored on the DB2/Oracle which carries data error due to scanning. This process helps upper management to view/compare the user opinions.

SPARK (Front end: Java/Jsp/Servlet/Oracle Backend)

Worked on front end and back end for the CESG new online system SPARK.

Produced a News Announcement, Links and Documents a front screen for SPARK.

Built a backend process that reports field by field changes made by users within a Spark system.

Database Tuning (DB2/Oracle/SQL server)

Initiated performance tuning for many queries to reduce execution time. One of the queries was fine tuned from 3 hours to 1 minute.

Involved in the development and support CESG Reporting cycle that uses Brio as a web based publishing tool.

BNY Mellon (Westborough) 1993–1998

Transfer Agency: (3 years)

Transfer agents record changes of ownership, maintain the issuer's security holder records, cancel and issue certificates, and distribute dividends.

Fund Accounting:

Worked on Invest One a fund accounting development and support along with various surround technology software development for the following projects:

Pricing and support

Cash management

Trade interfaces

NAV distribution

Automatic Upload and Download data From Mainframe and PC: (C++, HLLAPI)

In 1993 when FTP was not available built a system using IBM emulation 3270 “Higher Level Language Application Programming”

This Would allow users to encrypt the passwords and set up the scripts to send or receive data from the desktop to host machine.

Designed and developed a product “User Notification System”: (VB, SQL Server)

This product will let any support group send real time messages to a pre-defined user groups for certain activity

This product was similar to messenger product in 1990’s within network.

Worked on various client server applications using Visual Basic and Power Builder.

General Electric 1990–1992

Developed an Electronic approval system which will electronically approve various documents, payroll information, Employee information, various requests and update the approved information on the core systems. (Windows/SQL Server/VB/DB2/IDMS)

PCS 1988–1990

Worked in the export zone for a large Aluminum company on the product management, inventory and cost management system.

Standard Chartered Bank 1987–1988

Designed and developed various banking projects.

Personal Projects 1986–1993

A screen editor was developed on the windows platform with all the features such as insert/delete words, lines, page up, down, find, replace, perform macro operations, up to 32K columns, special windows with word count, multiple find search.

A Devnagari editor was built with all the words with combination of vowel format and word alignment. A printer driver was developed to print the complex character combination.

Developed video games to express one’s imagination and challenge players to reach up to the highest level where they will maximize fun.

All the operating system operations such as Format, disk copy etc. In addition, worked on some interesting copy protection techniques to prevent uses to copy software.

Developed a scientific calculator on PC and then ported it on the Data General machine. This gives all the mathematical expressions with closing and opening brackets. This will show uses last 15 operations and can scroll up and down to change prior data. User can redo or undo all the operations.

Contact this candidate