SUMMARY

Focused, Results - driven Data/Technology Architect with excellent Domain Experience in Insurance, Retail, Finance, Mortgage, Legal and Education. Expertise in Project Management, Data Analysis, Data Management, Business Intelligence and DevOps. Strong leader and problem-solver with strong analytical and consulting skills who combines technical and functional knowledge with business theory and experience to develop full project lifecycle plans and strategies. Outstanding communicator and presenter who excels at driving consensus through collaboration, organization and relationship building.

AREAS OF EXPERTISE

• Business Data Analysis
• Stakeholder Relations
• Project Management
• Agile Methodology
• System Design/Architecture
• Certified Scrum Master
• Business Intelligence
• Performance Monitoring
• Index Strategy
• Query Building/Optimization
• ETL Development
• Data Modeling/Architecture
• Data Analysis
• Data Warehousing
• Reporting & Data Visualization
• Dev Ops & CI/CD
• Technical Documentation
• Release Management

TECHNICAL SKILLS

Data Design & Modeling: MS Visio, MS Access, Star Schema/Snowflake Schema modeling. Physical & logical data modeling, De-Normalization techniques, Kimball & Inman Methodologies

Database/DW: MS SQL Server 2008,2012,2014,2016, PostGre SQL, Oracle 9i/10g/11g, Teradata, IBM AS400, IBM db2, MySQL, AWS Redshift, Redshift, AURORA

Big Data Ecosystem: HIVE, HDFS, Neteeza, Pig Sqoop Flume Oozie Cassandra

