Sql Server Customer Service

A JAY B ELE

C: 318-***-**** ********@*****.***

BUSINESS INTELLIGENCE PROFESSIONAL

Microsoft BI Development Client Communication Business Analysis

Highly motivated and experienced BI professional with expert proficiency in the design and development of SSAS, SSIS,

and SSRS solutions in a dynamic, fast paced corporate environment. Comprehensive understanding of the skills needed

to engineer rapid, innovative solutions narrowly tailored to resolve outstanding business needs. Skilled in establishing

positive relationships with clients to ascertain business requirements. Regarded for the ability to deliver outstanding

customer service with respect to all support and post project, post migration issue resolution. Intuitive person with

outstanding analytical skills required for delivering cutting edge BI Solutions.

SQL Server Analysis Services Excel Services

SQL Server Integration Services Database Programming

SQL Server Reporting Services Performance Tuning

MS Office/PerformancePoint KPIs/Scorecards/Dashboards

Business Intelligence ETL Architecture

Business/Systems Analysis Agile/Scrum Methodology

P R O F E S S I O N A L E X P E R I E N C E

NTT Data Inc., Chicago, Illinois (2011 Present)

Principal Consultant

As a representative of the company that provides Enterprise level leading edge solutions I was committed towards keeping

our customers satisfied by putting their needs first and providing custom solutions. My initial engagement is with

Redbox,Americas destination for Movies and Video games with 40,000 locations Nationwide, the company is renting

more than 2 billion discs to date. At Redbox I provide consulting services to the Data Integration/ Business intelligence

department. I took up some major responsibilities here to keep up with their rapidly growing business and innovative

initiatives, my Major accomplishment being Architecture/Design/Development of Customer Database. This was considered

the most pivotal project, the centralization of the customers and their transaction data was key for all the future

initiatives .Carefully balanced project deadlines to offer a consistent level of success in achieving both short and long term

milestones. Fulfilled a key role as subject matter expert for Customer Profile data. Also played key roles in several other

optimization projects and achieved scalability of rapidly growing data in Financial and Marketing data marts. Designed

some very competitive solutions to help marketing team identify the trends and adopt optimal marketing approaches

Achievements

Centralization of Customer data of both online and kiosk users.

Effectively played the role of Business Analyst to fulfill business needs.

Architected complex ETL and Database Solutions

Make Efficient use of Microsoft BI Suite to provide solutions to various business sectors including Finance,

Customer Care and Marketing.

Lead the project to upgrade SQL Server Database and BI Components from 2008 to 2012.

Played a key role in integrating and catering for multiple LOBs of the parent company Outerwall.

Third party integration through effective transmission of information back and forth via SFTP File transfers

CAREERBUILDER, Chicago, Illinois (2008 2011)

BI Data Warehouse Developer(Finance)

Developed innovative, targeted solutions to satisfy the analytical and reporting needs of the largest online employment

website in the United States, with more than 23 million unique visitors each month and a 34% market share . Engaged in

extensive consultation with clients to ascertain business needs and formulate approaches for resolution. Carefully

balanced project deadlines to offer a consistent level of success in achieving both short and long term milestones.

Fulfilled a key role as subject matter expert for Business Intelligence concepts. Executed Database/ETL architecture and

design to enable calculations and rules to be applied to populate sales data. Extensively tested disaster recovery

mechanisms for all data warehouse servers. Conformed with the Lean and agile methodologies practiced in the company.

Leveraged the latest Microsoft products and created solutions that helped users perform interactive analysis

Achievements

Fulfilled a key role in delivering a Sales Stats Application that provided instant insight into various sales metrics,

Customer and Activity information.

Applied technical expertise to translate business rules into code using complex SQL queries.

Design and develop SQL Server Integration Services packages to address ETL needs.

Create Cubes using SQL Server Analysis Services to provide a platform for Business users.

Developed SQL Server Reporting Services reports in integration with SharePoint technology.

Lead the project to upgrade SQL Server Database and BI Components from 2005 to 2008.

Created Scorecards and Dashboards that included KPIs to provide at a glance visually intuitive snapshots.

RUSH HEALTH ASSOCIATES, Chicago, Illinois (2007 2008)

ETL Architect and Developer

Responsible for the design and development of ETL (Extract, Transform, Load) jobs to load the Enterprise Data

Warehouse of Rush Health Associates, a nonprofit corporation whose members comprise hospitals, physicians, and allied

health providers. Collaborated with the data architect to provide input on database design. Engaged in consultations with

clients, as well as exchange of written documents, to clarify and define business requirements. Produced a complex

design document for the ETL process. Translated business needs into innovative database programming approaches

involving SQL, Transact SQL, Stored Procedures, Triggers, Indexes, SSIS Transformations, and Views.

BOWATER INCORPORATED, Greenville, South Carolina (2007 2007)

ETL Developer

Oversaw the preservation of critical data integrity on a strict deadline during the merger of the Bowater and Abitibi

companies. Ascertained business requirements and formulated technical specifications to address specific and critical

needs within a short timeframe. Enabled a variety of other packages to perform ETL jobs by implementing a generic SQL

Server Integration Services package, and modified SQL Server Integration Services to build specific packages that

were flexible and portable between environments. Executed a myriad array of other database development tasks,

including creating Tables, Indexes, Triggers, Views, and User Defined Functions on SQL Server 2005.

DOLLAR THRIFTY AUTOMOTIVE GROUP, INC., Tulsa, Oklahoma (2006 2007)

Senior Programmer and Analyst

Directed all aspects of a project designed to transfer legacy data to an SQL Server database, empowering users to access

data faster than before and to produce a variety of reports. Consulted with users to determine daily and monthly reporting

requirements for the new system. Interviewed clients and studied documentation to understand the architecture of the

legacy data and its relationship to the requirements. Designed and created the new database structure which would store

and manage the data, including the design of Tables, Indexes, and Stored Procedures. Used SQL Server Agent to

schedule daily and month end data transfer jobs. Handled all post migration issues.

CITY OF CHICAGO, Chicago, Illinois (2005 2006)

Software Developer

Developed reports for a Homeless Management Information System (HMIS) for the City of Chicago. Met with clients to

establish reporting requirements and parameters, resulting in the preparation of outlines and specifications for three types

of reports. Formulated rules designed to alert clients to duplicate entries in the HMIS system. Developed database

objects, including Tables, Indexes, Clusters, roles and privileges. Promulgated templates using HTML and JavaScript.

LOUISIANA TECH UNIVERSITY, Ruston, Louisiana (2003 2005)

Graduate Assistant

Charged with the design, development, and ongoing maintenance of all university database applications.

T E C H N I C A L P R O F I C I E N C I E S

Development Environments: SQL Server (All Versions from 2000 to 2012) SSIS, SSAS, SSRS, SQL Management

services, Data Transformation Services, Visual Studio 2005 to 12, Microsoft Excel, Microsoft Access, SharePoint,

PerformancePoint, Microsoft Word, Visual Source Safe, TFS, Windows, ERWIN, JavaScript.

E D U C AT I O N

OSMANIA UNIVERSITY, India (1999 2003)

B.S in Engineering(Mechanical)

Contact this candidate