Sr. Data Analyst Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

PROFILE

Results-oriented IT professional with 10 years industry experience and accomplished at combining analytical and exceptional problem solving skills. Highly analytical and inquisitive; a team builder with a can-do attitude and a passion for excellence. Seeking opportunities as a Bsuiness / Data Analyst in San Francisco Bay Area (local candidate).

SUMMARY

·         Proven track record in providing data analysis and business intelligence reporting solutions with exposure to all phases of development life cycle from gathering and translating business and functional requirements to developing, testing and implementing business solutions.

·         6+ years of working experience in SAP BusinessObjects reporting and analytical solutions.

·         Expertise in querying, optimizing, debugging and testing complex SQL queries including analytic functions, triggers, subqueries etc  in various relational databases such as DB2, MS Access, My SQL and Oracle (IBM Certified DB2 9.0 developer cum administrator)

·         Good understanding of the Data ware house concepts such as fact and dimension tables, star schema, snowflake schema.

·         Proficient in Excel including functionalities related to VLOOKUP, HLOOKUP, Pivot tables and charts, extracting data from External data sources, creating parameterized query templates etc.

·         A persuasive communicator who can "tailor" arguments to different audiences.

·         Proven track record at identifying the key elements involved in a business situation and analyzing them (both logically and quantitatively) to arrive at a decision; able to be objective and flexible in generating and evaluating ideas.

·         Proven success in contributing to a team-oriented environment and to work creatively and analytically in a problem-solving environment.

EDUCATION

Duke University, The Fuqua School of Business, Durham, NC                                             

Master of Business Administration (Weekend Executive Program), Dec 2011: Finance Major

NATIONAL INSTITUTE OF TECHNOLOGY, Warangal, India.                                                                              

Master of Computer Applications, June 2001

PROFESSIONAL CERTIFICATIONS

·         IBM Certified Database Administrator, DB2 9.0 for Linux, Unix and Windows

·         IBM Certified Application Developer, DB2 Universal Database V8.1 family

ACCOMPLISHMENTS

·         Developed an Award winning Technical video on “File-Aid – A file management tool” that was published in IBM Global Library – Year 2009.

·         Recipient of ”IBM BRAVO” for the dedication, commitment and team leadership skill – Year 2006, Year 2004

·         IBM Certified DB2 Application Developer, DB2 Universal Database V8.1 family

EXPERIENCE

Sears Home Services, Chicago, IL                                                                                                                        

Sr.  Data Analyst                                                                                                                                 April 2011-Feb 2012

Sears Home Services (subsidiary of Sears Holdings Inc) provides various residential and commercial services such as Installation, Repairs, Maintenance, Home Improvement and Cleaning for all major brands of products such as home appliances, lawn and garden equipment, home electronics, and floor-care products

Responsibilities:

·         Involved in the functional requirement gathering from the business users, application development team & database teams and translated the reporting needs into reporting specifications.

·         Provided first line support activities for all the customer reporting needs and user adhoc requests.

·         Performed the root cause analysis by querying and analyzing the multi source databases (Access and Oracle) for the data inconsistencies and provided alternative and corrective measures for the data discrepancies.

·         Represented the reporting team in the bi-weekly business meetings for aligning the priorities for high impact business needs and providing greater project visibility for all stakeholders.

·         Created parameterized query templates that generate Excel charts, Pivot tables and summary charts by extracting the data from the Access for the frequently recurring user requests.

·         Developed and maintained the BusinessObjects Universes and WebIntelligence Reports.

·         Created standard WebI reports that include Drill Down, charts, cross tab features for some of the most frequently requested requests and scheduled them to be run on a periodic basis based on the user needs.

·         Worked extensively on various functionalities under data foundation layer with in universe designing – Linking Universes, resolving Loops through usage of aliases and contexts, performing Integrity checks and resolving the conflicts, creating joins and cardinalities.

Technical Environment – Business Objects, Oracle, MS Access, Excel

NAVISTAR INC, Warrenville, IL                                                                                                          

 Sr.  Business Data Analyst                                                                                                                 May 2008 - Mar 2011

Navistar, Inc is a leading manufacturer and marketer for medium and heavy duty trucks and mid-range diesel engines. Inventory Management Systems captures information related to the inventory transactions including ASN Receiving, daily and weekly requirements, production progress, Cycle counting, inter plant ordering and line setting the jobs for each of the seven plants.             

Responsibilities:

·         Participated in the project planning sessions with project managers, business users, and team members to analyze the reporting requirements, and outline the proposed solutions.

·         Created technical design document detailing the data mapping, data conversion, data validations, file and field level mapping for the reporting requirements.

