SUMMARY

• An IT professional with over five (5) years’ experience in various domains such as Telecommunication and Healthcare domain.
• Very experienced in Data Analysis, Data Extraction, Data Manipulation, Research and Reporting in different Visualization formats and from various sources.
• Able to perform multiple duties in business analysis, project or program management, and functional leadership.
• A great team player who can relate and work efficiently with diverse groups.
• Proven ability to learn, utilize in - house databases and systems to maintain strategic vision of the organization and link it with everyday work.
• Strong ability to write complex SQL queries.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Exceptional organizational and time management skills with the ability to work independently.
• Great 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.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Experience with DATA MINING.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, and Access).
• Self-motivated individual with strong communication skills, great attention to details and the ability to execute under aggressive deadlines.
• Ability to work individually as well as a team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
• Strong troubleshooting and problem-solving skills
• Excellent knowledge and usage of reporting tools such as Excel, Tableau and Power BI.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Proven ability to design and develop reporting tools and dashboards.
• Business sense (finance, accounting, economics, risk management, public health economics, social service research or epidemiology).

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, 2008(X32, X64)

Querying language: SQL, PL/SQL, TSQL

Databases: MS SQL Server, Teradata, Oracle 9i, 10g, 11g

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

Business Intelligence Tools: Tableau 10.1,10.4, 2019.1, 2019.4, 2020.2, Excel, Power BI, SSRS

Querying Tools: SQL Management Studio, Teradata SQL Assistant, Teradata-BTEQ

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Data analyst / Tableau Developer

Responsibilities:

• Gathering Business Requirement and Designed Fact and dimensional Table to initialize a star schema used in creating physical KPI store database with MS SQL Server using the Erwin Data Modeling tool.
• Develop complex ETL (extraction, transformation, and loading) SQL scripts to gather data from various source systems like CSV files, Excel, and SQL Server.
• Identifies problems or needed changes, recommends resolution, and participates in quality improvement efforts.
• Creating dashboard by leveraging techniques such as parameters, filters, sets, groups, and table calculations for a granular and drill-down perspective of the reports.
• Created drill through reports and variance dashboard using tableau to assist the UAT for data validation.
• Generated KPI’s for customer satisfaction survey results and practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Developing KPI reports based on business requirements, creating intuitive dashboards using tableau for quick reviews to be presented to Business and IT users for enhanced business decision making.
• Made business recommendations based on data collected to improve business efficiency.
• Executed data queries across multiple data sources in support of business intelligence reporting needs
• Extensive experience in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Performed Ad-hoc data extraction through queries in SQL Server 2008, Excel, Tableau report.
• Experience in creating various views on Tableau (Tree maps, Heat Maps, Scatter plot)
• Conduct JAD sessions with CMS and other stakeholders to identify, document and communicate business and system requirements
• Managed dashboard view by initializing row-level security to restrict access for different level of business units.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters
• Worked with QA analysts to perform routine testing of imported data and result sets.
• Responsible for the interaction with business stakeholders, gathering and managing delivery of reports.
• Ensure that the deliverables meet organization and performance requirements.

Confidential, Germantown, MD

Data Analyst

Responsibilities:

• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Writing complex SQL queries and optimized queries, views for performance tuning to extract data from database to perform data analysis with Tableau.
• Developed ETL framework for processing and monitoring import of flat files in SSIS for key client
• Supported the company’s healthcare software functions, implementation, and training
• Developed and maintained SQL queries that support data warehousing, joining data from disparate systems, healthcare analytics, and semantic and business logic application, using Tableau.
• Created visualization for logistics calculation and department spending analysis using tableau.
• Maintain test log and test evaluation summary reports.
• Developed Database Triggers and Views, Stored Procedures and Functions.
• Delivered ad-hoc reports, writing SQL Scripts and formatted with Excel using advanced excel functions: pivot tables, v-lookups, etc.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom
• Wrote complex queries to extract data from different tables, using JOINs, Sub-queries, Correlated sub-queries and derived tables on Microsoft SQL server.
• Performed data integration and configuration using SSIS.
• Using MS SQL Server, I developed stored procedures, Furthermore, I executed test cases and defect management for ETL and BI systems, which culminated in improved risk management results.
• Performed planning responsibilities of SDLC and monitored defect tracking system using JIRA to prioritize defect and devise a plan for future enhancements and delivered the artifacts in timely basis.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Collaborated with client and team members to understand and clarify visualization requirements using JIRA, Google drive document.
• Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.