PROFESSIONAL SUMMARY

• 9 years of experience in data management services in the areas of banking, corporate finance, insurance, investments banks and other financial institutions business verticals.
• Wrote the project charter for new engagements and addressed assumptions, in - scope and out-of-scope events.
• Worked with Program and Project management team to consolidate the project tasks and timelines for product releases.
• Wrote the business requirements for transactional systems and Data Warehouse initiatives.
• Worked in the areas Waterfall and Agile Project Development Methodologies.
• Actively involved in project inception, elaboration, construction, testing and deployment phases.
• Involved in System Development Life Cycle Phases (SDLC) - Feasibility, Design, and Testing Phases.
• Wrote the Proof-Of-Concept use cases and test scripts to validate the product features and functionalities.
• Delivered Normalized and Dimensional Data Model Business Requirements for ETL Projects.
• Captured Business Logic for SCD and CDC Logics to handle the Incremental and Historical Records.
• Experience with enterprise data architecture, enterprise data integration, data virtualization, data modeling, analysis, and metadata management
• Understand business problems and apply technology to visualize data or provide decision support to those problems,
• Developed data flow and process flow diagrams and wrote gap and impact analysis observation documents.
• Worked with structured, semi-structure and unstructured data formats to write source to target data element mappings.
• Designed and created Reporting Mockups, User Interface Application Screens/Wireframes, and Data Navigation Flows.
• Wrote the requirements on business rules, process rules, data rules, data profiling rules and data masking rules.
• Captured Data Architecture Principles such as Governance, Integrity, Lineage, Profiling and Purging requirements.
• Reviewed the requirement documents with various business units to get the documents final sign-off process.
• Validate the defined Use Cases in Integration and User Acceptance Testing Environments by building Ad-Hoc SQL Scripts.
• Responsible to organize the meetings, consolidating and circulating the meeting minutes with project stake holders.
• Responsible to maintain Issue Logs, Change Log Requests, Requirement Business Matrix, and Business Dependencies.
• Hands on experience in writing SQL and T-SQL, Schema Management Scripts using Oracle 10g, MS SQL Server Databases.
• Various reports designed and developed in MS Excel, MS Access, SS Reporting Services, SS Analysis Services and Tableau.
• Captured process requirements for error handling, exception handling, audit control, and restart recovery logic.
• Demonstrated ability to organize, prioritize and complete to work independently. Self-starter with excellent written and verbal communication skills. Passion for providing excellent service to internal clients and business users.

TECHNICAL SKILLS

Domain Expertise: Corporate Finance, Risk, Asset, Investment, and Mortgage Retail Management

Databases: SQL Server 2005/2008/2012 and Oracle 10g, Hadoop

Microsoft Product Suites: MS Word, MS Excel, MS Access, MS Power Point MS Visio, and MS Project

Operating Systems: Windows XP and 2000/2003/2008 Servers and Windows Batch Script Programming

Microsoft BIDS Suite: Reporting Services (SSRS) and Analysis Services (SSAS), Tableau

Data Analysis Research Interpretations & Methods: Excel Macro Writing, V&H Lookups, Pivot, Slice and Dice for Data Validation SQL/T-SQL, PLSQL, Stored Procedures. Toad, Rapid SQL, Erwin Data Model,SAS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Peoria IL

Responsibilities:

• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers and analyzing raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data.
• Performing daily system checks and Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Designing, developing and implementing new functionality. And monitoring the automated loading processes.
• Advising on the suitability of methodologies and suggesting improvements also will Carrying out specified data processing and statistical techniques.
• Supplying qualitative and quantitative data to colleagues & clients.

Technologies: MS SQL Server 2012, MS office Suite, MS Visio, Share Point, Hadoop, SAS, CAT ETL Tool, DB2 and Jira.

Data Analyst/ Data Modeler

Confidential, Charlotte NC

Responsibilities:

• Gathered and Published Business Data Model Requirements from Interactive JAD Sessions to meet ‘Operational RISK Model (ORM)’ reporting Data Services.
• Created Conceptual Data Process Flows Illustrations and Translated into MS SQL Physical Data Model using Erwin 9.5 Tool.
• Established Agile Star Schema Dimensional Modeling Principles and Defined Metadata Definitions for 600 attributes which are shared across multiple dimensions, facts and aggregated facts.
• Worked with Operational DBA Group to Deploy DDL Scripts into multiple environments.
• Verified Referential Integrities, Indexing and Partitioning Scripts. Implemented Data Profiling, Data Validation and Data Quality Ad-Hoc SQL Scripts to meet User Centric Information Business Rules.
• Analyzed and configured Source to Target Element to Element Data Process Mapping with all derived, default standardization, and exception with error tracking codes.
• Designed and Developed Interactive Data Analytics Dashboard reports on ORM Model and Semi Structured Data Feeds using Tableau Software.
• Incorporated Quick Filters, Parameters, Context Filters, Performance Actions, Embedded Views, Derived Trend and Time series Metrics and etc.
• Implemented Drill down and across Functionalities to present ample amount of data for user community and prepared Reporting Run Book to utilize the products by external clients.

Technologies: MS SQL Server 2012, Erwin 9.5, Tableau, MS office Suite, MS Visio, Share Point, Windows and Jira.

Data Analyst

Confidential, Ridgewood NJ

Responsibilities:

• Gathered the requirements, analyzed the gaps, and interacted cross functional teams to finalize the business needs.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
• Build and modified the Business Process Flows and Data Flow Diagrams to establish future state requirements.
• Perform the source system analysis and data profiling activities for multiple business domains.
• Translated business process model into Credit Risk Logical and Physical Data Models.
• Added physical data model strategies for partitioning, indexing and aggregation requirements.
• Created scalable data processing solution that stores user personalization financial data.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Actively participated in the strategic decisions on migration, implementation and release management.
• Experience with Callidus True Comp and Reporting & Analytics (For report development and security configuration)
• Define the data structures and constraints, standardized attributes, and reviewed information access paths.
• Build the source to target data mapping, defined standards, and business rules for ETL load process.
• Prepared Data Integration Loading Dependency traceability matrix sheet for development activities.
• Wrote the Test scripts to validate the application and data change requests.
• Extensively wrote the T-SQL scripts to validate the back end database and export the data into excel to analyze.
• Created dashboard and pivot reports to underwriters and loan officers to trace the loan process appropriateness.
• Involved in change control and release management process to move the code into various life cycle environments.

Technologies: MS Visio, MS Office, Erwin, SQL Server DV 2008, Tableau, Jira.