SUMMARY:

• Database and Application development experience. An innovative and resourceful professional that has an excellent ability to provide analysis and solutions for business issues across multiple industries ranging from Banking, Engineering, Aerospace, Finanical Services, Manufacturing, Telecommunications, and Federal Government. Exceptional technical skills, troubleshooting, analytical thinking, excellent understanding of data, cross - functional team leadership and time management. Recognized for inspiring team members to excel and encourages creative work environments.

TECHNICAL SKILLS:

Applications: SAP/ HANA, Tableau, Oracle 10g, 11g, 12c, Epic, Salesforce.com, Microsoft Office 10, 13, 16 Microsoft Project, SQL Server 08, 12, 14, Business Intelligence, AWS S3, EC2, Apigee, Putty, Data Governance Collibra, Management Consulting, Alteryx, Python, inancial reporting, Blue Prism, PostgreSQL, BMC Control-M, Service Now, Hadoop, SharePoint, Spark, Apigee, Statistical Analysis Package,Teradata, Hive, SAP, Cassandra, MongoDB, Toad, Dbeaver, Bash Scripting, Control M, Data Modeling, Erwin, ERStudio, Informatica Power Center 6.2/5.1,MS Visio, MS Project

Operating Systems: Windows XP, Windows 7, Windows 10, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Data Architect/ Senior Data Engineer

Responsibilities:

• Designing, architecture and developing data analytics systems for various use cases including but not limited to network performance and field operations.
• Participating and contributing in engineering life - cycle including writing production code, building end-to-end machine learning solutions, conduct code reviews and working closely with infrastructure teams
• Experience managing Kafka clusters both on Windows and Linux environment.
• Building scalable systems to process petabytes of wire line and wireless data to provide real-time insights into the health of Confidential networks.
• Building batch and real-time data pipelines to ingest and transform data for model / testing; and building and deploy model inference pipeline.
• Designed and implemented by configuring Topics in new Kafka cluster in all environment.
• Responsible for resolving discrepancies between source data dictionaries and data provided
• Coordination of future acquisition and development activities
• Maintain and enhance predictive models. Identify and recommend improvements
• Data collection/analysis, ER / Logical / Physical modeling, Normalization, Denormalization, Star schema, Snowflake schema, Data mart / Data warehouse applications, CASE Tools and ETL Tools.
• Lead Confidential in building next generation private Data architecture.
• Responsible for analyzing and designing next gen data architecture, that will optimize networks to support innovative and disruptive enterprise applications.
• Data modeling expertise using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables design, Physical and Logical Data Modeling by using ERWIN 4.0/3.x and Oracle Designer and knowledge in data mart and data flow modeling.
• Experienced with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, informationStewardship, Data Profiling, Data Quality, and Data Model Standards.
• Consolidated and audited datafrom disparate tools and sources, includingSAPbusiness intelligence (BI). Extract, transform, and load (ETL), relational databases, modeling tools, and third-party data into a single repository.

Confidential, Texas

Data Architect

Responsibilities:

• Help define the vision and roadmap for realizing data analytics solutions
• Define the architecture of autonomous components of LM products or platforms from concept to specifications, recommending and making technical decisions on techniques, and solutions, and how solutions will be integrated and deployed with other systems to meet customer requirements
• Efficiently combine FOSS/COTS tools for data storage, processing, and visualization to allow the warfighter to make decisions quickly and effectively
• Design and build data-centric architectures that leverage common data models to allow for federated access to data
• Assisted in SAP Data migration team for Legacy data analysis, Master Data (Materials, Customers, Vendors), and transactional data collection, extraction, cleansing, harmonisation, and transformation to load into SAP
• Designs, develops, and analyze complex data queries necessary to identify data quality issues and presents results in an easy-to-understand format to end users
• Create customer segmentation schemes that will provide our analytic teams with insights into our customers
• Analyze and resolve cross-functional data issues across SAP modules and between SAP, legacy applications
• Master data consolidation, aggregating master data from across the system landscape (including SAP, non-SAP systems) into a centralized repository of consolidated information in MDM for companywide analysis and reporting.
• Working with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements.
• Perform data modeling, data architecture mapping, and data governance
• Design and implement data solutions by defining database physical and virtual structures and functional capabilities, security, back-up, and recovery specifications
• Deep knowledge of Master Data Management (MDM) principles, processes, architectures, protocols, patterns, and technologies
• In-depth understanding of Data Structure and Algorithms.

Confidential, Texas

Metadata Analyst, Business Systems Consultant

Responsibilities:

