SUMMARY:

• Highly qualified IT professional with nineteen years of technical and data architecture skills working for several IT customers employed directly with Confidential.
• Currenty working as Cloud Solutions Architect and responsible for building technology - based roadmaps for the enterprise focused on providing Business Intelligent (BI) solutions
• Adept at maintaining focus on achieving bottom-line results while formulating and implementing advanced technology and business solutions to meet a diversity of needs.
• Excellent interpersonal and communication style with expertise in solution designing & architecting high-performance technology and project solutions to meet business demands and recognized for consistently delivering projects with the optiomal solutions.
• Have worked primarily in the domain of Finance, Banking & Insurance, related to account management, lending & leasing and mortgage.
• Have worked as Senior Data Analyst in the Enterprise Wide Anti-Money Laundering Risk Assessment Program for mortgages from a functional standpoint. This is a global program wherein the end-customer is Office of Comptroller of Currency.

TECHNICAL EXPERTISE:

Data Modeling: Dimensional Modeling, Erwin Data Modeler

Databases: Confidential DB2, Teradata, Oracle 11g and SQL Server 2012

Tools: Erwin, Ab Initio, Informatica, Actuate, COGNOS 10.2, APEX, OBIEE, Business Objects, Hyperion Interactive Reporting (HIR) Oracle 11g/12c/19c - SQL, PLSQL, Teradata, Toad, SQL Developer

Confidential: Infosphere Information Server (Business catalog, Data quality) Amazon S3 Lake formation

AWS: Quicksight BI Reporting Platform

ETL: Ab Initio, AWS Glue, EMR

AWS: EMR, Snowflake, Tableau, Looker, Athena Unix, Linux

Autosys Scheduling Tool: Confidential Sterling, MFT - Managed File Transfer

Agile: Practice Scrum via Jira

PROJECT EXPERIENCE IN CHRONOLOGICAL ORDER:

Confidential, Plano, TX

Solutions Architect

Responsibilities:

• Executing architecture strategy for modernization of Legacy systems (both applications and underlying databases) including Oracle, Netezza and Mainframe DB2 databases into Snowflake Cloud
• Executing POC and evaluating data solutions using technologies like Amazon S3, AWS Glue, Crawlers, Snowflake, Athena, Google Looker, AWS Quciksight Mazda Financial Services: Design & Build solutions for Finacial Services for Mazda Motors.
• Working on Roadmap and actively moving on-prem Applications to AWS cloud platform via executing POC and making decisions using Well-Architected Tool & Best practices
• Solving complex business scenarios across various distinct business units towards achieving common organizational goal of faster and convenient data retrieval
• Actively working on Roadmap for Confidential ’s enterprise initiative for Confidential /Lexus vehicle data ingestion to implement M/L solutions to: - enable insight into performance of cars in real-time and helps in predictive maintenance and efficient existing-customer engagement

Confidential, Dallas, TX

Data Architect

Responsibilities:

• Worked with multiple SAFE (Structured Agile Framework) Teams to collect the pains and challenges of various business units of the organization. Aim was to focus on prevailing and desired state of data consumption requirements.
• Worked with Data Governance organization to understand the gaps in areas of Data Quality & Data Lineage
• Worked with Business Analysts across various groups to analyze the reporting mechanisms in order to drive home a common solution for the greater good of the organization
• Analyzed the various silo SQL Server databases comrprising of complex stored procedures
• Developed a strategic solution which consists of a hybrid model of Apache Hadoop platform and BI SQL Server based Enterprise Data Warehouse
• Worked extensively to separate used vs non-used existing database object(s) based on thorough research of data usage by various business users
• As a Data Architect & SME, working with two different Development Agile Teams to help execute Remediation of non-IT databases and helping business units do self-service operational reporting out of Hadoop based platform.

Confidential, Cleveland, OH

Enterprise Data Architect

Responsibilities:

• Supporting Key Bank s enterprise Data Supply Chain initiative and responsible for leading and analysis of old legacy systems and their conversion to Confidential BDW data warehouse model. Leading a data analysis effort to create a file extract for Oracle Financial Services Analytical Applications (OFSAA) from source systems in order to determine corporate profitability.
• Elicited data requirements using data analysis, requirements meetings, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
• Developed data requirements specifications according to standard templates for Confidential Banking Data Warehouse (BDW) model.
• Led the data analysis and mapping effort for creating an extract from source system that feeds data into Oracle Financial Services Analytical Applications (OFSAA). OFSAA will replace current profitability system (CRISP).
• Evaluated data attributes gathered from multiple sources, reconcile conflicts, and distinguish user requests from the underlying organizational needs.
• Proactively communicate and collaborate with internal customers to analyze data needs and functional requirements and deliver the following documents as needed: Data Requirements Document, Detailed Source to Target mapping, and Business Data Definitions.
• Developed data work flow diagrams to facilitate a solution - envisioning sessions.
• Developed data requirement traceability matrix to ensure that source data is captured and mapped as per business requirements.
• Written SQL test cases to test/validate data from source, including data profiling for attributes that are sourced into BDW.
• Used Teradata SQL Assistance, SQL Server in data analysis of source systems and its attributes.
• Collaborated with developers and subject matter experts to project s technical vision and analyze tradeoffs between usability and data needs.
• Assisted project manager in maintaining high-level project schedule, scope, resources, identified users and stakeholders, and communicated project information to release management.
• Assessed the impact of planned development on existing systems, identifying risks and roadblocks by hosting meeting between Business stake holders, data stewards and / or development Teams.
• Architectural supervision of project design for multiple projects
• Code review and development oversight of projects
• Working with Confidential in the resolution of challenges faced in Hadoop environment by participation in POC based on problems encountered by development Teams
• Implementation of best practices like Collect Stats for performance improvement
• Storing data in native HDFS file system in parquet format to improve performance and saving space.
• Providing Technical guidance to the Ab Initio development Team
• Development of Unix shell scripting in order to decommission of Ab Initio plans

Confidential, Irving, TX

Senior Data Analyst

Responsibilities:

• Worked as Senior Data Analyst in multiple projects across the Originations, Servicing and Default departments.
• Functioned as bridge between business and development Teams developing in-built house mortgage solution called COSMOS - Confidential One-Standard Mortgage Originations Suite.
• Leading the Analytics Team and parterning with BI Competency Center to deliver Analytical models and solutions in SAS and COGNOS.
• Leading the COGNOS Team to deliver Analytical dashboards in COGNOS
• Working with Confidential in the resolution of issues in the Confidential ’s Lifecycle Manager Tool for the upgrade of COGNOS reporting stack to COGNOS Analytics.
• Working with SAS Team to develop analytical and statistical models
• Leading the Data Quality Team and partnering with Data Stewards to deliver Data Quality dashboards built in SAS.
• Leading the SAS development Team to deliver Data Quality dashboards
• Working with Data Stewards in the resolution of data quality issues
• Development and maintenance of statistical models built in SAS.
• The platform is Data-warehousing with underlying tools being Ab Initio and COGNOS. Function as a bridge across multiple development teams.
• Identify and procure project infrastructure needs
• Identify and document project constraints
• Maintain project staff technical proficiency and productivity
• Ensure quality of deliverables
• Centrifugal point for project communications
• Conduct Status calls to track Technical milestones
• Monitor day-to-day activity and provide direction to team members
• Monitor project progress with team members and direct reports; analyze issues and potential roadblocks. Evaluate errors and establish directives and procedures to minimize errors, increase the efficiency of project and mitigate any risks
• Presentation of deliverables and walk-through of usage by live demonstrations via MS Live Meetings
• Monitor project progress with team members and direct reports; analyze issues and potential roadblocks. Evaluate errors and establish directives and procedures to minimize errors, increase the efficiency of project and mitigate any risks
• Measure any scope creeps and appropriate in corporation via Scope Change Requests
• Presentation of deliverables and walk-through of usage by live demonstrations via MS Live Meetings

Confidential

Business Systems Analyst

Responsibilities:

• Understanding the process flow for the construction of datamarts
• Working closely with Business to understand the business priorities required for iteration planning
• Creating Use Case Diagrams, Activity Diagrams and Use Cases to communicate requirements
• Peer Review of Use Cases and in corporation of suggestions/feedback
• Brainstorming for process improvement
• Interaction with the entire team of Business SME’s (Subject Matter Experts), Domain Experts, Technical Leads, Design Engineers, Development Leads from across LOBs
• Communicating the functional requirements to the offshore team
• Organizing and prioritize requirements, using Requisite-Pro
• Creating traceability of functional requirement to Use Cases and User Stories
• Co-ordination with offshore team, attending project kick off meetings and status update meetings with the Client
• Participating in retrospective meetings
• Responsible for the effort estimation, planning, and execution of testing activities
• Collaborate with applications developers on data modeling
• Conducting Regression Testing whenever some code module is changed
• Conducting Sanity Testing on the load environment before performance test begins
• Extensively used HP Quality Center 9.2 for Test management and execution of test cases
• Build and maintain SQL scripts and complex queries for data analysis and extraction

Confidential

Reporting Architect

Responsibilities:

• Lead the Data Modeling Team
• Designing solutions, Prioritizing the critical fixes and assigning the work from functional & technical perspective to the team members
• Design reviews, Quality assurance of code being delivered and the making sure deadlines, SLA are met
• Monitoring the progress of Technical work
• Holding Data Architecture Meetings
• Compiling monthly production statistics
• Reporting status to the client
• Mapped business objectives to specifications; defined interactions with diagrams and prototypes
• Collaborated with peers to define final interface designs
• Involved in High level and low level design
• Involved in SIT and Regression Testing

Confidential

Business System Analyst

Responsibilities:

• The project supports all the data marts and reporting activities for commercial finance businesses. This is in a datawarehousing environment with the ETL tool being Informatica and reports in Business Objects
• I lead the reporting environment of BO which involves enhancements and solving priority cases using Clarify