OBJECTIVE:

Seeking a business systems analyst position to explore new dimensions and hone my skills to bring innovation and add value to the organization.

SUMMARY:

• 5 years of industry experience as a Data Warehouse Analyst/data modeler with solid understanding of Data Modeling, Evaluating Data Sources, and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Accomplished various tasks in big data environment which involved Microsoft Azure Data Factory, Data Lake, and SQL server.
• Excellent in Data Analysis, Data Validation, Data Cleansing, Data Verification, and Data Mismatch Identification.
• Performed Business Requirement Gathering and Analysis, Feasibility study, ROI Analysis, Process Flow and Process Modeling, Functional and Techno - Functional Gap Analysis of existing system.
• Huge exposure to BI reporting tools in creating and assisting developers to get reports.
• Performance tuning of the queries and reports.
• Great experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Impressive for developing strategies for ETL (Extraction, Transformation and Loading).
• Huge exposure in working with offshore/onsite model to understand and/or create functional requirements while working with client to develop superb requirement analysis and generating test artifacts.
• Proficient in creating various artifacts for projects which include specification documents for data mapping and data analysis.
• Ability to learn new things quickly.

TECHNICAL SKILLS:

Programming Languages: SQL, PLSQL, UNIX Shell commands, AWK commands, HIVE.

Operating Systems:: Windows, UNIX.

Databases: Oracle 10g,11g, Teradata E12, MS SQL Server 2005/2008/2013/2014/2016 , MS Access, DB2, Azure Data Lake

Tools: HP/Mercury (Quality Center), Azure Data Factory, Ambari, Toad, SQL Assistance, IBM Data Stage8.7,11, Erwin r9.64, IBM Data Studio 4.1.1, IBM info analyzer, ER studio 9.6.1,16, GIT bash, COGNOS, Teradata SQL assistance, open refine, Informatica 8.1,Oracle SQL developer 4.1.1,Informatica IDQ 9.0.

EXPERIENCE:

Confidential, Watertown, MA

Data designer /Data Analyst

Responsibilities:

• Worked on a migration project which required gap analysis between legacy systems and new systems.
• Worked on data analysis, data profiling, source to target mapping, Data specification document for the conversion process.
• Worked with system architects to create functional code set cross walks from source to target systems.
• Well versed with managing change and constantly worked with varying requirements through the role in the project.
• Wrote ETL transformation rules to assist the SQL developer.
• Periodically interacted with Business and the Configuration teams to gather requirements, address design issues and made data driven decision and proposed solutions.
• Assisted in changing the data design for an update and tracked it on the data design document.
• Prepared the test plans for the component integration testing based on the logic's written.
• Performed component integration testing to check if the logics had been applied correctly from one system to other system.
• Coordinated with the QA team and conducted the triage on a daily, weekly and monthly basis to address the testing defects and worked on the HP Quality center to update the defect comments, resolution and tracked the defects till closure.
• Provided data samples and technical specification whenever requested from the higher management.
• Performed gap analysis, gathered the requirements, data discovery and data profiling for the TCE project and came up with the logic to make it work.
• Gathered the requirements for the Confidential reports.
• Developed Confidential reports in SQL for the higher management based on the requirements given.
• Designed the data flow and assisted the architect in solution design for new vendor data coming into tufts.
• Assisted ETL developers for scheduling and maintaining the jobs.
• Maintained the offshore team for the updates and project required details.

Confidential, Boston, MA

Data Wrangler / Data Analyst

Responsibilities:

• Performed data cleansing and made the data available for the data scientists to score their models.
• Developed the data quality framework using AWK, shell Scripts, python, and UNIX scripts.
• Used IBM info analyzer to do data analysis on MDM tables.
• Tested the compatibility of different open-source software with existing systems.
• Worked on the Microsoft Azure environment (blob storage, Data Lake, AZ copy) using Hive as extracting language.
• Utilized Azure Data Factory for transforming and moving data from virtual machine to Data Factory, BLOB storage, and SQL Server.
• Designed and assisted in developing and customizing the scripts for Quality Framework using Python.
• Analyzed the data and created models to store data in the big data environment.
• Established and deploy pipelines, activities with datasets, and linked services according to the business requirements.
• Used statistical sampling methods to perform data analysis of the dataset using Python.
• Reviewed data for master data management, maintain existing data models, and wrote Confidential queries to determine the quality and consistency of the data in DB2 database.
• Worked on decrypting and encrypting of the files.
• Installed the open refine and analyzed data in open refine.
• Worked on Qlikview and created reports for azure billing.
• Performance tuning of the SQL server after loading the data to tables.

Confidential, Los Angeles, CA

Data Analyst / Data Modeler

Responsibilities:

• Analyzed and divided the business requirements into subject areas and understood the data flow within the organization
• Understood business processes and data models to perform data analysis and map the requirements to the source systems.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis and determining columns to be used in required tables which were being moved into the new data warehouse.
• Written the logics for the ETL load to get the reports out of business objects.
• Created complex views in data mart for performance in reporting.
• Assisted in developing reports using business objects universe designer.
• Compared data from different databases to suggest the optimum way to merge tables.

Confidential, Dayton, OH

Data Analyst / Data Modeler

Responsibilities:

• Utilized business requirements to create Confidential reports using SQL.
• Created logic and mapping documents for data movement from external sources to EDW, EDW to DATA MART for report specific data.
• Analyzed and profiled the data to maintain the quality in the EDW, and worked on creating the data marts for reporting purposes.
• Debugged the logic in the existing reports and provided an optimum solution from the backend.
• Worked on creating the behavioral health reports out of report studio using framework manager in cognos connection.
• Loaded the data to the data mart using BCP utility and SQL loader.
• Assisted in developing reports on micro strategy.
• Had done performance tuning on the reports.

Confidential, Southfield, MI

Data Analyst

Responsibilities:

• Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL queries, Facets as the source, and Oracle as the database
• Accountable for researching data quality issues (inaccuracies in data), worked with business owners/stakeholders to assess business and risk impact, and provided solution, and prepared the issue list in the Quality Center.
• Used Data Stage to create jobs for changing dimensions using different stages and manage the stages using the Data Stage Scheduler.
• Debugged the data quality issues to find if the issues were in ETL or in the source data.
• Performance tuning of the oracle database and assisted DBA in deploying.
• Used quality center to track issues.
• Created logic and mapping documents for data movement from external sources to ODS, ODS to EDW.

Confidential

Jr.Data Analyst

Responsibilities:

• Used SQL Server to perform queries in the database.
• Collaborated with the Design and Development teams to implement the business and system requirements.
• Used the Quality Center to track and report system defects.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements.