Data Analyst

LYDIAH MERIN

BI DATA SPECIALIST

Contact

469-***-**** *********@*****.***

Profile

A well-organized, goal-oriented, highly motivated self-starter, effective team member with excellent analytical, troubleshooting, and problem-solving skills able to quickly adapt into the given role and deliver results in a timely manner.

Key Skills

ETL

Statistical Analysis

Data Quality Assurance

Business Intelligence

Writing SQL queries

PROFESSIONAL HIGHLIGHTS

4+ years of working within Data Warehouse environments

4+ years of experience with BI reporting, Power BI and SSRS

Experience maintaining Enterprise Data Warehouse (EDW) in support of business intelligence analytics

Experience developing and maintaining data warehouse objects

Experience in data warehousing design, tuning and ETL/ELT process development

Proficient in SSIS process design architecting the flow of data from various sources to target.

Experience in providing Logging, Error handling using Event Handler, and Custom Logging for SSIS Packages

Experience in deploying and scheduling SSIS packages across different environments.

SDLC experience using the Agile and Waterfall methodology

Experience with data quality assurance and investigating data quality issues and developing improvement plans

Experience with Business Process Improvement

Experience Building Business Process Flow Diagrams

Experience in Planning and Organizing Workflows

T-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL Serve

Experience leading small project teams and working directly with clients

Experience with data mining, report creation, modeling, and trend forecasting.

PROFESSIONAL EXPERIENCE

BI Developer (Power BI, SQL, DW) Mar 2019 - Present

Abott- Irving, TX

Generate on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS) and POWER BI.

Assist in development of data warehouse and ETL systems using relational and non-relational tools like SQL, No SQL and PostgreSQL

Develop periodic Dashboards and report for daily, weekly, monthly and quarterly.

Create various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.

Create Excel reports, Dashboards & Perform Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.

Contribute to project plan development, offer input, manage projects and initiatives, direct assigned resources, communicate project status and ensure timely issue escalation

Ensure projects comply with technology domain architecture, design and operate processes to help review ongoing activity against technology architecture and development standards

Apply industry and technical knowledge to provide solutions that increase business results and minimize risk.

Conduct pre- and post-implementation reviews

Lead in knowledge transfer meetings with senior management team, other technical areas and business units

Ensure that the design of data systems, including the Enterprise Data Warehouse, is optimal in order to achieve Business and Research goals and outcomes

Lead efforts to convert existing reporting tools to a standardized reporting infrastructure

Develop, implement and maintain reporting dashboards and scorecards, automated reporting solutions and other BI solutions to support tactical and strategic reporting needs of the organization.

Assist with identification of data integrity problems and recommend solutions

Work with internal customers to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, and scorecards

Serve as an Informatics Advisor to business leaders to support understanding of standardized measurement indicators and benchmarks

Create and deployed standardized financial reporting

Identify benchmarks and reporting tools necessary to compare operating performance to peers and the industry

Consult with internal clients to identify, assess, and solve challenging business problems

Develop data architecture plans and execute them in collaboration with Data Owners, Solution Architects & Technology Leads

Translate advanced business analytics problems into technical and data design approaches that yield actionable recommendations across multiple, diverse domains. Create, maintain, and communicate current and target state data architecture for data domains within an assigned subject area

Guide application development teams in the data design of complex solutions and ensure that teams are in alignment with the organization’s data architecture principles, standards, strategies, and target states

Facilitate the transition from high-level design to detailed implementation and support a project lifecycle with input from management where needed

Business Intelligence Data Warehouse Developer (Power BI, SQL, DW) Aug 2017 - Jan 2019

Collabrium Systems- PA

Defined, analyzed, designed, developed, tested, and maintained new software applications in support of the achievement of business requirements

Elicited, documented, and modified software requirements and specifications throughout the software system life cycle

Responsible for analyzing and amending software errors in a timely and accurate fashion and for providing status reports where required

Performed data warehouse design, including determining client requirements

Designed dimensional star schemas, OLAP cubes

Analyzed data from operational systems

Designed and documented ETL (extract, transfer, load) requirements; designing and documenting OLAP load routines; working with programmers to build ETL programs; and testing data loads for accuracy, completeness, and usefulness

Provided data warehouse user analysis and support and designs, creates, and manages the end user reporting layer creates user metadata documentation

Marketed data warehouse resources to the client community

Assisted clients in creating reports in the data warehouse and OLAP environments and provides guidance to clients as needed

Worked as a database designer for transaction systems, and designed concepts applied to normalized transaction databases and the data modeling techniques, and led client groups in data design and determining functional requirements

Worked with the IT department to develop an enterprise reporting environment including advising software and hardware decisions

Provided quality assurance of reporting data

Managed reporting users and user roles

Built new data procurement and data processing rules

Developed business reports and dashboards for operations, sales, and marketing users

Monitored analytical metrics and create automated alerts to trigger business response

Implemented new data analysis methodologies

Trained end users on new reports and dashboards

Provided technical expertise on data storage structures, data mining, and data cleansing

BI Data Analyst (SQL, DW, SSRS) Nov 2016– July 2017

Round Point Servicing Cooperation- Charlotte, NC

Gathered business requirements, definition and design of data source and data flows.

Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.

Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For-loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.

Designed SQL database with control and audit schema tables to maintain historical data and error handling.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.

Maintained and optimized the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SSRS and populate data warehouse using SSI

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Designed, developed and deployed SSRS reports including parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reports

Designed and develop Dashboards and Reports using SSRS.

Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SSAS

Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.

Contact this candidate