Jacky Tsang
Email: *********@********.***
Address: Apt 1506, 11300 Expo Blvd.
City: San Antonio
State: TX
Zip: 78230
Country: USA
Phone: 217-***-****
Skill Level: Experienced
Salary Range: 90
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
JACKY TSANG
Address: 11300 Expo Blvd, San Antonio, TX 78230
Tel: 217-***-****
Email: *********@********.***
Citizenship: United States
*CONTACT for Resume in WORD Format
Motivated, experienced professional with an exceptional track record
in creating and implementing tactical and strategic business solutions
abiding in industry best practices. Expert in delivering business
solutions; possesses a strong blend of enterprise analytical experience
and troubleshooting skills. Expedites all areas of project delivery,
operations management, process improvement, statistic analysis, and
risk management. Excels in challenges that call for innovation,
initiative, vision, organization, leadership and time management skills.
TECHNICAL SKILLS
Languages
VB Script, VBA, Java, C#, VB, ASP, .NET, C/C++, CSS, XML, HTML
Concepts
Business Intelligence, SQL Query, Project Management, Dynamic Reporting,
Data Warehouse, Process Improvement, Automation Scripting, ETL,
Data Conversion, Data Modeling, Database Migration, OLAP Cube, Salesforce,
SharePoint, Mainframe, Object Oriented Programming, Agile/Waterfall
Development, SDLC
Tools
Microsoft Visio, SAP Business Object / Xcelsius / Crystal Report,
MS Excel, MS Access
Databases
Oracle, PSQL, MS SQL Server, MySQL
Platforms
MS Windows 95/98/ME/NT/2000/XP/Vista/7,
Mac OS X, Dos, Linux, Unix
PROFESSIONAL EXPERIENCE
>
2010-Current
TCS - Tata Consultancy Services, San Antonio, Texas
One of the largest global consulting firms; provides business consulting
services to one of the fastest growing Fortune 200 Insurance/Financial/Banking enterprises
-> Design/implement multiple enterprise business intelligence solutions to create
a total costs saving of $3.5 MIL for a Fortune 200 company with over 9.2 MIL members
-> Deliver cost saving solutions by utilizing business process improvement,
project management, and agile development mythologies
-> Identify business improvement opportunities, evaluate cost benefit analysis,
design and propose business solution to executives
-> Revenue increase $500K by campaign and promote business solutions to internal
and external client
-> Manage and maintain multiple integrated products to meet agile business requirements
-> Lead and provide training and mentorship to junior analysts and business users
-> Enterprise business intelligence Subject Matter Expert
-> Recipient of Outstanding Achievement Award 2011 - 2012
>
2009-2010
TCS - Tata Consultancy Services, Cincinnati, Ohio
One of the largest global IT consulting firms; provides business services to enterprises
-> Develop Oracle and P-SQL data warehouse health care solutions for the largest
chain hospital in Asia
-> Communicate and manage relationship with stakeholders of all levels
-> Oversees complex data cleaning, ETL, and data aggregation project
-> Manage C#, VB, ASP.NET and healthcare management system development
-> Script automation data warehouse development to reduce 80% data migration workload
-> Define application user interface look & feel/action & behavior
-> Define development cycle best practices for process improvement
-> Review technical functionality and standard operating procedure documentation
-> Collaborate and engage with onshore and offshore product development activities
>
2008-2009
Prepress Training Solution, Bloomington, Indiana
A multi-million dollar consulting company offering business IT solutions
-> Lead application development, quality assurance, and software packaging
-> Gather project requirements, create and maintain project documentation
-> Develop and integrate enterprise data warehouse, Java API framework to meet
business needs
-> Lead migration of automated script testing methods to reduce testing script generating
time up to 50%
>
2006-2008
Indiana University Student Technology Center, Bloomington, Indiana
Provides technology consulting services to over 43,000 individuals in the "Most wired
public university in the United States"(2004-2009)
-> Integrate off-the-shelf software, configure and customize development framework
-> Utilize process methodology to reduce average customer service time by 35%
-> Recipient of the Consultant of the Month Award in 2008
>
2004-2005
Indiana University Student TV, Bloomington, Indiana
-> Develop internal web report inquiries XML data processing with batch SQL queries
-> Database development and Server administration
-> Maintain database data standard and metadata integrity
PROJECTS
Dynamic Product Management Project (2012)
Improve operation management by utilizing SAP technology and enterprise data
warehouse environment to creates a business intelligence dynamic framework.
Enabling collaborative and holistic management in complex business environment
-> Create interactive data visualization modeling to oversee annual revenue $48 MIL
of insurance & financial products
-> Monitor 200+ sales representatives' product performance on a
daily/monthly/quarterly basis
-> Provide KPI metrics to management to improve and strategize business model
Call Center Operation Management Project (2012)
Productivity dashboard that evaluates operation efficiency and interprets back office
operation activities metric in cube data warehouse architecture
-> Progressive dashboard name best BI tool of Enterprise 2012 innovation
-> Framework Implemented in Bank / Product Management / Member Service / Insurance area
Enterprise Change Management Project (2011)
SharePoint integration extracts and encapsulates enterprise project data.
Unique business intelligence platform and simulation modeling allows executives
to manage risk for all LOBs
-> Disaster simulation modeling and planning to minimize operation risk
-> Capacity planning and project management model to eliminate operation bottleneck
EDUCATION
BACHELOR OF SCIENCE IN COMPUTER SCIENCE
Indiana University, Bloomington, Indiana