SUMMARY

• Highly motivated Business Intelligence Professional using SQL Servers and Microsoft Technologies as well as other available technologies to analyze data.
• Experience in manipulating various data sources to support Senior Management decisions.
• Demonstrates teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision as well as work in a fast pace environment.
• Excellent Communication and interpersonal skills and experience working in a team - oriented environment.
• Experience with various stages of Software Development life Cycle(SDLC) like planning, design, production, development, implementation and unit testing
• Very Strong analytic mind and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.
• Experience in building and maintaining SQL scripts and complex queries for data analysis and extraction
• Ability to utilize SQL Server Management studio to query relational and multidimensional databases.
• Extensive experience in performing ad-hoc reporting using Pivot table, charts, graphs and V-lookups.
• Advanced skills in designing dashboards with various chart types such as pie chart, histogram, bar chart and lines using Excel.
• Ability to design and implement application database code objects, such as stored procedures and views
• Ability to create reports using MSSQL data with SSRS, Tableau and Power BI.
• Proficient with Microsoft SQL Server 2012 edition and above and also Teradata.

TECHNICAL SKILLS

Software: Microsoft Word, Microsoft Excel, Microsoft Access, Basic Java, SQL, SSRS, SSIS, Basic PYTHON.

Analytics: Regression, Correlation, Time series, Pivot Tables, Pivot Charts, pivot graphs, VLOOKUP, Tableau, MS Power BI.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Worked together as a team on the WCAO FCO Onboarding Performance Dashboard by gathering requirements through meetings with the Business Partners to have a proper understanding of the FSD and BRD metrics as well as the project goal.
• Worked in an agile environment by participating in daily stand up meetings (virtual due to COVID) team meetings to discuss about the project and look for ways to keep the project moving.
• Interpreted the FSD metrics together with my team and created a Derived table query for the data set that aggregates data from multiple data sources through JOINS in Teradata.
• Collaborated with my team members to fine tune and optimize the query performance by choosing the appropriate JOIN type, creating indexes and collecting statistics on data columns.
• Utilized Tableau to design, develop, enhance and support Tableau visualizations including highly interactive dashboards, scorecards and reports with drill down to detail and analysis pathways to other supporting reports.
• Built from scratch and publish customized interactive Tableau reports and dashboards as well as manage extracts and refresh schedules using Tableau Desktop and Tableau Server.
• Executed data queries across multiple data sources in support of business intelligence reporting needs.
• Held weekly meetings with the Business Partners at various phases of the project to do presentations and Modified the query and Dashboards based on the feedback.
• Created an ETL process with an SSIS Package through Microsoft Visual Studio that Extracts and transforms SharePoint data, then loads it into a DW table in Teradata to help automate the process of loading SharePoint data that was thrown into an Excel sheet and brought into tableau monthly.
• Created a dynamic FCO Team Members dashboards Score Card with row level security in Tableau that analyzes and shows each individual Performance against their looking at the volume request done as well as their cycle times compared to the teams SLAs and Cycle Times regarding Customer Onboarding.
• Applied statistical Analysis such as Mean, Median, Z-Scores on the Tableau analysis of the data to make more useful meaning from the data.
• Created a dynamic FCO Manager View dashboards Score Card with row level security in Tableau that analyzes and shows the Performance all Team members under that manager against their peers looking at the volume request done as well as their cycle times compared to the teams SLAs and Cycle Times.
• Created a dynamic FCO Executive Summary dashboards Score Card with row level security in Tableau that analyzes and shows the Performance at the various Sites/ Hubs compared against each other to their SLA Success Rates, Cycle times including hourly work rate pay per site to show where the company is spending more or less based on the cycle time taken to complete a request regarding Customer Onboarding that enabled the Business Partners to take smart data driven decisions through intuitive analytic dashboards and visualizations just at a glance.
• Held and participated in multiple meetings with Business Partners to gather requirements and asked probing questions on their FSDS and BRDs to have a clear understanding of the Metrics on the Reputational Risk project.
• Translated the Metric understanding into technical requirements that helps to develop and build the SQL logic with relative ease on the SQL end in Teradata.
• Worked on Reputational Risk Dashboard by Importing Excel data into Tableau and created a data model as well as a data blend on the various Excel data sources to analyze the data through intuitive visualizations such as line and bar graphs for time intelligence, area graphs, MoM, QoQ,YoY YTD, Current Month and previous Month KPIs. Statistical analyses such as Median and Mean, running averages were used also.
• Did presentations at various phases of the project so that the Business Partners can cretic the dashboard and in corporate the changes requested on the new version of the dashboard.
• Analyzed the company reputation in terms of negative social media feeds across various LOBs through intuitive visualizations.
• Designed and created a Data Dictionary at the end of the project to facilitate understanding of the metric calculations as well as maintenance of the various dashboards as it was handed to production.
• Developed SQL script to extract data from Teradata SQL Assistant to create excel and tableau dashboards.
• Creates T-SQL objects such as Tables, Views, Constraints and Queries used for reporting.
• Interprets BRDs and FSDs from Business Partners and uses them to create complex queries that is used for reporting in Tableau.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Designed and created Dynamic Tableau Dashboard prototypes that compares WCAO and WCIS accounts reconciliation for month end reporting with time intelligence graphs (Bar and Lines) that aggregates data over a period of time including KPIs that show the accounts statuses at a glance. As well as Donuts and pie charts that analyzes the data across other measures.
• Enabled the Business Partners to take smart data driven decisions through intuitive analytic dashboards and visualizations just at a glance.
• Writes SQL script to extract data from Teradata SQL Assistant to create excel and tableau dashboards.
• Develops various T-SQL objects such as Functions (UDFs), Tables, Views, Triggers, Indexes, Constraints and creates dynamic and Static Stored Procedures and Queries used for reporting.
• Creates tables and views in Teradata SQL Assistant and uses them to create dashboards that analysis Confidential Leveraged Lending for Senior Credit Officers and other senior leadership stakeholders.
• Tunes query performance by creating indexes and collect statistics in Teradata.
• Creates Dynamic Drill through Pivot charts and graphs that analyzes Confidential Commitments and Outstandings at the OCC groups and industries grain level.
• Designed and created a month end run book data repository that captured monthly and quarterly tableau and excel dashboard refreshes for the team.
• Creates Tableau dashboards from scratch following the Business Requirement Documents(BRD) from business partners and stakeholders
• Collaborates with business partners to create technical design specifications for each tableau dashboard project.
• Creates KPIs such as Month over Month, Quarter over Quarter, Year to date, and Year over Year etc on dashboards to easily make comparison and enhance understanding of the data at a glance.
• Creates and maintains monthly and quarterly tableau and excel dashboards for credit risk analysis for Senior Credit Officers and other senior leadership stakeholders.
• Creates dynamic pivot tables, graphs and charts that analyzes Confidential customer credit grades (CQR, BQR and AQR) for Senior Credit Officers and other senior leadership stakeholders.
• Handles Adhoc request that looked into Confidential lines of business (LOBs) in terms of credit risk.
• Creates parameters, calculated field and slicers in tableau to make the dashboard more dynamic.
• Maintains Monthly and quarterly tableau dashboards to capture current and up to date data.
• Edits and updates SQL scripts for existing dashboards in order to optimize performance of both excel and tableau dashboards for the Commercial Credit Portfolio Analytic Team.
• Works together with team members to design and create dynamic tableau dashboards that looked into Confidential concentrations in terms of industries migration.
• Creates dynamic power points slides for Group Senior Credit Officers and other senior leadership stakeholders.
• Connects to tableau server to publish dashboard to a central location for portal integration and also to the teams share point.
• Participates in team meeting and shared ideas to ongoing projects.
• Incorporates logic to meet a change to existing reporting (for example if a new measure, dimension, filter, etc. needs to be added to an existing Tableau dashboard)

