SUMMARY

• Overall 14+yrs of proven experience in IT with 12+yrs of Business/Data Analysis and ETL experience
• Strong Data Analysis, Business Analysis, Adhoc Reports and Business Intelligence Reporting (Metrics, auto, Adhoc, periodic, etc), Data Reconciliation, Data Cleansing, Data Mapping, Data Quality, Data Mining
• Full SDLC experience - IBM Mainframe, Client Server, Web development using Iterative, Waterfall, Agile methodologies
• Gap Analysis, Risk Analysis, Variance Analysis, Requirements gathering, Change Management, Requirements Traceability Matrix (RTM), Management artifacts using SharePoint and Rational tools like Requisite Pro, Clear Quest, etc.
• Business/Data Process Flows, Entity Relationship diagrams (ERD), UML with MS Visio, UAT
• Development/Enhancement projects, Production Support and Data Conversion/Migration projects across Finance, Mortgage, Retail, Insurance, Manufacturing, State Government industries
• Detail Oriented, Excellent interaction with Business/Technical groups, producing high-quality customer deliverables
• Develop user guides and reference materials, provide hands-on training for business users
• Lead development teams of size 2-7, Work independently as well as Excellent team player
• Strong Analytical and critical thinking capability with problem solving and Organizational skills, work under aggressive deadlines
• Excellent client relationship skills, Excellent verbal and written communication skills
• Self-starter, pro-active, Ability to learn/acquire new tools and technologies on the go

SKILLS

ORACLE, DB2, SQL Server, Sybase, OBIEE10x, SQL, TOAD, Rapid SQL, SSIS, PL/SQL, MS Excel 2013, MS Office, MS Project, Unix, MS Outlook, MS Visio, Rational ClearQuest, Rational RequisitePro, DOORS, Remedy, MS SharePoint 2010, MS Access, IBM Mainframe

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Data Analyst

• Extract data via SQL from various sources, perform Data analysis, create/modify scoring reports, Gap Analysis between current /future systems, Analyze new business rules, Impact Analysis on data elements/feeds with systems and external vendors
• Analyze old/new lookup values, Data Mapping, pivots, charts/graphs etc via SQL, MS Excel for finding data redundancies, Data Reconciliation between multiple sources, etc. to identify the data patterns, missing data, etc.

Environment: SQL, ORACLE11g, MS Excel 2010, Requisite Pro, Clear Quest, SharePoint 2010, MS Project 2010

Confidential, VA

Sr. Business Data Analyst

• Individual contributor serving the entire Data Center Operations (DCO) management across the world, gather Data Requirements from all levels of users around the world ranging from Data Technicians all the way upto VPs for DCO mgmt reporting, and all kinds of amzn data center issues to meet their report and dashboard needs related to managing amzn Data centers world wide
• Gather, Identify the key data elements, fields/sources across tickets and infrastructure systems/databases; Work closely with users asking all relevant questions to the problems/situations, understand the importance and priority of the background, etc. and perform Data Analysis, Data Validations and Reports on the tickets/infra data, Update tasks completion in JIRA
• Data mining via SQL to identify patterns, data issues, duplicate tickets, reopened tickets, root causes, related parts/warranty info
• Create and Maintain different Analytics Reports (Metrics, Adhoc, auto, periodic - wkly, monthly, etc.), Create Static and Interactive Dashboards via OBIEE Answers/iBots/Dashboards and MS-Excel doing Root Cause Analysis, etc.
• Perform Trend/Impact Analysis, Percentiles, Percentages, YTD, YoY (year-over-year), MoM, Quarter comparison, Cluster wise, Region/Zone/Mgrs. wise, etc. Create pivot tables, charts, V-lookups, calculations, etc in Ms-Excel for reports and data analysis
• 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
• Very detail oriented, Perform ‘what-if’ analysis, Collect/Analyze infrastructure data for performance issues or manufacturer parts issues related to HP, Dell etc., analyze potential issues related to warranty, etc.
• Cut Tickets, work with Remedy DBAs and Business Intelligence teams across the world to sort out Data Quality and availability issues spending long hours, crazy nights and wkends to get work done ontime and t o meet deadlines
• Occasionally train some data technicians and system engineers on how to build reports/dashboards using OBIEE, MS Excel, etc.

Environment: OBIEE 10.x Answers/iBots/Dashboards, SQL, ORACLE10g, MySQL, Toad, MS-Excel 2013, Share Point 2010, MS Office

Confidential, VA

Sr. Business Data Analyst

