SUMMARY

• An IT professional with (6) years’ experience in various domains such as Banking, Finance and Healthcare.
• An enthusiastic individual with extensive experience in Data Analysis, DataExtraction, and manipulation, ETL development, Data modeling and Warehousing, Research and Reporting from various sources.
• Proven ability to learn, utilize in - house databases and systems to maintain strategic vision of the organization and link it with everyday work.
• Able to perform multiple duties in business analysis, project or program management, and functional leadership.
• 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.

TECHNICAL SKILLS

BI Tools: Tableau, PowerBI, MicroStrategy, Excel, PowerPivot, Cognos and SSRS

Databases: MS SQL Server, DB2, Oracle, Access, Snowflake, Teradata

Programming/ Querying Language: SQL, PL/SQL, T-SQL, SAS, Python

ETL & Other Tools: SSIS, SAS Base 9.x, Erwin Data Modeler, Informatica power center, ER Assistant, Jira, Confluence

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst/Tableau Developer

Confidential - BALTIMORE, MD

Responsibilities:

• Use data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their Data.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Utilize SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
• Written complex SQL queries using advanced SQL concepts like Aggregate functions and optimized queries for performance tuning.
• Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server, and Oracle databases.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and dashboards using KPI’s.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.
• Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
• Produced Logical Data Models/Physical Data Models.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop and Created conditional filters to filter the data on dashboard.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Work with client and team members to understand and clarify visualization requirements
• Written complex SQL queries and optimized queries for performance tuning.
• Deployed product updates as required while implementing integrations when they arise.
• Automated our operational processes as needed, with accuracy and in compliance with our security requirements.

Tableau Developer

Confidential - COLUMBUS, OH

Responsibilities:

• Supports the company’shealthcare software functions, implementation, and training.
• Created, designed, and formatted technical documentation including architecture diagrams, process flows, and other information or processes needed to describe required system changes for development and QA.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Working with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premium data by pulling from data warehouse and generating day-to-day reports in support of the Actuarial Finance Department for pricing catastrophic actuarial analysis and other purposes.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
• Data analysis, reporting using Tableau and SSRS
• Ensured all project requirements and objectives are properly documented and pursued.
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using python.
• Designed, developed, tested, and maintained Tableau functional reports and visualization based on users’ requirements to solve business problems.
• Specified, documented, and developed new product features, and wrote automating scripts.
• Managed code deployments, fixes, updates, and related processes.
• Transformed business requirements documents into technical specifications.
• Identified trends and developments in competitive environments and presented findings to executives.
• Executed ad hoc reporting requirements for executive management team.
• Wrote Custom SQL to support business requirement and Implemented data blending to blend related data from different data sources.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.
• Utilized SSIS for ETL data modeling, data migration, and analysis
• Developed Database Triggers, Views, Stored Procedures and Functions
• Participated in training and developed end user training plan.

Data Analyst / SQL Developer

Confidential - Ellicott City, MD

Responsibilities:

• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Wrote complex SQL queries to retrieve data from disparate table utilizing Joins, Sub-queries and used concepts like Cast, CTE’s and table expressions against SQL server database and Oracle.
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST, and volatile tables.
• Created SQL stored procedures using SQL Query and prepare reports working with database structures and data modeling including working knowledge of SQL.
• Developed number of Complex Informatica Mappings, Reusable Transformations for different Systems to facilitate Daily, Monthly and Yearly Loading of Data
• Used SAS to import and export data from and into Teradata tables.
• Worked with OLAP and OLTP tools such as ETL, data warehousing and Modeling.
• Participated in analyzing business requirements, Use Case Modeling, Data Model Design, Data flow from various Sources to Target.
• 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 gives business a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Monitored and maintained user container space and suggested improvements in table creation to user who had skewed numbers.
• Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements.