Chandana Mukka

. Edison, NJ . H - 732-***-**** . M - 409-***-**** .

acebnx@r.postjobfree.com

Objective

To apply and hone my talents constructively in an organization where

excellence is pursued, sincerity is appreciated and performance is

rewarded.

Summary

V 9 years of software industry experience

V Adept at development, support and maintenance of SQL Server Database

applications including business logic, workflow, data transformation

and reporting

V Proficient with SQL Server advanced database concepts and techniques

including stored procedures, indexes, triggers, permissions, error

handling, execution plans, DTS, SSIS, SSRS etc

V Experience in analysis, design and construction of Data warehouses

V Profound understanding of software engineering and automation concepts

including all stages of software development life cycle (SDLC)

V Accomplished in applying best practices and providing automation

recommendations and strategies

V Intelligent, ardently scrupulous and keenly communicative

Education

Master of Computer Science (3.8 GPA, summa Lamar University, Beaumont,

cum laude) TX (2002)

Bachelor of Chemical Engineering (First Osmania University, India

Class) (2000)

Awards and Merits

. Recipient of Academic excellence scholarship, Lamar University,

Beaumont, TX (2000-2002)

. Recipient of Upsilon Pi-Epsilon (Honors Society) membership for

academic excellence

. Member of ACM and participated in ACM South Zone Programming contest

(2001)

. Placed in Top 5% in National Talent Search Exam in Science, India

(1993)

Skill Summary

Programming Languages C, C++, Java, VB, VBA, VB.NET, C#, ASP

Operating Systems Windows, Unix, Linux

Databases SQL Server 2008/2005/2000/7, Oracle 8i/9i, Sybase,

MS Access

Reporting Tools SQL Server Reporting Services (SSRS), Crystal

Reports, Cognos Impromptu, MS EXCEL

ETL SQL Server Integration Services (SSIS), Oracle

SQL*Loader

Other Technologies ERWIN, SQLCMD, Agile

and Tools

Professional Experience

TheLadders.com, NY Mar 2010-Jun2010,

Nov 2010-May 2012

SQL Server/ Database Analyst - Business Intelligence

My primary tasks at TheLadders.com involved database programming to

support the creation of ad-hoc reports in order to facilitate critical

business decisions. Reporting was performed against the

statistical/analytical database which has a typical lag time of 3 hours

from the main transactional database. The database size is in excess of 2

TB requiring precise and finely tuned queries and procedures.

Create complex analytic queries on large data sets

Create stored procedures, triggers and functions

Generate code to extract, transform and load data from production data

sources to the data warehouse

Maintain uptime demands on the BI system

Query optimization and database performance tuning

Design and Implementation of Web Traffic Tool Database (similar to

Google Analytics) for use by Corporate Business. Also responsible for

populating and updating the Web Traffic Tool database with current

statistical and historical data.

Create OLAP data Cubes for reporting

Create Dimension and Fact tables required to create the cubes

Production support for all the reports built by BI team