• Worked on 4projects team based; in one, I served as a single point of contact working closely with Business users (Chicago)
• On CLMS, 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
• Perform Source to Target Data Mapping, and updating Data Dictionary for the new releases, by working with business users
• Adhoc Analysis and support, create variety of Adhoc Reports using SQL and Ms-Excel; Create Pivot tables and Charts, Vlookups, formulas, etc. in MS-Excel based on business users need from data/business stand point
• Data Analysis and Data Mining via SQL to identify the data issues, where sources are coming from, and if there are data issues in any of the sources, data feeds and/or format issues, to clarify business functionality issues in applications
• Resolve Data reconciliation issues between multiple sources/systems, and their impacts on the reports and how to fix
• In FDW, create SQL scripts, Data validation using Business rules, and on Expected vs Actual(E2A), Reconcile Data when needed
• In all projects, acted as Liaison between Business/Tech teams, performed 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
• UAT to find business functionality issues and the related data issues, Functional test case, Functional/Integration testing, work with cross-functional teams, Prepare Requirements Mgmt. Artifacts
• Work on Clear Quest/Remedy tickets for issues/enhancements; coordinate with Change Management and other teams
• Perform project mgmt. activities and created Implementation Plan, Backout plan, Shakeout Plan, Assist PM with closeout activities and implementation
• Develop user guides, reference materials on various systems, provide training on tools/systems for business users

Environment: SQL, ORACLE10g, TOAD, Rapid SQL, Business Objects, DOORS, Rational Clear Quest, MS Excel 2010, UML, Visio2007, Requisite Pro, MS Project 2003, UNIX, SharePoint

Confidential, VA

Sr. Business Systems Analyst

• Support the Business users with Adhoc needs, trouble shoot issues related to issues on the functionality of the application, perform Data Analysis and being Liaison between Business/Technical teams on enhancement releases in the current systems
• Work with Senior Mgrs and Directors and other users to identify their data needs, do data pulls, lots of Adhoc repors, the data points necessary, what calculations necessary, new business rules to be applied, etc.
• Lots of Data Reconciliation via SQL across Oracle/Sybase/DB2 data on these 3systems Expense Reimbursements System, Mortgage Insurance System, and Confidential system on the critical loan financial data to Analyze/Research on loans and $Amt discrepancies which are in multi-million dollars across these financial systems, fix all the balance sheets (due to these errors) and Confidential reports based on the findings, which then goes to US Treasury
• Data Mining via SQL to find all fraudulent loans info in details based on business users input, and the trends seen past/current
• Analyze/Query databases via SQL to create lots of Adhoc reports, and produce trends, charts, pivot tables, etc. using MS-Excel
• Worked directly with Mortgage Insurance companies and Banks who are clients of Confidential for data validation on data files
• Tech docs, Data Mapping, Data Quality, Variance Analysis, Validate Business Rules, create Functional test cases, Perform UAT
• Work with cross-functional groups, Document various other Requirements Management Artifacts
• Document user materials along with providing necessary training for different user groups based on access levels

Environment: SQL, DB2, ORACLE 10g, Sybase, Rapid SQL, MS Excel, Visio, MS Access, Clear Quest, MS-Office 2003

Confidential, VA

Sr. Business Data Analyst

• Work with account managers of BearingPoint to make sure to collect all sources of billing data files coming in from various clients in various formats are received ontime (either daily or twice/wkly, etc.) in the agreed formats
• Data validation/mining via SQL from different sources of data, on accuracy, quality of the data being received and work with them if any issues; Identify the data issues on the daily billing data feeds from multiple clients and escalate to management
• Ensure all data is extracted and received from various clients sources and liaise with business team to resolve extraction issues
• Extract/Manipulate/Load Data from various data sources and build data packages using SSIS to export data onto production SQL Server and MS Access for business processes and data integrity, Detect/Solve Load errors, Data issues and Improve data quality
• Improvise the data build packages by doing Risk/Gap Analysis, Requirements Tracing, Data Analysis using SQL queries
• Periodic Data Cleansing via SQL, Data Quality, ETL, T-SQL, SSIS packages, Data Mapping, Business Process Improvement
• Create Functional test plans, Process/Data flow diagrams, Testing and Develop various Requirements Mgmt. Artifacts
• Document user manuals, provide user training on how to handle data packages for billing/reporting system

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

Confidential, TN

Senior Consultant

• Data Analysis, Data Mapping, Manipulate and Extract the data for Business Analysis, Rules and Validation
• Develop SQL scripts, ETL, COBOL/DB2 batch programs for data pull and create flat files
• Document Business Rules, Identify, Research and Raise concerns/issues related to data/business
• Business Process Improvement and Create all the Requirements Management Artifacts

Environment: SQL, SAP ECC 5.0, MVS, DB2, COBOL II, JCL, SQL, PVCS, MS-Office 2003 , UML, MS Visio 2003

