SUMMARY:

Motivated and results - driven Analyst with a proven track record in data warehousing, analytics, visualization and process mapping seeking an opportunity to contribute best of my ability to organization, dedicated and hard-working with a passion for Big Data.

SKILL:

Database administration

Data Modelling (ERwin)

Data analysis, Business Analysis

Data visualization: Tableau, SAP BO

Confidential Analytics

ORDBMS (Greenplum), RDBMS (Netezza, Oracle, SQL server, DB2)

SQL, PostgreSQL, PL/SQL

ETL: Datastage, ssis

Unix, Python

EXPERIENCE:

Business Data Analyst

Confidential, Coppell, TX

Responsibilities:

• Extract, transform and format the data to build metric analysis and identify anomalies for the client data.
• Scheduled periodic reports related to call center data and service delivery performance across all regions.
• Perform Data analysis and Data profiling using complex SQL on various sources systems including sql server and Oracle.
• Conduct Gap Analysis through understanding current business processes and future business processes to determine the new process reengineering.
• Analyzed call center data warehouse to identify the tables and their relations in order to extract required data.
• Produced daily, weekly, monthly reports for call center data, used by stakeholders to identify variance among metrics like calls answered, abandoned, OSAT score, time ranges, transfers etc.
• Performed data Analysis using visualization tools such as Tableau and SAP BO to provide insights to data across multiple metrics.
• Visualized data in Tableau reports using Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart.
• Communicate Data and analytics to stakeholders and business users in a non-technical manner.

Business Data Analyst

Confidential, Plano, TX

Responsibilities:

• Adopted Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives using JIRA.
• Designed RBES weekly and monthly repository for Consumer Lending used by Bank Business Analytics in identifying all the active and existing members on multiple metrics.
• Maintained a repository to identify Investor, Fund manager, Securities that are invested in and the Returns passed within a mutual fund.
• Designed source preps, xfm and load jobs in ETL Datastage 11.5 that are integrated and run on E3 framework.
• Utilized application Aginity to enhance performance and efficiency for generating and maintaining data in Fact and Dimension tables.
• Extract data from heterogeneous sources applied transformation logics to the data and load into target datawarehouse/datamarts.
• Perform Data cleansing and Data validation to validate the corrupt data.
• Produced weekly, monthly Tableau reports for Retail Banking Enterprise Marketing, used by stakeholders to identify variance among metrics like credit cards, checking/saving, consumer Lending etc.
• Designed Control-M cycle to automate the batch process and run ETL sequence to load historic data continuously.

Business Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Designed Metric Repository on Oracle database to extract Actuals and Budgets for individual measures, used to determine calculated metrics which drives the decision making across multiple Tableau Dashboards.
• Analyzed data from multiple data sources (excel, xml, fixed width, csv files) using data blending in Tableau.
• Generated McKesson Reports by designing ETL pipelines and data integration related to Purchases and Account Payable in Financial Data warehouse supporting Medical Center.
• Maintained and tracked the process to support Health System Business Line Allocation that distributes Revenue and Costs from Business Units into the Business Lines.
• Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding datafields from Legacy to target CRM application.
• Perform Source to Target data analysis and data mapping.
• Followed an industry standard Change Management Process in service now and documented any Change Requests in the requirements after the requirements were base lined.
• Collaborated with Data Governance team, Business Users, application owners for requirement gathering and to create a source to target mapping, POC's and Technical specifications.

Data Analyst

Confidential, New York, NY

Responsibilities:

• Built data and analytics to inform and enhance the Value Based Payment data strategy and payment modeling.
• Collaborate with Business analyst and come-up with solutions to reduce cost and improve quality of care for Fidelis Medicaid members.
• Developed normalized Logical and Physical data models.
• Monitored and supported greenplum database to keep track of claims inventory.
• Perform analysis using MS Excel, PostgreSQL logic and generate reports to identify trends.
• Worked on greenplum concepts like locking, indexing, replication, schema design etc.
• Good understanding of JIRA software and project development using Agile methodology.

ETL Developer

Confidential, New York, NY

Responsibilities:

• Worked in RES/PASS ETL team that is responsible for collecting all Business and Excise tax data that is used by auditors, modelers and other agencies.
• Extracted large data sets, transformed the data for the reporting purpose using IBM Datastage to deliver tax return data to Confidential .
• Performed data manipulation to import and export data from multiple sources using SQL.
• Develop, maintain and update current SQL programs in DB2.
• Involved in Tax Policy Committee, in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Wrote SQL Queries for Data Accuracy, Data Analysis and Data Extraction needs.
• Supported batch ETL jobs to retrieve New York State and New York City tax data.

Analyst

Confidential

Responsibilities:

• Part of Googles Lane mapping team that supported in generating the backend data using Confidential Atlas tool.
• Analyze large data sets and integrate it on real time Confidential maps to allocate lane markings.
• Data analysis using Oracle and sql server.
• Querying using SQL/PLSQL to manage and relate tabular data to spatial data.
• Analyzed project requirements to find existing lane mapping bugs and eliminate issues within a timely manner.
• Maintained quality-focused performance benchmarks and schedules when working with project teams.