Data Management
Resume:
Viju Sebastian
****@*********************.***
Summary:
Experienced Analytical professional with exceptional attention to detail and an appetite for problem
solving. Extensive background in implementing customized technologically advanced software
enhancements to business processes and information systems resulting in meaningful software
applications that support identified business goals.
Seeking a position where my professional experience, untiring work ethic, proven abilities, intuitive
interpersonal skills and requisite education will add similar or greater value.
Profile:
• Director of Business Intelligence for scalable integrated projects that use high volume
databases with complex data models that support critical corporate applications.
• IT Subject Matter Expert that provides cogent conclusions and sound recommendations with
emphasis on data integrity, data security, data governance and system capabilities. Ensure
consistent and up to date custom applications, incorporating next generation technologies,
industry standards, and best practices.
• Database Expert in creating scripts to upgrade and migrate data to new versions, to new
schemas, to facilitate data replication, to transfer, automate, scrub and load data. Skilled in
optimizing database performance and fine tuning inefficient queries and stored procedures.
• Application Architect skilled in requirement analysis, functional specification/design and Use
Case development, Software Design, Development, Documentation, Testing
Skills and Areas of Expertise
Technical: ; Data Warehousing; Message Brokers, SQL Server Service Broker; MDX and OLAP
Solutions w/Analysis Services and Reporting Applications: Crystal reports, Business
Objects and SQL Reporting Services; Analysis Services (OLAP) Cubes and Dashboards;
Proclarity; Microstrategy; Performance Point Server; Database Performance Tuning;
Stored Procedures, Triggers and Views; XML Data types and Spatial Data Types;
Strategy Companion Analyzer; Server Failover Applications; C# and VB.Net
Programming Languages; Microsoft SharePoint; Secure file transfer solutions on Unix
and Windows; Unix scripting; MS Visual Studio; SSIS Packages
Business: Business Intelligence Strategy; Master Data Management; Data Governance; Regulatory
Compliance; Functional Specification Design; Use Case Development; Software
Development Methodologies; Change Management; Software Applications Life Cycle
Processes; Application Deployment, Design and Development of Data and Process
1
Viju Sebastian
****@*********************.***
Models; Information Analysis Techniques; Data Analysis/Design/Gap Analysis; Business
Process Improvement; Multi Client Management; Disaster Recovery; Risk Management
2
Viju Sebastian
****@*********************.***
Education and Training
Cochin University Cochin, India
BS, Naval Architecture and Ship Design Technology 1994
Training
Implementing Performance Point Server 2009
Windows 7 Deployment 2009
SharePoint Development 2007
Current Employment:
Atlanta, GA
Director Business Intelligence
Code Ready Solutions May 2009 – Present
Strategic Business Intelligence team lead responsible for re designing, developing and implementing a
data warehouse and business intelligence solution from the ground up. The system extracts data from a
Customer Relationship Management (CRM) application and integrates data feeds from call centers, TV
media buyers, Google, MSN and Yahoo, Omniture and company’s internet applications. Design the
key performance indicators to monitor and influence the performance of television advertisements,
internet advertisements and direct mail campaigns. Lead the development team in database schema
design changes. Performance tune database hotspots. Optimize large volumes of data to minimize
impact of updates to production. Lead data migration efforts to migrate production data from legacy
system to new CRM system
• Build analytic tools and algorithms for purchasing TV Media for best performance.
• Measure returns on investment on ad spend and cost per acquisition.
• Use Neilson Claritas data to study the market and create successful targeted campaigns.
• Incorporate GIS data for improved site selection by layering historical performance and potential
customer bases.
• Integrate USPS API for data cleansing.
• Build OLAP cubes and dashboards to provide management complete access into company’s key
performance indicators.
• Build conversion funnel to analyze customer churn and take remedial action.
• Build call lists from the best customers for Multivariate and A/B testing.
• Forecast a customer’s propensity to buy based on psychographic analysis.
• Setup data governance and security initiatives to meet PCI and SOX compliance.
• Setup processes to aid in electronic discovery and reporting to regulatory authorities.
3
Viju Sebastian
****@*********************.***
• Create complex stored procedures to embed business logic into the data warehouse loading
process.
• Build software packages that automate the load of data to the warehouse and execute packages
with failure notification and generate reports on the status of data warehouse loads.
• Integrate data from Omniture into the data warehouse.
Professional Experiences:
Business Intelligence Architect Atlanta, GA
VCG Software Inc. July 2006 – May 2009
• Created Business Intelligence practice and designed re sellable Business Intelligence solutions
for complete product line of staffing software.
• Designed custom solutions for extracting data from proprietary financial systems, other time
keeping software and from other personnel management information systems into On Line
Analytical Processing (OLAP) cubes.
• Apply master data management principles to data migrations efforts for new customers and
existing customers undergoing mergers and acquisitions.
• Designed sales and profit margin activity reports and other corporate dashboard reports using
Reporting Services 2005.
• Designed and implemented architecture for improving application performance and scalability.
• Resolved performance problems at large customer installations.
• Conducted data analysis and multidimensional database modeling and design using SQL Server
Analysis Services.
Application Architect Atlanta, GA
Accenture, LLP June 2002 – July 2006
Client: BellSouth
• Designed applications for marketing department to analyze and improve effectiveness of direct
mail and print campaigns.
• Build and maintained the data warehouse to calculate sales commissions on all cell phone sales
and detect fraudulent purchases and returns.
• Maintained mission critical databases.
• Managed a coupon fulfillment application to validate coupons and sent data to the treasury to
print checks.
• Implemented change management procedures and brought applications into SOX compliance.
• Developed stored procedures geared for high volume databases.
4
Viju Sebastian
****@*********************.***
• Designed data extraction transformation and loading packages using DTS for various business
affiliates.
• Forecasted data growth and planned hardware upgrade/migration of mission critical systems.
• Setup data archival and backup schedules of production data based on data retention plans for
meeting legal and business requirements.
• Trained an offshore development team.
Application Architect Atlanta, GA
Platinum Technology Group Feb 2002 – May 2002
Client: United Way of Atlanta
• Application Architect for Speakers Bureau web application used to manage requests for speakers,
tours and campaign related corporate volunteer projects for United Way of Metro Atlanta.
• Architected, designed and developed the system in 3 tiers: ASP/C#/SQL Server
• Developed reports using Crystal Reports.Net
• Developed faxing application with VB.Net
Lead Developer Atlanta, GA
United Way of Atlanta July 2000 – Feb 2002
• Designed a database to interact with an existing web based fund raising application.
• Programmed stored procedures and business objects to be used from active server pages (ASP)
• Created the front end using VBScript and JavaScript.
• Integrated web reporting using Crystal Reports.
Database Analyst Atlanta, GA
GE Capital IT Solutions Aug 1999 – July 2000
• Created data warehousing solution to optimize and tune the performance of a Customer Care call
tracking system.
• Developed an application to switch over Customer Care Call tracking system with 300+ users to a
replicated database on a standby server in case of failure of the online server.
• Customized and implemented an existing web application for a new department and designed the
database, the web front end and the reports.
Database Administrator Atlanta, GA
Equifax Electronic Banking Solutions June 1998 – August 1999
5
Viju Sebastian
****@*********************.***
• Designed databases for Internet Banking System and Corporate Cash Management systems and
developed stored procedures, views and triggers to specification. Also created scripts for build
automation, migrations and loading configuration tables.
• Analyzed the Credit Card data structure on the mainframe system and implemented a data load
application for mapping and loading the credit card data.
Database Administrator New York, NY
Univision Television Jan 1998 – June 1998
• Designed databases and imported compiled data, created required views and generated
subsequent reports.
Systems Engineer
Mazagon Docks CAD Center. April 1994 Sept 1997
References available upon request
6
Contact this candidate