Project Sql Server

Ramesh Krishnan

***** *** ****** **, ****** MN **434

(********@*****.***)

763-***-**** (Home)

651-***-**** (Cell)

[pic]

MANAGEMENT INFORMATION SYSTEM EXPERT with over 17 years' experience.

Combines technical knowledge with strong business acumen to successfully

develop and integrate technologies to support broad-ranging operations and

organizational tactical and strategic goals.

BI Analytical Skills Computer Productivity Application

Ability to define problems Skills

collects data, establish trends Proficient in Project Management

and facts draw valid conclusions Methodology.

and communicate results Advanced Business Objects Universe

effectively. and Business Objects Report

Ability to interpret an extensive developer.

variety of technical instructions Advanced user of Compuware's

in mathematical or diagram form File-Aid, SQL developer and Data

and deal with several abstract Junction extraction transformation

and concrete variables in order and loading (ETL) tools.

to break complex issues into Advanced SQL Server Database

manageable parts. Administration and Database

Development.

Leadership Skills Strong in relational database

Effective listener and speaker. management systems such as DB2 and

Ability to perform effectively at Oracle.

both the individual level and Proficient in Avaya Operational

interdependent level. Analyst, Avaya IC Manager and CMS

Socially and culturally aware and telephony system.

appreciative of individual Knowledgeable of eTalk / Qfinitiy

differences. call center monitoring system and

Ability to operate tactically and analytic software.

strategically. Advanced user of Microsoft's

Flexible and adaptable. Visio, Word, Excel, Access,

Ability to manage multiple Microsoft Project, Outlook and

projects, delivering quality PowerPoint.

projects, on schedule, within Knowledgeable in Enterprise

budget using effective controls Architect framework (TOGAF and

and decisiveness. SOA)

Excellent people skills. Proficient in Microsoft SQL Server

Exceptional achievement in 2005 reporting solutions.

meeting and delivering customer (SSRS/SSAS)

needs. Practiced in all SDLC disciplines,

fluent in numerous business

Business Consulting functions, call center

Building solid relationships with technologies.

executives, business partners, Knowledgeable in COBOL, JCL, CICS,

clients, and vendors. EZTRIEVE, SAS, C, SQL, HTML, JAVA

Aligning business strategy with and Oracles PL/SQL Programming

IT services; crafting compelling Languages.

business cases; optimizing Qlikview Design and Development

project portfolios; developing

executable roadmaps.

Rich mix of business development

operations and create solutions

for operational efficiency.

Enterprise Data & Storage Mgmt - IT, Deluxe Corporation, Shoreview, MN

(2010 - Present)

. Reporting to VP of IT Infrastructure and Operations, responsible for

managing Deluxe enterprise data storage, backup and develop a

framework that includes standards and guidelines across all platforms.

. Build process and metrics and track process effectiveness overtime

include utilization, trend and forecasting the need to support

business operations.

. Leverage expert analysis and promulgate lean approach and team

empowerment that drives organizational improvements and insist best

practices.

. Overall decision making responsibility for data storage, backup

including DR initiatives and develop long term strategy to achieve the

IT Infrastructure and Operations goals.

Accomplishments:

. Managed the storage requirement for the new XMF platform also involved

in capacity planning which is still working as forecasted.

. Reduced backup processing time and the number of tapes there by

reducing cost overall to meet IT Infrastructure objectives.

. Implemented corrective measures to support batch operations, automated

file maintenance process to manage the file movement to provide better

performance.

. Reduced overall monthly service cost for UDS and UDP operations by

10%.

IT Relationship Manager, Deluxe Corporation, Shoreview, MN (2006 - 2010)

. Reporting to Director of IT Customer Relationship, act as a relationship

liaison with business group and IT development partners, analyze business

process and problems, successfully execute project that meets business

needs, facilitate requirement reviews, recommend appropriate

modifications, apply and direct efficient solutions and final project

approvals. Review User acceptance testing prior to implementation.

. Act as a BI Consultant for Sales & Marketing internal projects including

design of new systems and software for operational efficiency. This

includes gathering business requirements, translating into system

requirements by working closely with business partners and recommended a

2 year implementation road map for improving BI capabilities.

. Follow Project Management guidelines/Delivery Assurance framework to

manage multiple projects concurrently for Sales & Marketing within

project scope. Effectively communicate project status, process flows,

issues, and key decisions to project teams, senior management. Negotiate

and manage project scope, Identify, track and resolve technical or

business problems.

. Support SBS Sales & Marketing ongoing reporting requests such as

providing performance analysis and interpretation of key business results

within the call center relative to revenue generation, cost containment

and other performance needed to ensure the success of the business and

managing user acceptance testing prior to implementation.

. Assists in preparing the organization for contact center technology

advancements, advises internal business users and designs technical

solutions for business information needs.

. Defines the strategy for the applications within the scope of the team,

insures that the proper education is provided and makes sure that the

strategy is adhered to. This includes interfere with vendors in selection

and negotiation of software and hardware products.

. Work with IT professionals such as DBAs, LAN admin, telephony, security

and so on in the maintaining and upgrading of Contact center systems in

our environment.

. Significantly improved order entry process by integrating systems as well

as data from multiple sources to improve customer Satisfaction.

Accomplishments:

. Key accomplishments include execution of projects on-time within budget

following DA framework.

. Implemented self server Nuance IVR automated password reset system,

replaces helpdesk cost by 200k each month.

. Key accomplishments include reducing cost by 45% leveraging