• Pre-onboarding engagement to evaluate needs and partner with Enterprise Data Governance for direction
• Execute standard onboarding of business metadata for partners to the Enterprise Metadata Center
• Identifying strategic applications and APPs with support from domain executives.
• Identify emerging trends in technology in the MDM space and come up with innovative solutions, both technical and non-technical
• Results oriented approach with the ability to turn data and information into actionable insight to solve problems
• Work with key stakeholders and connect with cross functional groups to foster good relationships to drive continuous improvements in our tools and processes
• Partner with Data Stewards for requirements, integrations and processes, participate in meetings and working sessions
• Partner with Data Management and integration leads to continuously improve Data Management technologies and processes
• Wrote Spark-Streaming applications to consume the data from Kafka topics and write the processed streams to HBase.
• Create and maintain enterprise metadata standards, guidelines, and process documentation.
• Designed and implemented by configuring Topics in new Kafka cluster in all environment.
• Successfully Generated consumer group lags from Kafka using their API
• Build scalable and sustainable processes and tools for metadata management, and data quality measurement and monitoring, including developing guidance and best practices for both, in alignment with this policy.
• Built real time data pipelines by developing Kafka producers and Spark streaming applications for consuming.
• Ensuring consistency in data quality and metadata design, implementation, monitoring, and reporting
• Partnering with application business data owners to identify, ensure resolution, or escalate data quality defects.
• Providing a centralized function to support the remediation of data issues.
• Assist with facilitation of sessions for business and technology partners covering enterprise metadata standards, guidelines, and processes.

Confidential, Dallas, TX

Data Operations Engineer III

Responsibilities:

• Monitor data that moves to and from the Data Operations Center
• Complete and maintain all documentation relating to events that require data flow through the Data Operations Center (DOC)
• Ensure that critical customer operational issues are addressed quickly and effectively
• Have led in a Solution Architect role in full lifecycle implementations with a leading MDM product suite (Informatica, IBM InfoSphere, Oracle)
• Built real time data pipelines by developing Kafka producers and Spark streaming applications for consuming.
• Analyze individual issues in the context of an overall platform to proactively identify larger problems
• Differentiate between issues that arise in operations, user code, third party libraries or product
• Lead Operations Engineering team in investigating and troubleshooting product issues identified by clients or internal users
• Created database queries to help optimize database workflows.
• Design, maintain and coordinate issue reporting and escalation procedures across multiple internal teams, systems and time zones
• Provide product and engineering team with detailed root cause analysis reports for issues reported by our clients
• Worked on system change management for project plans with updates and managed test plans.
• Fulfilled ad-hoc reporting requests using the SQL Server software
• Manage and communicate Backlog through KPI Dashboard.
• Work with product and engineering team to provide client feedback on the enhancement of system features and ensure platform stability and supportability, prioritizing solutions based on business impact
• Help design system deliverability solutions, workarounds and system configuration changes
• Build and maintain technical documentation, how-tos, and known issues documentation for non-technical members of the team
• Provide the escalated level of support for critical customer operational issues
• Used SQL pull large dataset for analysis.

Confidential

Manager, Data Analytics

Responsibilities:

