Data Analyst

MAHESH SREEKUMAR

********@*****.*** 210-***-****

SUMMARY

• Over 8 years of IT industry experience in Application Design, Development, and Maintenance activities for financial organizations.

• Over 4 years of experience in ETL Development, Deployment, Maintenance and Support.

• Over 2 years of experience as SAS Data Analyst responsible for a vast range of Analytics activities.

• Vast knowledge of Business Intelligence concepts and tools

• Work experience in Data Analytics involving Data Mining, design and development of SAS driven solutions in Investment Banking

domains focusing on trend analysis and predictive modelling.

• Expertise in SAS - PROC SUMMARY, PROC FREQ, PROC SORT, PROC SQL & advanced DATA step operations.

• Experience in Data Conversion projects involving various sources in different platforms

• Knowledge on Data Warehouse concepts & experience in developing Data Warehouse & Data Marts using IBM Datastage

• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.

• Experience in designing of Parallel jobs, Job Sequences, and Batch jobs with expertise in Scheduler Control-M.

• Strong Mainframe background; Expert in SYNCSORT, JCL, COBOL, VSAM.

• Functional experience in Investment Banking, Life Insurance, Fraud & AML prevention, Health Care domains

• Development project execution experience in Waterfall, Agile & Business Intelligence Methodologies.

TECHNICAL SKILLS

SAS(Enterprise Guide), ETL(IBM Datastage), Mainframe(COBOL, JCL, VSAM), UNIX Shell Scripting, SQL, PL/SQL, NZSQL, Tableau,

Oracle, Netezza, Control-M Scheduler (BMC), MS Visio, MS Excel, MS Access

EDUCATION

National Institute of Technology Calicut, Kozhikode, India August 2002 – May 2006

Bachelors of Technology in Civil Engineering

EMPLOYER

Tata Consultancy Services (TCS) August 2006 – Present

WORK EXPERIENCE

Data Analyst (SAS) Duration: September 2012 - Present

Client: USAA. San Antonio, TX. Location: San Antonio, TX

Functioned as a Data Analyst lead in USAA’s Financial Advice and Solutions Group (FASG) and Business Intelligence area. Responsible for

delivering innovative solutions that provide the Business with essential information and Analytics to make business decisions that enhance

member experience and help in achieve best in class results.

• Used the analytics tools to provide insight and recommendations to help Business benefit our members and financials.

• Developed recurring SAS generated reports and shared dashboards that support front and back office operations.

• Fulfilled ad-hoc requests for operational,

• Supported IT projects by providing SME support related to reporting and analytics.

• Provided descriptive and predictive analysis by applying analytics techniques to answer critical business questions.

• Executed ETL operations using SAS/Base and Enterprise Guide.

• Worked extensively on building and scheduling on Control-M, analytic applications using SAS related products.

• Designed and built SAS programs to analyze and generate files, tables, listings, graphs and documentation.

• Successfully managed multiple complex business service requests applying Agile methodologies.

• Executed and delivered 250+ data requests from various lines of business till date.

1

MAHESH SREEKUMAR

********@*****.*** 210-***-****

• Integrated Business Objects with SAS reporting solution to provide elaborate reporting for Investment management company

platforms.

• Worked extensively on presenting SAS generated data on macro enabled Excel pivots to provide Daily, Weekly and Monthly

reporting needs.

• Developed SAS processes for business users to extracts summarized data and distribute business summary reports through

automated email.

• Presented descriptive statistics and inferential results to business users through automated scheduled tasks.

• Modified existing Data Architecture to implement missing Business Logics and created new reporting data marts.

• Worked with Business to gather requirements and design new data mart entities.

• Executed conversion of existing data warehouse & marts to Netezza.

• Designed & Developed Control-M jobs and its schedule for Datastage programs

• Developed Data Integrity check dashboard for Netezza tables.

Datastage Lead Developer Duration: May 2012 – September 2012

Client: USAA. San Antonio, TX. Location: San Antonio, TX

End-to-End reconciliation of statement & confirm document generation and delivery to members and report the results to business back-

office team for all IMCO mutual fund, Brokerage & managed accounts.

• Analyzed & documented as-is investment document generation processes

• Identified all the data sources influencing document generation.

• Developed & Incorporated Business Activity Monitoring (BAM) framework for all compliance document generation &

delivery process which gives proactive alerts & process tracking abilities to business back-office teams. Also, saves client

from penalties for being incompliant.

