EXECUTIVE SUMMARY:

• Total Exp of about 9 Yrs. 6+ Yrs. in Business Analysis/ Data Analysis, cleansing standardization and architecture for various domains including Finance. 2 Yrs. In Geospatial Data Analysis.
• Well experienced in eliciting, analyzing and documenting requirements for business process to create Business Requirement Document (BRD), Functional Requirement Document (FRD).
• Conversant with tools like UML, Use Cases, Activity and Class Diagrams, Data Flow Models, Entity Relationship Diagrams, SDLC, STLC and Defect life cycle.
• Extensive domain knowledge of financial service industry that includes policy making, planning, forecasting and cost analysis. Actively participated in company audits and played a vital role in quality assurance.
• Worked with data frames developed geodatabase, created metadata and analyzed spatial data.
• Completed independent research and scientific analysis on various projects, utilizing GIS technology and spatial data analysis.
• Technical Skills - MySQL, Oracle, Big data, Data Warehousing, Data Migration, Alteryx, Power BI, ArcGIS 10.4, SAP R/3, JIRA & MS Office Suite.
• Interpersonal Skills - Ability to work independently and within a team.

TECHNICAL SKILLS:

• SQL Server
• ArcGIS 10.4
• Advanced Excel
• Power Point
• Alteryx
• SAP R/3
• Visio
• Oracle
• Power BI
• JIRA
• Python 2.7
• MS Project
• Arc Map
• ArcGIS Pro
• Network Analysis
• Spatial Analysis
• 3D Analysis
• Model Builder
• 2016 Business Analysis
• Story Maps
• Python 2.7 Scripts
• SQL Query Scripts
• Spatial Analysis Functions
• Arc Globe
• Data Warehousing
• Data Modeling
• Data Validation
• Data Integration
• Data Cleansing and Standardization
• Data Analysis and Reporting
• Business Requirements
• Data Gathering
• Relational Database
• Project Management
• Agile Methodology
• Data Mapping
• Use Cases
• Test Cases
• ER Diagram
• GUI
• Defect Life Cycle
• Acceptance Testing
• SDLC
• STLC
• Manage Fixed Cost
• S&D System
• G&A Expenses
• Forecasting
• Financial Planning
• Reporting Standards
• Audit Compliances
• Budgeting
• Profitability Analysis
• Variance Analysis
• Month End Activities
• MIS Reporting

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr . Business/Data Analyst

Responsibilities:

• Crafted Business Rules and designed ERD Process flow diagrams.
• Developed Use case matrix and prepared discrepancy report.
• Prepared Interface control document and S2T tables for Source/Target/testing.
• Created matching rules and helped in developing and validating executed scripts in Alteryx.
• Conducted analysis of alternatives (AoA) to recommend best solution to perform data cleansing and data standardization.
• Performed data profiling and created a data cleansing and data standardization plan.
• Created data cleansing and data standardization scripts in Alteryx and analyzed, tested, and verified them with VHA P&LO subject matter experts using a sample data set prior to proof of concept testing at SCICs.
• Identified and corrected anomalies, recommend improvements to VHA P&LO based on analysis.
• Worked on field mapping, overall business logic checks and created standard template for outbound reports.
• Prepared Analysis matrix, site driven scenarios and confidence factor scale rating.

Confidential

Data Analyst

Responsibilities:

• Working on release of best value Request for Proposals (RFP) to select software and services.
• Involved in requirement gathering to structure quoting and actively involved in cost estimation.
• Incorporating all the data they have in an interactive way.
• Perform services in connection to design, build, and configure a GIS web-based system for Metro-North Railroad.
• Defined and custom visualizations of internally generated and consultant-sourced ridership data, demographic data, forecasting models, Grand Central Terminal counts data, Origin-Destination survey data, customer survey data, parking data, fare payment, fare type, and connecting services information.

Confidential, MD

Geospatial Data Analyst

Responsibilities:

.

• Worked with Subject Matter Experts (SME’s) to understand new system and business functions.
• Collected information and data from multiple sources and used analytical skills for providing strategic ideas and bringing business profitability.
• Build data models and ER Diagrams to show logical structure of database and relationship between entities stored in database.
• Prepared business plans & reports for effective planning and decision making.
• Completed independent research and scientific analysis on a various project utilizing GIS technology and spatial data analysis -
• Created story maps and web applications.
• Worked with ArcGIS PRO environment (Joined tables, created a calculation field, symbolized using graduated colors, geocoded location data, and used geoprocessing tools to analyze vector & raster).
• Worked on 3-D Analysis, Python Scripting and Business Analysis Applications.
• Worked on Network Analysis (Edges and Functions), Raster Analysis and Spatial Analysis (Created feature classes, added fields & domains, worked with metadata, created a web map).
• Designed thematic mapping, choropleth, heat maps, dot density and geocoded maps.
• Applied spatial queries in geospatial analysis using-Boolean Operators and Spatial Operators.
• Applied spatial joins (Simple Join, Summarized Join and Distance Join).
• Created maps using spatial analysis functions (Clip, Append, Merge, Buffer and Dissolve).
• Applied Map Overlay with attributes (Union and Intersect) and created geoprocessing programs using Model builder.

