We provide IT Staff Augmentation Services!

Reporting Analyst / Developer Resume

Sparks, MD

SUMMARY:

  • Seven (7) plus years of experience as an Analyst in various industries with emphasis in IT, Financial, Insurance and Healthcare Management.
  • Extensive Experience in Data Analysis, Data Manipulation, Data Extraction, Research and Reporting in different formats and 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.
  • 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, Windows Server 2003, 2008(X32, X64)

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

ETL/Other Tools: Microsoft Suite (Excel, Access, PowerPoint, Word, Visio), SSIS (Visual Studio)

Querying Tools: Quest TOAD, SQL Management Studio 2008/2012/2014, SQL Plus, SQL Developer, DBeaver

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 10.x, 9.x, Power BI, MicroStrategy, Excel, SSRS

Project Management Tool: Jira

PROFESSIONAL EXPERIENCE:

Confidential, Sparks, MD

Reporting Analyst / Developer

Responsibilities:

  • Design and develop metrics, reports and analyses to drive key business decisions.
  • Upload data from CMS files into database Tables to create report for business decisions
  • Examined reports to locate and resolve errors.
  • Analyzed data for business reports to make sure data and calculations are accurate
  • Utilized SQL server reporting services and SQL Server Integration Services to develop and maintain reports
  • Enhance data management and reporting environment tools to measure performance trends and enable identification of operational/control break points for various Regions.
  • Clean, process and load data through ETL using SSIS and queries in SQL Server, presented in MS Excel, Tableau report or PDF.
  • Create new database objects like Tables, Procedures, Functions, Indexes, Views.
  • Deployed reports for company Report server
  • Used SSRS and Tableau reporting tools
  • Created complex reports for company for Phlebotomist productivity for all Regions

Confidential, Dublin, OH

Data Analyst

Responsibilities:

  • Support, manage, and maintain organizations clinical data in databases in SQL Server.
  • Analyze data and develop unique tables, charts and other data displays for inclusion in reports to various clients and as data support for research/consulting staff.
  • Gather, analyze, and document data requirements for projects of medium to high complexity and moderate to high risk, perform source system data quality analysis.
  • Perform numerous data pulling requests using SQL server 2012 and Tableau for analysis.
  • Collect data from all clients and make recommendations for improvement.
  • Clean, process and load data through ETL using SSIS and queries in SQL Server, presented in MS Excel, Tableau report or PDF.
  • Create new database objects like Tables, Procedures, Functions, Indexes and Views
  • Support the company’s healthcare implementation and training.

Confidential, Northfield Township, IL

Data Analyst

Responsibilities:

  • Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
  • Used Visual Studio report builder to design report of varying complexity and maintain system design documents.
  • Data analysis, reporting using Tableau and SSRS.
  • Built and supported the transformation of various data inputs into the companies Data Warehouse.
  • Analyzed and designed solutions, create technical integration and consult with QA personnel on their tasks related to the imports and extracts.
  • Designed and developed Insurance, Reinsurance, Claims and Financial Reports Using SSRS.
  • Identified Data discrepancies and worked with database team to find better solutions.

Confidential, Pittsburgh, PA

Data/ Business Analyst

Responsibilities:

  • Created ETL solution to read Product and customer data from files on shared network into SQL Server database. Solution validated incoming data and performed notifications when jobs were complete. Loaded customer data into SQL Server to generate SSRS reports, which were set up for automatic delivery based on standard report subscriptions.
  • Implemented functionalities of application according to business requirements through stored procedures, functions and triggers.
  • Gathered and managed Data in SQL server 2012, MS Access.
  • Made business recommendations based on data collected to improve business efficiency.
  • Data analysis reporting using Tableau and SQL.
  • Demonstrated team cohesiveness and organizational commitment.

Hire Now