Confidential, CA

Sr. Business Data Analyst

• Capture Requirements and Data needs for the new system, identify the new business needs, processes and conversion methods
• Gap Analysis of as-is and to-be processes, Data Mapping from legacy DB2 to SQL Server, work with users on identifying the new business rules, analyze the existing system issues, and how to fill in the gaps and the work flows
• Perform the necessary Data Analysis, Data Cleansing, SQL Scripts, Data Integration, Data Conversion rules, Document business rules and other Requirements Artifacts
• Create High-level/Detailed Design docs, Business process flows, Data flow diagrams, Technical Design documents
• Work with Data Architects on enterprise level data flows related, participate in physical and logical data modeling using Erwin
• Develop SQR and COBOL reports, and common modules to convert data, prepare release notes
• Extract, Transform and Load DB2 data onto SQL Server using ETL tool Data stage
• Perform SQL scripts/queries in DB2/SQL-Server to convert data, maintain integrity, consistency
• Prepare user reference materials including conversion rules for users and technical groups

Environment: SQL, Citrix, MVS, SQR, SQL, Data Stage, DB2, SQL Server 2000, MS Visio 2000, MS Office 2000, Erwin, PVCS

Confidential, NC

Lead Analyst Programmer

• Received Best Performance Awards and Employee of the Month awards
• Analyze as-is/to-be processes, Identify business needs, act as liaison btw business/tech teams
• Create Architecture and Process/Data flow diagrams, Requirements Analysis, Data Quality Analysis
• Convert business requirements into Functional/Technical docs, Develop/Maintain Batch applications
• Participate in Database Design/Modeling, Data Mapping, Data Cleansing, Functional test cases
• System testing, Coordinate with Change Management/Production Control team to promote modules
• Develop/Maintain user reference materials on claims system based on enhancements

Environment: MVS, COBOL, DB2, VSAM, JCL, Visio, Visual Source Safe, MS Project, SQL Server, ORACLE 8i, MS Office

Confidential, CA

Senior Analyst/Programmer

• Requirements analysis, Gap Analysis, Data Analysis, Create Requirements/Functional specs, Technical specs
• Business support, Data mapping, Data dictionary, Data Quality, Business Analysis
• Develop HTML, ASP pages using ASP, HTML, VBScript, JavaScript, Stored Procedures

Environment: SQL, IIS 5.0, ASP 3.0, Visual Interdev 6.0, Source Safe 6.0, SQL Server 2000, VBScript, JavaScript

Confidential, OR

Business Analyst/Lead Analyst Programmer

• Received Cash Awards and Certificates towards Best performance
• Requirements Analysis, Gap Analysis, Convert Requirements into Functional/Technical design docs
• Identify business needs, Participate in Database Design, Develop various mainframe reports
• Develop Batch programs - reports, System/Unit testing, Implement and Support

Environment: SQL, IBM 3090, MVS, PVCS, COBOL II, DB2, CICS, VSAM, JCL, SPUFI, UML, MS Visio, MS Office 1997

Confidential, KS

Sr. Business Analyst Programmer

• Requirements Analysis, Data Analysis, Data Quality, Production support and Maintenance
• Add edits and new procedures to legacy system, Design/Develop code, Generate periodic reports

Environment: SQL, IBM 3090, MVS, DB2, VSAM, CICS, COBOL II, MS Visio, JCL, File Aid, SPUFI, QMF, ROSCOE

Confidential, NC/NY

Sr. Analyst/Programmer

• Business Analysis, Requirements Analysis, Gap Analysis of as-is and to-be processes
• Design Data Flows, Process flows, Data Mapping and Data Cleansing, Participate in Database design, Develop Batch/Online programs for various modules meeting strict timelines
• Created unit, system test plans, Test modules, Maintenance & Support

Environment: SQL, IBM 3090, DB2, VSAM, COBOL II, JCL, SQL Server 6.5, UML, Visio, MS Office 1997, Lotus Notes

Confidential

Tech Lead / Lead Analyst Programmer

• Lead a team of 7 members for the successful deployment of the Agency system
• Requirements/Gap Analysis of existing legacy mainframe system for the as-is and to-be processes
• Functional/Tech specs for new client server system using Business Process Reengineering approach
• Develop Entity-Relationship diagrams, Data Flow diagrams and participate in Database Design
• Data Analysis, Data Mapping, Code Reviews, Functional test cases, Unit/System testing, Implementation

Environment: SQL, OS/2.1, VisualBasic3.0, Crystal Reports, SYBASE 10, MVS, COBOL II, DB2, VSAM, JCL, SPUFI, QMF