SUMMARY

• Highly accomplished and motivated IT professional with extensive experience identifying business requirements, driving process improvement, and designing IT solutions dat drive business growth. Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
• Able to perform multiple duties in data analysis, business intelligence, ETL development, data modeling, visual analytics and SSRS.
• Experience in data scrubbing and cleansing.
• Great understanding of SDLC methodologies such as Waterfall and Agile.
• Excellent in data mining for fulfilling customer segmentation business requests and periodic report generation.
• Experience is generating business intelligence from customer data warehouse or data - lake both on-premises and in cloud environments
• Experience in Designing, Creating, Implementing, Evaluating, Repairing, and Improving current Bi solutions.
• Expert in finding Correlations in data to discover meaningful insights in Identifying Key Performance Indicators (KPI) to halp companies adjust and fulfill Objectives.
• Expert in developing visual reports and dynamic dashboards dat for C-suite executives and operations monitoring
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, AWS glue

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ, PL/SQL, AWS Athena

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau, MicroStrategy, Excel and PowerPivot, PowerBI, SSRS

Cloud Solutions: AWS, AZURE

PROFESSIONAL EXPERIENCE

SENIOR SQL DEVELOPER/ POWER BI CONSULTANT

Confidential, Bakersfield California

Responsibilities:

• Fulfilled numerous data request for financial profiling.
• Created dashboards and interactive visual reports using Power BI
• Designed, developed, tested, and deployed Power BI scripts and perform detailed analytics
• Performed DAX queries and functions in Power BI
• Identified key performance indicators (KPIs) with clear objectives and consistently monitored data and presented Data through reports to aid decision-making
• Created relationships between data and develop tabular and other multidimensional data models Chart creation and data documentation explaining algorithms, parameters, models, and relations.
• Creating views, functions, and stored procedures.
• Writing optimized SQL queries for integration with other applications.
• Created database triggers for use in automation.
• Created Views and Database Triggers, Stored Procedures and Functions using SQL such dat information entered by a certain WM can make appropriate changes to the respective tables.
• Developed, published, and scheduled Power BI reports as per the business requirements.
• Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Created and maintained views within SQL server for Business Analysts.
• Wrote highly complex but well-turned SQL queries using SQL assistant to run departmental reports within Teradata platform.
• Executed data modeling using ERWIN data modeling tool.
• Worked on Dimensional modeling to design and develop STAR Schema and Snowflakes Schema, and Dimension Tables
• Performed and coordinated system testing and user acceptance testing
• Developed and maintained technical documentation

Business Intelligence Engineer

Confidential

Responsibilities:

• Engaged in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created, maintained, and reviewed application designs in collaboration with Solution Architects and shared services Teams, ensuring alignment to the appropriate solution architectures and taking tradeoffs into account.
• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Reviewed functional and non-functional requirements and ensures success criteria is clearly outlined.
• Performed various SQL performance tuning including index recommendations or hardware configuration considerations.
• Used inner, left, right and outer Joins, CTE's, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and Stored Procedures and enforced business rules via checks and constraints.
• Monitoring database performance indicators of development and test environment to ensure promotion to production environment brings no surprises.
• Diagnosed database issues related to development activities in development and test environments.
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Wrote SQL queries dat were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Used Pivot tables to create reports dat did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of wat is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Supported ETL Team by maintaining already deployed SSIS packages for ETL from OLTP and various sources to staging then to Data warehouse.
• Performed ETL mappings using MS SQL Server Integration Services.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views source control and ticketing systems.
• Enhanced the performance necessary for statistical reporting after performance monitoring, tuning, and optimizing indexes.
• Created different types of reports like: Ad hoc report, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created calculated columns and measures using DAX for KPI's in Power BI Desktop.
• Developed visual reports and created relational model using Power BI Desktop.
• Secured the reports using row-level security on data in Power BI Desktop.
• Created dashboards dat provide aggregate information regarding daily departmental
• Other related duties, as assigned in task.