S Kumar

Axiom Consultant

Professional Summary:

Over 7 Years in IT & Financial Services domain with broad experience in Software Development and Support.

Worked as Axiom Controller View – Consultant, SQL Support Developer, Financial Research Analyst and Jr. SQL Developer.

Strong development experience in Regulatory Reporting using Axiom Controller View.

Expert knowledge of Axiom objects like Data Source, Data Model, Aggregation, Portfolio, Free Form Reports and Tabular Reports.

Working knowledge on FRY-9C FRY-14, CCAR 14Q, 14A Report Schedules.

Liaising in end to end SDLC. (Requirement Gathering, Planning, Development, SIT/UAT, Release Management and Production Support).

Working knowledge of Linkages between various Reports (High Level Linkages & Sheet Level Linkages).

Expertise in Oracle, PL\SQL, UNIX, Shell, Control-M.

Experience in effectively resolving production job failures during the support hours and ensure SLAs are met.

Extensive experience in various versions of Oracle databases such as Oracle 10g and 11g.

Working knowledge of IHC, CCAR.

Involved in scheduling the Control-M jobs using Control-M Desktop and Enterprises Manager.

Designed and automation of Axiom Workflows.

Experience in requirements gathering, System analysis, design, development, testing, implementation, support and documentation.

Strong SQL and PL/SQL programming skills. Proficient in writing stored procedures, functions, packages and triggers.

Strong Research Skills of Collecting Analyzing & Scrubbing the Global Public Entities Data.

Worked extensively researching on global companies and providing a detailed business and financial analysis of a particular company, its products/services, target markets, strategies, financials, competitors, key executives.

Analysis of Company’s Financial statements filed in SEC, SEDAR and company Websites to prepare Financial Reports like Balance Sheet, P&L, Cash Flow, Geographic Segment, Business Segment and Per Share Record as per FactSet methodology that gives clear and detail information to the client.

Experience in Classification of the Companies on the basis of industry as per guide lines of NAICS and SIC.

Analysis of Financial Reports of the companies (Press Releases, SEC filings, 10Ks and 10Qs, etc.) and updating of other relevant data into the product.

Extensively investigated different data issues and communicated with clients to resolve the issues.

Excellent interpersonal skills, ability to interact with people at all levels, good communication.

Worked extensively with geographically distributed and culturally diverse teams, involving interaction with clients and other team members.

TECHNICAL SKILLS

Languages

SQL, PL/SQL, XML, UNIX Shell Scripting

Database

Oracle 10 & 11g

Project Management

Microsoft Project, Microsoft Office Suite

Documentation Tool

Visio, MS Word, MS Excel, MS PowerPoint

Testing Tool

Control M (job scheduler), HP Quality Center 10

Tools

Axiom SL Controller view, APP-View, Toad

Operating Systems

Windows NT/2000/XP, UNIX

Accounting Software Tools

PGDCA, Tally.ERP9, Focus, Wings

PROFFESIONAL EXPERIENCE

Credit Suisse New York, USA

Consultant Jun 2016 – Present

Project: US Regulatory Reporting

My Role:

Worked on FRY, CCAR, FFIEC (US Reports: Y9C, CCAR 14Q, 14A FFIEC 031, 041)

Creation of Data Sources, Data Model, Portfolios and Aggregations based on the requirements.

Use Axiom SL controller view to develop, modify and support Regulatory Financial Reporting for banking institutions.

Coordinate with team members to understand the new requirement for the changes.

Modify the Portfolios configuration based on the new requirements.

Participated in Migration of Axiom (Controller View) components within environments.

Developed Data Models, Portfolios, Short hands and Tabular Reports.

Updated the fields mapping based on the new requirement on aggregations.

Schedule of Axiom workflows in Control- M jobs.

Interacting with business users for requirement understanding, SIT/UAT verification and production deployment.

Analysis of Functional Specification & Implementation.

Involved in the implementation cycle of developing regulatory reports using AXIOM, UNIX, Shell Scripting, and Control-M.

Developing Control-M scheduler for automation; UNIX scripts for file validations, Workflow execution.

Developing Reports using AXIOM objects i.e. Data Source, Data Model, Modify Model, Portfolio, Aggregation, Shorthand, Tabular Report, and Freeform Report.

Monitor the Control–M jobs to make sure the SLAs are met using APP-View.

