I am an IT professional with more than 5 years' experience in various domains such as Finance, Insurance, Retail and Healthcare. I am present with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. I pride myself in my ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and utilize that in completion of my tasks on the job. I can perform multiple duties in business analysis, project or program management, and functional leadership. I am also a great team player who can relate and work efficiently with diverse groups.
Skills
Ability to utilize business intelligence tools such as data warehousing, reporting, querying tools and excel.
Experience in Data Analytics and ETL techniques for loading enormous amounts of data.
Experience with DATA MINING.
Ability to identify issues when reports are created from several and complex data sources.
Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
Strong ability to write SQL queries.
Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
Excellent knowledge and usage of reporting tools such as Tableau and Crystal Reports.
Experience in data scrubbing and cleansing.
Great understanding of SDLC methodologies (specifically SCRUM).
Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
Good knowledge of portfolio analysis, management and customer segmentation.
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.
Experience
08/2019 to Current
Data AnalystAltice Usa – Parkersburg, WV,
Designed the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.
Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
Extracted, manipulated and built complex formulas in Tableau for various business calculations.
Involved in resolving reporting issues and design issues throughout the reporting life cycle.
Developed SQL queries to manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Ensured all project requirements and objectives are properly documented and pursued.
Created conditional filters to filter the data on dashboard.
Creating Parameters for desired functionality.
Responsible for developing, analysing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
Work with client and team members to understand and clarify visualization requirements
Written complex SQL queries and optimized queries for performance tuning.
Exporting data to MS Access and Excel for periodic and exception reporting; creating various types of graphs and summaries.
Interacting and communicating with colleagues as required for routine and ad hoc tasks to achieve objectives effectively
03/2018 to 08/2019
Senior BI / Data AnalystJP Morgan Chase – City, STATE,
Maintain Structured Query Language (SQL) and extract, transform and loading processes established to aggregate various data sources across the Bank used in analysis and modeling.
Complete quality assurance on data feeds, rectifying inconsistent or erroneous data to ensure the accuracy of data used in these analyses; research and respond to ad-hoc data requests.
Maintain the data structures through proper change management for use by multiple risk practice groups.
Document and maintain data process procedures to serve as reference; adhere to established controls to ensure data quality.
Use appropriate analytical software to develop custom balance sheet and risk reports.
Provide financial analysis and data support to other groups/departments across the Bank as needed.
Support presentation and visualization of data through standard tools (e.g. Tableau).
Support Treasury Division contributions to bank wide efforts (e.g. Stress Testing).
Create Technical / design specification based on business requirements in clear and concise formats.
Designed and use of Tableau Analysis/Reporting tool.
Proven ability to manage and analyze large data sets, with careful attention to detail.
Strong interpersonal skills, with an equally strong desire to learn Advanced computer skills and strong knowledge of pertinent word processing, spreadsheet and database software.
Experience using SQL, SAS or related language.
Designing automated processes to move, format, standardize and scrub large amounts of data.
Building databases for data standardization, data archiving and reporting.
Creating, maintaining and managing SQL Server Integration (SSIS) packages
04/2016 to 03/2018
Well Care, ContractorDATA MINING – City, STATE,
Creating KPIs for various lines of businesses for decision making purposes.
Supporting various departments such as Med Management, Customer service, and Finance with their daily ad-hoc data needs.
Writing and maintaining stored procedures to keep track of Monthly spending on, and MLR of patients and groups.
Creating reports to track ED Utilization and measures to reduce Utilization.
Utilizing knowledge of ICD codes, Procedure Codes, and Rev Codes to provide useful reports on utilization and Finance.
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 SQL Server databases.
Utilize SISS for ETL data modeling, data migration, and analysis.
Prepare high level analysis reports with Excel.
Provides feedback on the quality of data including identification of billing patterns and outliers.
Analyze and Assess invalid and missing data in the Claims Data.
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.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