·         Analyzed the relational databases (Oracle, DB2, and MS Access) to provide detailed analysis for some of the internal and external (KPMG) audit related queries on a periodic basis. 

·         Designed and built a fully automated reporting process by creating Excel templates that refreshes the data directly from the DB2 tables. This replaced a manual intensive process that reduced the management effort by 60% and provided greater flexibility to generate customized management reports.

·         Performed root cause analysis and implemented novel solutions for 25 recurring production issues that reduced the maintenance effort from 60% to less than 20%.

·         Provided the design solutions in the reporting needs that helped reduce the Cycle counter processing time from 4 hr / day to less than 10 min per day.  

·         Interacted with the end users and client management team in resolving the production issues.

·         Supported, maintained and managed the Universes and Web Intelligence documents in the enterprise repository.

·         Chaired weekly multi-team cohort meetings with remote and local teams to ensure effective collaboration and sharing of resources. Built consensus and drove deliverable schedule for sister teams.

·         Designed and developed various standard and canned reports, drill down reports, cross tab reports and summary reports in WebI.  

Technical Environment – Business Objects, Oracle, MS Access, DB2, Excel

PRUDENTIAL INC, Scranton, PA                                                                                                         

Technical Lead                                                                                                                                    Jan 2005- April 2008

Annuitant Benefit Consolidation Systems maintains and tracks the defined benefit plans and the annuitant information. In addition, the system is responsible for calculating period annuitant payments and send feeds to PRISM for generating the checks to the annuitants.

Responsibilities:

·         Performed synergies and gap analysis between the status quo and proposed system to merge Prudential and Cigna Defined Benefits plans.

·         Created updates to the Conceptual, logical and physical data models to the existing prudential DB 2 databases for handling the CIGNA data. 

·         Created new DDLs and DML statements for the new DB2 tables, views, triggers, indexes and constraints  and coordinated with the DB2 DBA team to implement them in development, test and production environments.  

·         Worked with the Prudential and CIGNA Business Analysts to understand the business requirement, perform the gap analysis and identify data constraints between the two systems.

·         Responsible for creating the detailed design and technical specifications for the entire migration project.

·         Created the data mapping, lookup tables and data validation rules between the source data and the target data.

·         Involved in the Business Continuation Plan (BCP) activities.

·         Responsible for maintaining the project deliverables to be SOX compliance that project documents and approvals for estimation documents, detailed design specifications, program specification documents, unit test plans and review document and defect tracking documents.

·         Involved in creating the test data and setting up the Test environments for performing the integration testing, system testing, load testing and regression testing for a smooth implementation of the project.

·         Analyzed the data requirements(CIGNA Prudential database systems) and  developed and implemented 40 reports in test and production servers.

·         Executed training programs to 40 CIGNA and Prudential business users on the business functionalities offered by the ABC system.

Technical Environment – Business Objects, OS 390, MS Access, DB2, Excel

PRUDENTIAL INC, Scranton, PA (Client)

Sr. Software Developer                                                                                                                      July 2001 – Dec 2004                                                                                                                                                                      

·         Led a 5 member technical team to successfully integrate Quote calculation and Tax Withholding functionality into Annuity Benefit Consolidation System.  The system reduced manual intervention of the user community by almost 70% and provided error free benefit plan quotes and tax calculations.

·         Played a key role in the technical development team to enhance the security for the Application Benefit Consolidation System. Enhanced system allowed restricted user accessibility to critical finance applications and significantly improved user accountability.

Technical Environment – OS/390, DB2, MS Access, MS Visio, MS Project, MQ Series, Lotus Notes, Rational Portfolio Manager

TECHNICAL SKILLSET

Reporting Tools                         : BusinessObjects Xcelsius/ Dashboard Design, Web Intelligence (Rich Client, Info View / BI Launch Pad), Crystal Report 2008

Data Modeling                            :  Universe Designer, Information Design Tool, MS Visio

Data Connectivity                      :  Query As A WebService(QaaWS), Live Office, WebServices

Relational Databases                : DB2, MS Access, My SQL, SQL Server, Oracle 

Version Controlling tools       : Life Cycle Management (LCM)

Scheduling Tools                      : Central Management Console (CMC)

Programming Languages       : VB, C,C++, Java, COBOL 390, CICS, JCL,REXX

Incident Tracking tools           :  IBM Maximo, IBM Plan View, IBM Lotus Notes

Project Management tools:MS Office Suite, Advanced Excel skillset, MS Project, IBM’s QMS (Quality Management System), RPM (Rational Portfolio Management), Sharepoint

Download Resume Format