Resume

Sign in

Manager Data

Location:
Canton, Massachusetts, United States
Posted:
February 02, 2018

Contact this candidate

Resume:

PONNAMPALAM SOORIYAKUMAR

Profile Summary:

SSRS BI stack, Financial Report Building, Automated Software Testing, and IT professional with over 20 years of experience. Expert knowledge of accounting, auditing, finance, and business management principles. Strong background in automated systems, database management, proprietary and commercial software applications. Superior analytical and creative ability.

Technical Skills:

Operating Systems: Window-based Systems, DOS systems

Commercial Applications: Microsoft Office Tools, Accounting Applications, Budgeting and Forecasting Tools, Operations Research and Quantitative Techniques Tools.

Database Systems: Ms Access, MS SQL Server 2005/08/12, SSRS, SSIS, SSAS, Crystal, IQ DB2, Power Builder, FoxPro

Languages: T-SQL script, Visual Basic, and C

Software Testing Tools: Rational Visual Test 6.5, SilkTest Segue 3.0

Professional Experience:

Unicom Engineering, Canton, MA May 2013 – Dec 2017

Business Intelligence (BI) Report Developer

•Design and develop analytics using project lifecycle model; gathering business requirements, translation into report requirements and design specifications, documentation, building reports, and testing.

•Implement reporting solutions using SQL Server 2005 & 2008 Reporting Services, Business Objects InfoView and potentially other standard reporting tools to support customer demands

•Responsible for Enterprise level report writing using SQL Server Reporting Services (SSRS), Crystal, IQ, and Access reports and translating functional and technical specifications into clear and concise Quantitative, Financial and Administrative reports.

•Provide timely and accurate reporting solutions ensuring data and report validity, consistency and standardization across operation areas.

•Maintain the scheduling, distribution, and refresh for reports, views, and OLAP

•Provide production support for the reporting and analytic environment including: troubleshooting, security, training, performance monitoring

•Serve as a technical expert on in-house business intelligence initiative and reporting tool solutions

•Provide subject matter expertise, training, and/or development for operational/production reports

•Assist in the development and support of the corporate reporting data warehouse and data mart structure

•Assist in developing and facilitating in-house training, best-practice scenarios and process flow standards and documentation. Mentor for 2 junior report developers.

Mortgage Master Inc., Walpole, MA November 2011 - April 2013

Reporting Developer/ Manager

•Developed Dashboard using BI Studio an integrated component of Visual Studio 2008/2010

•Implemented Hierarchical Role based Data Driven subscriptions, Snapshots

•Upgraded SSRS 2005 to 2008R2

•Administrated Report Server and report manager; designed reporting tables and indexes; triggers to update report table and views; stored procedures for shared datasets; Tested triggers & stored procedures for performance using SQL Profiler/Analyzer/Tracer.

•Implemented TFS for the reporting solutions and projects and created a customized dashboard to monitor Report Server activities; usage; and performance

Morrison Mahoney LLP, Boston, MA March 2005 - June 2011

Senior Report Developer/Writer/Analyst

•Owned and administrated the ‘accounting’ database in SQL Server named ‘watchdog’. All accounting related database objects are maintained in this single database. This server and the database were created at my request and approved by the managing partner.

•Created schemas to define entities and document naming conventions.

•Highly skilled at data analysis, manipulation (including xml formatted data) and building translation routines to create or update database tables and data mart. Conversant with advanced T-SQL commands like cursor and pivot.

•Responsible for Enterprise level report writing using SQL Server Reporting Services (SSRS), Crystal, IQ, and Access reports and translating functional and technical specifications into clear and concise Quantitative, Financial and Administrative reports.

•Responsible for converting 100+ Crystal and IQ reports to SSRS.

•Designed, developed, modified, tested and supported reporting solutions for Finance and HR Department.

•Fine-tuned queries using SQL Query Analyzer.

•Developed home grown VB.net/ SQL Server based application for fixed assets and depreciation accounting according to IRS rules and in order to automate monthly postings to General Ledger System.

