We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

4.00/5 (Submit Your Rating)

EXECUTIVE SUMMARY

Over 5 years of experience as a Data Analyst with large volume of data proficiency in relational database OLTP and data warehousing experience with expert level reporting experience in Access, Crystal reports and Business Objects, Extensively used Oracle 9i/10g/11g, SQL Server 2005/2008/2012, Access and Excel in all projects.

Proficiency includes:

  • Normalized and De-normalized Databases
  • Created Database and Table ER diagrams.
  • Also created Data Dictionary in Excel and in Oracle Database
  • Extensively worked on DML, DDL and DCL statements
  • Strong experience to gather data requirements.
  • Broad experience in Production support database including Physical and Logical Design of Databases Performed ETL process to prepare data to load into the database.
  • Altered and wrote SQL Views, SQL Script, Stored Procedures, Function and Triggers, Index and Sequence using PL/SQL and T-SQL.
  • Used, html, Visual Basic, UNIX and PuTTY .58 to maintain data files and run SQL Scripts, and Perl Scripts.
  • Excellent attention to detail and possess strong organizational skills Able to prioritize multiple tasks Skilled in conducting needs assessment, detailed analysis and problem solving Work well individually or as part of a team Excellent communication skills.
  • Find below my resume for your review. I am looking for opportunities to speak with you to discuss about my experiences in brief.

TECHNICAL SKILLS

Business Intelligence

Crystal Reports XI

RDBMS/Databases

Oracle 9i/10g, SQL SERVER 2000/2005/2008/2012 SQL, TSQL, PL/SQL, Procedure, Function and Trigger, Index and Sequence , Microsoft Access Query, Report and Form

ETL Tools

DTS, Import, Export, BCP, SQL Loader, SSIS,SSAS

Languages

SQL, TSQL, HTML, DHTML, C, C , VB 5.0/6.0, Java script

Operating Systems

UNIX, Windows NT/XP, WIN 2000

Data Modeling

Erwin 4.0, Visio Database Schema and flow chart

Applications

Toad, Visual basic 2005, Microsoft Excel Macros , PowerPoint, Word, Lotus Notes 8.5, Ceridian 5.50

Testing Tools

QC, Smart Bear ALM complete , HP Load Runner, Performance Center. IBM Rational Robot 7, Quick Test Professional QTP , Work soft Certify.

Bug Tracking Tools

Quality Center, Tracker and Bugzilla, Clear Quest, Jira

Network

Networked printers, WI-FI setups, Networked computers

WORK EXPERIENCE:

Confidential

Data Analyst

  • Any type of data issues are resolved based on the HR request.
  • Worked on HR data compensation, personal info, benefit eligibility, position
  • Support SQL server in the backend
  • Provide Support for the new OPEN ENROLLMENT benefit application
  • Worked on Backend of app and front end
  • Create issue log for app update
  • Create Test user for benefit enrollment app
  • Test HTML,GUI, .NET
  • Support offshore team app changes and feedback
  • Attend weekly meetings for the app update
  • Test Application from a user perspective
  • Daily Routines and ad-hoc request have been done using SQL and Access.
  • Create report using SQL Aggregate functions.
  • Create Table, Alter Table, and Update Tables.
  • Manipulated Data using DML statement Insert, update, Delete
  • Used UNIX VI to create monthly data folders and run SQL scripts using SQL plus
  • De-Dup data in tables
  • Worked on Employee data Update, alter, create view
  • Loaded manual data provided via CSV/Excel spreadsheets into SQL server
  • Export data from database.
  • ETL/SSRS,SSIS has been done Import data in staging server and prepare data to load into database Load data into SQL Server/Oracle from Excel, CSV, TXT and Access files Data integrity checks have done based on the business rules.
  • Worked closely with .Net developer to create and to write Procedure using T-SQL based on their need.
  • Created and modified Triggers based on the business rule.
  • I have Created SQL Views, SQL Script, and Function.
  • Conduct training, prototype business processes, develop solutions and services, and implement work plans Design and construct relational databases for web applications in SQL server 2008/2012
  • Create Access Form for end users to enter data.
  • Created Pivot table on gathered info. Created chart in Excel for upper manager.
  • Analyzed Data in Excel Apply Conditional Formatting and Sort Data in a Spreadsheet, Filter Data in a Spreadsheet and Apply a Formula
  • Presented Data in Excel Create Charts, Format Charts, Work with Illustrations, Share Excel Charts and Save Data in Presentable Formats
  • Created dashboard in excel by linking database query and importing data from different source.

Confidential

