SUMMARY

• Having 8+ Years of IT experience in BI Development and Data Analysis.
• Expert Knowledge on SQL Server, Data/Dimensional Modelling, MSBI tools - Power BI, SSIS, T-SQL, SSAS, SSRS and Tableau.
• Created 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.
• Expertise in SQL ServerandT-SQL(DDL, DML and DCL) in constructingTables,Joins,Indexed views,Indexes,Complex Stored procedures,Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using Power BI, Tableau and Reporting Services SQL Servers (SSRS).
• Experience in Extraction, Transformation, and Loading of data directly from different heterogeneous source systems like Flat File, CSV, XLS and Relational Database.
• Expert Knowledge onAzure Synapse Analytics, Analysis servicesand SQL databases.
• Solid knowledge of Power BI and Tableau Desktop report performance optimization.
• Expert on Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for executive level Business Decision.
• Expertise in the development of dashboard reports for the Key Performance Indicators (KPI) for the top management. Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Have good problem solving and analytical skills. Highly motivated professional, Team Player and the ability to effectively Work with, communicate and mentor people.
• Experience in AgileMethodology Scrumapproachesin theSDLC.knowledge of HDFS, and Hadoop/Hive and familiarity with big Data technologies (HBASE, Spark).
• Proactive in learning new technologies/frameworks and applying them in the assignments.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Confidential Azure

Cloud Platform: (Azure Data Factory, Azure Data Lake, Azure SQL)

Reporting Tools: SSAS 2016/2008R2, Crystal Reports XI/X/9/8, Excel, Tableau, Power BI.

Database: MS SQL Server 2016/2008R2, MYSQL, MS-ACCESS.

Programming: C, C++, C#.Net, Python, PL/SQL, TSQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management, Agile process.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, VSTF.

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server.

Application Servers: Confidential IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE

Sr BI Developer

Confidential - Birmingham, Alabama

Responsibilities:

• Designed, developed, and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Created complexPower BIdashboards.
• Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2016.
• Transferred data from various data sources/business systems includingMS Excel,MS Access, andFlat Filesto SQL Server usingSSIS/DTSpackages using various features.
• Experienced working onStarandSnowflake Schemasand used thefactanddimensiontables to build the cubes, perform processing and deployed them to SSAS database.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Created Azure Data factories for loading the data to Azure SQL database fromCosmosplatform.
• Worked on creating tabular models onAzure analysis servicesfor meeting business reporting requirements.
• Have good experience working with Azure BLOB andData Lakestorage and loading data intoAzure SQL Synapse analytics (DW).
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Knowledge of managing security and metrics of the data presented using the admin portal.
• Used Visual Studio Team Services (VSTS) for version controlling, assisted in documentation, and creating data dictionary.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.

Environment: MS SQL Server 2014/2016, Power BI, SSIS, SSRS, SSAS, SQL Profiler, SQL, C#, web DEV(VB.NET), Visual Studio, Azure Analysis Services, Azure Synapse Analytics, Azure SQL Server and cosmos db.

BI Developer

Confidential - Irvine, CA

Responsibilities:

• Built business intelligence and data visualization dashboards using various technologies such as Power BI, and Tableau.
• Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.
• Designing ETL architecture and developed capacity-planning and trending-data warehousing solution to load data from multiple sources into Data warehouse.
• Design SQL 2008,2012 SSIS Packages, design SSAS OLAP Cubes, SSRS Reports database schema, tables, views, stored procedures, triggers, functions
• Designed an end-to-end analytical landscape involving PowerBI dashboards connected to backend SQL Server 2016 system on Azure.
• Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views, and associated reports.
• Involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Implemented Azure policies to keep control over the types of resources that could be provisioned.
• Created alerts and action groups in Azure that monitored CPU usage.
• Knowledge of Azure Active directory and managed service identities.
• Built, maintained, and deployed SSAS Tabular model cubes that were leveraged by end users for self-service reporting. Built drilldown, drill through, Chart, and graph reports using Power BI, SAP Business Objects Web Intelligence, and Tableau.
• Created, maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Worked directly with stakeholders for requirements gathering and developing various decision-making Dashboards.
• Created developing dashboards and reporting visualization.
• Created joins and sub-queries for complex queries involving multiple tables.
• Experienced in Confidential -SQL design, coding, testing, and implementation.

Environment: MS SQL Server 2014/2016, Power BI, SSIS, SSRS, SSAS, SQL Profiler, Confidential -SQL, C#, VB.NET, Visual Studio, Azure Analysis Services, Azure Synapse Analytics and Azure SQL Server.

Data Analyst

Confidential

Responsibilities:

• Analysis of functional and non-functional categorized data elements fordata profilingand mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Involved inData mapping specificationsto create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed, and sent to an external entity.
• Analyzedbusiness requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Worked with data investigation, discovery, and mapping tools to scan every single data record from many sources.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
• Written several shell scripts usingUNIXKorn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Metrics reporting, data mining and trends in helpdesk environment usingAccess.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MSAccess,Excel,and SQL.
• WrittenSQLscripts to test themappingsand Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complexSQLqueries and involved in back-end testing and worked with data quality issues.
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc.
• Involved inTeradata SQL Development, Unit Testing and PerformanceTuning and to ensure testing issues are resolved based on using defect reports.
• Worked with end users to gain an understanding of information andcore dataconcepts behind their business.
• Assisted in defining business requirements for the IT team and createdBRD and functional specificationsdocuments along with mapping documents to assist the developers in their coding.
• Identify & record defects with required information for issue to be reproduced by development team.
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.

Environment: Windows XP,QTP 9.2, Test Director 7.x, Load Runner 7.0,Oracle10g,UNIXAIX 5.2, PERL, Shell Scripting

SQL Developer

Confidential

Responsibilities:

• Involved in technical design documentation, development, unit testing and maintenance of internally developed applications.
• Worked on PL/SQL queries with Joins on multiple tables, Stored Procedures, Functions, and Triggers. Worked on detailed technical specifications for subsystems and identify integration points.
• Developed ETL packages using SSIS and stored procedure for data loading.
• Performed unit testing and debugging and set test conditions based on code specifications. Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements.
• Worked on agile methodology to practice-based methodology for modeling and documentation of software-based systems.
• Creation and Maintenance of Application services in Informatica. Creation, deletion and maintenance of Informatica Users and Groups.
• Experience in FTP and file management across various UNIX servers.
• Developing ETL jobs on Informatica, scheduling and troubleshooting. Ensure that the Service/Problem requests raised by the customers are resolved within the SLA timeframe.
• Monitoring the loads in production and troubleshooting the failures. Status Reporting of Weekly / Daily activities.
• Dropped and recreated the Indexes on tables for performance improvements.
• Developed roles, policies, and procedures for ensuring the security and integrity of the report. Fixed issues in the existing reports.
• Written technical design documentation for alterations to current business logic and future project designs.
• Performing Load Jobs within the Customer fixed SLA timelines and resolving failures during load.

Environment: SQL, C#, SQL Developer, MySQL, Toad for Oracle, Visual Studio 2012, SQL Server 2012