PREM KUMAR MANI

Email: ac2fal@r.postjobfree.com Mobile: 651-***-****

Summary of Experience/Skills:

Overall 11+ years of experience in developing Enterprise Business Applications.

11+ years of experience in PowerBuilder development environment.

8+ years of experience in Oracle PL/SQL and T-SQL.

6+ Years in ETL using SSIS, Oracle SQL Loader and Informatica.

2+ years of experience in Microsoft .Net development environment.

Specialized in the implementation of client/server, database, Internet-based systems using Visual Studio .NET Suite, PowerBuilder.

Expertise in PowerBuilder Objects, DataWindow buffers, PowerBuilder events, Dynamic DataWindow creations, windows (types and events), External API, Webservice call, Files systems, Create Batch scheduler using PB, etc.

Have good knowledge in PowerBuilder migration.

Have web based enterprise application development experience using ASP.Net, VB .NET, MVC 4

Having good experience in developing reports using PowerBuilder Datawindow and SSRS.

Have hands-on experience in developing rules engine based applications.

Have good exposure in Data binding in .Net.

Have good exposure in MVC architecture, extensively used MVC in GUI.

Have good knowledge in Web Services.

Have good experience in Data Modeling.

Excellent backend skills in creating database objects like Tables, PL/SQL blocks, Stored Procedures, Views, Indexes, Triggers, SQL Loader, External tables, Defaults, user defined data types and functions.

Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan and Performance Monitor

Have good Knowledge in job schedulers like SQL Server Agent, OpCon Enterprise Manager and Unix Crontab job schedulers.

Have good experience in the SSIS migration.

Have good experience in Batch scripts and VBS scripts.

Handled high priority production issues, have ability to work under pressure and meet deadlines.

WORK EXPERIENCE

Working for Cognizant’s client Cargill Inc. as a Senior Developer from Nov 2016 to till date

Worked for Cognizant’s client 3M as Senior System Analyst from August 2010 to Nov 2016.

Worked as a Product developer in 3i-infotect Ltd from Nov 2006 to Aug 2010.

Worked for CTL as Application Maintenance Engineer from Dec 2005 to Nov 2006.

.

Technical Skills:

RDBMS:

Oracle 11G, Microsoft SQL server, Sybase ASE

Tools:

PowerBuilder, Oracle SQL Developer and MS Visual Studio

Reporting:

PowerBuilder Reporting (DataWindow) and SSRS.

Domain (Workflow):

Pricing, Mutual Fund (Investment Banking), Trading (Grain Commodities) and Payroll

Modeling Tool:

MS Visio 2013

Frame work

PFC and MVC 4

Job Scheduler

MS SQL Server Agent, OpCon Enterprise Manager, Unix Cron jobs.

Languages:

Power Script, VB, C#, Java, C++ and C.

Version Control:

VSS and TFS

Operating System:

Windows, UNIX

Project Management Tool:

Microsoft Project, IBM Clear quest.

Education

Masters - MCA Master of Computer Application from Anna University (2002 -2005)

Bachelors - BSC Computer Science, Madurai Kamarajar University (1999-2002)

Professional Experience

Cognizant Technology solutions

Senior Associate – Projects as Feb 2013 – Till date at Minneapolis Area, USA.

Client: 3M, Cargill

