SUMMARY

• Highly skilled IT professional with over 5 years’ experience in Business intelligence for various companies with proficiency in data analysis, modeling and reporting
• Strong experience in using the Microsoft Suite (SQL Server Management Suite (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power Bi
• Experience in using Full System Development Life Cycle (SDLC), including Requirement Gathering, Analysis, Design, Development, Testing, and Implementation of various client/server applications in a structured development environment
• Knowledgeable in the ETL Lifecycle and Agile Methodology
• Ability to prioritize multiple tasks. Excellent communication skills, proactive, self - managing, and teamwork spirit, goal-oriented, highly motivated with excellent analytical, troubleshooting, and problem-solving skills
• Designing and Implementing Database Schema, Data modeling, creating normalized datasets, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Temp tables, and complex SQL statements
• Establishing referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans, normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts
• Joining multiple Tables using the Inner join, Full Join and Left outer Join functions from database to combine data for reporting purposes and reducing need to repeat columns thereby increasing work efficiency and avoiding system overloads
• Experience working with Power BI Desktop for data visualization
• Experience working and writing accurate DAX(Data Analysis Expressions) formulas to meet business needs
• Experience in Developing, Publishing, scheduling reports and building dashboards to meet business requirements
• Ability to build data analytics enterprise models using Microsoft Power Bi
• Experienced in transforming unstructured data from various data sources such as Excel Spreadsheets, OLTP databases, flat files, XML files etc
• Extensive experience with requirement analysis, design, development, customizations, and implementation of Data Warehousing ETL applications
• Experience in all phases of Software Development Life Cycle (SDLC) with experience in ETL Tools, Microsoft Business Intelligence Suite - SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), and knowledge in SSMS (SQL Server Management Studio)
• Implemented Various Error handling and Event Handling Techniques to ensure efficient package execution
• Responsible for designing, building, and testing Data flow in SQL Server Integration Service (SSIS)

TECHNICAL SKILLS

• SQL Server 2016
• SQL Server 2014
• SQL Server 2012
• SQL Server Integration Services (SSIS)
• T-SQL Stored Procedures
• Power Bi Desktop
• Excel
• Word
• PowerPoint
• Search Engine Expert (Google)
• MS OneNote
• MS Publisher
• Access
• Outlook
• SharePoint
• Oracle SQL
• Teradata
• PostgreSQL

PROFESSIONAL EXPERIENCE

Confidential, Denton

Data Quality Analyst/Power BI developer

Responsibilities:

• Worked with team of developers to design, develop, and implement multiple reports like sales report, inventory reports etc. using Power Bi Desktop tool
• Analyzed and gathered business requirements for designing and developing SSRS visualization solutions
• Supported the Senior Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designed visualizations for initial concepts and prototypes that can be presented to the business and clients for feedback
• Advanced SQL and Excel skills. High comfort level with consolidating and joining data using Left and Right Outer Joins, Inner joins, creating formulas, sub queries and CTE.
• Contributed to the development and modification of coding standards in SQL for the team to ensure consistency, efficiency and accuracy in reporting and data analysis
• Used Trend Lines Statistics and, Groups hierarchies, and sets to create detailed level summary reports and Dashboards using KPIs
• Worked on Power Bi dashboards using stack bars, bar graphs, scattered plots, geographical maps
• OptimizedSSISpackages and stored procedures that improve the processing speed of large files
• Generated Dashboards and sub reports with Parameters, calculated fields, matrixes, drilldowns, and drill throughs to handle and view reports more efficiently
• Built, published, and customized interactive reports and dashboards, report scheduling using Power bi report servers

Environment: SQL Server 2012/2014/2016 , Visual Studio 2015, MS Excel, Tableau, Integration Services (SSIS), SSRS, Power Bi Agile, Project

Confidential, Wichita falls

Senior Data Analyst

Responsibilities:

• Published various kinds of live interactive data visualizations dashboards and reports according to the business requirements using SQL Server Reporting Service (SSRS) and Tableau
• Utilized SQL queries and scripts to extract and aggregate data to validate its accuracy
• Performed daily integration and ETL tasks by extracting, transforming, and loading data to and from different SQL Server databases
• Created calculated fields, Parameters, Filters to develop user-friendly, interactive, and actionable reports and dashboards in Power BI
• Created parameterized reports for projects, with drill-down, drill-through features in SSRS
• Performed data cleansing using SSIS
• Carried out data extraction and data manipulation using SQL as per project requirements
• Transformed data from multiple data sources in SSIS and extracted it into a newly centralized database in SQL per project requirements.
• Developed script task in SSIS and used C# tool to develop file validation and error handling per project requirements.
• Configured site access for users, groups and domains related to each project via active directory
• Provided ongoing support and user training for SQL and SSRS
• Migrated dashboards from Development to Production server as per business request
• Scheduled user request refresh on SSRS report servers

Environment: SQL Developer, MS-SQL, MS-Access, MS Excel, XML, FLAT file, SSIS, Visual studio, C#