Data Analyst

  • Analyze OLTP and OLAP data in SQL Server 2005/2008 and Oracle 10g databases.
  • Made sure production data are up to date.
  • Any type of data issues are resolved based on the customer request.
  • Daily Routines and ad-hoc request have been done using SQL and Access.
  • Create report using SQL Aggregate functions.
  • Create Table, Alter Table, and Update Tables.
  • Manipulated Data using DML statement Insert, update, Delete
  • Used UNIX VI to create monthly data folders and run SQL scripts using SQL plus and Perl scripts for data check.
  • De-Dup data in tables
  • Export data from database.
  • ETL has been done Import data in staging server and prepare data to load into database Load data into SQL Server/Oracle from Excel, CSV, TXT and Access files Data integrity checks have done based on the business rules.
  • Worked closely with .Net developer to create and to write Procedure using T-SQL and PL/SQL based on their need.
  • Created and modified Triggers based on the business rule.
  • I have Created SQL Views, SQL Script, and Function.
  • Conduct training, prototype business processes, develop solutions and services, and implement work plans Design and construct relational databases for web applications in SQL server 2005 and Oracle 10g.
  • Create Access Form for end users to enter data.
  • Created Pivot table on gathered info. Created chart in Excel for upper manager.
  • Analyzed Data in Excel Apply Conditional Formatting and Sort Data in a Spreadsheet, Filter Data in a Spreadsheet and Apply a Formula
  • Presented Data in Excel Create Charts, Format Charts, Work with Illustrations, Share Excel Charts and Save Data in Presentable Formats
  • Created dashboard in excel by linking database query and importing data from different source.
  • Entered statistical data into excel of medical subspecialty and surgical subspecialty clinics
  • Organized statistical data into orderly fashion by dates and months.
  • Helped patients to answer their unique questions by web with the providers and track in Access database.

Confidential

Financial Data Analyst

  • Have done Logical and Physical data modeling
  • Created data dictionary and Metadata process
  • Create custom SQL scripts to extract data for internal division and external requests
  • Wrote Procedure and DTS package to load the data in Loans database
  • I have done Data mapping
  • I have set meeting with different department's mangers and gathered requirement
  • Assist to create Data Marts for secondary marketing with Dimension and fact table
  • Maintained SQL Server Data Warehouse, Retail Banking.
  • Created various Reports by pulling the OLAP and OLTP data from Data Warehouse like Sales of Product, By Region wise, Reports Based on time like Year, Quarter, Month, Week, Geographic reports and Comparative reports Created charts in Excel to display summary of the data usage
  • Check for data integrity and discrepancy
  • Responsible for all management reporting and interface maintenance.
  • I have provided business managers with operational business analysis for process enhancement.
  • Altered and modified table structure based on business need.
  • Generated reports on quarterly basis for Auditing done weekly, monthly, and yearly report using SQL, Access, and Excel.
  • Troubleshoot and rectify problems to maintain optimally functioning data management solutions.

Confidential

QA Analyst

  • Analyzed the business requirements and involve in the review discussions.
  • Was involved in dry run in every week for release updates.
  • Participated in high level design sessions. Detected, reported and classified bugs in ALM complete.
  • Participated in the QA activities for various releases in the Project.
  • Performed System and Integration Testing.
  • Log Defects based on requirements in ALM complete
  • Find bugs beyond requirement and discussed with developers
  • Drafted test cases based on Functional Specifications and System Specifications.
  • Prepared of Test Plan and analyze integration system impacts.
  • Involved in Manual Testing of the application for Negative and Positive scenarios.
  • Mentored the team members with business functionality.
  • Performed the Regression Testing to make sure that the bug has been fixed and the application was running properly.
  • Used ALM complete for managing test execution and defect tracking of all issue.
  • Extensively involved in executing, analyzing and verifying test results and worked with developers to resolve issues.
  • Communicated project business issues to appropriate business leadership groups.
  • Master Object Repository is maintained in the central repository and changes are made to it for every version.
  • Wrote SQL statements to extract Data and verified the output Data of the reports.
  • Prepared Requirement Traceability Matrix RTM to establish traceability between requirements and test cases.
  • Modified and maintained test cases due to changes in the requirements.
  • Conducted internal and external reviews as well as formal walkthroughs, and provided feedback in status meetings.

Environment: Windows Server 2003, 2005, Java, Java Script, HTML, UNIX, SQL server, Web Logic, ALM complete, HP Quality Center, PVCs Tracker, Charles, fiddler, chrome.

Confidential

Networking/ Computer Tech

  • Configured and maintained networks Updated hardware/software and expanded memory
  • Troubleshot hardware, software and network problems Repaired cables/ computers
  • Helped student with Access project and Excel Visual Basic Applications
  • Setup databases for Employee, Facility, Vendor and Payroll data
  • Extensive use of Stylist, Personate, and AccuMail to cleanse data and map zip codes to 9 digit codes for zip to district matching
  • Automate data load processes with design and implementation of data transformation services DTS packages
  • Perform database backup, performance optimization, and database maintenance
  • Provide technical support for database related problems and troubleshooting back-end issues
  • Participate in the design, execution, and ongoing maintenance of disaster recovery and high availability planning
  • Process client requests using data mining tools in Visual FoxPro, SQL Server, and MS Access. Design and create custom reports using Active Report Writer
  • Implement T-SQL data access methods and processes stored procedures, views, triggers

We'd love your feedback!