•Created payroll schema and related tables to capture imported bi-weekly payroll data from Fidelity Payroll system.

•Created payroll data mapping for General Ledger posting.

•Accomplished in SSRS, Crystal Reports, Access, Excel, Flat files and other Data-sources

•Fluent with multiple development tools and languages including Visual Studio (BI), SSIS, VBA, VB.net, T-SQL including Stored Procedures, Triggers, and User Defined Functions.

•Developed a financial model for both annual partnership profit & loss statements and productivity reports for 70 individual partners. Created a dozen of User Defined Functions to execute Overhead allocation, appropriation, and absorption of calculations.

•Developed an application to automate dispatch of monthly customized reports to over 240 attorneys via e-mail.

•Developed e-mail notifications using SSRS Data Driven Subscriptions for employee’s AP Direct Deposit on expense claims.

•Developed snapshot/gallery of summarized activity report (Dashboard) using data mart.

•Applied my extensive software testing knowledge to facilitate the upgrade of Legal Billing System (Elite) Version 3.5 to 3.8 and store procedures in the test environment using a test plan provided by the Elite project manager as a basis. Coordinated with IT manager and Elite project team to ensure recommended DBCC procedures were run with consistency and integrity of the son_db.

•Helped troubleshoot coworkers’ problems by reviewing and analyzing Log reports.

Creative Financial, Boston, MA October 2004 - February 2005

Financial Analyst

•Preparation of financial statements

•Excel/ Ms Access automation

Accountemp, Braintree, MA August 2004 - September 2004

Accounting Staff

•Loading checks into the Peagus accounting system

Equiserve, Canton, MA, March 2004 - April 2004

Accounting Staff

•Reconciliation of Daily bank activities to general ledger

Cruz Management, Boston, MA April 2003 - January 2004

Interim Controller Consultant

•Directed financial affairs and prepared financial analyses of operations, including interim and final financial statements with supporting schedules for the guidance of management

•Supervision over general accounting, property accounting, and budgetary controls

ADE Corp, Westwood, MA December 1999 - August 2001

Senior Quality Assurance

•Responsible for release of quality products to customers involving planning, designing, and execution of automated and manual testing and managing bug tracking system.

•Created and executed Comprehensive Test Plans and Schedules for assigned projects.

•Conducted internal meetings as needed.

McKesson HBOC Group, Marlboro, MA January 1999 - October 1999

Software QA Consultant

•Senior contract level on the QA teams

•Responsible for Y2K and function testing through automation

•Tested stand-alone and client server based hospital utilization management software application

New England Financial MetLife Group January 1998 - December 1998

Software QA Consultant

•Tested “NEFConnect” core components including back-end internet infrastructure- electronically view via the Internet personal investment, Insurance and Annuity financial information and carryout transactions

•Tested Power Builder based Client server ‘E-Commerce’ customer support application

•Ran batch-jobs in the TSO/ISPF main frame environment-sung Rumba as the interface between PC and mainframe

•Wrote SQL queries for data validation in the DB2 database

Education:

Institute of Chartered Accountants, Sri Lanka, Colombo

- ACA received 1983

Uniform CPA Examination, Boston, MA

Professional Training:

Institute of Data Processing Management, England, London

- Introduction to Data structure, Systems design, and basic programming language

Clark University, Boston, MA

- Completed Microsoft Windows NT MCSE Program

SQA Society, Boston, MA

- SQA- Methods and Approach

Boston University, Boston, MA

- C Programming

Northeastern University, Boston, MA

- Visual Basic Programming

- SQL Scripting

Microsoft, Seattle, Washington

- Visual Test 6.5 – Intermediate & Advances course

Boston University Metropolitan College

- Relational Database Management System Course #752, MOC 20463, MOC 20466, 70-432

- Data Fusion – a Thomson Elite Partner

- Elite Table structure (2006) - in Boston

- Crystal Reporting for Elite (2007) - in Maryland

- Elite Administration/VBA/ VB Scripts/Data Integrity Checks & Elite Balancing (2010) - in California



Contact this candidate