AVINASH NAGENDRA

Email: acgh86@r.postjobfree.com Mobile: 703-***-****

SUMMARY

Accomplished IT management professional with extensive background in directing data operations. Consistent record of account

management, business intelligence and data warehouse re-engineering to facilitate revenue growth. Expertise in business unit

management, application development and reporting systems alignment to enterprise goals. Adept at leading development and

launch of global systems.

AREAS OF EXPERTISE

1. Business Intelligence / Data Warehousing / IT Operations / Strategic Planning / Metrics

2. Data Management / Business Process Reengineering / Analytics / Reporting / Leadership

3. Systems & Application Development / Cross-Functional Team Management / Problem Resolution

PROFESSIONAL SUMMARY

1. CES – (Client: Jefferies Inc) – VP / Senior Manager, Technology Services (Jan

2013 – Present)

2. Western Union Business Solutions (WUBS) - Senior Data Architect / Manager

(Jan 2012 – Jan 2013)

3. Travelex Global Business Payments (TGBP) - Senior Data Architect / Lead DBA (Feb

2009 – Dec 2011)

4. Merkle Inc. - (Clients: SSI / P & G / Nike) – Database Consultant (May

2008 – Dec2010)

5. McCain Foods Ltd. – Product Manager / Tech Lead (Jan

2004 – Apr 2008)

6. Texas Tech University – Developer

(Aug 2000 – Dec 2003)

JOB HISTORY

CES (Client: Jefferies Inc) Jan 2013 – Present

Vice President/Senior Manager, Technology Services

Account and Delivery Manager Enterprise for Jefferies Inc, an Investment bank. Provide technology services focused in database

development, data integration, data analysis, data integration, application development.

Strategic DW/Credit Risk/CRS/GMI

Responsible for peering into the future with regard to data and databases for the Credit Risk Department.

Currently leading a team of up to 30 business developers and data analysts both On-Site and offshore dedicated to

enterprise BI and data warehousing programs within the Risk Management division of Jefferies, a 4B+ investment bank.

Established cross-functional relationships and directed all requirements gathering, data analysis and

documentation for enterprise projects to centralize risk data into a single multi-terabyte data warehouse with advanced

reporting.

Engage the business client early and effectively building solid relationships and pushing IT value upstream as key

business direction is being set. Collaborating with business partners to find alternatives and solutions to business challenges.

Facilitation of the IT planning and estimating phase, Managed the delivery of business cases, scope and

requirements documents, use-case documentation, test plans, and rollout communications

Act as primary liaison with program and Solution Management during the development lifecycle from needs

analysis and bug tracking to UAT and rollout. Developed compares for data analysis for moving the legacy CFO risk app to

GMI.

Developing and managing direct relationships with key stakeholders and subject matter experts to ensure the

business solutions are aligned with their goals and priorities, and how process automation through IT solutions will help them

reach their goals. Exercise independent judgment in developing methods, techniques and standards for obtaining solutions.

Created and maintained a cohesive, coordinated plan to deliver solutions that meet the stakeholders priorities

within budget and product requirements, Defined and gained agreement on a project budget, ensured project tracks to the

budget

Provide in-depth business & technical strategy for systems solutions, identify business gaps and correlate to

potential solutions. Made scope/schedule/resources (including budget) trade-off decisions with little or no guidance

Ensured line of business priorities and IT capabilities (technology and resources) are aligned

Ensured requirements are traceable, well communicated and aligned to the overall business or solution vision.

Gathered end-user data and reporting requirements and performed in-depth analysis of source systems, data and

complex business rules in order to build optimal solutions to meet the needs of our data consumers.

Environment: Oracle 11g/Informatica/Linux/Visio

Western Union Business Solutions (WUBS) Jan 2012 – Dec 2012

Senior Data Architect / Manager

Manager and Lead architect of Database Technology team responsible for the management, data architecture, data integration and

the design, development and implementation of the enterprise data platform to include, but not limited to the following:

Currency Trading application

Provided technical leadership and solutions architecture for large scale OLTP application.

Oversaw development, improvement, and management of trading platform, business intelligence reporting

services and data warehouse for provider of faxing, voicemail, and unified messaging solutions with over $180 million in

