SUMMARY

• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server Database
• Experience in Dimensional modeling using Star Schema and Snowflake Schema and data analysis to provide Business Intelligence solutions.
• Professional Tableau Developer | Data Analyst with over 8+ years' experience in the Data IT fields such as healthcare, Banking, and Insurance domain. Including extensive technical background in DB applications, Data Analysis, Dashboard development, ETL Development, and Data warehousing concept.
• Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management.
• Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
• A wonderful team player who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups.
• Self - motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Excellent knowledge of Business Intelligence and Data Warehousing with good fundamentals in Databases.
• Identified issues when reports are created from several and complex data sources.
• Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For-each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc. Also, different types of sources and destinations like Oracle source, SQL, Excel, flat file, Raw, etc.
• Working experience in using various Microsoft office products like MS Excel, MS Access, MS Visio, and MS PowerPoint to create and reports and templates.
• Excellent knowledge and usage of reporting tools such as Tableau and Power BI.
• Experience in data scrubbing and cleansing.
• Participating on Review and Retrospective meetings for sharing ideas to improve productivity.
• Good understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Exceptional organizational and time management skills and the ability to work independently.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2012/2016/2018 MySQL 5.2, 5.7, Oracle 9i, 10g, 11g Snowflake

Proficient in Microsoft Office: (Excel, Access, Word, and PowerPoint)

Operating SYSTEMS: (Win XP, Vista, 7, Windows Server 2008, 2010 (X32, X64)Unix)

ETL / Other Tools: SAS Base 9.x SAS Enterprise Guide SSIS, Erwin Data Modeler ER Assistant

Querying Tool: SQL Management Studio 2008/2012/2016/2018 SQL Plus, SQL Developer

Business Intelligence Tools: Tableau, Power BI MicroStrategy, Excel and PowerPivot, SSRS

Programming Language: SAS

PROFESSIONAL EXPERIENCE

Confidential, VA

Database Developer

Responsibilities:

• provided hospital staff after Cerner Go-live support.
• Creating patient list, creating, and preparing patient discharge.
• Support in a primary care ambulatory setting.
• Actively troubleshoot any issues that arise during testing and production, catching and solving issues before launch.
• Test our system integrity, implemented designs, application developments and other processes related to infrastructure, making improvements as needed.
• Update our processes and design new processes as needed.
• Deploy product updates as required while implementing integrations when they arise.
• Automate our operational processes as needed, with accuracy and in compliance with our security requirements.
• Specifying, documenting, and developing new product features, and writing automating scripts.
• Manage code deployments, fixes, updates, and related processes.
• Offer technical support where needed, developing software for our back-end systems.
• Transform business requirements documents into technical specifications.
• Assisted the front desk on how to scan in epic using the media Manager.
• Using Epic super user supporting nursing staff and provider support with inpatient cliindoc, and Ambulatory clinic, applications along with providing elbow to elbow support to nurses for clinical documentation during Epic, Cerner, and McKesson conversion.
• Designed built and maintained backend database using Azure SQL Databases
• Developed Database Triggers, Views, Stored Procedures and Functions.
• Assisted with validation of the clinical workflows.

Confidential, Arlington, VA

Data Analyst | Database Developer

Responsibilities:

• Assists with coordination of database changes within context of overall configuration management process.
• Analysis of the specifications provided by the client
• Assists with coordination of database changes within context of overall configuration management process.
• Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques.
• Responsible for Backup and Recovery, Monitoring, creating data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
• Created and populated Customer data using advanced SQL
• Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
• Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN.
• Maintained data consistency, SQL database integrity and reported instances of data corruption.
• Performed numerous data extraction requests involving SQL scripts.
• Performed data migration between different environments and Third-Party Databases.
• Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.
• Performed data migration between different environments and Third-Party Databases.
• Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.

Confidential, Weston, MA

Tableau Developer | Data Analyst

Responsibilities:

• 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 that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Vast experience with the design and development of Tableau visualization solutions.
• Ability to work independently or in a team setting.
• Generated advanced Tableau dashboards that allowed business to track and improve customer units KPI.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Confidential, Schaumburg, IL

BI Developer | Data Analyst

Responsibilities:

• 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 that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
• Used SAS to import and export data from and into SQL Server tables.
• Planned, analyzed, and designed Universes using SAP Business Objects as per Business needs.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS).
• Write reusable, testable, and efficient code using python.
• Design and implement of low-latency, high-availability, and performant applications
• Design and implement of low-latency, high-availability, and performant applications