Resume

Sign in

Data Analyst Project

Location:
Gardner, Kansas, 66030, United States
Salary:
75k
Posted:
April 24, 2018

Contact this candidate

Resume:

Anitha Basker

Data Analyst

+678-***-****

ac48kz@r.postjobfree.com

Experience Summary

•Around 6+ years of experience in Data Warehouse analyst, Business Intelligence reports, ETL applications in various domain like HealthCare, Insurance & PeopleSoft HR.

•Having extensive experience in backend testing, starting from project initiation activities till closure and exhibited great capabilities across each phase of the lifecycle.

•Have worked in different domains and domain knowledge has never been a hurdle through quick grasp and adaptability in the projects

•I have profound knowledge in entire testing life cycle process and played pivotal role in establishing process for new assignments.

•Key activities including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance.

•I have profound knowledge in entire development life cycle process and played pivotal role in establishing process for new assignments.

•Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.

•Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling.

•Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.

•Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.

•Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding

• Expertise in ETL tool like Informatica, DataStage.

•Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping and also having very good knowledge in PL/SQL.

•Validated reports developed in OBIEE.

•Good knowledge and working experience in using UNIX commands and VI Editor

•Having 6+ years of experience in validating ETL, PL/SQL, UNIX batch jobs scheduled using Autosys

•Very good knowledge in various data warehouse built on Oracle, SQL Server, Teradata and DB2.

•Working on various source systems such as RDBMS, Flat Files and Legacy Systems.

•I have been a quick learner with the ability to make solution-oriented, creative and innovative contributions in highly demanding situations and also good in process documents and has been trained to handle process audits.

•Having strong knowledge on demonstrating good skills of evaluating testing process, performing gap analysis and provides suitable recommendations across multiple QA areas.

•Excellent communication, technical skills and very good team player.

Technical Skills

ETL Tools

IBM DataStage version 7.5, 8.1 & 9.1 Informatica 7.1.3 & 8.6.0,Ab Initio

Reporting Tools

OBIEE 11.1.1.6.9 Reports

Databases

Oracle 11g, SQL Server 2005,Netezza

Test Management Tools

ALM Quality Center 11/ 10.0 & Mercury Test director

Defect Management Tools

ALM Quality Center & Mercury Test director

DB Query Tools

Toad 9.7, SQL Developer-3.2, SQL * Plus

Tools

Oracle SQL Developer, Toad version 9.5 & SQL developer

Operating Systems

Windows NT/2000/XP/7

Programming Language

PL/SQL, SQL

Other Tools

Putty & WinSCP

Education

•B Sc., Coimbatore, Tamil Nadu, India

Employment History

•ETL Data Analyst in Alora Healthcare Systems from Feb 2016 to till date

•Data Analyst in Binotech Private Ltd from Nov 2009 to Dec 2013

Project Experience

•Healthcare Systems, United States

Project title

Mail Order Delivery

Period

09/2017 – till now

Location

Atlanta, GA

Time Size

4-6

Environment

Datastage, WinSCP, HP ALM 11.5x, UNIX, OBIEE 11g, Java, Autosys, Putty & WinSCP

Project Abstract

Cost Per Fill - Orders are placed by Alora members who have opted for mail order delivery of medical supplies through various channels including Mail, web and AVA.

City Transition - City mail order pharmacy was developed by Pharmacare and still operates on Pharmacare’s system

Roles & Responsibilities

ETL Data analyst / Jr. Data Analyst

•Accurately and effectively communicate product risks to project team

•Involved in design of dimensional data model – Star schema and Snow Flake Schema

•Involved in Effort estimation and tracking of the project plan for Dev activities

•Participated in project meetings and lead the team members in delivering quality solutions and assisted them in better understanding of the project requirements.

•Generating DB scripts from Data modeling tool and Creation of physical tables in DB

•Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files

•Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)

•Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.

•Involved in creating the test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents

•Preparing & reviewing the test scenarios, test data, test case design and execution

•Developing complex SQL queries for data validations as part of ETL testing

•Performing data validation in ETL code, batch jobs scheduled

•Used SQL Developer to run SQL queries to check data is populating as expected from tables.

•Validated the slowly Changing Dimension (SCD) based on the requirement

•Performing in data validation, data profiling, data scrubbing, and data frequency analysis

•Involved in testing reports and closely worked with Release team

2. HealthCare, United States

Project title

Informatica-to-Datastage Conversion project

Period

02/2016 – 10/2017

Location

Atlanta, GA

Time Size

6-9

Environment

Datastage, Informatica, Teradata, ORACLE,Netezza, SQL Server & DB2, OBIEE 11g

Project Abstract

Consolidation of the enterprise Extract, Transformation & Load (ETL tools). This project requires a conversion of all Informatica 7.1.3 and 8.6 repositories to Datastage 8.1 grid platform. The retirement of Informatica deployments provides significant recurring cost saving and avoidance of application licensing, maintenance and management upgrade cost. Consolidating ETL code on the Datastage 8.1 grid simplifies the governance of data integration capabilities and gets our ETL capability closer to a shared function. source datas from different database like oracle,Netezza,sqlserver. Informatica 7.1.3 & 8.6 is at end of life, and Informatica Corporation no longer supports this product.

