Amit Kumar Singh 484-***-****

ac0sda@r.postjobfree.com

PROFESSIONAL SUMMARY

Approx. 5 years of combined experience in IT industry using various Microsoft Technologies and Third Party Products which include design, architecture, development of Web and Windows applications.

Worked extensively on Crystal Reports and SSRS in creating new reports and maintaining the existing ones.

Experience in writing complex SQL queries and Database Programming (Stored procedures, Triggers, PL/SQL) using SQL Server 2008/2014.

Worked on various phases of Software Development Life Cycle (SDLC) such as Requirement Analysis, Design, Coding, Testing, Production Support and Documentation.

Handy experience in migration process across different environments [Dev/UAT/Prod].

Resolved the performance issues in many reports that have complex SQL queries, Procedures by using various tuning and optimizing tips.

Used SQL Profiler and Index Tuning Wizard for tracing slow running queries.

Development of custom scripts and stored procedures for data import and manipulation.

Performed Debugging on the Stored procedures for the requirement to handle the errors.

Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.

Extensively trained and experienced in Integrating, Financial Accounting Reporting Solutions with SunGard’s Investier and Investran.

Have knowledge of Web Services and WCF.

The responsibilities I have undertaken also include, understanding of client requirements, design documents, develop proposals/solutions, maintain and document code by using industry’s best version control software’s, prepare and maintain technical documents for client deliverables and uploading enhancements on production server.

TECHNICAL SKILLS

Primary Skills

C#.Net, Crystal Report 8.5/10, SSRS/SSIS 2008, Microsoft .Net Framework 3.5, ASP.Net, Web Services, SQL Server 2005/2008,SunGard Investier/Investran

Languages

C#/VB/ASP .Net, Visual Basic 6.0

Development Tools

SunGard Investran, Visual Studio .Net 2005/2008, Visual Studio 6.0, Visual Studio Team System 2008, Report 8.5/10, SSRS 2008

Scripts

VBScript, PowerShell Scripts, Dos Batch script.

Database Connectivity

SunGard Investran OLEBD, ADO.Net, SQL OLEDB,ODBC

Databases

MS SQL Server 2005/2008, MySQL, MS Access

Configuration Tools

VSS, SVN,GIT

Legacy Systems

Job scheduler (CA Scheduler, Active Batch)

Networking

VPN Client, FTP/SFTP

Documentation

JIRA, Confluence, Microsoft Visio

PROFESSIONAL EXPERIENCE

NTT DATA Global Delivery Services Ltd. Sep' 13 – Current

Client: SEI Investments, Oaks PA

Project: Hedge Client Custom (HCC)

Sr. Developer

Description: SEIC is a global provider of asset management, investment processing, and investment operations solutions.

Hedge Client Custom (HCC) develops custom reporting solutions for SEI’s Global Fund Management for Investors.

Hedge Client Custom (HCC) reporting solutions were integrated on Hedge Portal (HOP), is an operations portal for Hedge business line, it has three main subsystems that collect data, workflow for fund accountants and data distribution.

Hedge Client Custom (HCC) reporting solutions are developed over underline SUNGARD’s proprietary solutions, INVESTIER and INVESTRAN.Hedge Client Custom (HCC) is scalable to thousands of investors, and virtually any customer type, including both onshore and offshore hedge funds and fund of funds, investor allocations and calculations, and both fund and investor reporting, helping to reduce cost and operational risk associated with manual processing.

Responsibilities:

●Analyzing, coding, testing, and assisting with user acceptance testing, production implementation and system support for the HOP Application.

●Analysis, Design, Development of modules for custom Accounting reporting solutions.

●Integrating NTTDATA’s Custom reporting solutions with SunGard’s reporting solutions/databases.

●Documenting requirements and defects/changes.

●Preparing PoC’s for new modules and enhancements.

●Analysis of requirements and design of modules.

●Enhancement and customization of the Hedge Client Custom (HCC) reporting solutions.

●Design Graphical User Interfaces (GUI) for Hedge Client Custom (HCC).

●Develop scripts to automate the build and deployment process of the Hedge Client Custom (HCC) reporting solutions. The scripts will be customized for Investors/Clients Databases/Data Warehouses.

●Document the Data Dictionary and Screen-Level Data Mapping for new module additions to the Hedge Client Custom (HCC).

●Discuss with the business team to clarify the requirements to get clarity of certain business functionalities.

●Deployment of the code in UAT environment to run through Hedge Portal.

●Deployment and configuration of the code in the ECR application.

●Perform defect fixing for the Production Issues raised by the business Users.

●Assistance to business users while performing UAT/PROD testing.

●Coordinating with offshore team on daily basis and help understand the business requirements.

●Manage the issues raised from QA and work with them to resolve the issue.

●Technical activity includes developing code in C#, Asp.NET and SQL Server database (2008, 2012), SSRS, SSIS, Crystal Report.

●Perform code and design reviews and defect monitoring to ensure that the deliverables adhere to the project guidelines and specifications.

Environment: SunGard Investier/ Investran, C#.Net, SQL Server 2005/2008/2014, Crystal Report 8.5/10, SSRS/SSIS 2008, VS 2005/2008, .Net Framework 3.5.

NTT DATA Global Delivery Services Ltd. Dec' 12 – Oct' 13

Client: SEI Investments, Oaks PA

Project: Corporate Technology Services (CTS)

Developer

Description: Corporate Technology Services is the core project of SEI that automates and enhances business related processes which are being carried out by private banks, investment advisors, investment managers, institutional investors and affluent individuals to create and manage wealth systems.

Responsibilities:

●Create, enhance, and monitor IT automated processes/tasks using Mainframe CA-7 Scheduler.

●Building SSIS/DTS packages for loading, extracting and updating the portfolios, indexes and funds information for Private Banks and investment management units.

●Create and enhance VB script to automate window desktop tasks.

●Create and manage the FTP/SFTP accounts.

●Deploying and verifying crystal reports against UAT/PROD environment.

●Incident handling in case of production server outage, application failure and services breakdown.

●Confer with internal staff to assure smooth functioning and minimal downtime of newly implemented systems and/or procedures.

●Designing application architecture & writing technical design documents.

●Providing UAT/PROD support.

●Responsible for the enhancements in live UAT/PROD automation processes.

●Publishing departmental shift turnovers and morning health reports to all respective parties and management groups.

●Written documentation to describe program development, logic, coding, testing and changes made.

Environment: Visual Basic, CA 7, Active Batch v9,,SQL server, PL/SQL

EDUCATION

Sl. No.

Degree

Branch

Year of Passing

Name of the College / Institute

Name of the University

Percentage / cgpa / Grade

1

Bachelor of Technology (B-Tech)

Computer Science

2012

Quantum School of Technology

Uttarakhand Technical University

71.1%

2

12th

Science

2008

River Dale High School

ISC

80.8%

3

10th

Science

2006

River Dale High School

ICSE

81.3%

Contact this candidate