Data Financial Analyst

Thanuj Shiva Kumar (Thanuj)

Contact: 510-***-****

Email: **********@*****.***

Linkedin : www.linkedin.com/in/thanujshiv

Professional Summary

Associate Projects expertised in providing Data warehousing – ETL and Business Intelligence solutions.

Overall 5 years of hands-on-experience in Techno-functional Analysis of requirements, development, integration, implementation and migration of projects in Data Warehousing.

Industry experience in Consumer Goods, Retail, Banking (Risk Management, Rewards & Rebates) and Finance.

Experience in Oracle,Netezza,DB2 and Teradata.

Technology expertise in ETL, Data Quality, MDM, Reporting, SQL Optimization and Performance Tuning.

Diverse experience of working in design, development,Migration as well as production support.

Worked extensively in Informatica, OBIEE, Argos, Databases, Crystal Reports, Autosys and Unix Shell Scripting.

Key Strengths

Excellent blend of Technical, Functional, Multi – Programming Skills and People management skills which helps in time bound delivery with assured quality.

Possess very good organizational skills, with the ability to multi-task and deal with shifting priorities.

In-depth knowledge in multiple tools to provide dynamic design solutions.

Mentoring experience by conducting effective cross location training sessions in Oracle,Informatica and C Programming Language.

Experience as a Teaching Assistant in handling inter class communication technically and functionally.

Experience as a Financial Analyst, Developer &Project lead (Associate Projects).

Skill Summary

Functional Domains Banking, Consumer Goods, Retail, Finance

Databases Oracle, SQL Server, Netezza, Teradata, SQL, PLSQL, NzLoad, NzSQL,MySql

ETL Informatica Powercenter 9, MDM & Informatica Power xchange

Data Quality IDQ, DVO, Informatica data analyzer,

Reporting OBIEE, Argos Enterprise Reporting

Batch Scheduling Autosys Ixp Client, Cron Jobs

Data lineage Metadata

Scripting Unix Shell Scripting & Batch Scripting, MS Excel VBA Scripting

Design Tools Microsoft Office, Adobe Photoshop 7, Drupal, Erwin, Microsoft Visio

Programming Languages C, C++, Core Java, HTML, CSS5, JQUERY, XML

Document Enhancement Tools Evisions FormFusion

Process Tools Ellucian Banner

Software Methodology Waterfall, Agile and Scrum

EDUCATION

Masters of Science in Computers Information Systems(MSCIS) from New England College,United States. (December 2017)

Bachelor of Technology in Computer Science and Engineering from Jawaharlal Nehru Technological University, India (2007- 2011)

CERTIFICATIONS

Internal Process

RDP Certification 2013

Internal Domain

Retailing 2012

PAT-COGN2993545-DB-ConsumerGoods-Overview 2012

PAT-COGN2885254-DB-Banking-Securities 2012

Have attended soft skills programs on Customer Orientation,Business Orientation,Articulation Skills

And Stress Management.

Achivements

PAT-PAT of the Quarter Award (2012).

PA-Rewards and Recognition Awards -Individual contribution(2012 & 2013).

Member of Global Outreach, Go Green and EMRT groups (2012 – 2015) Cognizant.

Project Experience

New England College

Financial Analyst Intern - Student Financial Services (May2017 – October2017)

New England College(NEC) is a Private non profit educational Instituition in New Hampshire, United States. focused on experiential learning and offering undergraduate, graduate and doctoral degrees. Student Financial Services is a department of NEC which manages the complete Finance, Fees, Payments, Financial aid and Payroll of the institution.

Tools and Technologies used:

Ellucian Banner, Evisions Form Fusion, Arogos Enterprise Reporting, Oracle, SQL Scripts

Overall responsibilities:

High Level Analysis,Design,Development,Solution providing and working with Multi Phased applications.

Worked with the Evisions Form Fusion to design dynamic Students Financial Aid invoice and display the Account Balances,Payment Types ( Credit, No Payment ).

Worked with the Evisions Form Fusion, Form stamp and detail stamp templates of Student Financial Aid Payment invoices, to dynamically adjust the Address headers with the window of an mail envelope.

Coded SQL scripts in RORULE forms in Evisions Banner to pull up the information of the students to dynamically process data onto other processing banner forms.

Developed Multiple Reports using Argos Enterprise Reporting to functionally work based on the high level requirements

New England College

Teaching Assistant- Java (March2017 – May2017)

New England College(NEC) is a Private non profit educational Instituition in New Hampshire, United States. focused on experiential learning and offering undergraduate, graduate and doctoral degrees.

Tools and Technologies used:

Core Java, BlueJ, Eclipse IDE

Overall responsibilities:

Worked with Associate Director of school as Teaching Assistant to help students in his class on the course work.

Making sure all students checked in class.

Providing additional one-on-one support to students for letting them understand and

perform class-work, home-work,assignments,quiz & exams.

Attending and supporting classes regarding regular instructions provided by professor and monitoring tasks and schedule accordingly

Collecting Feedback, complaints and suggestions from students on any course-related

activity and bringing it to Professor’s notice.

Focusing on providing the best available resources to students so they could be able to complete work on schedule.

Reviewing all students course related work and making sure that everybody is on track and up to the mark and check their activity is in sync with the course schedule

Motivating, encouraging and supporting students to do additional projects and help them do co-curricular activities.

Technical & Module Lead– American Express (May 2014- Dec 2015)

(Account Receivables,Business Intelligence,Rewards and Rebates Warehousing)

