PROFESSIONAL SUMMARY:

• Experienced Data Management Professional with expert level competence in data warehouse and Business Intelligence, with skills to perform testing, data quality, data governance, data integration, data statistics, data policies, business process management and risk management surrounding the handling of data in the organization.
• In Depth knowledge of SQL on various platforms like Hive, Oracle, SQL Server, MySQL, Netezza, Redshift

TECHNICAL SKILLS:

Languages: SQL/PL SQL, Python, ASP.NET, C#, Visual Basic, HTML, XML, CSS, PHP, JavaScript, JAVASAS

Tools: Hadoop, IBM Netezza, Amazon Redshift, SQL Server, SQL Server Integration Service (SSIS), SQL Service Reporting Service (SSRS), Qlikview, Tableau, Power BI, MicroStrategy, Toad for Oracle, SAP Business Objects, Pentaho, Collibra, Visual Studio, Alteryx

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential

Responsibilities:

• Implement Data Quality framework.
• Collect metrics and requirements from stakeholders, analyze business needs and implement framework.
• Extract data from various telecommunications data marts and perform data profiling and data lineage analysis on data
• Implement Data Quality Tool that allows monitoring of datasets and reports on a frequency basis
• Create business rules using data quality dimensions like accuracy, validity, consistency, and integrity to measure the quality of enterprise data sets.
• Developed a health scorecard that quantifies the issues surfaced from a dataset
• Develop various reports that include Financial, Operational, and Engineering KPI metrics, trend analysis, budget forecast analysis etc.
• Collect feedback and perform iterations to propose solutions compatible with our client's strategic direction.
• Develop test plans, test scripts and testing of the data extracts and uploads using SQL
• Perform data validation to ensure traceability of requirements on products of Data Warehouse hosted by databases Hive, Oracle 11g, IBM Netezza and Amazon Redshift.
• Perform report validation developed on technologies Tableau, Power BI and MicroStrategy.
• Provide data management analysis that focuses on data design, integration, data relationships, data quality and transformation
• Support Ad - Hoc requests from the users and business and turn the requests around in a timely manner.
• Facilitate data merging and transformation in preparation for analysis by process planning.
• Communicate and educate both senior and junior colleagues to embed data science and analytics across the organization

Environment: SQL, Hadoop, Hive, Python, Oracle 11g, MySQL, C#, IBM Netezza, Amazon Redshift, Tableau, MicroStrategy, Power BI, UNIX, Alteryx, Querysurge, Collibra, JIRA, SSIS, SSRS

Data Reporting Analyst

Confidential

Responsibilities:

• Co-ordinate with various judiciary representatives (Clients) to collect requirements and data needs.
• Analyze various judiciary data elements fordata profilingand mapping from source to target data environment.
• Provide framework required to manage and ensure the availability, quality, consistency and ability to audit data.
• Performdata analysis, data standardization anddata profiling.
• Perform testing for data integration from various source systems to Administrative Office database systems.
• Develop several complexSQLqueries to perform data validation in SAP Business Objects, Webi reports.
• Review and coordinate issue fixes for SAP Business Objects, Webi reports for Case information for multiple courts
• Provide a formal data governance framework to store and manage the data that supports the Judiciary’s information needs.
• Develop data governance policy, guidance, including; Data Access Policy, Data Usage Policy, Data Integrity and Integration Policy and Communication Plans
• Identify issues in the data governance process that require investigation and assess remediation activities.
• Insert governance steps into System Development Life Cycle (SDLC) and provide data governance hand-offs for project managers
• Conduct requirements sessions, JAD Sessions, leading meetings, unifying business units / departments.

Environment: SQL server 2008/2012, SQL Server Reporting Service(SSRS), Microsoft Office, Microsoft Visual Studio, SAP Information Steward, SAP Business Objects Data Services, SAP Business Objects Web Intelligence, Visual Basic, Python, Tableau Reader

Data Product Management Developer

Confidential, Oakbrook, Illinois

Responsibilities:

• Execute the data strategy of the business which includes Managing and implementing new data Products
• Implement high quality data integration and master data Management (MDM) solutions.
• Design requirements for identifying and acquisition of 400 most important diversity and enterprise data sources.
• Design and implement the automated Extract, Transform and Load for aggregating the sources.
• Implement Vendor Master that allows merging and purging of data sources as desired.
• Released our latest database design by migrating 5 million supplier databases.
• Develop reporting framework for both Enterprise Data Warehouse and Client data mart.
• Develop and manage data product concepts, business models, project plan and product roadmaps
• Manage the database architecture to facilitate maintenance of corporate linkages family tree structure
• Manage the coordination of changes to data elements, prioritize and identify the impact to users.
• Maintain data glossary and define workflow to approve change requests to metadata
• Provide custom solutions for data delivery clients to facilitate non-standard offerings
• Prepare detailed technical documents and data management guidelines
• Prepare requirements, design web pages and lead the development of internal web tools that interface SQL Server for Data Analysis and Data Research
• Identify opportunities to utilize our Unique Data Assets (40 million client data) with big data solutions for the purposes of up selling new data products
• Create a data strategy to sustain the health of the Database by doing daily routines for identifying completeness and age of the data (data governance)
• Create a business logic for purging and archiving data based on data source relevancy

Environment: SQL Server 2008/2012, SQL Server Integration Services(SSIS), Pentaho, Python, SQL Server Reporting Services(SSRS), SQL Server Analysis Server(SSAS), QlikView, Microsoft Office, Visual Studio, SQL, NoSQL, C#, Visual Basic, ASP.NET, MDX, PERL

Data Analyst

Confidential, Oakbrook, Illinois

Responsibilities:

• Design and develop new internal processes for scaling data products
• Develop .NET application to generate reports for Data analytics and diversity reporting
• Redesign the existing database architecture for the purpose of controlling the intake and purging of our data
• Remediate performance and scalability issues with-in the application.
• Various Integration Services packages for automating the integration of the data sources

Environment: SQL Server 2008, SSIS, SSRS, SSAS, QlikView, Pentaho, Microsoft Office, Visual Studio, PL SQL, T SQL C#, Visual Basic, ASP.NET, MDX