We provide IT Staff Augmentation Services!

It Data Analyst Resume

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

Hire Now