SUMMARY

• Proficient in MS Excel, Pivot Tables, MS Word, MS Access Database, MS Powerpoint, Visio, MapInfo, SQL, Javascript, Windows Server 2008 R2, MS Exchange, TCP/IP Protocol, JIRA.
• Experienced in Data mining methodologies, aggregation, Ad hoc analysis, data presentation, dashboard creation, data migration and statistical analysis. Also resource discovery using Metadata.
• Experience with ETL, MDM tools like Informatica. BI Data visualization with Tableau and PowerBI, experience with commercial lending solutions like Fiserv and Cadence.
• Adept at creating Business Requirement Documents (BRDs) and Functional Requirement Documents(FRDs) as well as Use Cases.
• Experienced in Supply chain, sourcing, procurement, and supplier relationship management. Performance, Time Tracking and Creating Dashboards and reports using Excel.
• Experienced in Creating, manipulating, and validating SQL stored procedures for SSRS reports.

WORK EXPERIENCE

Data Analyst

Confidential - Oakland, CA

Responsibilities:

• Built PowerBI data visualization dashboard connected to live datasource for operational reporting to help electric utility clients track project performance across multiple zip codes and help in making better informed decisions.
• Created Data quality report to highlight areas of low data quality with the overall goal of improving data quality and integrity across the company and client databases. Also analyzed the data and documented recommendations for improvement.
• Built Tableau reports for NVE, the public electric utility that services the state of Nevada to visualize the tiers of electricity customers based on energy savings from participation in NVE s energy efficiency programs.
• Used SQL to aggregate complex and large datasets covering customer data, energy utilization and zip codes from multiple electric utilities databases across the US. With dis me was able to determine which energy saving measure was most effective based on different metrics like customer type, region, Utility etc.

Data Analyst

Confidential - Dallas, TX

Responsibilities:

• Data analyst for Radio Frequency(RF) optimization team. Collaborated with RF engineers to identify and implement KPIs. Identified alternate use cases, and implemented metrics for optimum telecom traffic routing.
• Used advanced excel functions such as SUMIF, COUNTIF, SPLIT, INDEX, and PIVOT Tables to clean data and create reports. Also used Data validation in excel to ensure data integrity.
• Analyzed variance of KPIs between different regions using Excel ANOVA and Developed Exponential smoothing models to forecast Network performance which helped the Network Engineers in choosing the right transmission equipment.
• Troubleshoot data of dropped calls and low data throughput within clusters of transmission towers. Pinpoint data anomalies & decipher hidden traffic patterns. Create use cases, test cases, and test scripts.
• Collaborated with RF data collection team and RF engineers on LTE, UMTS deployment and optimization. Prepared Powerpoint presentations of network performance optimization using field data.
• Troubleshoot inconsistencies in monthly sales results. Pinpoint data anomalies & decipher hidden traffic patterns. Identify high value data points for user fingerprinting and for KPI calculations. Apply transitive property to match many incarnations of a single user from registration to point - of- sale to increase accuracy of sales conversion calculations. Create use cases, test cases, and test scripts. Verify data for user events, user tracking and Marketing Analytics database. Collaborate with Marketing team on a daily basis.
• Finalized requirements for data migration project by meeting with Business Users, Technical Team, IT management, Project Management, and the data vendor. Author requirements document based on kickoff meetings and using high-level powerpoint as baseline. Identify and document potential scalability issues. Recommend operational protocols to track nightly performance against department SLAs.
• Combined Data Analyst role on the same data migration project. Vet the new vendor feed for precision, accuracy, and completeness. Perform validations against the legacy data source, the new candidate data source, and the data destination. Cross-check all findings against Master/Reference Data feeds.

Business Analyst / Data Analyst

Confidential - Atlanta, GA

Responsibilities:

• Part of Agile development team delivering full life - cycle business intelligence. Created user stories. Participated in sprint planning, backlog pruning, sprints, daily scrums, and sprint retrospectives. Optimized data reporting for contact center through company CRM
• Implement third party MDM application (Master/Reference Data). Conduct current state capability analysis to assess existing organizational capabilities versus business objectives. Interview business users, and model Business Domain end-to-end using high-level Use Case diagrams depicting data entry, data consumption, data enrichment, and data deployment to website. Document data flows and compile data dictionary.
• Validate new data flows against baseline use cases and business objectives. Set performance targets and work closely with vendor to close performance gaps. Perform iterative data migration & data reconciliation between mysql and Postgres. Liaise between business users and solutions vendor designing user interface and workflows.
• Leveraged start-up ETL toolset to load and manipulate data in EAV product data warehouse. Reconcile,normalize, merge, and collate data across multiple sources, vendor feeds, and databases. Validate contents of data warehouse. Vet and cleanse data iteratively. Examine data distributions and identify anomalies and outliers and consult research team to remediate. Reconcile upstream data feeds to downstream NoSQL mongoDB database.
• Authored high-level diagrams and documentation for management and non-technical staff. Search for language and images that will resonate with target audience to increase understanding and encourage dialogue and build consensus.
• Deconstructed & reverse engineered existing dataflows & applications, and document and centralize findings to provide reference repository for Technical team decisions.

Business Analyst

Confidential - Atlanta, GA

Responsibilities:

• Deployed and integrated Commercial lending solution for a Georgia Credit union to augment their existing Fiserv lending suite for better tracking of loan officer and borrower performance. Also for setting loan pricing models, customized pay - back regimes, primary factoring and credit risk management.
• Construct Business Domain model documenting operations, workflows, and system interactions for each department in high-level use-case framework. Produce accompanying narrative identifying each department's area of expertise, stakeholders, key systems & reports, existing workarounds.
• Managed and Coordinated procurement of tools and equipment for clients and analyzed projects to reduce costs and risks.
• Created use cases for deployment of Virtual calling card portal for Amerimax which focused on Latin American Demographic. Used data from user profiles to create customized suggestions for additional services offered by Confidential .