Post Job Free

Resume

Sign in

Data Analyst

Location:
Grapevine, TX
Posted:
January 29, 2015

Contact this candidate

Resume:

Priya Hatle

**** ***** ********* ***** ****,Grapevine TX 76051

806-***-**** ( ( acn2r1@r.postjobfree.com

EXPERIENCE

Maintenance Net, Inc

Carlsbad

Data Analyst

Dec 2011 - Present

. Build ETL processes utilizing SSIS, SQL Server 2008 and FTP data from

location, transform it, map it to database and provide proper error

handling and alerting

. SQL database architecture design including create & modify tables, stored

procedures to develop processes

. Used query optimization techniques like table indexing by using SQL

Profiler and analyzing execution plans

. Worked with T-SQL, stored procedures, ETL mapping, SSIS

. Analyzed data to generate report based on requirements by using complex

SQL queries.

. Involved in ETL architectural design process

. Designed and developed database schema for new clients

. Worked with the Business Analysts on data requirements and mapping

. Handled and modified data import processes

. Fixed bugs in production environment

. Build test scripts and worked on peer code review

. Provided training and technical guidance to ETL team

Texas Tech University

Lubbock, TX

Graduate Assistant

Jan 2009 - Aug2011

. Maintain Texas Tech Civil Department website

. Assisted Professors with lectures, grading and presentations

Reliance Communications

Mumbai, India

SQL Developer

Nov 2006 - Nov 2008

. Plan, design, and implement database for new clients

. Determined and documented user requirements and worked closely with

system users to make sure design meets the requirements

. Worked with T-SQL, stored procedures

. Used SSIS for ETL processes

. Document processes

EDUCATION

Texas Tech University

Lubbock,TX

Masters of Science in Management Information Systems

2011

University of Mumbai

Mumbai, India

Bachelor of Engineering in Electronics and Telecommunications

2006

SKILLS

. Basic Programming skills: C#.NET, HTML, CSS

. Development Tools: SSIS, SSRS, Visual Studio 2008, Web Expression,

Talend

. Databases: SQL Server 2008, MS ACCESS, Mongodb

. Version Control: SVN, Mercurial

. Analytical tools: SAS, SAS-EM, SAS-EG

. Special Softwares/Tools: MS Project, MS Excel, Pivot tables, Macros,

Power point, Star UML



Contact this candidate