SUMMARY:

• Overall 10+yrs of proven experience in IT with data, Business Intelligence and reporting background working with business users
• Passion and love for data and SQL, Business/Data Analysis, Data Analytics, KPIs, metrics, ETL, Data Mining, Business Intelligence Reporting & Dashboards, Data Wrangling/Validation/Reconciliation, Data Cleansing/Mapping, Data Quality, and Adhoc support. Create Business/Data Process Flows, Entity Relationship diagrams(ERD), perform UAT & System Testing along with documentation
• Well versed working on projects using Agile methodology, waterfall and iterative methodologies with full SDLC experience
• Big data projects, Confidential projects, Data conversion/migration projects, development/enhancement projects and Production Support and QA in Finance, Federal/State Govt, Mortgage, Retail, Education, Insurance, Manufacturing industries
• Self - starter, strong Analysis and critical thinking skills, problem solving skills, proven organization and decision making skills
• Curious and Adaptive mind, hungry for knowledge, always willing to learn new tools/technology and processes on the go
• Detail Oriented, Excellent interaction with Business/Technical groups, develop high-quality customer deliverables and user materials
• Solo contributor, Lead as well as excellent team player, Excellent client relationship skills and verbal/written communication skills

SKILLS:

SQL, Unix, Linux, PostgreSQL, AWS RedShift, MySQL, SQL Server, Oracle Sybase, DB2, Apache Hive, pgAdmin, DBvisualizer, Toad, MySQL workbench, Putty, JIRA, AWS RDS, AWS S3, WinSCP, SSIS, stored procs, OBIEE10/11g, Tableau 10.2, Rapid SQL, Informatica, PL/SQL, Excel, MS Project, Visio, SalesForce, ClearQuest, RequisitePro, DOORS, Remedy, SharePoint, MS Access, IBM Mainframe

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. BI Data Analyst

Responsibilities:

• Write SQL queries and perform ETL testing in different environments and servers on commercial and federal data
• Analyze and Trouble shoot data issues, optimize performance of SQL queries for production support, work with various teams
• Perform Data Analytics and metrics on the fed data doing metrics, Data cleansing, find data quality issues (identifying erroneous data, missing data, bad data patterns), and find appropriate solutions
• UAT the Oracle BI reports and dashboards for data accuracy and new functionality, work with developers to fix issues
• Adhoc support, pull production data writing simple-to-complicated SQL queries (using joins, analytical functions, etc.), functions
• Test the federal portal and environment, and the dashboards moved into this environment

Environment: SQL, Oracle, SQL developer, SQL server, SSIS, putty, winscp, Excel, JIRA, OCI (oracle cloud infrastructure)

Confidential

Sr. BI Data/Reporting Analyst

Responsibilities:

