Sr. Data Analyst Resume

SUMMARY:

Over 7 years of experience in functional Business Analysis and technical Data Validation.
Experienced in gathering and documenting Project and Report requirements
Experienced in Database Development and Data Management in MS Access
Built and maintained OLAP and OLTP databases
Experienced gathering business requirements from business users.
Experienced extracting data from various data sources/applications then transforming and cleansing the data and identifying ways to integrate and loading it into a data warehouse.
Expertise in Data Analysis by writing Ad - hoc T-SQL (DML and DDL) Queries.
Experience in creating Views, complex Stored Procedures, Effective Triggers, and user defined functions to facilitate efficient data manipulation and consistent data storage.
Hands-on experience in debugging stored procedures to optimize performance.
Good experience on Relational Database Modeling and Dimensional database modeling concepts.
Worked in Agile and Waterfall SDLC environments.

TECHNICAL SKILLS:

SSAD: Structured Systems Analysis and Design Quality management services to ISO 9001-2008 standards

Datawarehousing and Business Analysis: Datastage,IBM DB2, Teradata, SQL Server 2014, MS Access,MS Excel, Word, Powerpoint, Pivot table

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Analyst

Responsibilities:

Worked with cross-functional teams with the intent of solving business issues, co-ordinated with SME’s, Stakeholders as needed Facilitated JAD sessions, retrospective meetings to review, evaluate, and/or propose new business opportunities through the implementation/enhancement of technical solutions.
Extensively Worked in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process.
Ensured efficient transactions of complete HR data of IBM Global services employees, reducing the processing time of volumes of data by 35%, and enabling 98% success transaction rates
Performed deep data analysis on regression tests for Asia Pacific employees, created dashboard for results and presented to senior management to ensure accuracy of process flow.
Prepare user cases, business requirements documents (BRD), system requirements specification (SRS) documents and other functional documents.
Prepared Unit test cases, Test scenarios and ensured successful UAT Testing and deployment to production of phase 1 and phase 2 of HRMS Interface Program.

Confidential

System Analyst

Responsibilities:

Performed data integration on confidential Financial data related to international assignees on cross reporting from various data sources.
Transformed the data using KPI( Key performance indicatiors), applied Business rules to data and loaded in reporting tool - Cognos for senior management view.
Created complex rules to be applied to tax component of international assignees and helped ETL Team to load the data in the datawarehouse which improved loading accuracy by 20%
Used SQL queries (select, insert, update, delete, sub-queries, joins, etc) to manipulate the data in the database and generate reports to help the business users for there daily activities.

Confidential

Data Analyst

Responsibilities:

Data Specialist in Integrated Reporting for Bharti Airtel covering all line of business including Telemedia, Mobility, DTH, Enterprise
Created Automation Process for the end to end deployment of EIS Project by transforming raw employee extract to staging and finally applying business rules to load it in the reporting tool Cognos.
Created dashboards on Bharti executive information.Key visualizations from the reports were used to enhance Bharti Airtel customer retention during the year 2009-11.
Performed end to end testing with the Testing team ensuring 99.2% successful run of the module after deployment.