Offshore/Onsite model, resulting in providing 24/7 development window.

. Reducing IT budget by 200k by identifying, commissioning out obsolete

software, and by consolidating software vendors by applying lean

techniques. Decommission eGain and eStara solutions on the e-Com

websites.

. Successfully migrated Contact center Incentive reporting system from MS

Access to Business Objects.

. Successful execution of migration of order entry system as well as

migration of data movement to the Enterprise Data Warehousing for the

contact center operations.

. Key accomplishments include upgrading from eTalk to Qfinity and eWork

Force Management application.

. Managed baseline budget for Sales & Marketing issues/enhancements.

. Consistently awarded quarterly IT Spotlight award winner in 2009

Database Analyst, Deluxe Corporation, Shoreview, MN (2003 - 2005)

. Act as an IT Data Steward for SBS to ensure the privacy and security

guidelines are met, appropriate access is granted as needed to perform

job duties. Assist in the development, implementation, and maintenance of

processes to assure compliance with Deluxe Corporation's privacy and

information policies and practices.

. Coordinate the implementation of Deluxe's information practices within an

assigned business or functional unit. Serve as the subject matter expert

and resource on information practices.

. Assist in preparing PIA make sure to complete a Privacy Impact Assessment

(PIA) whenever data of any type is being used for a product or service or

when negotiating a contract that involves the use of data.

. Identify, analyze, document and communicate end-user business and

technical requirements for SBS Customer Care. Specifically, assisting in

the definition of Measurement and Reporting group's business requirements

and bridging those requirements into technical specifications for

development.

. Develop, monitor and maintain databases for several Deluxe SBS Customer

Care departments resulting in reduced dependency for these departments on

other departments or external vendors to fulfill their ongoing database

and reporting requirements. Ultimately leading to a net reduction of cost

for the business as well as a quicker development cycle.

. Define data architect strategies that meet the business' needs and

follow best practices. These strategies include data and process modeling

that fit the overall business data model (within cost/benefit

constraints) and is recognizable to multiple applications and front ends

in order to fully leverage existing data sets.

Accomplishments:

. Key accomplishments include delivery of Agent performance reporting from

multiple sources such as Phone data, SAP employee data, and transactional

data.

. Delivery of multiple SQL server 200 reporting systems for the call center

operational needs.

. Develop strategies for improving the reporting and analysis environment.

. Ensure the privacy and security guidelines are met with IT and Business

strategy.

IT Consultant, iDlx Inc / eFunds IT Solutions, St Paul, MN (1997 - 2003)

. Managed Bsinet development team (Deluxe Corporation) in the development

and maintenance of high quality deliverables through the design and

implementation of a refined and repeatable process.

. Act as a Technical Lead for solving List processing requests, giving

ideas to business users, Design and develop reports for Marketing,

Accounting, and CMO groups.

. Gather Business requirements and engage Bsinet development team (Deluxe

Corporation) resources, assigning projects/tasks.

. Manage offshore support team, gather business requirements and provide

work direction for project/task deliverables.

. Communicate with the Business Sponsors and Business SME's, Identify gaps

and apply tactic solutions.

. Collaborate with Bsinet development team (Deluxe Corporation) members to

establish objectives and common goals and foster professional growth

through mentoring relationships and a focus on training and development.

. Analyzed and made recommendations to GE Capital Information Technology

Solutions disaster recovery plan.

. Assisted with internal support of the network and business system.

Programmer Analyst/Member Technical Staff, HCL Consulting, (1996 - 1997)

. As a Lead developer for Data Migration Project for SWEB (South West

Electricity Board) UK.

. Design and develop programs based on the requirements from Client.

. Review of Specifications received from the onsite counterpart, coding new

programs (both root modules and sub programs) according to the

specifications, Unit Testing, Integration Testing and Code Review

. Participated in QUALITY EDUCATION SYSTEM (Philip Crosby) at HCL

Consulting, Madras July.

Senior Software Engineer, SRIVEN Computer Solutions, (1994 - 1996)

. As an application developer, involved in maintaining the existing

software, it is basically a maintenance project of SEALAND Corporation,

one of the Leading shipping companies in USA.

. Assist in developing/coding new programs making code changes to correct

problems in functionality, resolving PITS (Problem Information Tickets),

Suggesting enhancements to Sealand Information Technology Managers,

Updating unstructured code to structured code and creating test data to

test changes that are being made. Learned Business logic and was able to

. Provide maintenance and 24- hour Production Support.

University of St Thomas, St Paul, MN

Master of Software Systems (MSS) (2008)

Govt of Technical Education, Kerala, India

Post Graduate Diploma in Computer Applications (1994) -- PGDCA

M G College, University of Kerala, India

Master of Science (MS) - Electronics Major (1991)

. Advanced Business Objects certification.

. MS SQL server reporting services certification.

. Cognos Reporting Certification.

. SharePoint certification.

. Completed 'CONSULGING WITH CLIENTS' training. This is an Overview of the

program and introduction to the primary models, basically learned the set

of tools consultants can use to increase their effectiveness.

. Completed training in Project Engineering Platinum tool, and learned more

about project management and understood how effectively manage a project.

. Completed QUALITY EDUCATION SYSTEM (Philip Crosby) at HCL Consulting.

Available upon request.

HIGHLIGHTS OF SKILLS

Core Competency

INFORMATION TECHNOLOGY EXPERIENCE

EDUCATIONAL QUALIFICATION

CERTIFICATION

REFERENCES

Contact this candidate