We provide IT Staff Augmentation Services!

Snr Data Analyst / Bi Developer Resume

Washington, DC

SUMMARY:

  • 9+ years in fields such as Financial, Banking, and Healthcare domain. Savvy and dynamic individual with a wide range of IT knowledge and expertise gathered over the span of Very passionate about projects and able carry out tasks that are time sensitive in an efficient manner in order to guarantee the growth and improvement of the organization.
  • Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
  • Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Experienced in working with tools like TOAD, SQL Server Management studio(SSMS), SQL Developer, and SQL plus for development and customization
  • Ability to understand the business from various points of view due to diverse experiences as Programmer Analyst, Business Analyst and Marketing & Strategic Planning Analyst.
  • Experienced in Data manipulation, Report creation, Importing & Exporting Data in different formats and from various sources
  • Proven ability in working with enterprise level large data warehouse, RDBMS systems, and ETL and modeling tools/techniques
  • Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
  • Experience with DATA MINING.
  • Identified issues when reports are created from several and complex data sources.
  • Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin
  • Expertise in ensuring quality and data integrity in all project deliverables
  • Extensive TABLEAU Experience in Enterprise Environment, in Tableau 10.x, 9.x, 8.x as a Developer and Analyst
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Experience working with various data sources such as Oracle, SQL Server, Teradata, PostgreSQL, MySQL and flat file sources
  • Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, Sharepoint and Visio).
  • Excellent knowledge and ability to create reports, dashboards and Trend analysis with tools such as Excel and Tableau
  • Experience in Data Munching (data scrubbing and cleansing).
  • Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
  • Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
  • Exceptional organizational and time management skills and the ability to work independently.
  • Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS:

Operating Systems: Win XP, Vista, 7, Unix, Windows Server 2003, 2008(X32, X64)

Databases: Oracle 10g/11g/12c, MS SQL Server 2008/2012/2014, MySQL 5.2, 5.7, MS Access, Teradata, PostgreSQL

ETL/Other Tools: SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, SVN, Github

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: Quest TOAD, SQL Management Studio 2008/2012/2014, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata-BTEQ

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 10.x, 9.x, Jaspersoft, Cognos, Excel, PowerPivot, SSRS

Programming language: R, Python, Java, Shell Scripting, HTML, PHP

Project Management Tool: Jira

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Snr Data Analyst / BI Developer

Responsibilities:

  • Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
  • Business requirement gathering and translating them into clear and concise specifications and queries
  • Played a key role in UAT process by taking valuable feedback from customers and improving product performance which led to project's extension
  • Created database objects such as tables, views, stored procedures, triggers
  • Produced clear, concise, relevant and accurate documentation based on captured requirements and information gathered from stakeholders and subject matter expert
  • Created Dashboards that ensured data driven monitoring of KPI, KRI and KCI, exposures, controls and processes tracked appropriately to provide guidance for risk mitigation and process improvements
  • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
  • Documenting the extent to which data fails to meet threshold reporting requirements
  • Define and maintain current state documentation and data lineage capture using data flow and metadata
  • Mastered the ability to design and deploy rich Graphic visualizations with Navigational sheets, Drill Down menu option and Parameterized using Tableau.
  • Generated Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
  • Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 10.x/9.x
  • Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Confidential, Providence, RI

Sr. Data Analyst

Responsibilities:

  • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
  • Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
  • Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS
  • Utilize SSIS for ETL data modeling, data migration, and analysis
  • Business requirement gathering and translating them into clear and concise specifications and queries
  • Prepare high level analysis reports with Excel and Tableau
  • Provides feedback on the quality of data including identification of billing patterns and outliers
  • Analyze and Assess invalid and missing data in the All Payer Claims Data
  • Used SAS to mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis
  • Documenting the extent to which data fails to meet threshold reporting requirements
  • Created T/SQL statements (select, insert, update, delete) and stored procedures.
  • Data governance and defining processes concerning how data is stored, archived, backed up, and protected from mishaps, theft or attack.

Confidential, Oak Ridge, TN

SQL Developer / Tableau Developer

Responsibilities:

  • Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
  • Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
  • Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
  • Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
  • Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
  • Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse
  • Created numerous Permanent tables, Volatile tables and Global Temporary tables
  • Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
  • Ensured that data warehousing design was scalable and maintainable
  • Created dashboards using scatter plots, histogram, Box Plots, geographic map, Pie Charts and Bar Charts, trend charts, Waterfall charts
  • Experience in creating filters, quick filters, data source filters, local and global filters, context filters and user filters.
  • Created different Calculation fields per requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
  • Created dashboards using advance analysis actions, groups, parameters, background images, maps, groups, and sets.

Confidential, Chicago, IL

Data Analyst / ETL Developer

Responsibilities:

  • Performed data mapping for the process
  • Performed ETL data loads from flat files, DB2, Teradata, PL/SQL etc. to transform data into complex scripts and codes for software application testing
  • Enhanced the PL/SQL test scripts for data driven tests
  • Developed and executed automated test case scripts Test for the Front-end applications
  • Performed Data Analysis, created gap analysis document, and performed data quality Checking.
  • Created numerous temporary, derived, permanent and volatile tables.
  • Used Teradata OLAP functions like random, qualifies, top n, rank, sample and random.
  • Created an automated daily ETL (Extract, Transform& Load) process using Teradata Utilities such as Fast Load, Multi Load and SQL Assistant
  • Worked with the testing team to resolve bugs related to ETL mapping before production
  • Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements

Confidential, Minneapolis MN

Data Analyst

Responsibilities:

  • Created an automated daily ETL (Extract, Transform& Load) process using Teradata Utilities such as Fast Load, Multi Load and SQL Assistant
  • Experience with Centers for Medicare and Medicaid Services, health care provider data and online data submission process.
  • Use state-of-the-art decision support and neutral network tools to detect potential fraud and support investigations organizing case files, research violations and accurately and thoroughly document all steps taken in project development
  • Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group By and OLAP (Online Analytical Functions).
  • Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
  • Worked with OLAP and OLTP tools such as ETL, data warehousing and Modeling.
  • Responsible for designing the new reports and writing the technical document, gathering the requirements, analyzing the data, and creating SSRS reports and dashboards.
  • Created numerous permanent tables, Volatile tables and Global Temporary tables.
  • Provide data analysis support to the fraud investigation team in support of their investigation leads
  • Created SQL stored procedures using SQL Query
  • Prepare reports working with database structures and data modeling including working knowledge of SQL.
  • Handle Strong healthcare material including experience with transaction standards (e.g. HIPAA Conduct self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospital, and rehabilitation facilities.
  • Gathered Information, analyzed reports and presented reports

Hire Now