Sign in

Data Analyst

Jersey City, New Jersey, United States
February 07, 2018

Contact this candidate

P Shailaja Email:

SQL AND Data Analyst Contact: 732*******


To be a part of the challenging team which strives for the better growth of the

organization and which explores my potential and provides me with the opportunity

to enhance my skills.


Over 3+ years of experience in Database design and development of applications using SQL Server 2005/2008/2012 and MS Suit.

Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2012.

Experience with all phases of software development life cycle (SDLC) and project methodologies.

Created Tableau Dashboards on agile methodology with interactive views, trends and drill downs along with user level security.

Facilitated Agile and Scrum meetings, which included sprint planning, daily scrums or standup’s.

Excellent skills in implementing ETL Packages using Data Transformation and SSMS 2005/ 2008/2012/2014.

Worked on JIRA, Trouble Ticketing System for tracking and reporting issues.

Knowledge on GIS tools, performed graphical and spatial representation of data.

Experience in Importing/Exporting Data from various data sources like SQL Server, Excel, DB2.

Excellent hands on experience in creating groups, hierarchies and measures, KPIs.

Evaluated database performance and performed maintenance duties such as Backup, Restoration and Disaster Recovery.

Administered conversion of Microsoft Access reports into Crystal Reports.

Worked intensively on the Crystal Management Console and produced monthly report.

Performed administrative activities viz. installing, configuring and maintaining Crystal Reports Enterprise, Adding & Updating repository objects, Configuring Info View, etc.

Maintained and reviewed technical designs for development of reporting solutions.

Effectively worked on creating Interactive Media, Web Images and Graphics.

Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts and understanding of Data Mining, Data Warehouse Architecture and Designing.

Good knowledge on working and functionality of Integration services (SSIS) and reporting services (SSRS).

Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.



SQL, T-SQL, MySQL, C#, .Net, Visual Basic 6.0

Application Tools

Microsoft SQL Server Management Studio, GIS, Query Analyzer, Export and Import, Microsoft SQL Server Integration Services (SSIS), VB Macros, Visual Studio 2008/2010, Team Foundation Server 2008/2010, Tableau, Qlikview, SQL Server 2012/2008/2005, JIRA, Import/Export Wizard, BI Studio, MS Access.

Operating Systems

Windows Server 2008/2003/2000, Linux.

Business Tools

Word, Excel, PowerPoint, Access, Outlook, Visio, Team Foundation Server, Pdf.

Reporting Tools

Crystal Reports 8/10, SQL Server Reporting Services ( SSRS ), Tableau.

Modeling Tools

Microsoft Visio 2003/2007/2010, Toad.


New York institute of technology

Masters in Computer Science. (G.P.A 3.57/4)

Jawaharlal Nehru Technological University Hyderabad, India

Bachelor of Engineering in Computer Science Engineering (GPA: 7.0/10)

Education Dynamics, NJ

Data Analyst JUN 2017- NOV 2017

Working closely with the sales account management team in understanding client requirements and translating them to IS data setups.

Creation and maintenance of client data within their internal systems.

Setting up client campaign products in internal administrative systems and managing implementations from start to finish.

Analyzed the data from various data sources and maintained associated databases.

Monitoring data integrations with clients and assisting in troubleshooting issues.

Working on lead discrepancies such as lead flow, rejections and resolving the issues.

Developed dashboards that provide clear visualizations of industry -specific KPIs.

Use statistical methods to extract data and generate useful business reports.

Understanding and translating client data documents and specifications.

Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression.

Provided both internal performance reporting and web analytics (customer usage behaviors).

Developed interactive graphics and data visualizations of structured data, gathering information from web contents.

Processed data load requests, manually entered data, created data extracts and reports.

Created pivot tables and charts using worksheet data and external resources, modified and formatted pivot tables, sorted items and group data.

Designed, recorded, and executed macros to automate data entry inputs.

Working with other internal departments to meet deadlines and client expectations.

Extensive Knowledge and understanding of implementation cycle in sales and marketing modules.

Participated in the various troubleshooting process and data recovery, implemented the various data changes to the CRM.

Working with Marketing and sales department to develop reports that helped them to maintain better customer relationships.

Worked on JIRA, Trouble Ticketing System for tracking and reporting issues.

Formatted spreadsheets and workbooks for print, document reproduction, and presentations.

