Sql Server Management Systems

Name: Janna Baah

Address: Triangle VA *****

Contact Info: *****.****@*****.*** /703-***-****

Position@Firm: Sr. Database Architect @Leidos

Summary: Information Systems Professional with 25 years of diverse technical experience focusing on providing high quality IT solutions in both commercial and Federal government environments. Expert in Oracle RDMS, SQL Server, PostgreSQL, Redshift Database management systems on premise and the cloud environments - AWS, Azure cloud platforms. Possesses solid data mining and analytical skills, proficient in Data Warehousing, building of data lakes with structured, semi-structured, and non-structured data. Experienced ETL designer, developer and maintainer of large-scale data pipelines.

Key Technical Capability Skills and Experience

5 years of experience with Cloud migrations from on premise data center to AWS Oracle RDS, PostgreSQL, Redshift. Expert in setting up and configuring EC2 instances, S3, migration of legacy source code to glue, lambda, pyspark, python pandas, Athena, Iceberg, security and roles management, Starburst data lake.

Experience with development of the highly effective ETL pipelines in AWS cloud environments using EC2, S3, glue, lambda, spark, python, Athena, Iceberg, Oracle, and PostgreSQL databases.

5 years of experience working on MS cloud services on Azure platform. Expert in SQL Server, PostgreSQL data management systems, Business Intelligence (BI)/data analytics with Tableau, Tableau Server, Tableau publisher.

Experience with SQL Server on Azure platform, set up and tuning of PostgreSQL cluster, configuring database templates, creating service and user accounts and roles, provisioning alert logs for performance and security monitoring. Experience with Azure Analytical and Reporting services.

25 years of IT experience with demonstrated hands-on expertise in Data modeling techniques including dimensional modeling (star schema and snowflake schema) in Oracle and MS SQL Server environments.

Experience with design of data warehouse and RDBMS, logical/physical data modeling, including dimensional modeling.

25 years of IT experience with demonstrated hands-on expertise in Development of clear and concise technical documentations including data models, architecture and data workflow diagrams, design documents, and deployment documents.

Proven experience with developing, tuning, and debugging code, stored procedures, functions, and SQL packages. Extensive experience in logical, physical Data Modeling, and Database Design.

10 years of experience in Big Data Analytics, Data Cleansing, Data Retention and Data Security implementations.

Proven experience with Data profiling and assess the quality of data by utilizing advanced tools and techniques to analyze data quality characteristics such as completeness, accuracy, consistency, and timeliness.

25 years of experience in providing software Quality Assurance, developing and executing Software Test plans, and Use Cases. Data quality verification and application functional testing and verification.

Proven experience in providing high quality Testing and Verification. Ability to skillfully execute Test cases using Application tools and custom build scripts. Ability to develop High-Quality Test Documentation. Familiarity with System Integration, User Acceptance and IV&V testing and verification.

Education:

●M.S., Mathematics, Moscow State University, Russia, 1992.

●B.S., Computer Science, Moscow State University, Russia, 1988.

Selected Experience:

Leidos, Data Architect/Data Integrator July 2022 - current

●Nature of Project: FAA Airline Safety Management Systems for supporting Aircraft Insurance filing submission and maintenance.

●Methodology Employed: SQL Server on premise and in Azure Cloud cluster maintenance and operations – new release installation, versions maintenance, and upgrade to new releases. Database maintenance, security protocols, database backup, and recovery. Integrated services for data ETL between remote databases, Reporting server upgrade, and maintenance, Analysis server upgrade and maintenance. Solution delivery to QA, UAT, Pre-Prod and Production environments.

●Tools Utilized and Supported: Azure Cloud services, Azure Analytical platform, Azure db studio, SSMS, SQL Server Data Tools, SQL Server Analysis Services, SQL Server Integration Services and SQL Server Reporting Services, Tabular Model Editor, DAX Query Builder, GitLab, Bitbucket, TOAD for SQL Server, ER Studio Data Architect.

Major accomplishments on the project are listed below:

●Provided operational support to the SQL server on premise databases Dev, QA, UAT, Pre-Prod, and Production environments on premise and Azure environments.

●Provided technical support in resolving Production issues and in support of ongoing system maintenance.

●Evaluated and implemented data support enhancements resulting in shorter load times, eliminated manual data load processes, and improved data quality and availability.

●Installed and maintained SQL Server Analysis server, developed, and deployed Tabular Data Models in support of the Reporting server upgrade to version 2022.

●Installed and maintained SQL Server Reporting Server 2019, configured the server, deployed, and maintained over 200 reports.

●Installed and maintained SQL Server Data Tools and Integration Services. Configured, maintained, and upgraded ETL jobs accessing remote databases. Provided up-to-date data exchanges for application systems support.

●Developed and maintained SQL server Database related documentation, such as Data Dictionary, Entity Relational Diagram (ERD), System Integration Design documents.

Implemented data cleansing strategies to rectify identified data quality issues and discrepancies.

Investigated and resolved data quality issues in a timely manner, collaborating with relevant stakeholders as needed.

Worked with IT and business teams to address underlying issues and implement corrective actions

Prepared and presented reports on data quality metrics, trends, and issues to management and stakeholders.

●Provided guidance, mentorship, and training to team members to incorporate data practices and standards across our delivered services and technology platforms

Hays (as a sub to IBM), Senior ETL/Data Quality Engineer, SEC Oracle Data Maintenance and Operations, August 2018 - July 2022