annual revenues. Administered $5M operations and capital budgets.

Supervised multi-departmental task force including DBA’s and Developers, Code reviews, change management,

including 11 direct reports. Carried out project planning, risk management, and implementation.

Created multi-department task force to resolve issues with data management infrastructure, formulation of

corporate metrics, and standardized reporting. Led design and launch of products.

Strong negotiation and consensus building skills when dealing with internal customers, stakeholders and team

members.

Understand current/changing business processes, participated in defining application and platform functionality

Responsible for all phases of the SDLC including gathering requirements, data/system analysis, data modeling,

ETL development, database development, testing, deployment, UAT etc.

Environment: SQL Server 2000/2005/2008/2012, DTS/SSIS, TSQL, Windows Server 2008, SSRS, MKS, Visio

Travelex Global Business Payments (TGBP) Feb 2009 – Dec 2011

Senior DBA / Technical Lead

Provided technology services focused in database development, data integration, data analysis, data integration, application

development and web content. Major projects include, but not limited to the follow:

Migrate SQL Server 2000 to SQL Server 2008, Travelex (TGBP)

4. Lead a Team of DBA’s and Developers in the migration effort to port SQL Server 2000 database tier to SQL

Server 2008.

5. Configured and tuned SQL Server 2012/2008/2005/2000 on all production, development, staging and

clustered servers.

6. Involved in Performance tuning for source databases, target databases using SQL server Profiler to generate

traces.

7. Ran Upgrade Advisor for upgrading and migrating data from SQL Server 2000 to 2008.

8. Relocated databases, architectural planning, backup and recovery and administration and maintenance of all

databases.

9. Performed database tuning and performance monitoring at the OS level, Application Level, DB and SQL

level (Logical and Physical I/O and Indexing). Ran Index tuning wizard and implemented Log Shipping.

10. Created various change control documents for Data migration and production changes.

Environment: SQL Server 2000/2005/2008/2012, DTS/SSIS, TSQL, Windows Server 2008, SSRS, MKS, Visio

Merkle Inc (Clients: SSI, Proctor & Gamble, Nike, ESPN) May 2008 – Feb 2009

Data Warehouse Consultant

Part of the Business Intelligence Technology team involved in the design, development and implementation of a large-volume data

warehouse. The design and development included dimensional data modeling, performance tuning, conceptual, logical, and

physical data models; PL/SQL development; ETL strategies; solving object-relational mapping challenges and mapping them to

implementation strategies and design (system/application architecture).

Data warehouse / Migration for Marketing/Campaigns/Reporting, Proctor & Gamble/Nike

Migrated SQL Server 2000 database tier to SQL Server 2005 32bit/64bit.

Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.

Monitor database growth activities & Troubleshoot Transaction Log & Space issues.

Performing the ETL operations to support the data loads and transformations using SSIS/DTS.

Good understanding of developing Data Ware house applications using star schema approach.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Provided project management services/expertise to business applications group responsible for enterprise systems.

Carried out a Proof of Concept (POC) test and documented the steps and activities to gracefully switch-over to the

standby server and operate for a week and gracefully switch-back. Study and build Body of Knowledge for support of

Applications.

Environment: SQL Server 2000/2005, DTS/SSIS, TSQL, Windows Server 2003, MS reporting Services

McCain Foods Ltd., New Brunswick, Canada Jan 2004 – May 2008

Product Manager /Technical Lead

As Product Manager, led team of 20 BA’s and software developers in different geographical locations. Lead the technology team

responsible for Administration, Analysis, Design, Development and Support of MS SQL Server 2005, 2000 and Oracle databases

in Production, Test, Development and Cluster Server Environments. Define the architecture for .Net/SQL Server applications and

Macola ERP Suite (including hardware configuration, support software, development tools and application architecture for both

client/server and web components). Managed full life cycle development of business intelligence systems.

Transportation Management & Reporting System, McCain Foods Ltd

1. Planned and carried out detailed analysis of existing systems and developed functional specifications, risk

plans, and acceptance procedures as well as direction of application and operating system upgrades.

2. Created Stored Procedures, Triggers, Views and Functions for the Application.

3. Installed, configured, developed and deployed reports on Crystal XI and SQL Server 2005 database.