Managed project reporting, creating and maintaining project status updates.

Ensuring data and content meets all quality standards and company guidelines.

Strong attention to detail and Affirmative organization skills.

Environment: MS Excel, MS Word, MS Access, JIRA, MY SQL, Power Pivot, PDF, Tableau, SQL Profiler, Windows XP, SQL Server 2008 R2 Enterprise Edition, Windows 2003 advance server, Web analytics, GIS, MS SQL Server Management Studio (SSMS) 2008/2012/2014, Agile, Microsoft Visual source Safe, Microsoft visual studio Team Foundation Server, Tableau, XML and Windows.

New York Institute of Technology, NY

Data Analyst FEB 2016– NOV 2016

Conducted research to collect and assemble data for databases. Responsible for design/development of relational databases for collecting data.

Manipulating, cleansing & processing data using Excel, Access and SQL.

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.

Responsible for loading, extracting and validation of Data.

Importing and exporting of data between SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.

Assisted in the assessment, estimation and assignment of work for the End users.

Provided both internal performance reporting and web analytics. (e.g, customer usage behaviors).

Importing Excel spreadsheets into Crystal reports for better understanding of data, and converting them to PDF.

Created several data reporting processes from start to finish, which included the data mining, analysis and reporting pieces.

Performed Data Staging, Integrating and accessing information as a part of data warehousing.

Designed mapping templates and graphical maps for better understanding of data.

Used spatial analysis to identify sites for school projects.

Information yield – Made information graph introductions and coded factors from unique information, directed measurable examination as and when required and provided summaries of analysis.

Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.

Cooperated with external outsourcing for the design and development of analysis.

Environment: MS Excel, MS Access, Power Pivot, Crystal Reports, PDF, Windows XP, SQL Server 2008 R2 Enterprise Edition, Windows 2003 advance server, MS SQL Server Management Studio (SSMS), Windows 2003/2000.

Verizon, India

CS Technical Associate Jan 2014 – Jan 2015

CS Associate in Voice Process for (Verizon) at Tech Mahindra (Hyderabad).

Verify provisioning and diagnose device or Network issues. Troubleshoot for PC Operating systems, specifically Device Manager and TCP/IP configuration.

Use various administrative department tools and on-line resources for customer resolution. Use trouble ticket system for tracking customer interactions and problem resolution. Evaluate customer's concerns and resolve problems to the customer’s satisfaction.

Demonstrates and practices regularly, the skills necessary to handle any customer service and/or Technical Support call type that is routed through the center.

Environment: MS Office Suite, MS Outlook, MS Excel, Excel-pivot, Internal Ticketing system, Administrative department tools.

Natco Pharma, Hyderabad, India

SQL DBA Intern March 2013 – Dec 2013


Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Migration of databases from MS SQL Server 7.0 to MS SQL Server 2000.

Installation and configuration of MS SQL Server on Windows 2000/2003 Server.

Involved in designing of Conceptual Logical Model and Physical Model.

Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Installed and configured MySQL on Linux and Windows environments.

Involved in performance tuning and monitoring of both MYSQL and PL/SQL blocks.

Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

Administered conversion of Microsoft Access reports into Crystal Reports.

Created new forms in Crystal Report using Stored Procedures in SQL Server 2000.

Testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Environment: SQL Server 2000/2005, MYSQL, SQL Profiler, Visual Studio 2008, MS SQL Server Management Studio (SSMS) 2005/2008/2008R2/2012, DTS, HTML, T-SQL, .Net, Windows Server 2000/2003, UNIX.


Reverse Engineering Data Access Layer Generator.

Includes automatically generating Data Access Layer for accessing data bases.

Also generates Entity classes, stored procedures script, Audit tables and Triggers.

It is 100% .NET based code generation framework powered by Visual Studio 2008 and SQL server.

Game Application Using C# .Net framework.

Developed a 2 player game application for windows systems using C# and .net framework

Created A Dynamic Web Pages.

Created and designed dynamic web pages as a part of workshop on WEB DESIGNING using Html, Xml, CSS, Java script.


- Received a certificate on National Security system standards established by the (NSA).

- Participated in YAPPON event (app development) by Microsoft. Attended workshops on web designing and android affiliated to IEEE, IETE ISTE Student chapters.

- Volunteered and organized various technical events in college fests

*References available on request

Contact this candidate