Shanti Veerasamy Naperville, IL
Email: [Send email using form at bottom] Green Card Holder
(913)484-7073
Professional Profile
Senior level IT professional with eight years of experience in data warehouse
environments as a Project Lead, Business Analyst and Systems Analyst and full
cycle SDLC experience on several infrastructure projects and on multiple
platforms.
Strong understanding of Business concepts in Telecommunications, Manufacturing,
Health and Sales and Distribution industries.
Successful track record in collaborating with IT and functional teams to
implement systematic solutions for Business.
Experience in implementing systems involving large databases (Terabytes) and
working on multiple projects simultaneously.
Self starting and motivated individual, with a very positive attitude, requiring
very little management and direction.
Key Skills :
Oracle SQL PL/SQL Unix Shell Scripting Cobol, JCL, MVS CRM, Data Warehousing
Teradata, SAS TOAD SQL *Loader Fastload ERP systems Chameleon 2000, CIIM
Avalon
Visual Basic Microstrategy Syncsort BTEQ Project Management
Business Analysis Requirements Gathering JAD sessions Facilitation SDLC Scope
Management
Issue Resolution Quality Assurance MS Excel, Access and SQL Server Microsoft
Office, PowerPoint MS Project, Visio
Experience:
DHSoft Inc.
Client : SPRINT, Overland Park, KS Aug 07 Jul 08
Business Analyst, Marketing, Base Management
Role : Consultant
Produced monthly churn analysis metrics and dashboards for executives that
identified key factors that would help in churn reduction and customer
retention.
Perform data mining activities that help to identify potential
up-sell/cross-sell opportunities based on criteria requirements identified
through JAD sessions with the Business.
Analysis was done on a Teradata based data warehouse and Oracle based data
mart and SAS dataset based modeling repository.
Used tools such as Queryman, Toad, Teradata fastload and SQL Loader to load
data obtained from other sources and develop SQL based queries.
Produced SQL Server/Excel Pivot table based analysis cubes to help Management
plan on future Marketing strategy.
SPRINT, Overland Park, KS
Software Engineer, CRM Development Jun 01 Apr 04
Role Project Management, Design, Develop, Testing implementation and support
Implemented projects that tracked and reported Sprints campaigning
effectiveness using mainly ORACLE PL/SQL, Teradata, SQL LOADER, FASTLOADS and
developers tool like TOAD and SQL Plus.
Managed projects throughout its SDLC and was responsible for Requirement
Specification, Data Flow Diagram, Data Dictionary, Program Specification and Job
Flow Diagram deliverables.
Redesigned large database (millions of records) that stored CRMs campaign
tracking and campaign planning data in order to improve ORACLE performance by
using Explain plans, Indexes, Hints and Join views.
Competent in working with ORACLE stored procedures, packages, triggers,
debugging for errors, Query Optimization and UNIX shell scripts.
Led ORACLE PL/SQL development team in the requirements and designing stage on
how the Sprint PCS data would be stored and reported for the CRM and Small
business end-users.
Support User acceptance testing by aiding in test data production and produced
Wrapper scripts in UNIX to automated test cycles.
Facilitate JAD sessions especially for Microstrategy reporting.
Developed GUI system using Visual Basic that retrieves data from ORACLE
database.
Tata Technologies Singapore Pte. Ltd 1993-1997
Business Analyst Consultant
Managed over 10 person project teams in requirement gathering, business
re-engineering, developing, testing and implementing ERP Package Chameleon 2000
modules and CIIM Avalon modules which include accounting, sales, purchasing and
manufacturing modules.
Client worked for:
Client Name Country Industry
Jerodong Park Medical Center Brunei Health
Marlex Pte Ltd Singapore Sales and Distribution
Total Petroleum Singapore Petroleum Sales and Distribution
Sumitomo Pte Ltd Singapore Manufacturing
Education: Bachelors in Computing and Information Studies (Univ. of London)
1999
|