• Work with Investigatory Attorneys on the PII data (from sources - cell phone carriers, SSA, FBI, DOJ etc.) to ETL, validate, and process huge datasets to detect fraud, help build a case against these carriers, support the Confidential process in the lifeline program with proof of data and the concepts of why/how fraud was identified
• Lots of adhoc support, Develop Normalization and Risk Score Algorithms (match multiple identifiers) in PostgreSQL and SQL server to cluster the fraudulent data, use Data wrangling (on names, ssn, dob, phone# etc fields) to find dupes and fraud patterns on PII, damage analysis, risk/money involved, etc. to help find fraud and pursue a case worthy enough for OIG
• Create tables/indexes, extract/load/process millions of records (csv, txt and bak files) in multiple databases hosted in AWS RDS - MySQL, PostgreSQL and SQL server using SQL, Linux commands, build SSIS packages, perform Data validation, Data Migration across these DBs and run various algorithms to detect fraud, and perform data analytics on that
• Write simple-to-complicated SQL queries (using joins, analytical functions, etc.), triggers, functions and store procedures across these databases to pull/analyze/validate large datasets for checking business rules, find anomalies, patterns, dupes, keywords, fuzzy-matches, to find fraud/anomalies in the sensitive data, while maintaining Data Integrity across various sources of data
• Create summary tables for the aggregated/metrics info from the output of other queries/algorithms, extract data from the relevant databases, create pivots/charts/calcs etc. in excel for presentations, show fraud patterns, volume growth, and adhoc reporting
• Architect, design and develop Risk Scoring and pattern matching analytic Algorithms/processes/data flows via SQL in PostgreSQL
• Perform DBA activities like vacuuming (full, analyze) tables in PostgreSQL, on a scheduled/as-needed basis
• Code changes in the existing python scripts (for uploading json files), trouble shoot and fix python code for errors/enhancements
• Trouble shoot queries and data issues, fine tune SQL queries for optimal performance in PostgreSQL, create/manage indexes, monitor the AWS dashboard for database performance spikes, CPU utilization, work with DBAs,
• Restore SQL server .bak files (obtained from FBI or DOJ or other sources), explore and understand the data, create data dictionary
• UAT the ongoing PostgreSQL code migration from SQL Server, bring MS-SQL server algorithms results/data into PostgreSQL, write SQL scripts to compare MS-SQL vs PostgreSQL results, document findings and work with developers to fix code/errors
• Source-to-Target Data Mapping, Data Quality/Cleansing on dirty data that comes in, document every single info

Environment: SQL, SQL Server, PostgreSQL, SSIS, MySQL, Linux, Putty, WinSCP, pgAdmin, python,MySQL Workbench, EmEditor, JIRA

Confidential, Hilton, VA

Sr. BI Data/Reporting Analyst

Responsibilities:

• Create SSIS ETL (Extract/Transform/Load) to process files from suppliers and SFTP sites into SQL Server, Build data flow diagrams
• Build Adhoc metrics financial reports, KPIs and visualizations in Tableau (use calc fields, parameters, filters, etc.) and Excel
• Source-to-Target Data Mapping, Data Quality/Cleansing on suppliers data, build SSIS packages to upload data, and do Fuzzy lookup and FREETEXT search mapping on hotel names and addresses between supplier data and the Hilton property database info
• Write SQL queries in SQL server and AWS RedShift for data analysis, data mining/validation, find data anomalies (inconsistencies, redundant, missing, incorrect data, etc.) and patterns on supplier provided data, from payment/products/categorization aspect, and to main data integrity, trouble shoot data issues to find root causes, and work with users and fix it in the database
• Query data using SQL in Apache Hive (UAT), and validate data for the ongoing data migration from SQL server to Bigdata/Hadoop
• Develop tools/solutions to increase efficiency of all data related processes with focus on ease of use maintenance wise
• Data Validation/Reconciliation on suppliers and payments/checks financial data coming from various sources, Maintain accuracy on spend Analysis financial reports, product level compliance and supplier level compliance related Tableau reports/dashboards
• Work with Stake holders, Vendors and Suppliers on requirements and Business/Data issues, web portal issues, SFTP data into Hilton
• Perform UAT, Data validation and System testing on customer portal Tableau reports, and PeopleSoft portal for suppliers data

Environment: SQL, SSIS, SQL Server 2014, Apache Hive, AWS Redshift, DB visualizer, Excel2014, Tableau 10.0, Alteryx (2wks trial)

Confidential

Lead BI Data/Reporting Analyst

Responsibilities:

• Data Analysis, daily processing (daily, wkly, bi-wkly, monthly, etc.) jobs, Data mining, Production support and Adhoc support on critical 1095A Confidential health care data using SQL on SQL Server and SharePoint Database via MS Access SQL, MS Excel
• Identify and problem solve complex systemic issues spanning multiple systems and teams as they relate to corporate IT initiatives, in Agile environment; includes designing systems/services from ground up, Respond and resolve production defects within SLAs.
• Finding bad/redundant/inconsistent/missing data, inconsistencies, Root Cause Analysis, Write Queries and stored procedures to Extract/M­anipulate/Validate data from multiple sources on SQL Server, run business rules validations, SharePoint databases, and files from outside vendors, Reconcile, trouble shoot and fix data issues across Health Insurance policy issuers and vendors
• Build/Maintain metrics reports, KPIs via Tableau Visualizations and Da­shboards in Tableau Desktop Professional (TDP) and publish them onto Tableau Server for CMS management to access via web. Create/Maintain comprehensive project documentation
• Provide ad-hoc support, extract data from SharePoint database and SQL Server database, reconcile/manipulate data, create pivots, calculations, VLOOKUP’s, charts in MS Excel for any adhoc support for management
• Present data findings and work with other members to identify and implement strategies that will address tactical/strategic goals
• Create SSIS ETL (Extract, Transform, Load) packages, and stored procedures to process incoming flat files daily containing millions of healthcare records, run business rules/validations and process/load data received from various sources into SQL Server database
• Analyze data within the enterprise data systems for trends, variances, anomalies, data cleansing, escalate and resolve data issues
• Reconcile data across SharePoint and SQL Server databases, implement the mass data corrections along with enhancement requests
• Improvise existing/new business processes by working with users, document steps and screen shots for each process that I built
• Guide team members, support them for any questions on SQL, MS Access, and databases support, give demos and train team members on any/all processes which I developed and streamlined, for them to do on a periodical basis and at ease
• Work under high pressures, Recognized as ‘Outstanding and Going Above & Beyond’ for performance, and received cash awards

Environment: SQL, Linux, SSIS, Stored procedures, Tableau 9.2, SQL Server 2012, SharePoint2013, MS Access, MS Excel2013

Confidential, VA

Sr. Data Analyst / Sr. Data Quality Analyst

Responsibilities:

• Extract/validate educational data via SQL from many sources, Data analysis, metrics reporting on scoring data, UAT
• Pull, upload, and validate data files (.dat, xls, xml, csv, pdf) from/to diff servers on AWS S3. Track tasks via JIRA for daily standups
• Via SQL, Analyze data, Data cleansing, fine tune queries, perform Data Quality (DQ) checks and testing to find QA and DQ issues, present those to production control team and mgmt. and work with development team to fix it
• Analyze old/new lookup values, Data Mapping, pivots, charts/graphs via SQL, MS Excel for finding data redundancies, Data Reconciliation between multiple sources to id the data patterns, missing data, validate XML files that are part of data feeds exchanged between College Board and its external vendors

Environment: SQL, PL/SQL, Oracle11g, Toad, AWS S3, MS Excel 2010, XMLspy, JIRA, SharePoint 2010, MS Project 2010

Confidential, VA

Sr. Data Reporting/Metrics Analyst

Responsibilities:

• Sole contributor serving the entire Data Center Operations(DCO) working directly with infrastructure mgmt across the world with Data center managers, Sr. Managers, Directors, Sr. Directors, VPs, exec VPs for DCO management, and Data Technicians to gather requirements and build/automate all sorts of metrics reports and dashboards in Oracle Business Intelligence and MS-Excel
• Analyze various sources of tickets data and infrastructure databases, validate data, Data mining via SQL to id patterns, data issues, duplicate tickets, reopened tickets, and its related parts/warranty info
• Design, build, automate and present to Infrastructure mgmt the metrics Reports and findings (Adhoc, weekly, monthly, Year-over-Year, YTD) and Dashboards to drive key business via OBIEE Answers/iBots/Dashboards, also in MS-Excel using pivots, V-lookups, calculations, charts/graphs (vertical, horizontal bar charts, pareto charts, column/stacked charts, pie/line charts, area charts, etc.)
• Root cause analysis, Trend/Impact Analysis, calculate Percentiles, Percentages, YTD, metrics and data analytics for mgmt, Year-over-Year charts, (monthly/quarterly also), Cluster/Region/Zone/Managers wise that helps management to take measurable actions
• Perform research collecting different sources of info from several people involved, analyze data, and create reports for amazon DCO security teams also related to badging issues, onboarding issues, vendor issues and Amazon Web Services teams
• Research/Troubleshoot on Tickets data for any/all issues, Data Analysis, Data pulls from InfraDB/Shift Report database
• Perform ‘what-if’ analysis, Collect/Analyze infrastructure data for performance issues or manufacturer parts issues related to vendors like HP, Dell, analyze potential issues related to warranty
• Create Tickets, work with Remedy DBAs and Business Intelligence teams across the world to sort out Data Quality issues, and availability issues (round the clock when needed) to get work done ontime and t o meet deadlines
• Train data technicians and system engineers on how to build and use these reports/dashboards using OBIEE, MS Excel

Environment: OBIEE 10g/11g, SQL, Oracle10g, Linux, MySQL, MS-Excel 2013, Share Point 2010, MS Office

Confidential, VA

Business Data Analyst

Responsibilities:

• Gather Business and Data Requirements, Data Analysis, Impact/Risk Analysis, Data Mapping, Data Dictionary, Data Quality checks
• Work with Data Architects and DBAs on the data flows across Fannie based on new rules, work with Business Objects reporting team to build/validate the data pushed onto the Data Mart tables for reporting purposes, Perform Source to Target data Mapping, updating Data Dictionary, data validation on new business rules, validating expected-vs-actual results, in Agile environment
• Detect fraudulent loans/activities, Respond and resolve production defects within SLAs, involves working with business users
• Build Adhoc Reports, support data inquiries using SQL and Ms-Excel (Pivot tables, Charts, Vlookups, formulas) on financial data
• Financial Data Analysis, Data Mining via SQL to id data issues; As part of DQ, Data profiling on data from different sources/systems
• Resolve critical Data reconciliation issues between multiple sources/systems, and their impacts on the reports and how to fix
• Write complex queries and SQL scripts to test ETL process, validate data if Business rules applied, compare Expected/Actual(E2A)
• Perform Business Analysis, Business Rules validation, Technical Design docs, Requirements Traceability Matrix (RTM), Business Process flows, Data flows diagrams, Support java based web apps using Agile/Waterfall technology
• Perform UAT, Functional test cases, Functional/Integration testing, and work with cross-functional teams, Work on Clear Quest/Remedy tickets for issues/enhancements; coordinate with Change Management and other teams, Assist PMs with project mgmt. activities and created Implementation Plan, Backout plan, Shakeout Plan, closeout activities and implementation
• Create and maintain comprehensive project documentation, work with Business stake holders, obtain sign offs on the relevant docs

Environment: SQL, Linux, Oracle10g, TOAD, Rapid SQL, Business Objects, DOORS, Clear Quest, MS Excel 2010, UML, Visio2007, Requisite Pro, MS Project 2003, Linux, shell scripts, SharePoint, Informatica

Confidential, VA

Sr. Business Systems Analyst

Responsibilities:

• Individual contributor supporting Expense Reimbursement system, Mortgage Insurance System and Accounts Payable systems
• Fix data discrepancies in multi-millions of dollars and loans across these 3 systems, Data Reconciliation via SQL across Oracle/Sybase/DB2 data on these 3systems to Analyze/Research/Fix the discrepancies, fix impacted Balance Sheets and Accounts Payable reports based on the findings, which is then sent to US Treasury after signed by the VP of finance dept
• Provide Adhoc support and reports, data analysis, trouble shoot issues, being
• Analyzing/Finding fraudulent loans and bad performing banks and insurance companies, based on various factors from time to time
• Id users data needs, extract data from databases, create Adhoc reports, calculations, charts, find trends, pivots, vlookups
• Liaison between business and development/testing teams, work with mortgage insurance companies and banks for expenses and reimbursements related issues, and thereby resolving data issues across critical financial reports and loans involved
• Data Mining via SQL to find all fraudulent loans info in details based on business users input, and the trends seen past/current
• Tech docs, Data Mapping, Data Quality, Variance Analysis, Validate Business Rules, create Functional test cases, Perform UAT

Environment: SQL, DB2, Linux, Oracle10g, Sybase, Rapid SQL, MS Excel, Visio, MS Access, Clear Quest, MS-Office 2003

Confidential, VA

Sr. Business Data Analyst

Responsibilities:

• Work with users, Analyze billing data, process, and upload data files onto DB using SSIS, adhoc reporting on critical financial data using SSRS and MS Excel (building Pivot tables, Charts, Vlookups, formulas, etc), data inquiries/pulls/support using SQL

Environment: SQL, SQL Server 2005, Linux, SSIS, SSRS, MS ACCESS 2003, MS Office 2003, Visio 2003, Oracle 10g, TOAD