Project Data
Resume:
Ashok J. Paswan
************@*****.**.**
+**-
Pune, India
Professional Summary
10+ years of progressive experience in all phases of software development
life cycle (SDLC) which includes Business Intelligence (BI) and data
warehousing solutions (Teradata, Unix, IBM Tivoli) and 3 tier/client server
architecture using Microsoft Technologies.
. Actively participated in solution design and architectural decision
making.
. In-depth experience in requirement analysis, conceptual design,
development and implementing data warehousing solutions and front end
applications.
. Extensive experience in RDBMS, client/server and data warehouse
architecture.
. Skilled in problem solving, environment setup, performance tuning and
optimization.
. Proficient in providing technical leadership and E2E analysis.
Technical Skills
RDBMS/Databases: Teradata 12/13, SQL Server 2000, MySQL, MS-Access,
Foxpro, dBASE-III+.
Languages: C, C#.Net, Visual Basic 6.0, VB.Net
Tools & Utilities: BTEQ, FastLoad, MultiLoad, TPump,
FastExport, SQL Server DTS Packages.
Internet Technologies: PHP, JavaScript, VB Script, HTML, JSON.
OS: UNIX, DOS, Windows 98/2000/XP.
Experience Summary
. IBM India (P) Ltd. - Pune, September, 2013 - Present.
. NCR Corporation Ltd.(On Shakti IT payroll) - Gurgaon, May, 2012 -
July, 2013.
. IBM India (P) Ltd. (On Magna InfoTech Payroll) - Pune, October, 2011 -
May, 2012
. Lester Infoservices - Turbhe, Mumbai - February, 2007 - October, 2011.
. Human Infosoft Technologies, Mumbai - June, 2003 - January, 2007.
Experience
IBM India (P) Ltd.
Technical Lead - IT Specialist - 09/2013 - Present
CSI (Continues Service Improvement) - BI UK Vodafone
Working on CSI program which involves performance improvement of legacy
systems.
Presentation Layer (PL) which used to take 9 hours, reduced 1 hour run-time
by applying Teradata optimization techniques and functional approach.
We are targeting to reduce more 2 hours by applying various functional and
technical approach.
o Analyze application logs/explain plan and identify opportunistic
query/jobs/stream to optimize.
o E2E impact analysis, environment setup for development.
o Apply various optimization techniques like change SET to MULTISET,
proper STATS, eliminate 30 months old registrations, sequential
job run to parallel run etc.
o Prepare, discuss and review optimization approach with Architect.
o Development, system testing, Data Governance approval and
deployment.
o Prepare deployment plan, review checklist, post deployment
activities.
Assisted BAG SIP (Vodafone - UK) project.
Assisted BAG SIP project for performance improve of some job streams.
o Identify most resource consuming queries which can be optimized.
o Analyze EXPLAIN PLAN and define the optimization approach.
o E2E impact analysis of approach.
o Discuss optimization approach with architect.
o Test environment setup.
o Development and testing of change.
o Prepare deployment plan, review checklist, post deployment
activities.
o Analyze schedules for performance improvement.
Worked on Vsight (Vodafone - UK) project.
This phase of Vsight solution aims a the reengineering the design and
develop a data integration application which is an improvement over the
existing data processing. Vsight focuses on 4 subject areas i.e.
Registration, Usage, Denorm and Migration.
o Understand requirement and document business rules/derivations.
o Provide technical leadership on tactical (Teradata) solutions in
all areas.
o Performance tuning and trouble shooting.
o Prepare HLD/LLD and distribution of task to team.
o E2E Impact analysis.
o Code review and discuss the approach.
o Prepare integrated deployment plan, review checklist, post
deployment activities.
o Drive daily meeting with team.
NCR Corporation (On Shakti IT Payroll)
Sr. System Analyst, 05/2012-07/2013
Worked on Global Command Center project (GCC). This is a real-time
monitoring system for NCR global business users. EDW subscribes data from
various sources systems like D1, CSA and ES (Oracle) and process the data
and generate snapshots in every 30 minute to provide current status of the
work orders and also forecasts the work order status for the entire day in
30 minute window.
Also worked on Capacity Management and Planning (CMP) application. This is
another track of Command Center Project. The CMP application is designed to
forecast the work orders by analyzing the historical data.
Here, the role of the EDW is to subscriber data from D1, CSA,ES (Oracle)
and process the data by applying business rules and publish data to third
party vendor for further process and generate forecast.
o Analyze business requirement and provide conceptual design.
o Design process and programming specifications.
o Writing load processes using BTEQ, FastLoad, MLoad.
o Responsible for providing daily and weekly CSA extracts to business
users.
o Developed various macros for data subscription.
o Performance tuning and trouble shooting.
o Database design and data modeling in initial phase of the project.
o Developed DR (Disaster Recovery) module for routine backup of daily
snapshots.
o Provide technical support to team.
IBM India (P) Ltd. (On Magna Infotech Payroll)
Technical Lead - Software, 10/2011-05/2012.
Worked on Price Checker application for Vodafone, Netherlands. The purpose
of this project is to verify the generated billing as per the defined
tariffs and business rules for the different Price Plans and Pricing
Features. Involved in project migration from legacy system to New Business
Support System (NBSS).
o Responsible for interface design, process design and functional
specification.
o Involved in data modeling and database design.
o Designed load process for monthly reporting system.
o Designed process for weekly and monthly extracts.
o Involved in migration plan and identify impacts on existing system.
o Writing load processes using Teradata tools like BTEQ, MLoad, TPump,
o Writing stored procedures to implement new price features.
o Performance tuning and trouble shooting.
Lester Infoservices (P) Ltd.
Technical Lead - Software, 02/2007-10/2011.
Worked on DataReturn and Lead Processing application. Lead processing
application processes the data gathered by heterogeneous sources, apply BPA
rules and publish data to Scripting module for survey purposes.
Worked on DataReturn application which subscribes data from Scripting
modules and generate the demographic reports and send it to over shared
drives for further analysis.
Worked on client server applications and developed Scripting Tool using
Visual Basic and SQL Server. This is a dynamic multi-user application
which includes three modules, i) Script Definition ii) Script View and iii)
QC Module. The complete system to define script for the survey which
includes execution and understanding of complex logic design and dynamic
behavior of the survey at real-time and also an ability to communicates
with the Concerto dialer system. The Scripting Tool facilitates two way
communications with the Concerto and Small Wander dialer.
o Analyze business requirements and development.
o Responsible for writing ETL processes as per the business need.
o Responsible for publish hourly campaign wise snapshots of call/survey
details.
o Responsible for database and architectural design for Script
Definition, Script View and QC Module.
o Designing data transformation tool for central hub using SQL DTS.
o Developed daily backup system using Teradata tools like FastExport and
MultiLoad.
o Designed and developed various tools and application using Microsoft
technologies/tools like DTS, VB Script, VB, .Net.
o Developed stored procedures lead processing and validating business
rules.
o Performance tuning and troubleshooting.
Human Infosoft Technologies.
Software Developer - Software, 06/2003-01/2007.
School Management System is windows based multi-user school management
system. The system provides all features of school management. The system
takes care of academic activities from taking admission to passing out
academic. The system includes modules like Student Registration, Defining
Subjects and setting min/max marks for the defined subjects, Assigning
Subjects to Class, Exams, Assigning optional subjects to students, Student
Attendance, Mark Check List, Subject Average Sheet, Periodic And Final
Processing Configurations and Mark sheet Printing .
o Requirement gathering, Analysis & Design and development.
o Developed, modified, and debugged old application.
o Worked on database Designing and Normalization.
o Developed dynamic Mark Sheets and various academic reports using
Crystal Reports.
o Involved in deployment of the application at client site.
o Developed multiple COM,DCOM for the application as per the
requirement.
Education
Bachelor of Information Technology (BSC-IT), 2013.
Certificate In Computing (CIC), 2000.
US VISA
Holding B1/B2 visa till 2019.
Approved H-1b Petition (Year 2014)
Contact this candidate