Roles & Responsibilities

ETL Data analyst / Jr. Data Analyst

•Accurately and effectively communicate product risks to project team

•Involved in all phases of Agile Development Methodology.

•Involved in creating the test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents

•Preparing & reviewing the test scenarios, test data, test case design and execution

•Developing complex SQL queries for data validations as part of ETL testing

•Performing data validation in ETL code, batch jobs scheduled using Autosys

•Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)

•Involved in creating UNIX shell scripts for database connectivity and executing queries in parallel job execution.

•Used SQL Developer to run SQL queries to check data is populating as expected from tables.

•Validating the custom reports and ad hoc reports built in OBIEE

•Validated the slowly Changing Dimension (SCD) based on the requirement

•Performing in data validation, data profiling, data scrubbing, and data frequency analysis

•Involved in testing reports and closely worked with Release team

•LAARS, Chennai

Project title

Land Acquisition, Alienation and Resettlement System (LAARS)

Period

07/2011 – 12/2013

Location

Offshore – Chennai, India.

Time Size

2

Environment

Forms D2k, Oracle PLSQ & Mercury Test director.

Project Abstract

LAARS is developed for Neyveli Lignite Corporation. It deals with Land acquisition, Alienation and resettlement. This project involves acquiring Government lands and Private lands. This project contains five modules. The master information contains district details, village details, scheme details, land type, land classification, thahsil details.

A) Planning Module - Entering residential land details, subdivision details. In scheme details contains various residential details from various districts, taluks, villages, sanction and Schema Details.

B) Requisition Module-This module deals with moving various lands into separate batch, here splitting single residential numbers to multiple residential numbers and subdivisions, number of extend and payment details. We are combine different residential numbers to single residential numbers, we are request the lands from state government, this lands from various schemes, various villages and various districts.

C) Allotment Module- Allotting various lands to a separate block and set of blocks to various thasildhar.

D) Acquisition Proceedings Module-In Acquisition Proceedings module contain preliminary notification to various thasildhar and government gazette, we are decide the pre-valuation date, joint valuation, work deposit, payment details and civil court deposit.

E) Government lands Module – This module deals in categorizing banned and non-banned. Takeover of government lands and numbering of lands by allotting blocks numbers and subdivisions.

Roles & Responsibilities

•Involved in creating Table definitions, indexes, views, sequences, Materialized view creation

•Prepared documentation for addressing the referential integrity relations in between the tables at ETL level

•Redesigned the existing server jobs with a different logical approach to improve the performance

•Prepared documentation including requirement specification.

•Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).

•Peer reviewing of test design documents of my team members and guides the team in successful delivery of the projects.

•Initial load has been tested in ETL tool and incremental testing has been performed through Autosys.

•Managed the defect tracking process using QC.

•Prepared the Daily Status Report (DSR) and Weekly Status Report (WSR) and Monthly Status Report (MSR) for internal audit.

•SkillWhere

Project title

SkillWhere

Period

11/2009 - 08/2011

Location

Offshore – Chennai, India.

Time Size

2

Environment

Visual Basic 6.0, SQL Server 2000, SQL, PL/SQL, Crystal Reports 8.5

Project Abstract

This Package was developed for the HR Consultants; it has taken care of the entire work process of the consultants. It automatically scans the Resumes of the candidates and captures important fields such as Name, email ID, Skill sets, Educational Qualifications, Projects Done, Date of Birth, and Passport Number etc. To a particular requirement the consultant can fire a query within the database to get the relevant resume for a specific requirement. From the query result the process of short listing, Interview line up, scheduling etc. can be handled by the package. Various MIS reports can be generated using the package. This package can also be customized according to the Clients (consultant or corporate) working style.

Roles & Responsibilities

Database Tester

•Involved in modifying existing ETL jobs and flat file data transfers without relying on a GUI layer

•Tested the Data Validations in application using the SQL Queries in TOAD.

•Peer reviewing of design documents of my team members and guides the team in successful delivery of the projects.

•Involved in batch Unit testing using Oracle SQL Developer

•Validate at the lowest granular level possible for field level

•Prepared Design documents and involved in coding/ write stored procedures to add a new feature.

•Created database scripts to implement the new features in Database.

•Prepared Test plans and performed Unit testing, System testing & UAT.

•I was also involved in bug fixing.

•Managing defects in defect tracking in system.

•I was involved in enhancement of the application based on client

•Involved in the discussion with End users to ensure that the project has met all the business needs.

•Involved in Analysis, Coding, Testing and Implementation of Enhancements raised by the client for SCR (Software Change Request).

•Actively involved in Customer Interaction, gathered information related to Change Request and developed the same.

•Responsible for solving day-to-day issues faced by the client to their satisfaction.



Contact this candidate