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