SUMMARY

• 6+ years of Data Analyst experience.
• Experience using MS Excel, SQL and/or other applications to perform various types ofanalysis.
• Skilled in Microsoft Access, PowerPoint, SQL Server and various RDBMS.
• Installation, testing, configuration, maintenance, and troubleshooting of all SQL Server components.
• Experience with BI tools such as Tableau and PowerBI.
• Proficient in Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Knowledge in writing Business Requirement Documents (BRD), Use Cases, Functional Specifications; well versed with Use Case Diagrams, User stories, Process flow charts and UML modeling tools such as MS Visio.
• Extensive knowledge of financial management and key financial terms
• Expert in Agile Methodology of SDLC for implementing Business projects.
• Experience with collaborative tools such as Rational Requisite Pro, Rational Team Concert (RTC), SharePoint, Clarity and JIRA.
• Knowledge on Power BI and Tableau to importand analyze datafrom various sources such as SQL Server.
• Create various filters and parameters for reports using Tableau desktop.
• Skilled in Microsoft Excel (e.g., formulas, pivot tables, graphing).
• Experience indatamigration tasks using PL/SQL, SQL Loader.
• Experienced inDataMigration,DataTransformation,DataConversion, andDataloading.

TECHNICAL SKILLS

• T - SQL
• PL-SQL
• Excel
• Microsoft access
• Tableau
• PowerBI
• JIRA
• Confluence
• WPT
• MS SharePoint

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential, Baltimore MD

Responsibilities:

• Developing annual operating plans, capital budgets, and forecasts, and build business cases for new business initiatives (cost/benefit analysis).
• Project Management Experience, working through Corrective Action Plans from beginning to end
• Defining business requirements and provides analysis to increase operational efficiency
• Analyzing actual results against plan and forecast and recommending interventions where appropriate.
• Creating Various Financial reports to help each business unit to manage their budget and aid in forecasting each project cost
• Provide detail presentation financial reports to Senior Management to keep them informed of the company’s performance and Challenges.
• Create and run SQL queries to help pull necessary data from Database
• Identifying opportunities for improvement in operational performance and notifying management of issues and problems requiring immediate attention.
• Providing analytical support for multiple, complex cross-functional projects simultaneously, establishing work plans and timelines.
• Developed T-SQL queries for table creation, wrote stored procedures, views, triggers, and tested tables
• Tracking and analyzing business process operations and key performance indicators (KPI)
• Run daily and weekly reports in excel and macro access database to track team/business process performance.
• Create excel reports using formulas and power queries, linking reports to Database and PowerBI dashboard
• Develop trend reports by creating Power Bi dashboard and analyze report to responsible users
• Develop, organize, and improve business processes for internal and external use.
• Played the role of facilitator as well as a scribe during different JAD sessions

Data Analyst

Confidential, Washington DC

Responsibilities:

• Create and run queries as necessary for project deliverables using SQL
• Work closely with the Risk, Team Leads, and stakeholder to come up with a plan to effectively find the correlation of at-risk enrollment behaviors.
• Evaluatedatapulled for accuracy and relation todatarequests
• Modified an existing MS Access database to improve the usability and reporting by adding menu items and tabs
• Support leadership team in explaining and disseminating information to appropriate stakeholders
• Created financial Ad Hoc reports for EDS Managers and Directors of Medicaid for program monitoring.
• Develop statistical methods to evaluate and analyze numericaldatausing computer software, including MS Access, MS Excel, Oracle, SQL and/or other applications, for assigned projects
• Develop innovative analytical approaches and predictive modeling techniques for reactive or proactivedata analysis, sampling, and study design
• Involved in reporting status, milestones, and project plan tracking to project management and project owners on a weekly basis.
• Communicated with stakeholders, source system teams & developers to understand and explain functional and technical aspect of the project
• Develop trend reports to identify potential program or systematic vulnerabilities
• Provide expertise and guidance to unit and corporate staff as required.
• Represents and participates in group or committee discussions.
• Involve in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
• Improve query performance.
• Data Profiling for accurate and better reporting and analysis.

Data Analyst

Confidential, Vienna VA

Responsibilities:

• Extracted, compiled and trackeddata, and analyzeddatato generate reports
• Participated with troubleshooting, and problem resolution efforts
• Performed dailydata manipulation using SQL and prepared reports on weekly, monthly, and quarterly basis.
• Used Excel functions to generate spreadsheets and pivot tables
• Identified, analyze, and interpret trends or patterns in complexdatasets
• Cleansing and Blending multipledatasources to allow for different views on applicationdatain a single dashboard
• Aided team indatacollection to be used for Tableau visuals
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Performdatamanipulation operations like import/exportdatafrom various external file formats using SQL
• Generated variety of business reports from SQL server using excel with pivot table and pivot chart
• Develop and implement databases,datacollection systems,dataanalytics and other strategies that optimize statistical efficiency and quality
• Checked for invalid/out of rangedata
• Performdatamanipulation operations like import/exportdatafrom various external file formats using SSIS
• Develop, update, and maintain current SQL programs
• Develop and implement databases,datacollection systems,dataanalytics and other strategies that optimize statistical efficiency and quality
• Acquiredatafrom primary or secondarydatasources and maintain databases/datasystems

Data Analyst

Confidential, Bloomfield

Responsibilities:

• Managing master data, including creation, updates, and deletion.
• Managing users and user roles.
• Developed dashboards for internal executives, board members that measured and reported on key performance indicators.
• Developed dashboards for internal executives, board members and county commissioners that measured and reported on key performance indicators.
• Create interactive dashboards and reports for teams within the organization.
• Provide quality assurance of imported data, working with quality assurance analyst if necessary
• Responsible for data mining, development, and preparation of data to provide useful information for internal and external stakeholders.
• Compare medical budgeting to their prior analysis, and assist in customer service issues.
• Develop, update, and maintain current SQL programs
• Perform data manipulation operations like import/export data from various external file formats using SSIS
• Providing technical and process user support functions and software training to staff
• Cleaning and transforming massive data into useful and insightful to specific teams
• Identifying opportunities to enhance data integrity through database structure modifications.