Chakkolil Vadakkathil Varghese John
*********@*****.*** Mobile: 425-***-****
Objective
Looking for an excellent opportunity to work as a Senior Database Developer / Architect where my 16 years of
experience, my passion for problem solving in distributed applications handling large data can bring value to the
team. My Strong partnering skills and good collaborative skills will enhance the relationships with the customers.
Highlights
• Delivered high scale online solutions on time with high quality in online services at weekly interval positively
impacting millions of users.
• Experience in working for software applications developed for diverse industries including finance,
manufacturing, and Information technology – using the SDLC and designed and implemented enterprise based
applications involving web and windows based services.
• Architected, designed and implemented multiple applications with business rules implemented in database and
Middle Tier.
• Performed analysis and identified bottlenecks in databases with high transaction levels and provided short term
and long term solution options for addressing performance issues.
• Experienced in working in a technical support of a clarify CRM based customized application deployed in all
European countries.
• Designed and implemented transactional and warehousing (BI) software solutions.
• Migrated / Upgraded data to higher version of application and database server and implemented multiple
rollback solutions for databases
• Worked on disaster recovery solutions for high availability applications, defined best practices for development.
• Influenced and embraced cross-functional teams in critical business decisions.
• Worked on several complex projects simultaneously, driving positive results and excellence.
• Tracked production system KPI and created auto recovering solutions for online systems.
• Delivered Projects using in TSP (Team software planning) Process/tool & SCRUM/Agile methodologies.
• Created system for system engineers to monitor and respond to high priority business issues.
• Tracked and analyzed critical product implementation and created projections for future.
• Learning Hadoop for developing decision systems.
Page 1 of 6
• Worked with Cosmos (Microsoft version of Hadoop system)
Technical Skill set
Development Tools Visual SourceSafe, Clarify CRM,Dundas Charting component,Clarify CRM,Sqlserver
Reporting server and Sqlserver Integration services. MS SQL SERVER 6.5 /
7/2000 /,2005,2008,2012,Oracle 7.1, VSTS, Win Forms,Visual Studio
2003,2005,2008,2010,VB 5.0
Middleware ADO.NET, Active X
Internet Technologies ASP.NET, ADO.NET,,Webform, ASP, VBScript, JavaScript, IIS, HTML, XML, Web
Services, SharePoint 2007,Http modules,Http Handlers
Design Tools UML, MS Visio,Erwin
Professional Experience
Software Development Engineer at Microsoft, Redmond, USA (As a FTE) July 2006 – Till Date
Analyst Programmer at Microsoft ( As a Contractor), Redmond, USA Oct 2005 – July 2006
• Worked in Online Service Billing platform enabling efficient management of advertisers and publisher
payments.
• Re-architected the internal and external interfaces for the Billing platform to work for the current volume and
to accommodate future volume.
• Worked on an enterprise application which deals with storage and delivery (Downloads) of Microsoft
products across the world. Designed and developed projects in the application which serves users across
the world from four regional centers in Redmond, PuertoRico, Singapore, and Dublin.
• Executed multiple project based on plan and provided plan vs actual data reports along with the technology
upgrade plans for the system
Page 2 of 6
• Designed and developed solutions to improve the performance of the highly available enterprise application
by 800%.
• A generic data model for collection and storage of data from different applications.
• Data migrations from set of legacy based application to fit the new data model.
• Migrated the services from unmanaged to managed code.
• Designed and developed a tier storage solution for files to save cost of storage.
• Created a deployment mechanism to deploy services to multiple servers with less manual intervention.
• Tuned multiple databases and developed phase in and phase out of schemas from systems.
• Designed and developed BI solutions, which had all stages in the ETL process and provided BI reports for
business users and created datamarts for consumption of data by different groups.
• Created physical and logical data models
• Created different algorithms to consumer different data feeds and designed the efficient storage
methodologies.
Technologies and tools VSTS,Visual Studio 2003,2005,2008, Sqlserver 2000,2005,2008,2010
Integration (SSIS)and reporting services(SSRS),Visio,Erwin,Http
Modules, Http Handlers,webservices,Sharepoint 2007
Systems Associate at Credit Capital Research Technologies, Pune, India Jan 2004 - 22nd Jul2005
• Designed and delivered multiple analytical solutions on time
• Created different data collection and distribution algorithms to provide a seamless, secured view of a
company from a technical and fundamental analysis perspective.
• Created data cleansing and monitoring mechanisms to alert specific events that needs to get captured and
reported.
• Architected and implemented a completely automated solution related to fundamental analysis and
technical analysis of companies related to stocks, bonds, CDS, Loans, and Indices.
• Worked on multiple applications to analyze risk return profiles for all traded instruments.
• Managed the requirements gathering and classification of them into multiple projects and assignment of
projects to appropriate resources, provided guidance as technical lead.
• Created design for storing information collected on daily basis and in cumulative forms.
Page 3 of 6
• Gathered requirements, proposed design options, assigned resources and scheduled the execution of the
project.
• Designed and developed an application that parses emails with no structure from different brokers,
identifies the patterns in the email text, filters and extracts meaning data used for hourly trend analysis.
Page 4 of 6
Technologies and tools VisualStudio2003,Sqlserver2000,Erwin,webapplications,windows
forms,Dundas Charting, ADO.NET, Active X
Software Development Engr at DigitalGlobalSoft (Now HP), Bangalore, India Sep2000 - Jan2004
• Worked as a technical support executive in supporting a Clarify CRM based application.
• Involved in analyzing and fixing of technical issues in the application which was implemented in all
European countries and Middle East.
• Developed an archive solution to provide data for different users in different countries based on the specific
requirements from each country.
• Tuned the system from a database perspective to make it more available and efficient.
Technologies and tools Clarify CRM, Sqlserver 7.0,Citrix server application,VB 5.0, ASP,
VBScript, JavaScript, IIS, HTML
Executive-Systems at Parrys Confectionery Ltd, Chennai, India Oct 1997 - July 2000
• Managed a team of developers to design and implement software applications required for the company.
• Gathered requirements, designed and developed a product trading application for the company outlets and
whole sale agents.
• Designed and developed applications which deal with inventory, accounting, sales and marketing for the
company.
• Provided inputs in implementation of a country wide network based application.
Technologies and tools Oracle 7.1,Forms,MsAccess,VB 5.0
Support Executive at Capital Market Ltd, Chennai, India Nov 1995 - Nov 1996
• Worked as a Trainee developer and support executive in a financial services company.
• Involved in daily data collection and consolidations from different data sources and loading of data to
different application specific formats.
• Developed tools for management of data, customer database and subscriptions management.
Page 5 of 6
Technologies and tools MSAccess,micro databases (FoxPro)
Education
Bachelor of Science (Physics) From Madras University, TamilNadu, India, 1995
GNIIT – Professional Computer Course
Certification
Microsoft Certified Solution Developer in .NET.
Page 6 of 6