Post Job Free
Sign in

Business Systems Data Warehouse

Location:
Bartlesville, OK
Posted:
November 25, 2024

Contact this candidate

Resume:

KAUSAR SHAIK

E-mail: **********@*****.*** Mobile: 918-***-****

Career Summary

Job Summary

We are seeking an experienced Senior Business Systems Analyst with a strong background in data warehousing to lead requirements gathering, analysis, and design for data-driven projects. The ideal candidate will have a minimum of 10+ years of experience in business systems analysis, with proven expertise in data warehousing projects and data management. This role involves collaborating with cross-functional teams, stakeholders, and data engineers to drive business requirements, optimize data solutions, and enhance our data warehouse to support strategic business goals.

Technical Skills Summary

Programming Languages: Python, SQL, PL/SQL, Java, C, HTML

Databases: Teradata, Snowflake, Oracle, Sybase, MySQL, MS SQL Server

Tools & Utilities: Teradata SQL Assistant, SQL Developer, TOAD, MS Office, Tableau

ETL Tools: Informatica PowerCenter (8.7, 9.1, 9.5)

Working knowledge of Agile and Waterfall methodologies

Professional Experience

Sr. Business System Analyst

Elevance Health March 2015 – Present

Responsibilities:

Engaged with stakeholders and clients to gather requirements, propose solutions, and deliver high-value outcomes and developed business requirement documents (BRDs),functional requirement documents (FRDs) and process workflows.

Collaborated with the Chief Business Architect and executive teams to support strategic initiatives and operational excellence.

Defined, executed, and managed deliverables for projects aligned with organizational objectives.

Supported product intake processes and streamlined operational workflows to enhance efficiency.

Worked in cross-functional teams, including Development, Offshore, Release Management, Operations, and Product Management teams to deliver impactful solutions and ensure data integrity.

Applied Agile and Waterfall methodologies to ensure smooth and adaptable project delivery.

Develop and automate business performance reports, dashboards, and key metrics using SQL, and Excel that support decision-making by business units and management.

Conduct data analysis to identify trends, patterns, and anomalies in claims, revenue, and membership data.

Manage ETL pipelines using Informatica and Talend, ensuring data integrity and scalability.

Oversee the integration of Snowflake for enhanced data warehousing performance.

Develop dashboards and visualizations in Tableau and Power BI to support data-driven decision-making.

Key Achievements

Automated balancing and reporting processes using OMAR (Operational management and reporting tool), reducing manual effort by 40%.

Successfully led a multi-year data warehouse migration project, ensuring compliance with audit standards.

Developed and implemented strategic initiatives, including an optimized product intake process.

Spearheaded cross-functional workshops that improved stakeholder alignment and project delivery timelines.

Performed regular data audits successfully ensuring compliance with SOX and internal auditing standards (E&Y).

Project Name: Safeway Insurance DWH.

Client: Safeway Insurance Group, USA.

Role: Software Engineer

Duration: July 2012 to May 2013

Responsibilities:

Responsible for implementing the Life insurance Datamart Module

Analyzed client requirements on the Life insurance Datamart module.

Analysed the sources and Target systems.

Created mapping documents for Quote requests, Quote updates, Insurance underwriting, and Invoicing interfaces

Designing and implementing Quote, Underwriting, and Invoicing interfaces using various Informatica Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Expression, and Sequence Generator Transformations.

Resolving any issues in transformations and mappings with the help of technical specifications.

Conducting Unit Testing of the Life Insurance module.

Conducting system testing and UAT for the Life Insurance module.

Supporting Life Insurance Datamart interfaces during the guarantee period.

Project Title: Farmers Data Warehouse System (FDWS)

Client: Farmers Data Warehouse System.

Role: Software Engineer.

Duration: May 2010 to Jan 2011

Responsibilities:

Involved in analyzing the source and target systems and existing data warehouse.

Designed various mappings for extracting data from various sources involving flat files and relational tables.

Created source definitions, design targets, mappings, and developed transformations.Created different transformations for loading the data into the Oracle database e.g. Source Qualifier, Joiner transformations, Update Strategy, Lookup transformations, Filter, Rank transformations, Expression, Aggregator, and Sequence Generator.

Developed SCD Type2 effective Date Range process according to the requirements.

Created sessions using the Informatica power center server.

Involved in Unit Testing and prepared Test Cases.

Involved in System testing and support.

Educational Summary:

Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh, India.



Contact this candidate