• Support and mentor the Audit teams in the use of Data and Analytics (D&A) in our engagements including data extractions and analysis from large scale ERP systems.
• Partner with the Audit engagement teams and communicate any technical implications of D&A Tools, including extraction, processing, data mapping, data conversions and interpretation of large data sets as well as delivery of reports.
• Provide technical support for configuration of SAP/Doculink configuration and development experience with various scenarios accessing archived data
• Worked on Master Data (Materials, Customers, Vendors), BOMs (Material BOM, Equipment BOM, Sales order BOM, Variant BOM,
• Engage the client technology teams to discuss any technical implications in performing extractions and integration of their financial data and any further analysis needed by the KPMG Audit team.
• Facilitate the project plan, project scope, schedules, resource estimates, project budget, issue management, risk management, change control and status reporting with the Audit engagement team
• Support retrieval of the archived data from the third party medium such as IBM certified storage products.
• Collection of master data requirements to be processed in SAP, Provide parameters for identifying obsolete / inactive records
• Consolidation of Material master, Vendor master, and Customer master data
• Manage technology projects on Scope management and requirements management best practices and processes
• Updating douments for SAP/Python intergration project.
• Managed resource allocations for projects through completion.
• Tracked Status of ongoing projects, reports processes to management.
• Create documentation for extracting, analyzing and mapping of ERP system from the client team.
• Analyze, design, create HANA data models to support various reporting requirements.
• Primary activities involved Identifying Archiving Objects of the Production system.
• Take an active role in requirements gathering and reviewing the high-level business requirements converting them into Functional and Technical Specifications.
• Work with multiple stakeholders to develop a comprehensive archiving blueprint and roadmap.
• Prepare design documents, configuration, testing documents and other technical aspects related to SAP Data Archiving.
• Ensure technology projects have solid requirements/scope management process to prevent scope changes or timeline adjustments
• Demonstrated Subject Matter Expertise and direct hands-on experience in areas such as: legacy data archiving strategy.
• Participate in the design, development, and implementation of new KPMG extraction software tools/modules as well as managing fixes and enhancements to these components.

Confidential

Manager of Data Analysis

Responsibilities:

• Developing data analysis metrics to assist clients in understanding the trends and anomalies of their business by understanding the key performance indicators
• Written SQL Server programs to facilitate the validation of datasets.
• Provided Risk Adjustment and SQL programming for new hires and junior employees.
• Researching and benchmarking key statistics to aid clients in the comprehension of their data profiles
• Creating executive summaries and reports to present to senior management and partnerships
• Designing databases/program code to gather information and develop standard reports
• Expanding audit plans and fraud procedures in the key business areas of Accounts Payable, Accounts Receivable, Financial Reporting, Payroll, etc.
• Managing the scheduling of projects and team of 5 data specialists to ensure timely execution of projects and deliverables as well as matching the appropriate resources to the level of expertise required for the projects.
• Database Management, Requirements Analysis, Software Development Fundamentals, Problem Solving, Documentation Skills, Verbal Communication, Data Maintenance, Database Security, Promoting Process Improvement, System Administration
• Provided SQL and SPSS programming consultation for financial services and Statistician.
• Review the requirements with the QA team to identify the gaps and work to resolve the gaps
• Counseled and guided over eight staff members throughout the Southeast region from new hire through several promotions. Mentored and advised several star performers through their career development.
• Maintained SQL to use in extraction of the dataset.
• Assisting an internal audit client in the decision-making process to re-engineer their inventory stocking process versus adding additional headcount. Accomplished by analyzing and reviewing several types of inventory and receipt files for movement versus quantity and timing
• Updated SQL query to assist in data workflows.
• Providing client with spend analysis recommendations based on accounts payable vendor and disbursement information
• Used SQL skills to extraction data for reporting needs.
• Developed and enhanced SQL Server procedures for statistical analysis output generation.
• Estimates staff resource needs for analysts, programmers, user personnel, consultants, and equipment
• Determining the feasibility of implementing an estimation-sampling program for a distribution center by review of the physical and systematical flow of merchandise within a large pharmaceutical warehouse
• Preparing and presenting overall results of a three-month global compliance review to client senior management, two lead client partners and a panel of international legal counsel

Confidential

Senior Data Analyst

Responsibilities:

• Designs develops implements and maintains custom oracle applications written in PL/SQL.
• Monitor the Adjudication process data flow for the state of Washington.
• Analyzes and resolves issues from the lane vendor and credit card processing.
• Create business process models to automate workflow.
• Maintained, reviewed and implemented database enhancements to better serve the needs of the business.
• Engage with End Users to manage problem management activities including root cause analysis.
• Direct and manage the day-to-day activities of project members.
• Worked with the team to ensure all lane tolls are fully processed in the system.
• Developed a reconciliation process for Finance to track transactions.
• Create ad hoc report data in support of Operations’ transaction/financial reconciliation.
• Work with a diverse group including business users, developers, etc.

Confidential

Data Architect

Responsibilities:

• Support the roll-out of automated reporting solutions.
• Create reports, dashboards, and email templates.
• Work with users to understand needs and provide assistance in response to ad-hoc data requests.
• Performed data validation and testing with customers and other subject matter experts to ensure data accuracy.
• Implementing solutions that enable marketing and sales processes to work in a synchronized.
• Developed custom reports in from the EPIC Clarity Database using SQL stored procedures and Crystal Reports.
• Customize the application to meet changing business needs.
• Assist with data mapping and data enhancements, recommend new processes.
• Organizing Marketing teams and directions for ongoing .
• Facilitate maintenance of a mission-critical business application.

Confidential, Atlanta, GA

Test Engineer

Responsibilities:

• Uses proprietary systems and tools to set up and configure tables/parameters for the system.
• Assisting the implementation teams in data migrations and data analysis.
• Working with Line of business managers to ensure implementations were successful.
• Writes configuration, procedural, and technical documentation based on the analysis specifications
• Utilizes relevant problem-solving resources and communication.
• Moving data from one database into another for data entry to maintain data updates.
• Running data integrated checks to verify data was correct before going live date.
• Setting up applications to data cleaning and validation.

Confidential ., Alpharetta, GA

Systems Analyst

Responsibilities:

• Creating Crystal Reports for auditing databases and data accuracies.
• Modifying existing reports for data metrics for employee turnaround time.
• Developed templates for data migration for data analysis using Crystal Reports.
• Develop and execute test plans and test scripts using Oracle from requirements.
• Writing scripts to convert data files to a comma delimited files for FTP Server.
• Work with management to ensure projects adhere to quality standards and deadlines.
• Develop and execute test plans and test scripts using Oracle from requirements.
• Build and review test data to support test scenarios for CRM systems.
• Maintain legacy applications for customer data in ServiceCenter
• Use Crystal Reports to produce daily, weekly, and monthly for customers.
• Writing scripts to convert data files to a comma delimited files for FTP Server.

Confidential

Programmer

Responsibilities:

• Developed MS Access application to process the SQL Server Databases.
• Programming modifications for MS Access Databases as required.
• Converted the MS Access database for storage in the SQL Databases.
• Maintaining and updating in MS Access for SQL Server Databases.
• Generated reports monitoring the data entry in databases.
• Indexed acrobat images using SQL Server DTS packages.

Confidential, Nashville, TN

Computer Programmer

Responsibilities:

• Developed Visual Fox Pro Applications.
• Assist Systems Analyst in a Creating Visual Fox Pro Databases.
• Queried the Visual Fox Pro database for employment and unemployment stats.
• Wrote programs in Visual Fox Pro to retrieve data and increase the efficiency of data processing.