Confidential, Dallas TX

Business Intelligence Developer and Data Analyst (SSRS)

Responsibilities:

• Developed various T-SQL objects such as Functions (UDFs), Tables, Views, Triggers, Indexes, Constraints and created dynamic and Static Stored Procedures and Queries used for reporting and data mining.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Was responsible for improving performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used SSRS to develop, design and maintain reporting requirements.
• Created report templates (including corporate logos, textbox for expressions, Data source and datasets) using SSRS.
• Imported data from SQL Server DB, Azure SQL DB, and Excel files, etc to Power BI to generate reports.
• Created Data Models by establishing primary and foreign key relationships in the Power query or transformation window.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Used the CALCULATE (), ALL () and FILTER () DAX expressions to compute complex calculations.
• Created DAX Queries to generated computed columns and measures in Power BI.
• Generated calculated measures with DAX such as Previous Month, Current Month, MoM, YTD etc to use in analysis.
• Publishing Power BI reports of dashboards in Power BI server and scheduled the dataset to refresh for upcoming data in power BI server.
• Created Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Created Tabular Reports, Matrix Reports, Parameterized Reports, Sub Reports, Global map reports in Power BI Desktop.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile app.
• Generated KPI for customer satisfaction survey results and sales management on Power BI Dashboards.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie chart, bar graphs and density charts.
• Explored data in a variety of ways and across multiple visualizations using Power BI tool.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Was responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Strategic expertise in the design of experiments, data analysis and visualization.
• Involved in troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Confidential, Dallas TX

Business Intelligence Developer and Data Analyst (SSIS)

Responsibilities:

• Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
• Designed and implemented a snowflake -schema Data Warehouse in SQL Server based on the existing data warehouse.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Managed and developed existing and new ETL processes for SQL Server reports. Refreshed staging tables with ETL. Scaled SSIS to make it work more reliable.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 to meet business requirements activities including database consistency check, data backup & restore strategy, index defragmentation.
• Worked with various Dataflow transformations like Merge Join, Audit, Lookup, Union All, Merge, Aggregate, OLEDB Command and Conditional Split while designing SSIS Packages.
• Wrote enterprise reports and stored procedures upon requests. Designed report models to meet business requirements and allowed users to perform fast queries.
• Designed and maintained ETL processes with MS SQL Server Integration Services 2012 (SSIS) using advanced data transformation and SSIS task scripting
• Built Reports with MS SQL Server Reporting Services 2012 (SSRS) implementing tabular, matrix (crosstabs), bar and line charts, spark charts, and multi-tiered drilldowns as well as advanced formatting such as data driven color coding, visibility, and both fixed and movable headers.

Confidential, Dallas TX

Business Intelligence Developer Intern

Responsibilities:

• Performed descriptive statistics for clients to determine average daily, monthly and yearly sales.
• Assisted Clients to export data from SQL to Excel
• Designed ad-hoc reports using pivot tables and charts
• Generated and developed required reports using SSRS
• Created queries using T-SQL used to develop complex reports and generate sub-reports, drill-down, drill-through and parameterized reports using SSRS.