Environment: SQL Server 2008, CLR (C#), Agile, Visual Studio 2008, EXCEL

2007, ProClarity 6.0, SourceGear Vault

Israel Discount Bank of New York (IDB Bank), NY July 2010 - Oct 2010

SQL Server Developer/Analyst

IDB Bank provides domestic and international, personal and commercial

banking services to its U.S. and foreign clients. I was part of i-Series

Relocation Project which involved the migration of internally maintained

mainframe server to be maintained by Fiserv. While Fiserv handled the

ICBS the core banking system application all the other applications and

interfaces were to be maintained internally.

Research, analyze and document the processes/interfaces that communicate

or depend on the Core Banking system.

Changes to DTS Packages to use OLEDB connections (instead of ODBC)

Create new or modify existing batch/VB scripts (to ensure the data in/out

to ICBS mainly FTP)

Document all the changes and migration process for the go-live day

Responsible for all the development, integration and QA Testing the

interfaces and validating the data/transactions

Worked with several Banking applications like BankTrade, LoanIQ, ICBS,

Web and .Net applications

Environment: SQL Server 2000, SQL Server 2005, DTS, DOS Batch Scripts, VB

Scripting, FTP, Excel

L'Oreal USA - Luxury Products Division, NJ Jan 2006 - Feb

2010

Lead SQL Developer / Software Developer

The goal of Fusion-Legacy Migration Project was to migrate existing the

ERP Infrastructure to SAP Landscape. Fusion-Legacy Development team was

responsible for remediating the dozens of legacy applications to work in

new SAP environment. Also make changes to all existing front end and back

end applications to incorporate the new business hierarchy.

Design and create new databases

Plan, design and implement database code objects such as stored

procedures, SQL Jobs, triggers, functions etc. to support business

applications and data maintenance.

Debug, analyze and troubleshoot database coding to support and maintain

existing functionality.

Customize and maintain the Atlas Sales Forecasting Tool as per business

requirements

Build and maintain ETL processes using DTS, SSIS and T-SQL for the

following

To assimilate data from disparate sources and load it for use by sales

forecasting system.

Transform and export data following user manipulation as feed to the

finance forecasting system.

To read data in out of POS Reporting Data Warehouse (star schema)

Building business reports using Crystal Reports XI, SSRS, EXCEL(Pivot

Reports) .

Work with business users, application developers and support teams to

identify business needs, discuss solution options and document

requirement analysis.

Ensure application of best practices through documentation, code reviews,

change management and quality assurance.

Designing, developing and maintaining dozens of legacy applications

including order processing systems and those managing millions of dollars

of product allocations using VB, ASP and, C#, VB.NET.

Build and modify applications to accommodate changes resulting from

migration of legacy systems to SAP.

Assisted business by writing EXCEL VBA code and using macros to automate

manual processes to speed up and maximize the accuracy.

Also as part of production support team supported was responsible to

maintain all the front end and back end applications, software and

investigate all the data related issues.

Environment: SQL Server 2000/2005/2008, Oracle 8i/9i, SSIS, SSRS, SQLCMD,

Crystal Reports XI, Atlas Sales Forecasting System, Remedy Change

Management, MS Access, MS Excel, VBA, VB.NET, C#, VB 6, ASP, XML

Coach USA, NY Jan 2005 - Dec 2005

SQL Developer / Software Developer

HR/Payroll Departments at Coach used Ultipro HRMS System for Recruitment,

Benefit Enrollment, Tax Filing & Wages, Salary & Compensation, Payroll

etc. Also Kronos System was used for Time keeping and Labor Management.

MS SQL Server 2000 was the back end database for all the applications and

development.

Administered and configured Ultipro HR System, Kronos and Mercury Quality

Center.

Plan, design and implement database code objects such as stored

procedures, triggers, functions etc. to support existing HR and Payroll

systems.

Build and maintain Data Interfaces and ETL processes for data

transformation and movement for vendors.

Identify, analyze and resolve data incompatibilities in data

communications.

Work with business users, application developers and support teams to

identify business needs, discuss solution options, document requirements,

specifications and design.

Ensure application of best practices through documentation, code reviews,

change management and quality assurance.

Created, modified and optimized business reports using Cognos Impromptu

and EXCEL.

Developed several Excel Templates to automate the business process using

VBA and Macros.

Developed applications using VB, VBA and MS Access to clone the

functionality and UI of Pro Business and Power Source systems to

eliminate training and support overhead incurred due to discontinuation

of the above systems.

Environment: SQL Server 2000, MS Access, MS Excel, VBA, Cognos-Impromptu,

Mercury Quality Center, Ultipro, Kronos

Moody's Investors Service Oct 2004 - Dec 2004

Lead SQL Developer

Built complex ETL processes for data transformation and migration from

legacy systems to PeopleSoft.

Work with PeopleSoft implementation team, business users and business

management to identify and document requirements.

Propose and discuss solution options with business and PeopleSoft

implementation team.

Ensure application of best practices through documentation, change

management and quality assurance.

Environment: SQL Server 2000, Sybase

MineTech, Inc, NY Sept 2004 - Oct 2004

SQL Server Developer

MineTech is an international marketing analytics firm. They are a leading

data mining and modeling company that specializes in helping companies

uncover information stored within their data.

Data migration from Legacy Systems

Design and develop ETL workflows to be used for data mining

To load the interface files from various sources into the staging

database and transform the data by applying all business logic and load

them to the Data Warehouse

Environment: SQL Server 2000, DTS, Oracle SQL*Loader

Four-D Software, Inc, TN Feb 2003 - Aug 2004

Lead Software Engineer

Medatrax Cases / Evaluations is a web and PDA based data tracking product

specifically designed to assist Nurse Anesthesia university programs and

is being used by over 30 major universities. It allows students to track

data for sets of class, student or program criteria. Administrators can

create a variety of reports and monitor individual student and class

progress.

Proposed and discussed new enhancements and solutions based on customer

feedback and company vision.

Performed detailed requirement analysis and documented upgrade

specifications, managing and documenting incremental changes.

Designed and implemented new product version based on requirement

analysis, enforcing best practices and quality assurance.

Performed DBA tasks such as Database Backups, Restore, Configuring

Disaster Recovery backup SQL Server, Security

Production support for all the applications

Diagnostic Neurology Departmental Administrative System (DNA) is a system

for tracking patient transcription and order processing.

Provided database coding to support various functionality enhancements

Provided application coding for incremental product versions with new

features, functionality and bug fixes.

Created various application reports using Crystal Reports.

Created linked server and distributional queries to access data from

Oracle system

Environment: SQL Server 2000, Crystal Reports, ASP, VB, IIS Server,

TogetherSoft 6.0, Windows 2003 server, CASLSoft 4.1

Lamar University, Beaumont, TX Jan 2001 - Dec 2002

Graduate Assistant

Recreational Sports, Lamar University Department need a system for

maintaining and validating information of semester passes issued. Also

this new system was to handle four different categories of users and

coordinated several facilities of the same.

Followed the Software Development Life Cycle (SDLC) through the Project

Designed and Implemented a database to handle the entire student and

staff/faculty of Lamar University

Designed and implemented user interfaces and data reports using

Lamar Institute of Technology

Programmer

Enhanced and maintained web site of LIT

(http://www.theinstitute.lamar.edu)

Updated and built additional web pages

Environment: VB 6.0, SQL Server 7, MS Access, Java, Java Script, HTML and

DHTML

Contact this candidate