PROFESSIONAL SUMMARY:

• A diligent and talented professional with over 13+ years of extensive experience in the field of Data Engineering, Data Warehouse, Database Modelling, Data Analysis, Business Intelligence in Finance and Healthcare Industry.
• Master’s in financial engineering from Confidential, broad based acumen, blend of analytical skill, technological acumen, and leadership qualities.
• Experience working in Financial Industry - Capital Markets, Mortgage Backed Securities, Market Risk, Credit Risk, Fixed Income, Derivatives, Equities, Securities, Futures and Options, Market Data, Data, Wealth Management, Asset Management, Portfolio Management, Enterprise Data.
• Serves as a subject matter expert for data domains and act as liaison between cross-functional teams. Curious in improving and automating processes and persistence to troubleshoot issues. Experience in managing projects from concept to completion. Highly motivated team player with excellent interpersonal and customer relational skills
• Passionate in learning new technologies and positive attitude towards challenging work
• A strategic thinker and effective communicator.
• Excellent working knowledge of. SQL, Python, Microsoft BI Stack (SSRS, SSIS, SSAS, Excel Services, Performance Point, and PowerPivot, Transact SQL.
• Extensive experience with creating reports using Microsoft SQL Server Reporting Services and Tableau.
• Experience in analytics, data visualization and modeling to find solutions for a variety of business and technical problems.
• Excellent experience working with analytical and data visualization tools and techniques (Power BI)
• Experience in Data Management using Collibra for Enterprise Data Governance.
• Excellent working experience in Agile Methodology & Software Development Life Cycle (SDLC) processes.
• Enthusiastic learner with analytical and problem-solving abilities.

TECHNICAL SKILLS:

Big Data: Apache Spark, EMR, Hadoop, Hive, Sqoop

ETL and Reporting: SSIS, SSRS, SSAS, IDQ, Tableau, MicroStrategy, AWS Quicksight, MS Excel

Programming: SQL, Python

Scripting: Shell, Powershell

Databases: Microsoft SQL Server, MPP databases (AWS Redshift), Oracle9i, MS Access

Modeling: Erwin, Visio

Governance Tools: Collibra

Statistical Analysis: Minitab, R, SAS Enterprise Guide, SPSS, Arena Simulation

Cloud Technologies: AWS, Microsoft Azure

Version Control: Git

Machine Learning: Databricks, Scikit-Learn, Spark MlLib, AWS SageMaker, NLP, Keras, Computer Vision

Tools: JIRA, Confluence, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential

Lead Data Analyst

Responsibilities:

• Used Collibra Tool to manage, store rationalized metadata and created automated process workflows for Data Validation by Chief Data Stewards.
• Conducted Analysis, and created an automated process.
• Leveraged Microsoft BI Stack such as SSRS, SSIS, SSAS, Excel Services, Performance Point, and PowerPivot.
• Conducted analysis and created T-SQL code for data retrieval process.
• Analysis and query writing to assist in supporting key business initiatives.\
• Created reports using Microsoft SQL Server Reporting Services.
• Conducted Data Lineage by mapping data flows & managing and creating data dictionary.
• Conducted Data Quality and executed Data Profiling using Informatica (IDQ) tool.
• Worked on Key Data Element in order to get the Data Quality rules implemented by the enterprise.
• Rationalized Metadata & created Entity Relationship diagrams thereby modeling the data.
• Created various Operational, Maintenance and Ad-hoc BI reports using Tableau for day-today analysis and statistical information.
• Reviewed Architecture Diagrams & Onboarded Applications from on-prem to AWS cloud S3.
• Developed and supported the ETL process for the data warehouse from various data sources including EDW.
• Verified the data quality and tested the functionality of the reports to conform to the business requirements. Strengthened the existing program iteratively over a period of time as per the business needs.
• Worked on creating the Data Mapping document (Source-Target Mappings) from the Source to Target system which comprises the definition of every column on Target system, their significance and corresponding source column.

Confidential

Sr Data Analyst

Responsibilities:

• Created Advanced SQL Queries using Presto (AWS) and conducted Data analysis & validation to meet regulatory requirements.
• Worked on creating the Data Mapping document (Source-Target Mappings) from the Source to Target system which comprises the definition of every column on Target system, their significance and corresponding source column.
• Created Data Mapping & Data Lineage activities.
• Created forms using MS Access.
• Generated Reports using Tableau and Micro strategy.
• Worked closely with Data Architects and development team, helping them understand the exact business requirements that needs to translate into code.
• Assisted the development team by analyzing the various incoming data feeds using SQL and Excel, and providing the results to the source teams and developers.
• Worked with the Data Regulation Team on a lead role.
• Created User Interface for TRACE application & exception handling for the data.
• Created System Requirements Specifications, process workflow diagrams to be leveraged by the Architecture team.
• Worked with Developers, ETL Teams & Architecture team.

Confidential, Washington DC

Senior Data Analyst/Project Management Access Management

Responsibilities:

• Created Advanced SQL Queries using Toad for Oracle for Data Validation Process thereby generating Business Rules.
• Created Mapping Specifications for Source to Target Data, Use Cases, Activity Diagrams, and Sequence Diagrams as per the Process Workflow.
• Worked with Data Modelers for conceptual & logical modeling effort to design ER Diagram & Data Model.
• Conducted Data Quality check based upon the queries created & resolved errors.
• Determined Data patterns & created mapping specifications & impact assessments.
• Created Reports for presenting data to the end users.
• Executed data lineage activities and drafted data definitions and data quality rules.
• Project involved utilizing Bimodal approach of Active Directory for authentication, provisioning & de-provisioning of users from Ram Siebel Database & Teradata database.
• Replaced team member for Scrum Team for last 4 Sprints thereby following Agile methodology.
• Created Advanced SQL Queries using Toad (Oracle) for validating data between Active Directory & Ram Siebel (Database).
• Worked with ETL & Java Developers to resolve data anomalies.
• Created Data Mapping Specifications, to map data from Source to Target & created service specifications for API.
• Analyzed & discussed issues & their mitigation plan in Daily stand up calls.
• Created Vision Statement, Scope, Burndown chart, velocity chart to display Sprint activities & progression.

Confidential, Reston VA

Senior Data Analyst

Responsibilities:

• Worked with Salesforce App Cloud Integration with Apps with Contract Database.
• Managed project deliverables as per SDLC v 5.0 process.
• Identified relevant design, process and specification issues to translate business requirements
• Analyzed and created Documentation for Metrics Calculation (SAT/PSAT).
• Conducted Data Analysis by creating using SQL Queries.
• Used Informatica IDQ for data analysis, cleansing, monitoring of Enterprise data.
• Created Data Quality Queries & worked with DBA’s, Architects & ETL team to resolve issues.
• Created Specifications Document for providing overview of the product to the end user.
• Provided assistance to team members & worked as a team player to support the project.

Confidential, Herndon VA

Senior Data Analyst/ Business Analyst

Responsibilities:

• Created CBRS Business Rules for Mortgage Backed Securities.
• Reverse Engineered Logic for Prefix Analysis and created Eligibility Grids.
• Managed Project Deliverables using Software Development Life cycle methodology.
• Created Business Requirements Document, System Requirements Specifications as per System Context Diagram.
• Conducted Data Analysis by creating Advanced SQL Queries using Toad for Oracle, Advanced Access & Excel.
• Created Mapping Documents from Source to Target, Use Cases, Activity Diagrams, and Sequence Diagrams as per the Process Workflow.
• Worked with Data Modelers & ETL and Mainframe Developers to determine data relationships for logical and physical models as per the systems requirements and created Business Rules.
• Used Doors, Rational Requisite Pro, Rally, and ALM for Requirements Documentation and management.
• Lead UAT effort and Production Readiness Review.

Confidential, Mclean, VA

Senior Data Analyst

Responsibilities:

• Worked in Agile Environment for managing and creating Business Analysis/Data Analysis documentation.
• Created System Requirements Specification (Technical Specifications), Process Workflows and Mapping Documents for various interfaces that were used for sending flow data to CSP.
• Created User Interface, GUI Mockups for exception management of data that would be sent via various interfaces to CSP.
• Worked with the Business Team, ETL team and Java Development Team to mitigate risks issues and gaps.
• Conducted Data Analysis by using advanced SQL and Access.
• Worked with Data Architects to identify data relationships for logical and physical models as per the systems requirements.
• Worked with change control board (CCB) for change management process.

Confidential, Washington DC

Lead Data Analyst/Project Manager

Responsibilities:

• Worked with Access Management/Inventory Management system for managing user profiles.
• Conducted Data Analysis by using SQL Server and Advanced Access.
• Worked with Data Architects and modelers for ER relationship diagram as per the specifications.
• Created Business Rules, transformation rules and mapping documents as per logical and physical data models.
• Worked with BMC Remedy for successful release of project.
• Worked with CMDB (ITIL) as required for Enterprise Account Management.
• Managed Project Deliverables as per SDLC Life Cycle and mentored team members.
• Conducted Data Analysis and worked with the Development and Reporting team for technical requirements.
• Managed Data Accuracy, Completeness and Data Point Changes as per Requirements.
• Managed, maintained and tracked Change Requests for existing new/existing requirements.
• Verified accuracy of operational data by creating SQL queries and validating Reports using Business Objects
• CIT Group, Livingston, NJ - Project Manager Managed the last phase of Risk and Vendor Management Application.
• Developed project charter outlining project objectives, scopes and identifying all the key stakeholders.
• Created & managed project as per the project plan for the VMO project initiatives and monitored that project meets the overall objectives, business requirements, quality standards, performance criteria and user needs.
• Managed and directed team in creating documents as per SDLC v 2.01 such as BRD, Systems Requirements, Test Plan and Test Cases.
• Worked with teams to integrate change management activities into the overall project plan.
• Facilitated status meetings to manage risks and issues log.

Confidential, MD

Project Management/Lead Business Systems Analyst

Responsibilities:

• Created Business Analysis Documentation by the standards and procedures of HIPAA compliance.
• Conducted Data Analysis by using Advanced SQL Queries in Oracle DB2
• Created project plan and managed projects of Applications owned by Confidential and used by AstraZeneca.
• Maintained Risks and Issues Log and provided status reports to IS Business Team.
• Conducted Data Mapping and data validation process.
• Worked with Central Database Management (ITIL) for Asset Management, Portfolio Management Modules, CMDB, Remedy, and SharePoint.
• Worked with ServiceNow management for Assets, Applications, Software, Hardware, Financials Costs associated with the services.

Confidential, Herndon Virginia

Project Manage

Responsibilities:

• Played key role of project manager and managed the project lifecycle and provided all the deliverables as per SDLC v2.03 and Conducted and created Business Analysis, Data Analysis, QA testing documents required for the NPL A-Frame project
• Worked with BMC Remedy, CMDB, Business Objects, HP QC tools during the project life cycle
• Project management using Central Program Office tools which provided a report to Local Governance Council for the progress of the project and conducted PRR with the SOX and Business team for the final release of the project.
• Conducted Data Analysis for Financial Data using SQL, Access, SAS, and Advanced Excel, and validated financial reports using BOXI

Confidential, Hopewell New Jersey

Senior BA/Data Analyst

Responsibilities:

• Gathered Requirements and created Business Requirements documentation, Functional Specifications, schedule, and scope changes, conducted requirement analysis from various Business Users in order to design the application
• Analyzed and mapped data using SQL Server, TOAD,
• Business Process Re-engineering for defining current and future state
• Created Functional and nonfunctional requirements which includes descriptive text, screen mockups, defect reporting and management/ change management
• Worked Web-based technology tool/ online tool utilizing XML payloads and responses

Confidential William Street, New York

DA/BA

Responsibilities:

• Performed extensive Requirement Analysis and created BRD, FSD, Business Glossary, Actors Catalog and Data Dictionary to facilitate the other teams in understanding client business.
• Analyzed Cost Analysis, Variance and Gap analysis on data for Business Support Team.
• Created Business rules, mapping documents, change management trackers in order to migrate to the new financial system and sunset the old system
• Business Process Engineering process defining as - is to future state.
• Provided to Business End Users from various financial sectors such as Debt Securities /Bonds, Equities, Funds, Derivatives, Commodities and Foreign exchange
• Ensured traceability between different development artifacts and proper configuration management of the artifacts.

Confidential, Water Street, New York

Business Analyst

Responsibilities:

• Prepared Use Cases which provided the Trading Customer with the options to buy or sell securities at market price, for their accounts and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Developed prototype of new information processing application and facilitated collection requirements and preparation of business requirement documents (BRD) and functional specification document (FSD) in support of risk underwriting strategies for execution by the IT group.
• Identifying the scope of the product, deriving specifications and design for the product line.
• Collaborated with project manager in tracking and managing project development process following RUP based SDLC methodologies.