Programming Languages: C, C++, T-SQL, PL/SQL, PowerShell, XML, MDX, PHP, .NET (ASP.NET, C#, VB.NET), JavaScript, Shell scripting

Tools: /Utilities SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, Workbench, DTS, Analysis Manager, SQL Profiler, Visual Studio 2005/2008, SQL * Plus, Toad, Erwin, Integration Builder(IntApp)

Design Tools: HTML, CSS, Adobe Dreamweaver, Adobe Photoshop, Adobe Sketch

Dev Ops / Release Management: Azure DevOps Server, Autosys, IBM ClearQuest, JIRA, Team Foundation Server(TFS), JENKINS (Local, Enterprise), ANT 1.8, MAVEN, Atlassian CRUCIBLE (Code Review Tool), BMC (REMIDY), SubVersion (SVN), Chef, Nexus, Puppet, Shell Scripting

Business Intelligence Tools: SQL Server Data Tools, Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server, Visual Studio, Crystal Reports, BIRT, COGNOS, Tableau Desktop 8.3/7, Tableau Server 8.2­

Cloud Solutions: Microsoft Azure, Amazon Web Services (AWS), Google Cloud Platform, Digital Ocean

PROFESSIONAL EXPERIENCE

Confidential

Leadership/Project Management

Responsibilities:

• Analytical mind - creative development to solve actual operation situation to demonstrate level of performance against the optimal standard
• Certified Scrum Master from Scrum Alliance (CSM) and extensive experience in Application lifecycle management using tools like TFS 2015/2018, JIRA, Rally and Azure DevOps.
• Managed daily stand-up calls and scrum after scrum meetings and helping team to come up with definition of done (DOD) and acceptance criteria.
• Extensive experience and exhaustive knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Agile, Waterfall and other Software Development Methodologies.
• Worked closely with project stakeholders, SMEs, and staff to understand the requirements and specifications for new applications along with enhancements to the existing applications.
• Lead an Agile Steering Committee to define and establish enterprise standards and championed enterprise tools like ServiceNow, Azure DevOps, and Enterprise Architect by identifying and training key SME’s to increase adoption
• Strong track record and positive reputation to influence others and move toward a common vision or goal, enabling communication, consistency, transparency, and traceability regarding data and governance solutions that impact stakeholders
• Perform and review internal audits, including facilitating audit teams through project management and technical processes
• Created and authored corporate data model management strategies that facilitated effective and efficient management data structures through the release process and produce a process with greater accountability and integrity in date definition.
• Provided a Master Data Management (MDM) and Data Governance (DG) Assessment, Recommendation & Roadmap for DG, MDM profiling and analytic opportunities; designed the Data and content Management (MDM/RDM) Strategy including metadata, Data Lineage, cataloging, and architecture (Azure, SQL RDBMS)
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2016/2014/2012/2008/2005, Oracle 10g/11g/12c and Teradata
• Experience in Strategic analysis, Design, Develop and Implementation of DataMart’s and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Extensively used Data modeling in Enterprise Architect to design target data models for enterprise data warehouse (EDW).
• Expertise in RDBMS concepts, Creating Databases, DDL/DML Triggers, constructing normalized and de-normalized tables, User Defined Functions, Complex and Dynamic Stored Procedures, Views, Cursors and Clustered/Non-Clustered Indexes using SQL and PL/SQL
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling, Star/Snowflake modeling with tools like Erwin, ER-Studio & Enterprise Architect
• Performed ETL to a Redshift cluster of over 1 TB of source data of Mortgage Pool/Loan Historical Status data

Confidential

Business Intelligence

Responsibilities:

• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports, and distributed reports in multiple formats using SSRS in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (2012).
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages using various data transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Expert knowledge in managing and automating Control flow, Data flow, Events, Error handling, Performing Incremental Loads and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Created 400+ worksheets and 50+ Dashboards in large BI environments from multiple data source using Tableau, SSRS and Power BI
• Skilled in implementing Calculations, Perspective, and Key Performance Indicators (KPI), providing the cube solution in Power BI for slicing and dicing the data and analyze KPIs across various dimensions.

Confidential, DC

Enterprise Architecture

Responsibilities:

• Established enterprise architecture to map Integrations, Data Flow, Governance Models, all enterprise applications into Enterprise Architect (Sparx systems)
• Integrated Enterprise Architect with Service Now to pull Business Catalog information.
• As part of the prestigious Global Analytics and Reporting project (GAR), developed the Deployment Pipeline, Ticket Pipeline, Development and Test Cycles within Sprints, Automation Deployments in TFS alongside Developing the Technical foundation for the Data Warehouse in SQL Server 2016, Reporting and Analytics using Power BI and Azure.
• Championed to establish Microsoft Power Platform (Power BI, Power Apps, Flow) under Microsoft’s umbrella of Analyze, Act and Automate. Moved light weight business apps to Power Apps which saved the firm 7% costs on Development, Infrastructure and Maintainability
• Lead efforts to establish a project building permit process using PowerApps and Flow for intake of new Projects which includes automating the request process for Infrastructure, AD Accounts, ALM project space while integrating with Service Now
• Technical advice on various project initiations to approve architecture and to ensure the projects fit into the ‘Bigger Picture’
• Train Business Users, Partners and other Stakeholders to use tools like Service Now, Power BI and Enterprise Architect
• Application Owner for Team Foundation Server and Azure DevOps Server.
• Currently leading efforts to establish a DevOps Strategy at the enterprise level which includes building a standalone Code Repository and defining deployment pipelines in Azure DevOps Server
• Technical Lead in the Enterprise Agile Center of Excellence team responsible to establish a unified project reporting metrics and standardize use of Scrum/Agile to drive project requirements that provide value
• Core member in the Enterprise Service Now Champions team that is responsible to advice users on capabilities and usage of Service Now, keep Service Catalog updated and advice on adapting Service Now dev team on potential adaptation of other HoganLovells use cases.
• Work with Firm InfoSec team to establish Security Testing criteria for all projects with the Azure DevOps Server

Confidential, DC

Enterprise Architecture

Responsibilities:

• Lead companywide review of business-critical applications, documenting data structures and ETL processes and presenting recommendations for structural improvements and optimization strategies to C-Level management and directors
• Co-developed and governed the baseline architecture of the Enterprise Solutions' End-to-End Systems Integrations.
• Architected and Developed the Master Data Management solution using MDS and Maestro which is used enterprise wide as a Data source for Data Stewards, Applications and Reference Data.
• Integrated the MDM solution to over 45 different applications within the first 12 months of establishment helping the Enterprise standardize data across multiple streams.
• Architected and Lead efforts to reintegrate 60+ applications away from Legacy sources to data integration hub(DIH) and other system of records.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the data warehouse integrity checks and shell scripts to balance the data between source and target tables after each ETL process.
• Created Data Lineage specification spreadsheets to document the transformation logic.
• Converted Business Logic to SQL Code and defined it under a rule engine, which the Stored Procedures ran on. This helped to segregate data as per the Rules.
• Re-Architected the existing integrations in the ETL tool Integration Builder(IntApp) into SSIS to keep the SLA of one hour or less to the internal customers
• Developed and Configured dataflow rules and integrations with multiple application using Integration Builder(IntApp)
• Gathering the report requirements from various stakeholders, cross-functional departments, business users and documenting them in the reports specifications document and report inventory
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server
• Identified data sources, construct data decomposition and data flow diagrams, metadata link, map, context lineage; Id Required catalogs of business Building Blocks - Business capability, value stream stages, KPIs, roles, business service, business strategy, market position and capabilities to redefine the operating model - presenting to stakeholders
• Created organized, customized analysis and visualized projects and dashboards to present to C-Level executive leadership using Power BI
• Worked with Quality Assurance team to automate tests using LegiTest by Pragmatic Works

Environment:: MYSQL, SQL SERVER 2014/2016/2017, SSRS, SSIS, Power BI, SSAS, .NET, Azure, Azure DevOps, JENKINS, Code Deploy, GitHub, JIRA, Confluence, Visual Studio 2015/2017/2019, Integration Builder, IntApp, WallBuilder, Workday, Enterprise Architect, Enterprise Elite, Master Data Services, Data Quality Services, Maestro (profisee), Workbench (Pragmatic Works), LegiTest

Confidential, Washington DC

Technology Analyst

Responsibilities:

• Analyze & reverse engineer the existing application code and document the current state.
• Reengineered existing process and developed a new application for RPL- Reperforming Loans which streamlined the Loan Pooling Re-Process (SQL, SSIS) by running the Loans through a Rule Engine (Business Logic Converted into SQL) and creating audit on Loans that failed and passed any given rule.
• Provide DEV Support(L3) to Production Teams(L1/L2) to handle Long running Queries leading to SQL Query Optimization & PL/SQL code tuning using Explain Plan, gathering statistics, monitoring database performance.
• Provide technical direction and guidance to customers/stakeholders by understanding and assessing their needs, researching efficient options, providing solutions, and following up on effectiveness of the solution
• Provide foresight on what types of visualization techniques that work best for different types of data, as well as the limitations of certain techniques.
• Responsible for creating Databases, Tables, Views, Store Procedures, Triggers, Functions etc. using T-SQL and/or PL/SQL to provide structure to store data and to maintain database efficiently.
• As a Database developer, responsible for designing database structures, SQL and PLSQL code development, writing packages, procedures/functions and triggers, analytical functions, join strategies, managing performance indexes & table partitions, data masking.
• Responsible for SQL query optimization & PL/SQL code tuning using Explain Plan, gathering statistics, monitoring database performance
• Provided support for ETL processes, test plans and integration testing, production support (24/7) for resolving critical data issues managing, mentoring development team
• Performed data Extraction, Pre-processing & cleansing to remove redundant and unwanted data (SSIS) to extract insights from unstructured data thereby use the analysis to construct the roadmap for future analysis.
• Automated different database related activities including backup, monitoring database health, disk space and backup verification using SSIS package and different queries.
• Used various SSIS tasks such as Conditional Split, Derived Column etc. for Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created and Maintained Build, Deployment and Testing pipelines and Automated Setup for Continuous Integration and Continuous Delivery (CICD) pipelines in Jenkins across the application involving different components
• Worked with principle architect to manage Infrastructure for the team and assisted for any new server setup and server application installations, also maintained the Infrastructure Document for 30 different servers.

Environment: SQL Server 2008/2012, Oracle10g/11g, SSIS, SSRS, SSAS, SharePoint 2010, Visual Studio 2008, AUTOSYS, Crucible, SVN, GITHUB, Jenkins (Local, Enterprise), RALLY, Remedy, MAVEN, ANT, Unix, JUNIT, MS Power Pivot, ServiceNow

Confidential, Sterling, VA

Sr. Data Analyst

Responsibilities:

• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata, in order to ensure accuracy of the data between the warehouse and source systems.
• Wrote SAS/SQL ad hoc report programs to track, identify and resolve customer account errors. Process included gathering business requirements from internal customers, supervisors, call center management teams, identifying critical data points and determining service level objectives.
• Responsible for designing and developing a new critical system, API Performance Monitoring System (APMS) which helped monitor various API calls based on defined Threshold levels.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Work with the DBA’s to get PROD server UPDATES, Database consistency checks using DBCC Utilities monitor deadlocks in PROD using tools like FogLight, a database monitoring system.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Environment: SQL Server 2012, T-SQL, SQL Server Data Tools 2012 (SSIS, SSRS), Tableau, Python, PowerShell, COGNOS, SharePoint 2010, Visual Studio 2008, ASP.NET, SQL Server Profiler, MS Power Pivot, Microsoft Project, JIRA, SVN, GITHUB