Senior Data Analyst
United Way
Total years of experience :11 years, 0 months
• Built reports and dashboards with SSRS (SQL Server Reporting Services) and Power BI. These reports were automated.
• Created dashboards in Andar and Power BI using complex SQL scripts.
• Built SSIS Packages for data transfer.
• Stakeholders were Executive Leadership Teams.
• Increased overall efficiency of the team.
• Developed efficient SQL queries for data extraction and loading.
• Created self-serve reports for slicing and dicing.
Environment: - MS SQL Server 2016, Microsoft Office Suite 2016, Andar, CSS3, Power BI Service, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Report Builder 3.0
• Transformed and loaded Unstructured Data (Microsoft Word File) to Structured Data (SQL Server Database) using C#.net Interop.
• Created data models for importing the data into SQL Server database from unstructured data source.
• Created complex scripts for ETL into SQL Server.
• Created KPI reports using SSRS from the transformed structured data.
• Built reports from three different sources (Microsoft Word File, Microsoft Excel File & Questica Data (SQL Server))
• Published the SSRS reports onto the Power BI Report Server (PBRS).
Environment: - MS SQL Server 2016, Microsoft Excel 2016, Microsoft Word 2016, Report Builder 3.0, SSRS (SQL Server Reporting Services), Visual Studio 2017
• Involved in Data migration between different law enforcement agencies in Madison County (Alabama).
• Participated in creation of Case Management System for Madison County Alternative Sentencing Office (MCASR).
• Created data models for data extraction into SQL server databases.
• Created KPI reports, Business Intelligence reports and Data Analysis using Tableau, SSRS and CARE (Critical Analysis Reporting Environment).
• Created ETL templates and designs for CARE Dashboards.
• Created XML schemas in compliance with NIEM (National Information Exchange Model)
• Statistical Analysis of large Datasets for federal agencies using R platform and MINE tool
• Created Data modeling diagrams (Dimensional Model).
Environment: - MS SQL Server, Oracle, Excel, TOAD, SQL Developer, C#.net, MS Visual Studio 2012, MS Office, Liquid XML, NIEM (National Information Exchange Model), SSRS, R, CARE ETL Reporting Tool, MINE statistical tool, Power BI
• Part of Sovereign countries rating team involved in creation of Decision Support System for Financial Analysts across the globe who would rate financial institutions for auditing.
• Worked in coordination with development team for new Case Management System.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Closely worked with ETL team in identifying the design pattern.
• Involved in AGILE methodology with updates on daily scrum meetings. The Scrum meetings were handled by VersionOne.
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
Environment: - SQL, Excel, Oracle, TOAD, SQL Developer, Arrow Global (S&P Proprietary), VBA Macros, VersionOne
• Created standalone reports using SAP Business Object Desktop and SAP Business Objects Web Intelligence Reports application.
• Creation of SAP Business Objects Universe.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2.
• Worked in importing and cleansing of data from various sources like Oracle, flat files onto Oracle
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, SAP Business Objects XIR3, Oracle 10G, TOAD, Sapphire R5.
• The project was the deployment of Verizon Wireless 4G Network in Columbus, OH.
• Performed IRAT tests which include 4G to 3G CS cell reselection in idle mode, 3G to 4G CS cell
Re-selection in idle mode.
• Used Delorme for route planning and directions.
• Responsible for solving all the issues with LLDM & WINDS software and post processing of the data.
• Writing scripts to test the data from different cells.
• Operate database management system for RF data from different cells.
Environment: Microsoft Excel, WINDS, LLDM, Windows XP
• Maintained database for entire chemical inventory.
• Created reports depending on dept requirements using TOAD.
• Guided undergraduate students in different lab activities including Organic chemistry and Bio- Chemistry Lab.
• Graded exercises, assignments, worksheets, as well as record grades and attendance.
Environment: CISPro, Oracle, TOAD, Windows XP
• Published The Northwest Missourian newspaper on the website www.nwmissourinews.com.
• Won third prize for best college newspaper website by Associated Collegiate Press in the year 2009.
• Extensively used HTML and XML for publishing.
• Designed advertisements for student publications using Adobe InDesign and Photoshop.
• Published data onto the newspaper from student journalists.
Environment: College Publisher 5.0, HTML, Adobe InDesign, Photoshop, Dreamweaver, Flash, Macintosh
Masters in Computer Science Aug' 2008 - May 2010 Northwest Missouri State University Maryville, MO
URL removed due to policy violation. Please contact support for further information.