American Express Company, known as AmEx, is a diversified global financial services company headquartered in New York City.One among the Fortune 100 Financial Services Company, present in more than 130 countries with revenues exceeding $25.8 billion.

The scope of the program is to migrate the BIDW applications from DB2 to Netezza to address capacity and performance related issues and to establish a scalable platform in Netezza to host advanced analytics and capabilities.

Tools and Technologies used:

Netezza 7.2.0.4,Nzadmin 7.1.0.3,Informatica 9.6.1,TDM(Test Data Manager) 9.6.0,Informatica Analyst,DB2.

Overall responsibilities:

High Level Analysis,Architecture,Design,Development,Solution providing and Leading Offshore Team in Multi Phased Migration tracks.

Re-designed Physical Modeling to include efficient data distribution/Organise keys across tables for faster data loading and reporting performance improvement.

Architecture design of Database Layout,Object,User group creations,Analysis of Data/Process skews and Performance Tuning.

Scheduling Back up,Reclaim, Statistics,Groom and all Database maintenance activities along with Concurrency and Capacity Planning.

Implemented Netezza load utilities and Data transmission concepts for Historical Data Migration and Informatica PowerExchange Bulk writer feature to improve performance using External tables.

Compilation and registeration of UDX/UDA process on Netezza host to interact with c++compiled output files.

Optimized the ETL Logic to reduce the cost for update strategy and re-engineered the mappings to remove the bottlenecks in performance.

Extensive usage of Solution Accelerator tools for Data Migration and Validation.

Gained appreciation from Tech Architect and Client side coordinator for extra ordinary on the Fly Design solutions and exhaustive scenario analysis.

Point of Contact- Working as touch point and reference for EVENT AND USSR Modules related Information during and after project duration.

Enabled reusable scripts for Data movement using nzload bulk option,DDL Comparator utilities for Column Name, Data Type, NULL, DEFAULT constraints,Primary key validator and violation checks which would enforce additional integrity to the data,Performance Monitor and Data/Process Skew Checks.

Involved in Data movement from ETL side integrated with Data Quality aspects and projected in the Reporting end thus enabling profound understanding of Data.

Technology Analyst – Coty-Philosophy (Jul 2013-April 2014) – Cognizant Technology Solutions

Philosophy EDW&BI

Coty Philosophy is a Consumer Goods beauty products manufacturing company. It has its own manufacturing units where they sell products to retailers and also acts as distributor to their products. The main objective of the project is to track their products sales, Forecast, Inventory and Planning about their products based on Supply and Demand in the market.

Tools and Technologies used:

Informatica Power Center, Oracle Business Intelligence 10g,Oracle 11g and UNIX.

Overall responsibilities:

Understanding requirements and update the design and mapping specification document.

Development of ETL mappings, Reports & Dashboards.

Work on ETL Analysis, Design, Coding and Integration

Reports & Dashboards Unit testing.

Involved in System testing. Supported client’s IT team during UAT.

Developed Unix Shell Scripts for file validation, file creation, error handling and data loads.

Worked with multiple sources and transformations such as Relational Databases, Flat files

Developed and tested Informatica mappings involving dynamic lookups and update strategies.

Performance Tuning.

Analysis of Expand plans and Optimization of SQLs in Oracle.

Developer – Dean Foods (Dec 2012 – Jun 2013) – Cognizant Technology Solutions

Financial Planning And Analysis(FPA)

Financial Planning and Analysis(FPA) involves in acquiring the commercial data from various accounting systems, reference systems of record, other risk aggregators and reporting systems in the DeanFoods, and applying FPA business specified calculations to support analyzed reporting. In overall, this project aims at re-platforming and re-designing the existing FPADW Analysis data sourcing and business transformation processes to Teradata from DB2.

Tools and Technologies used:

Unix shell scripting,Informatica,Autosys and Teradata V13 and DB2

Overall responsibilities:

High Level Analysis,Design solutions,Development of Unix shell scripts.

Involved in Operational control Management for ETL and ELT process for Integrated Functionalities.

Participated in estimation of scripts using existing FPA Data model.

Developed Unix Scripts and worked on BTEQ, FastLoad and Multiload scripts

Provided solutions for complex design problems.

Took responsibility for Developing/Testing/Implementing the key scripts which determine the critical functionalities of the FPA module.

Performed Self Testing/Peer Testing .

Reviewed design documents and test scripts of subordinates.

Implemented reusable jobs /solutions for data validations which helps in reduction of manual intervention and increase in productivity/ performance

Developed automation scripts to load some static tables thus saving time and effort.

Developer – Avon (Jan 2012 – Nov 2012) – Cognizant Technology Solutions

AVON DWHBI-EID Biz Activation

Avon Products, Inc. known simply as Avon is an American international manufacturer and distributor of beauty, household, and personal care Company that sells products through representatives in over 140 countries across the world. It is the fifth-largest beauty company and second largest direct selling enterprise in the world, with 6.4 million representatives. Avon Products is a multi-level marketing company.

Tools and Technologies used:

Informatica, Oracle, Toad, Unix,Autosys.

Overall responsibilities:

Worked extensively in Maintenance,Developement, Deployment,Enhancement and support for Informatica Jobs.

Performance Tuning of Informatica jobs and SQL optimization.

Development of Unix shell scripts for File Management.

Code reviews, resolving technical and design issues.

Autosys creation and schedule management.

Assessing inventory of mappings and SQL queries.

Development of the PL/SQL Procedures.

Contact this candidate