SkillS: Spatial data analysis, model builder, business plans, story maps, network and spatial data analysis. Used relational database, data model & ER diagram. Website creation and database management, database design & project management, MySQL, Python 2.7, networking & decision making, e-business & technology, spatial queries & Joins, ArcGIS 10.4 (Arc Map, Arc Scene, Arc Globe, ArcGIS Pro), network analysis, spatial analysis, 3D analysis, 2016 Business analysis.

Confidential

Business/Finance Data Analyst

Responsibilities:

• Created & Reviewed Business Requirement Documents.
• Coordinated with IBM team and MU office and took care of ensuring 100% accuracy of reports.
• Worked for data validation and data warehousing and ensure it is effectively carried out by cross verifying the data accuracy.
• Acted as a liaison between business, technology teams and Subject Mater Experts at time of introducing handhelds in market.
• Implement actions that come out of Retrospectives (essentially lessons learned) during internal and external audits.
• Created databases for company profitability analysis.
• Managing fixed costs to come in on AOP by regular monitoring and review of S&D, G&A and preparing G&A MIS monthly.
• Coordinate (FPR) with auditors & MU office for completion of statutory audits.
• Assisted unit/UM in AOP - volume/GR/ST/ED/ROI working.
• Monthly review of upfront account and highlighting volume gap.
• Computed GR by territory on a weekly basis and impact of same on a/c of mix.
• Monthly review of invoice discount and assisted DB/market audits.
• Supported in month end closing activities and taking care of legal compliances.
• Worked with all management levels and cross-functional team of business to discuss co-related activities.

Skill Set: BRD creation, coordinate with IBM, Data warehousing, costing and coordinated (FPR) with auditors, SAP R/3, MS office suite (Excel, Publisher, PowerPoint, Word), profitability analysis, managed fixed costs to come in on AOP by regular monitoring and review of S&D, G&A and preparing G&A MIS monthly. Supported in month end closing activities. Worked with cross-functional team of business to discuss co-related activities. Costing and variance analysis.

Confidential

Business/ Financial Analyst

Responsibilities:

• Actively involved in creating project plan, process flow, design requirements, documentation and implementing process.
• Prepared Project Charter and Implementation plan.
• Gathered requirements from different sources like stakeholders, documentation, existing systems, and subject matter experts by reading documents, market analysis and observations.
• Prepared comprehensive business requirement documents using ratio & variance analysis.
• Worked with director to set up realistic project expectations, financial analysis of budget, and impact of change from current state to future state and included key milestone of project.
• Worked with cross-functional team of business to discuss co-related activities.
• Costing and variance analysis for various clients.
• Analyzed financial budget v/s actual and projected profitability.
• Knowledge of reporting standards, USGAAP & IFRS
• Thorough knowledge of database design & project management.

Skill Set: Project management, preparing and executing business plans through effective planning, organizing, and on-going evaluation processes, timeline management, impact analysis, documentation and risk assessments. Gathered requirements from different sources like stakeholders, documentation, existing systems, and subject matter experts by reading documents, market analysis and observations. Prepared comprehensive business requirement documents. Ratio and Variance Analysis.

Confidential

Business Associate

Responsibilities:

• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Conducted Gap analysis and developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Worked on Issue Identification, Tracking, Logging & Reporting.
• Conducted quantitative analysis of data to forecast revenue, identify future trend, risk assessment of new opportunity.
• Created delivery orders, closure documents, IRR Reports & prepared remittance entries.
• Monitored freight and onward freight expenses, travelling expenses and handling charges.
• Involved in banking operations & bank charges computation.
• Cash forecasting by using moving average method, record was maintained in SAP portal.
• Updated and sent money requirement sheet & assisted in issuance of F-Form.
• Monthly reports sent and monitored to ensure compliances.

Skill Set: Monthly reports sent and monitored to ensure compliances. Financial modeling and analysis, forecasting, budgeting, reporting and risk analysis.

Confidential

Credit Control Officer

Responsibilities:

• Worked as CRM Admin and helped in maintaining database.
• Administered and monitored sync up process by verifying data across all locations.
• Ensured proper Documentation, analysis and reporting of packages and freights.
• Performed Gap & SWOT analysis.
• Monitored timely deliveries and competitors pricing strategy.
• Surveyed target market clients to enhance customer satisfaction level and increase profits.
• Got involved in logistics management to reduce inventory-holding costs.
• Prepared MIS reports and sent final status to corporate office monthly to ensure compliances.

Skill Set: Documentation, analysis and reporting, Gap & SWOT analysis. Got involved in logistics management to reduce inventory-holding costs, Monitored timely deliveries and competitors pricing.