Sr Reporting Analyst Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Specializes in using data to tell a story. Dedicated and results - focused BI Developer with over nine years of in strengthening organizational transformation by driving strategic technology initiatives.
- Natural relationship builder who knows how to get bottom-line results. Analytical thinker who excels at communicating with individuals, groups, and teams. Adept at translating technical concepts into user-friendly language. Certified in COGNOS 8 BI Report Authoring.
- Data Mapping Data Modeling BI Reporting Ad Hoc Analyses Relationship Management Agile Methodology
TECHNICAL SKILLS:
- ETL
- SQL Server
- Oracle 9i
- Dynamics GP
- EDI
- Power BI
- Cognos
- Azure
- SQL Integration Services
- SQL Analysis Services
- SQL Reporting Services
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
SR Reporting Analyst
Responsibilities:
- Created a BI Clinical Dashboard for 24-hour Monitoring Center.
- Designed and completed a Data Warehouse solution with daily, weekly, and monthly data loads.
- Created a Forecasting Calculator to provide predictive staffing needs and analysis.
- Developed ETL solutions utilizing SQL Server 2012 Integration Services (SSIS/DTS/DTSX).
- Investigated and mitigated any errors during the daily/weekly/monthly/quarterly ETL import process.
- Constructed Ad-hoc and on-going SSRS reports using cube and data warehouse solutions in Azure platform.
Confidential, Houston, TX
System Support Analyst
Responsibilities:
- Led initialization, testing, and maintenance of EDI processes and relationships.
- Read and diagnosed X12 coding errors and designed solutions for the proprietary data mapping and translator.
- Established and performed an introduction level program for new customer users.
- Built stored procedures, functions, triggers, and SQL Server jobs to enhance productivity and decrease development time.
Confidential
Data Analyst
Responsibilities:
- Participated in team that transitioned internal business intelligence from MS Access to SQL Server Reporting Services.
- Monitored and verified synchronization of three different accounting systems.
- Performed ad-hoc data queries for internal and external users.
- Wrote and published 60 SSRS reports for internal users.
Confidential, Dallas, TX
Consultant
Responsibilities:
- Enhanced project file version control by leading a team of 5 developers to define, design, develop, roll-out, and test web-based artifact system employing XP methodology, PHP, XML, JavaScript, and DB2.
- Increased development lead, application responses, and messaging times by collaborating on the design, development, implementation, and testing of an integrated business application.
- Maximized inventory, trend, and product placement management for a leading soft drink manufacturer by drafting a Proof-of-Concept model and documentation for a real-time reporting application.
- Streamlined business model standardization by teaming on conversion of coast-to-coast medical lab acquisitions from project start-up. Defined/prioritized business intelligence needs, purchased front-end BI system, and crafted reporting/ETL processes to integrate multiple legacy databases.
- Decreased enhancements and error corrections 30% in 6 months by initiating investment in reporting analysis application. Logged pinpointed errors and delegated correction tasks.
