Senior Business/ Data Analyst Resume
Lafayette, LA
SUMMARY:
Experienced Business/Data Analyst with 5 years of experience in diverse IT domains such as Healthcare, Retail and Education. Very skilled in translating business requirements into functional requirements to support business and data analysis. With my wide range of technical expertise and multilingual skill, I strive to leverage my expertise with team effort to attain organizational goals
TECHNICAL SKILLS:
BI Software/ Programming languages: SQL, PL/SQL
BI/ Visualization Tools: Tableau Desktop, Tableau Server, Power Point, MS. Excel, MS. Access
Database: MS SQL server 2008/2012, MS. Access, Oracle
Data Modeling: Oracle, SQL, Erwin
PROFESSIONAL EXPERIENCE:
Confidential, Lafayette, LA
Senior Business/ Data Analyst
Responsibilities:
- Helped in the resolution of scope questions and issues
- Maintained Data Normalization Routine in order to maintain Data quality and consistency
- Acted as liaison and advisor between the business and IT stakeholders.
- Participated in the analysis of client business processes and functional requirements
- Maintained Data mapping documents, Bus Matrix and other Data Design artifacts that define business data requirements and transformation rules.
- Independently performed data analysis, data discovery and data profiling using industry standard querying tools to support business requirements development that are complete, clear, unambiguous, well written and appropriate to audience.
- Participated in the analysis of client business processes and functional requirements
- Structured and drove working and informational sessions that promote collaboration, synergy, and achieve desired outcomes
- Ability to present ideas in user - friendly Language
Confidential, Harrisburg, PA
Data Analyst
Responsibilities:
- Participated in the analysis of client business processes and functional requirements.
- Analyzed data to understand gaps, inconsistencies and other quality issues and devised DQ improvement solutions.
- Created new database objects like Tables, Procedures, Functions, Indexes and Views
- Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
- Participated in cross-functional task forces to identify and document functional requirements.
- Extracted data from existing data stores and warehouses, Developed and executed departmental reports for performance and response purposes by using SQL Server Management Studio, MS. Access, MS. Excel
- Worked in conjuncture with business analysts to clarify requirements for report requests.
- Analyzed BRD/FRD in order to determine feasibility of requirements for reports.
Confidential, Atlanta, GA
Business Analyst/ SQL Developer
Responsibilities:
- Created rich dashboards using Tableau Dashboards and prepared user stories to create compelling dashboards to deliver actionable insights.
- Extracted data from data warehouses, Developing and executing departmental reports for performance and response purposes
- Created pivot tables in Excel by getting data from Teradata and Oracle and used the data to find data anomalies.
- Maintained Data consistency and database integrity.
- Developed scenarios for Unit testing and Integration testing.
- Involved in Production Support and troubleshooting data quality and integrity issues.
- Possess good Analytical and Documentation skills and ability to perform in a Team Environment.
- Responsible for interactions with business stakeholders, gathering requirements and managing the delivery.
- Connected Tableau server to publish dashboard to a central location for portal integration.
- Created visualization for logistics calculation and department spending analysis.
- Maintained test log and test evaluation summary reports.