Electronic Information Services Pvt. Ltd Hyderabad, India

SQL Support Developer May 2014 – Dec 2015

Job Responsibilities:

Involved in preparing Functional/Technical specifications, Design documents, Test plans and actively involved in UAT, Integration, Regression testing.

Involved in System Analysis, Development and support FIRE, CAMRA application using Oracle, PL/SQL, Sybase, UNIX shell scripts and Perl scripting.

Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.

Sending the FIT report which includes status of all the jobs in critical path and co-coordinating and driving the weekly CAMRA status meeting.

Enhancements primarily include 60-120 hrs. Effort involving enhancements. Scripts include Oracle packages/procedures/functions/triggers, shell scripts and Perl scripts.

Involved in Dev, UAT and Production support and making sure that the SLA’s are met.

Used Break Glass for support issues to fix the incident in production.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Involved in scheduling the Control-M jobs using Control-M Desktop and Enterprises Manager.

Executed in converting most of the jobs [FIRE application] to re-run able which include change the shell scripts logic to take care of delete the loaded records and restart the load process from beginning.

Extensively investigated different data issues and communicated with clients to resolve the issues.

FactSet Systems India Pvt. Ltd. Hyderabad, India

Research Analyst Dec 2012 – Mar 2014

My Role:

Worked in the Global Entities Public process where we deal with collecting, analyzing & scrubbing the Global Public Entities data. We cleanse the information of Management, Corporate Hierarchies, Merger’s & Acquisition Private Companies and Parent/Subsidiary relationships of corporate entities. Capture the data of Clients/Customers, Suppliers, Partners & Financial Information.

Analyzing and updating the company’s financial documents to the FactSet’s tool.

Researching on Global Companies and providing a detailed Business and Financial Analysis of a particular company, its products / services, target markets, strategies, financials, competitors, key executives etc.

Primary and Secondary data collection, development of financial models, content development and report writing.

Analysis of Financial reports of the companies (Press Releases, SEC filings, 10Ks and 10Qs, etc.) and updating of other relevant data into the product.

Classification of the companies based on industry as per the guide lines of NAICS and SIC.

A comprehensive research on Private Equity & Venture Capital Funds and Portfolio companies under management, Ownership Positions, M&A deals from SEC Filings, Lexis-Nexis, Google, etc.

Geographical and Segmental Analysis of the Revenue, Expenses and Net Income of the company.

Capture share related data, voting rights, no. of shares outstanding, shareholding pattern and calculation of the free floating shares of the company etc.

Dealing with the “Initial Public Offerings (IPO)” and “Pre-IPO” and “Secondary Offerings” of the companies.

We analyze company’s financial statements filed in SEC, SEDAR and company websites to prepare financial reports like Balance Sheet, P&L, C/F, Geographic Segment, Business Segment and Per Share records as per FactSet methodology, that gives a clear and detail information to the client.

Presenting the most accurate financial data about the companies to clients.

Shore Infotech India Pvt. Ltd. Hyderabad, India

Junior SQL Developer Feb 2011 – Dec 2012

Job Responsibilities:

Created tables, views, index, synonyms and sequences.

Create daily reports in designed Excel spreadsheet with pivot tables.

Manipulating, cleansing & processing data using Excel, Access and SQL.

Responsible for loading, extracting and validation of client data.

Importing, cleaning, transforming, moving and manipulating data, performing data analysis.

Performing database queries and analysis on data, creating report queries utilizing standard T-SQL.

Assisting in troubleshooting data staging issues, analyzing and correcting as needed.

Helping in the implementation, debugging, optimizing and maintenance of SQL Server database objects.

Supporting clients in the areas of data issues and analytical reports.

Monitoring the automated loading process.

Writing T-SQL scripts to manipulate data for data loads and extracts.

Performing daily system checks.

EDUCATIONAL CREDENTIALS

New England College New Hampshire, USA

Master of Science in Computer Information Systems Jan 2016 – May 2017

Curriculum Courses: Database Design, Computer Security, Java, Web Applications and Web Design Development, Data Mining for Intelligent Business, Python Programming, Database Management, IT Project Management.

GPA: 3.95 (4.0 scale)

Osmania University Hyderabad, India

Master in Business Management Jun 2010 – Sep 2012

Contact this candidate