Data Analyst Resume
Richmond, VA
SUMMARY
- Over 4 years of experience in Data Analysis and 2 years of experience Software Engineering, Production Management, Code Management, Development, and Deployment of various enterprise applications in USA, UK & India.
- Expertise in Web Intelligence documents, CA Business Intelligence Reports - Crystal & Universe reports in ITIL environment.
- Extensive experience in ad-hoc and persistent reporting using: MS SQL Server. Managed the database in RDBMS using SQL Query, Trigger, Joins & Transactions, DDL, DML via Microsoft SQL Server.
- Expertise in Java & J2EE programming using Hibernate, Struts and JDBC. Experienced in all phases of Software Development Life Cycle (SDLC) and Maintenance of the applications.
- Experience in developing SOAP web services and GUI by using tools like Confidential, AJAX, JavaScript and HTML.
- Experience of web application layers: Back-end technologies- Oracle 8i/9i/10g (SQL, PL/SQL, Stored procedures, Triggers, Joins, Views); Scripting (UNIX Shell, JavaScript); Front-end technologies- Java & AJAX, and Middleware- IBM WebSphere Application Server.
- Experience of working with Application Performance Management (APM) tool- Wily; Monitoring & Capacity Planning & Modeling tool- TeamQuest and Control-M application.
- Experience of Retail domain functionalities -Sales, Cash management, Goods advice, Ticketing. Knowledge of SalesForce CRM application
- Demonstrated project-leadership qualities and have ability to work collaboratively with cross functional team members. Provided mentoring and training to programming staff through multiple Knowledge Transfer (KT) sessions.
- Generated new ideas and coordinated for quick learning of new technologies to get the job done efficiently.
TECHNICAL SKILLS
CA Business Intelligence: Business Objects, Crystal Reports & Universe Reports
Relational Database: Oracle 8i/9i/10g, Microsoft SQL Server,PL/SQL
Web Technologies: HTML, VB Script
Productivity software: Microsoft Office- Words, Excel, Power-Point, Outlook
GUI/Tools: Aqua Data, Wily (Application Performance Monitoring tool), Putty, Toad
Operating Systems: UNIX, Linux, MS windows XP/NT/2000/7/8
Programming Languages: Java, J2EE, C/C++
Client end Technologies: JavaScript, AJAX
Application IDEs: IntelliJ, Eclipse, NetBeans, Eclipse
Aplication/Web Server: Websphere, Apache Tomcat, Glassfish
Monitoring: TeamQuest (Monitoring, Capacity Planning and Capacity Modeling)
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Data Analyst
Responsibilities:
- Led the team of the data analysts.
- Designed data collection formats and reporting systems. Created and executed dashboard reports including pilot dashboard reports.
- Scheduled, executed, exported and maintained report data Using CA web Intelligence.
- Made key decisions through evaluation of given data.
- Assisted in development and efficiency of data systems
- Entered and analyzed numerical and text data into databases in a timely and accurate manner.
- Managed the database in RDBMS using SQL Query, Trigger, Joins & Transactions, DDL, DML via Microsoft SQL Server.
Confidential
Data Analyst
Responsibilities:
- Created time-saving techniques to increase quality output in an accelerated time table.
- Created and executed dashboard reports including pilot dashboard reports.
- Scheduled and ran dashboard reports using CA web Intelligence.
- Exported and maintained report data.
- Managed the database in RDBMS using SQL Query, Trigger, Joins & Transactions, DDL, DML via Microsoft SQL Server.
- Remotely led the team of Data Analysts. Assisted in development and efficiency of data systems.
Confidential
SOFTWRE ENGINEER
Responsibilities:
- Created and executed dashboard reports including pilot dashboard reports using CA web Intelligence.
- Scheduled and ran dashboard reports.
- Added new material to file records and created new records
- Exported and maintained report data.
- Compiled and extracted requested files for clients. Organized forms, made photocopies, file records and prepared correspondence and reports.
- Created and managed database queries and triggers using SQL.
- Developed and created utilities in Java.
Confidential
PROGRAMMER
Responsibilities:
- Developed Web application for Client provided E-Commerce framework.
- Developed various UI (User Interface) components using Struts (MVC), Confidential, HTML.
- Developed the action classes, Action form Classes, Created JSPs using Struts and configured Struts-config, xml, web.xml files.
- Review, analyze, and modify programming systems, including coding, testing, and debugging
- Performed requirement analysis, and created complete storefront using Java and Oracle.
- Created, reviewed and Unit tested various Confidential modules before delivering to QA.
- Communicated with Catalogue Teams across the globe and supported the Integration testing.
Confidential
DATA ANALYST
Responsibilities:
- Managed the database in RDBMS using SQL Query, Trigger, Joins & Transactions, DDL, DML via Microsoft SQL Server.
- Aggregated, manipulated where legal, and maintained the database as required.
- Collected and analyzed the data, and created summary reports using programming tools.