SUMMARY

• Overall 15yrs of proven experience in IT with 12 yrs of Business/Data Analysis and ETL experience
• Strong Data Analysis, Business Analysis, 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

Sr. Bus/Data Analyst

• Sole contributor serving the entire Data Center Operations DCO management, gather Data Requirements from all levels of users ranging from Data Technicians all the way upto VPs around the world for DCO mgmt reporting, and all kinds of amzn data center issues to meet their report requests and dashboard needs related to managing amzn Data centers world wide
• Gather, Identify the key data points, 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
• 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, Data Mining
• Perform Trend/Impact Analysis, Percentiles, Percentages, YoY year-over-year , MoM, Quarter comparison, Cluster wise, Region/Zone/Mgrs. wise, etc. Create pivots, charts, vlookups, 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, and work with Remedy DBAs and Business Intelligence teams across EST/PST/India/UTC to sort out Data Quality and availability issues, had spent long hours, crazy nights and wkends working with people across the world to meet strict 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 2010, Share Point 2010, MS Office

Confidential

Sr. Business Data Analyst

• Worked on 3projects team based, except 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
• Create lots of Adhoc Reports based on what business users want from time to time, after gathering their data needs
• In FDW, create SQL scripts, Data Validation 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, 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-Office 2003, UML, Visio2007, Requisite Pro, MS Project 2003, UNIX, SharePoint

Confidential

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.
• Data Reconciliation on Oracle Sybase DB2 data across the 3systems Expense Reimbursements System, Mortgage Insurance System, and Accounts Payable system on the critical loan financial data to Analyze/Research on loans and Amt discrepancies across the systems, fix the balance sheets and Accounts Payable reports based on the findings, which then goes to US Treasury
• Analyze/Query the databases to create lots of Adhoc reports, and produce trends/charts/pivots/etc. for mgmt. using MS-Excel
• Worked directly with Mortgage Insurance companies and Banks who are clients of Freddie Mac 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

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
• Validate the data from all these sources on the accuracy, quality of the data being received and work with them if any issues
• 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 SQL Server and MS Access for business processes and data integrity, Detect/Solve Load errors, Data issues and Improve data quality checks
• Improvise the data build packages by doing Risk/Gap Analysis, Requirements Tracing, Data Analysis using SQL queries
• Periodic Data Cleansing, 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

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

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

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

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

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