It Data Analyst Resume
3.00/5 (Submit Your Rating)
Newark, NJ
SUMMARY:
- Result - oriented Analyst with 5+ years of experience in data analysis and database systems.
- Track record of delivering reporting and data analysis to facilitate Senior Management decisions. Demonstrated leadership qualities and team work in implementation of data quality solutions. Six-sigma
TECHNICAL SKILLS:
Database: Teradata, Oracle 9i/10G, IBM DB2, MS SQL Server 2012, MS Access
Business Intelligence: Qlikview 11, Tableau 9, Cognos 10.1, Business Objects
Additional Skills: Informatica MDM, Informatica IDQ, Informatica DIH, Hadoop, MongoDB, Amazon Web Services, Enterprise Master Patient Index, Data Warehouse, Service Oriented Architecture, SAS Enterprise
PROFESSIONAL EXPERIENCE:
Confidential, Newark, NJ
IT Data Analyst
Responsibilities:
- Spearheaded development of a multi-year roadmap for a multi domain MDM solution that aligns to the strategic goals of the enterprise
- Engaged with business partners to establish the data governance council, its vision, charter, and monthly operations to communicate data standards, ensure a common business vocabulary, and leverage data cross-functionally
- Designed plans for auditing, profiling, and cleansing data from multiple sources to measure quality of data
- Performed root cause analysis on data anomalies via SQL and presented recommendations for data stewardship
- Produced Tableau dashboards and IDQ scorecards on data quality metrics in order to evaluate critical points of interest
- Directed and coached team of Junior Data Analysts on project deliverables and expectations
Confidential, New York, NY
Senior Business Analyst
Responsibilities:
- Delivered reporting and analytics that identified opportunities for cost savings through implementation of Alternative Fee Agreement(AFA), Alternative Dispute Resolution(ADR), and Panel Optimization initiatives
- Designed real-time QlikView and Tableau dashboards which evaluate law firm performance based on defined KPIs and quantify $3B in AIG legal spend
- Created, implemented and automated UK and US operational reports to track ebilling utilization of matter management platform TeamConnect resulting in $100M of savings over 3 years
- Identified data quality issues and ensured critical data elements are compliant with AIG Data Governance standards and stakeholder expectations
- Employed text analytics tools such as Python NLTK and Mallet to identify claims eligible for E-discovery and Contract Attorney savings ($20M over life of claim)
- Streamlined ad-hoc SQL query usage resulting in 72% decrease in the AIG Data Center charges ($815K to $228K) across DB2 and Oracle systems
Confidential, New York, NY
Systems Engineer Analyst
Responsibilities:
- Developed test cases with client technical lead to detail Windows 7 requirements
- Managed project metrics and reporting through SQL Server and Access databases
- Utilized MDT and SCCM technologies to execute enterprise-scale Windows 7 deployments
- Organized and streamlined weekly reporting through Excel PivotCharts and VBA scripting
- Facilitated discussions with clients to highlight project roadblocks and assess risks