WeMed Service Inc. (as a sub to Vencore Labs), Senior Data Modeler, SEC Oracle Data Maintenance and Operations, August 2016 – August 2018)

●Nature of Project: Design, Develop and implement scalable and efficient ETL pipelines for SEC internal and external data sets on Unix/Linux servers, ETL using IBM Netezza (Pure Data) appliance, Oracle database, SQL Server, python scripting for data pipelines, creation of a Tableau server on Windows 2019 for Analytical platform. Perform migration of the datasets from on-premises to AWS cloud platform. Upgrade legacy ETL source code to efficient cloud solutions using glue, lambda, S3, python pandas, pyspark.

●Tools Utilized or Supported: Oracle RDBMS, SQL Developer, SQL Server administration, performance tuning, Bash, Python, Perl, DataStage, ER/Studio, SVN, Jira, XML, Unix/Linux utilities, GitLab, Tableau Reports/Dashboards, Ec2, S3, lambda, pyspark, Athena, Iceberg.

Major accomplishments on the project are listed below:

●Provided operational support in the diverse Oracle/SQL Server Database environment for nearly 130 ETL processes.

●Provided technical support resolving Production issues and ongoing system maintenance.

●Evaluated and implemented data support enhancements resulting in shorter load times, eliminated manual data load processes, and improved data quality and availability.

●Maintained common solutions across multifunctional teams, collaborated with data vendors and SMEs to improve ETL processes and data storage solutions.

●Performed ETL systems evaluation and enhancements in accordance with the installed agile practices, improved SEC’s technical knowledge base by providing well documented technical processes, test plans, backup and recovery procedures.

●Developed and deployed in production databases on the MS SQL Server 2019 using SQL data modeling tools, advanced querying, complex query tuning, stored procedures, and packages. Participated in SQL Server upgrade, and database migration, post migration testing and validation.

●Developed custom reports, and Data Visualizations using Tableau Graphs, Charts, and interactive dashboards. Managed hundreds of data views in Oracle database as sources for Tableau data driven customizations. Used Tableau Desktop for creation of reports, Tableau Server, and Tableau Publish to deploy customizations to the user community for data analysis and data mining.

●Promoted Tableau experience among user community as a leading tool for Business Intelligence (BI), worked on adaptation and expansion of best practices across Tableau platform.

●Modelled database structures in support of the user requirements for system enhancements.

●Updated logical and physical systems’ Data Models in support of the application designs, data quality and data integrity.

● Provided guidance, mentorship, and training to team members to incorporate data practices and standards across our delivered services and technology platforms

Lockheed Martin, Database Administrator, Federal Aviation Administration, May 2010 - July 2016

●Researched business processes and data mining needs. Prototyped and designed database entities and software objects to satisfy business requirements for data integrity and 24X7 availability.

●Developed and tested multiple Oracle 10G/11G based PL/SQL packages containing over 200 stored procedures and functions in support of web applications and reporting queries.

●Used advanced features of Oracle, such as dynamic cursors, XML file exchange, data retrieval and manipulation of the binary objects (LOB), etc.

●Designed and developed Database objects (materialized views/partitioned tables) in support of user reporting environment. Wrote ETL queries/scripted database jobs for data loads and resolved technical issues with ETL/reporting instances/schemas.

●Worked on database and software performance tuning projects, established and/or re-designed tables and indices, rewrote existing slow performing PL/SQL code, and reviewed database server parameters and space allocations to optimize performance.

●Served on the CWP Database support/DBA Counsel. Participated in monthly discussions on database issues and database support needs, provided quality technical expert analysis and opined on database matters involving integrity, performance, security, and data management automation.

Caelum Research Corporation, Senior Oracle Data Warehouse Architect, May 2006 – May 2010

●Researched business processes and data warehousing needs. Designed and prototyped database closely integrated with Production database environment. Designed data flows and supporting processes.

●Designed entities and processes for data warehouses in support of the mission critical management decisions. Designed and created a Business Intelligence environment consisting of over 40 custom reports and data queries.

●Provided database programming technical support, conducted specifications and technical design reviews of software.

●Worked on database and software performance tuning, re-designed tables and indices, rewrote existing slow performing PL/SQL code, adjusting database server parameters and space allocations for performance boost.

●Performed Oracle 9i/10G database and application server migration.

●Performed maintenance and functional upgrades on Oracle Developer 10G Suite, including Oracle Forms and Reports 10G. Worked extensively with libraries, triggers, stored procedures and functions.

Indus Corporation, Senior Software Engineer, October 2000 – May 2006

●Implemented custom Oracle database design during conversion of the Legacy Cobol system to the Oracle 8i relational architecture.

●Participated in enhancements of the Oracle Database and application side entities (Forms, Reports) in versions 8i, and later in version 10G.

●Developed, tested and implemented software releases and patches in accordance with the CMMI best practices and procedures.

Relevant Training: Java, .Net, SQL Server, DataStage, Unix Scripting, Perl, Data Modeling, Data Warehousing, Oracle PL/SQL, SQL Loader, Data Pump, Tableau, Amazon WS Practitioner, Amazon ETL developer, Big Data Analytics, Big Data science, MS Azure database administrator.

Certifications or Special Knowledge and Capabilities:

●Oracle Certified DBA, Oracle 10G, 2004

●International Association of Software Architects (IASA), Member

●Mid-Atlantic Association of Oracle Professionals (MAOP), Member

●Virginia Oracle Users Group (VOUG), Member

Citizenship Status: U.S.

Clearance Level (if applicable): Public Trust (SEC)

Contact this candidate