SUMMARY:

• SQL/BI/TABLEAU/SSRS/SSIS Developer with 5 years of experience in implementing database development and data management solutions in Microsoft SQL server, writing complex queries to develop database objects, developing and maintaining ETL frameworks, data modeling, developing data warehouse, database design, dynamic reporting platforms, business intelligence applications and solutions, data management and analysis. Looking for dynamic working environment and competent firm, where I can contribute and further advance professionally.
• 5 years of experience in developing Power BI applications utilizing SQL server, BI stack, Power BI, and Tableau.
• Extensive experience in investment banking - Treasury, Corporate Finance and Capital Market Security settlement operations and detailed knowledge in Fixed Incomes and Global Cash Equities.
• Developed advanced analytics, performed detailed data analysis from multiple data sources with the ability to seek out meaningful extrapolative trends and predictive patterns to provide actionable business insights.
• Developed numerous financial models, BI and tableau reports, defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions, advanced Macro, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX and Tableau Visualization Tool.
• Performed data mining, data analyses and statistical analysis with Statistical Tools Mini-Tab, SAS focused on seeking out meaningful 'story' to provide insights, interpreted patterns predicted trends.
• Developed the Statistical and BI databases in SQL Database with automated overnight ETL processes from multiple major data sources and implemented entirely new reporting systems with SSIS and SSAS, SSRS and building OLAP Cubes with MDX scripts.
• Expertise in data modeling both Conceptual/logical and physical, designed table schemas defined Primary foreign keys to describe their relationship for data from variety of sources.
• Expertise designing BI database structures, streamlined process-flows, work-flows for data integrity accuracy and interpreted the consolidated information to deliver innovative solutions to business issues.

TECHNICAL SKILLS:

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net, SharePoint

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS), Tableau

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.

Database Tools: SQL Server Management Studio, Oracle SQL Developer

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

PROFESSIONAL EXPERIENCE:

Tableau/power BI Developer

Confidential, Atlanta, GA

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly registration and physician specific registrations used dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Prepared different views for Patient Registrations, Doctor Scheduling and Lab Tracking.
• Generated dashboard for Billing and Deposit Systems
• Provided security and user roles for all the users of the various modules
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.

SQL Developer/ETL

Confidential, Alexandra VA 

Responsibilities:

• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using Micro Strategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.

Junior SQL/ETL/TABLEAU/POWE BI Developer

Confidential

Responsibilities:

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc
• Installed and configured Enterprise gateway and Personal gateway tableau in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.