Project: Pricing and Trading (https://www.cognizant.com/)

Modules: 3M-Pricing (Item master, Pricing Maintenance, Merchandising, Contract Management), Cargill - Trading (Contract, scale, purchase and sale, Inventory, Finance, Advisor and Blending supply chain, and Testing)

Location: Chennai, India and Minneapolis, USA.

Cargill Inc. Project Description: (Nov 2016 – Till date)

Agrosoft is an application that automates Cargill's grain contracting and settlement process. This system is designed to help, improve both the efficiency in handling transactions and the speed of gathering and communicating data. Using Agrosoft, transactions can be automated from truck unload to the final settlement. The system has subsystems like Contracts, Operations and Financial Settlements

Responsibilities:

Taken ownership of Cargill’s Trading and ERP application that is used in more than 100 facilities across North America.

Understand the complete landscape of the application that includes more than 20 interfaces by participating in knowledge gathering sessions with SME’s and prepare a detailed AOD document.

Analyze historical tickets logged in Remedy and prepare a ticket volume metrics report which was used for staffing purposes.

Development, Production support and handling the work request for the application using PowerBuilder PFC Framework.

Development and Maintenance of the application using VB .NET and ASP .NET.

Development and Maintenance of the DB objects like procedures, Packages, Triggers, functions, etc using oracle PL/SQL.

Performing Data Analysis and Creating complex reports based on business user needs using datawidow.

Requirements analysis, estimation, coding, Production support issue analysis, enhancements, testing.

Responsible for managing / tracking the change requests coding, testing and deployment onto the Staging environment.

Responsible for ensuring quality deliverables from the team.

Environment

PowerBuilder 12.6, Oracle 11G, SQL Server, Windows 2007, UNIX, OpCon Enterprise Manager, TFS, VB.NET, ASP.NET, C#, VBS scripts.

3M Project Description: (Aug 2010 – Nov 2016)

Applications has been designed to facilitate the collection of products and their contract information which is used to calculate the 3M products price for their End Users and distributor. Calculated price will be sent many downstream e-business applications like EPC, CSMS, and Info Center.

Typically, it is like a warehouse where all the product information is refreshed daily from the different product source like (GGSM, GSDB). Pricing jobs which computes the product prices and sends it to many downstream applications.

Responsibilities:

Developed related PowerBuilder objects like (windows, datawindow, External API, Webservices calls, User Object) and Database Objects like (Stored Procedures, packages, functions, types, Tables, views etc ) using Oracle PLSQL.

Developing and Maintaining the application using VB .NET and ASP .NET.

Performing Data Analysis and Creating complex reports based on business user needs

Requirements analysis, estimation, coding, Production issue analysis, testing.

Responsible for managing / tracking the change requests coding, testing and deployment into the Staging environment.

Performed PowerBuilder migrations.

Developed SSIS packages for Integration and involved in SSIS migration activities.

Responsible for ensuring quality deliverables from the team.

Environment

PowerBuilder 11.2/12.6, Oracle 11G, Sybase ASE, MS SQL server 2012, SSIS, SQL Server Agent, Windows 2007, UNIX, TFS, VB.NET, VBS scripts.

3i-Infotect Ltd

Product Developer/Software Engineer as Nov 2006 – May 2010

Client: Deutsche Bank, LICMF, ICICI PRU, NIFCO

Project: Mutual Fund - Asset Management (http://www.3i-infotech.com)

Modules: Funds master, Assets, Securities, Deals, Fund accounting, settlements and Reporting)

Location: Bangalore, India.

MFund AM, the asset and mutual funds management module, is a multi-currency, multi-fund best-practice-based system that enables compliance to regulatory requirements and minimizes manual tasks. Designed for mutual funds, unit trusts, asset management companies, and portfolio managers, it automates all investment management back-office operations from post-trade settlements and fee accounting to income and corporate benefits accruals

Key features

Multi-asset class support (equity, fixed income, money market, asset-backed securities, exchange trade derivatives, interest rate swaps, and Forex)

Double-entry based built-in integrated online general ledger (GL) system

Compatible with a variety of third- party front-office trading systems, corporate GL systems, and price feeds.

Responsibilities:

Design and develop application using Power Builder 8.0.

Creating ORACLE PL/SQL stored procedures for data modification and creating processes.

Building customized report and modules development based on the clients need.

Involved in the production support activities which required immediate attention.

Shouldered responsibility of managing / tracking the change requests coding, testing and deployment on the Staging environment.

Environment

PowerBuilder 6.5/8.0, Oracle 10G, Windows XP, VSS.

CTL- Cosmosoft Technology Solutions (Payroll Product), Chennai India

Application Maintenance Engineer as Dec 2005 – Nov 2006

Client: Nittany, L&T

Project: Cpay Payroll (http://www.ctlindia.com/)

Modules: Employee, Payroll processing, Leave Management, Final Settlements, TDS

Location: Chennai, India.

Payroll Application:

cPay provides a comprehensive solution for managing the work force with powerful querying and reporting features. The various subsystems under the APPLECART are Personnel Management, Payroll & Tax Accounting, Leave & Loan management and JV Passing to ERP systems like SAP.

The salary processing and tax computing engines are very powerful yet easy to implement and use. Payroll user will be able to easily define the pay components and its computation sequence in simple mathematical formulae, eliminating the need for customization for any future changes in the pay structure. All statutory deductions such as PF, ESI, TDS and accounting of these is kept track in the system. The monthly / annual reports and statutory forms are generated by the system automatically. The powerful process engine is capable of processing thousand employees per minute & is the fastest payroll processing engine ever developed

Responsibilities:

Designing and development of user Interface.

Building customized report and modules development based on the clients need.

Involved in the production support activities which required immediate attention.

Shouldered responsibility of managing / tracking the change requests coding, testing and deployment into the Staging environment.

Environment

PowerBuilder 8.0, Sybase ASE, Windows XP.

Contact this candidate