• Adhoc data mining tools to bring out different scenarios during analysis phase

Data Conversion (Datastage, UNIX, Mainframe) Lead Duration: April 2011 – May 2012

Client: USAA. San Antonio, TX. Location: San Antonio, TX

USAA identified a third party vendor product Maxit as a book of record for Costbasis. All the historical trades & asset details of USAA

investment customers were formatted as per Maxit requirements and sent to Maxit as multiple files. All the going forward trades are sent

to Maxit on daily basis. All the Costbasis data generated for USAA customers are provided to customers via statements and in online

banking pages.

• Converted entire Mutual fund & Brokerage account, trade, position & security data to the new Costbasis engine which is a

third-party vendor application. Data distributed across different platforms mainframe, Oracle Databases in different UNIX

servers. Developed JCL mainframe jobs, Datastage Parallel jobs for initial conversion & daily data feed to vendor system

• Created ETL jobs to receive & load daily, weekly data from vendor system to internal tables and re-distribute to Regulatory

bodies.

• Created File-transfer interfaces using B2B with clearing corporation DTCC, vendor (Scivantage) application & external

broker dealers to transfer Costbasis when Asset transfer happens between Client & other broker dealers.

• Analyzed existing systems & identified potential gaps in tracking Costbasis transfers. Established Reconciliation process to

track & report Costbasis transfers and ensured client is in compliance with SEC & FINRA regulations.

• Created daily & weekly Recon between Application data & Vendor data to ensure data quality using Datastage jobs.

2

MAHESH SREEKUMAR

********@*****.*** 210-***-****

• Created Recon Audit databases in Slowly Changing Dimensions (SCD) type4 using Datastage Jobs

• Executed Integration Testing involving all stake holders (DTCC, Costbasis Vendor, an external Broker Dealer)

Data Warehouse ETL (Datastage) Offshore Developer Duration: August 2010 – April 2011

Client: Cardinal Health. Dublin, OH. Location: Chennai, India

Developed Data warehouse for financial shared services record for the health care client. Data warehouse had five fact tables and

sixteen dimension tables.

• Led a team of 4 to develop Data marts & warehouse in Teradata for financial supply chain data of a healthcare client

(Cardinal Health) from various data sources like AS/400, DB2, Oracle & flat files.

• Loaded nearly 4500 attributes (fields) and Applied SCD-1, SCD-2 on jobs based on the design requirements.

• Used conversions like decimalTodate, decimaltostring, stringTodecimal, stringToDate etc. Handled Null fields

• Created Source-to-Target Mapping for sources distributed in Oracle, DB2, AS/400 & Flat files.

• Stages Used: Transformer, Look-up, Join, Sort, Change Capture, Oracle connector, DB2 Connector, DB2 API stage,

Teradata, shared containers, execute-command, user activity, job activity, sequence activity, mail notification

Data Conversion (Datastage, Mainframe) Offshore Developer Duration: August 2009 – July 2010

Client: USAA. San Antonio, TX. Location: Chennai, India

Worked as a Data conversion developer for Client (USAA) Bank’s Fraud hotlist & Account ownership data from mainframe DB2 &

VSAM files to vendor EWS application.

• Prepared analysis & design documentation for the Conversion of huge volume of data.

• Prepared & presented different approaches for File transfer to vendor application

• Incorporated Mailing Address check & auto correction module to cleanse address values before sending them to vendor

application

• Developed Datastage parallel & sequence jobs along with mainframe JCLs to unload, transform and send to vendor

• Performed integration testing using vendor application GUI

• Developed Recon routines to check and ensure 100% conversion

Mainframe Offshore Developer Duration: October 2006 – August 2009

Client: Prudential Insurance, Newark, NJ Location: Chennai, India

• Developed Pub-Sub architecture around mainframe & UNIX servers for real-time Debit card alerts to customers.

• Developed & maintained CICS screens & transaction routines for Agents Database application of Client Prudential

Insurance.

• Re-engineered Agents Compensation application for Client Prudential Insurance by re-writing 200+ mainframe components.

ACTIVITIES/ACHIEVEMENTS

• Recruitment Coordinator, TCS, Organized and helped TCS’s BS recruitment for 2014 at University of Houston.

• Awarded “Star of the Month”, TCS, for the zero defect conversion of Mutual fund Costbasis System for month of May 2012

• Self-learning Big Data/Hadoop technologies from online resources

• Trained in IBM Datastage & SAS by TCS Learning & Development team

3

Contact this candidate