4. Developed and deployed an Enterprise reporting solution using VB.net to generate dynamic Crystal reports.

5. Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.

Implemented automated backup, database maintenance plans and disaster recovery plans for production servers.

6. Ran Profiler Trace to troubleshoot database and DBCC consistency checks for other database maintenance

aspects.

7. Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks, Database Mirroring on SQL Server

2005.

8. Set-up Production and UAT database and Application environments for Load balancing and High Availability

Environment: SQL 2000/2005, TSM, DTS/SSIS, TSQL, Windows Server 2003, Citrix, VMWare, Crystal XI

Order Management System

Configured, tuned and supported (24 X 7) SQL Server 2005/2000 on all production, development and staging

servers.

Supervised multi-departmental task force, including 7 direct reports. Authored project proposals, defined scope of

work, and prepared cost estimates, schedules, budgets, and resource requirements.

Configured two Active / Active & Active/Passive Clustering setups for failover on production servers.

Installed SQL 2000/2005 Enterprise on Windows Server 2003 Data Center Edition on IBM blade Servers.

Performed all aspects of database administration, including data modeling, backups and recovery.

Configured Transactional replication between Primary Server and three Read-Only servers, with separate

Distributor server and troubleshooting replication problems. Maintained Operators, Alerts, Notifications, Jobs, Job Steps and

Schedules.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management

Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: SQL 2000/2005, TSM, DTS/SSIS, TSQL, Windows Server 2003, Vb.Net, ASP.Net, Crystal XI

Macola ERP Implementation

Implemented (Onsite), Installed and Upgraded Macola Exact 7.6.300 ERP.

Installed and Upgraded Macola to SQL Server 2000 from Pervasive SQL 2000.

Designed and developed the application UI and the Data Access Component in Vb.Net./ADO.Net

Constantly seek to understand client businesses and needs to improve and enhance the solutions offered to them.

This included installing windows cluster service, MSDE, MDAC 2.8 and SQL 2000 on Windows 2003 Enterprise

Edition.

Involved in the Daytime Savings Project (DST) research and testing of various patches.

Transitioned the acquired knowledge to the offshore team and coordinated with them.

Environment: MS SQL Server 2000, Windows 2003 Server, ASP.net, VB.Net, Macola 7.6.300/200

EDI Application

Designed a customized EDI application in .Net, for downloading data from various growers, who supply raw

produce to McCain. Data is sent from the grower’s own software system to McCain’s server, in the form of XML.

Developed SQL DTS packages to parse XML and download the XML into GMS (Grower Management System).

Planned database physical layouts and Object sizing for future growth and new projects in pipeline.

Provided support to the development team for database requirements through all stages of application

development.

Worked closely with business clients and software developers to obtain system specifications and requirements

and facilitate communication between technical and non-technical project team members.

Environment: MS SQL Server 2000, Windows 2003 Server, .Net Framework 1.1, ASP.net, C#.Net, VB.Net

Texas Tech University., Texas, USA Jan 2001 – Dec 2003

Research Assistant / Database Engineer

Worked as a Database Engineer for the University Technology Services

Integrated Reporting Solution / Patient and Payment Management System

Maintained Oracle Database systems for test, development and production in Linux environment.

Installed, configured and developed reports on MS Access 2003 and Oracle 9i database.

Monitored and managed Data files, Processes, Start up and Shutdown Instances.

Scheduled database cleanup scripts and nightly scripts on Cron.

Upgraded databases, Reorganized Database tablespaces, tables and rebuilt indexes.

Created Linux shell script for Cold Backup and restoration of databases and tested different recovery scenarios on

test databases. Maintaining and monitoring SQL Server Forms, Report servers

Environment: Oracle 9i, Linux, Crystal 9i, Java, ASP, SQL Server 2000

Education Training & Certifications

Master of Science – Management Information Systems Microsoft Certified SQL 2005 Administrator (MCP)

2002 – 2003 (Texas Tech University, Texas) Microsoft Certified Windows 2003 Administration Training

Master of Science – Industrial and Systems Engineering MCP (Web Applications using ASP.Net 2003)

2000 – 2002 (Texas Tech University, Texas)

REFERENCE AVAILABLE ON REQUEST

Contact this candidate