Uploaded File
add photo
George
gadjaidoo@gmail.com
lyrixg@gmail.com
301-452-2385
Finksburg, MD 21048
Sr. Software Engineer - Precision Medicine
18 years experience W2
0
Recommendations
Average rating
15
Profile views
Summary

  • Over 14 years of experience in database analysis, database design and development in SQL 2014/2012/2008/2005/2000 in production and support environment
  • Expert in SAS
  • Expert in Shell Scripting Linux, Unix systems
  • Expert in PowerShell
  • Expert in Automation Solutions
  • Experience in High Availability / Disaster Recovery (HADR) solutions Failover Clusters AlwaysOn Availability Groups, REPLICATION, Log Shipping Mirroring.
  • Experienced in Upgrade / Migration of MS SQL SERVER 2008 TO MS SQL SERVER 2008 R2, FROM SQL SERVER 2012 SQL SERVER 2014.
  • Experience working WITH application team implemented databases as per the specification FROM LOB applications.
  • Experienced in installation, configuration, maintenance optimization of SQL SERVER HADR solutions.
  • Experienced in BACKUP Recovery, Query Optimization Security.
  • Experienced in monitoring the health performance of SQL servers as well as home grown applications using SQL SERVER native tools several other third party solutions.
  • Adept at T
  • SQL, stored procedures, tables, indexes, VIEWS, functions, triggers.
  • Expert in creating DTS packages TO utilize SSIS functionalities
  • Strong knowledge of Relational Database Management Systems (RDBMS) concept
  • Experienced in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS)
  • Worked on activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS. Change Data Capture, Slowly Changing Dimensions, etc.
  • Experienced in data import/export, data migration between homogenous system using Data Transformation Service (DTS) Packages, Bulk Copy command (BCP) and Bulk Insert.
  • Experienced in Data Warehouse/Data Mart methodologies Kimball vs. Inmon
  • Experienced in XML data exchange XBRL
  • Experienced in XML to SQL Server data base using SSIS
  • Experienced in XML messaging
  • Experienced in XML Shred and Writing using XQuery, XPath
  • Experienced in SQL service broker
  • Experienced in Advance T-SQL querying programming, string manipulation, dataset manipulation like Dynamic Pivot, UNPIVOT, Cross Apply, CTE, Cursors, while loops, Etc.
  • Experienced in Advance analytic functions windowing functions in SQL Server (LEAD, LAG, PERCENTILE_CONT, ROW_NUM)
  • Expert IN using DTA / Extended Events / PerfMon / SQL Profiler / Scripts and other third party tools to resolve bottlenecks, dead locks

Experience
Banking/Financial
Jun 2017 - present
Washington, DC
(SEC) The mission of the U.S. Securities and Exchange Commission is to protect investors, maintain fair, orderly, and efficient markets, and facilitate capital formation. Senior Consultant for XML/XBRL SQL Database Developer/ETL Developer Responsible for supporting the complete SDLC for IDAP. IDAP is a web application for production support of XBRL filing information, Audit Analytics ("AA") and other data sets. Responsible for the Data extract from WRDS by developing SAS programs Responsible for the End to End ETL process of SAS data to SQL Server by developing SAS Programs and Shell Scripts to facilitate automation by initiating the process from a Linux Command Line. Support translation of business requirements and rules to technical system design. Responsible for Developing Complex Analytical Views in SQL Server on the back-end to Support Java Based APIs on the front-end Maintain the Enterprise Data Warehouse and DataMarts for Office of Structured Data (OSD) Design ETL process and CreateETL jobs usingUNIX shell scripts (BASH), Python, CMD line, Talend and SSIS Implementation of text file transformations using SED, AWK, GREP and other complex Shell Commands Develop T-SQL Code to fulfill Business and Technical requirements for new Initiatives Develop complex stored procedures and functions to aid the overall workflow efficiency and data integrity. Analyze complex legacy code to improve and or make corrections for consistency and accuracy. Build complex formulas by code to support business financial reporting Develop and execute complex python and shell scripts, install and update real-time and continuous updates to Arelle and Arelle plugins, ongoing updates for Cygwin Develop DTS, SSIS, BCP to import & export data from flat files, excel to MS SQL Server database. Analyze and perform data mapping which involves identifying source data field, identifying target entities and their lookup table ID's, and translation rules. Develop SQL Code to support Tableau Report Development Migrate existing legacy reports into Tableau while building new reports from our formal data warehouse initiative Developed Tableau semantic layer through reusable data sources using Tableau 9.3 platform Migrate existing legacy reports into Tableau while building new reports from our formal data warehouse initiative Develop and deploy reports using SQL Server Reporting Services Create ad-hoc reports to users in Tableau by connecting various data sources. Generate Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau 9.3 Publish Workbooks by creating user filters so that only appropriate teams can view it. Embedded Tableau views in to SharePoint and analyzed the source data and handled efficiently by modifyingthe data types. Used excel sheet, flat files, CSV files, SQL Server views to generate Tableau ad-hoc reports. Generated tableau dashboards with combination charts for clear understanding. Develop DTS, SSIS, BCP to import & export data from flat files, excel to MS SQL Server database. Involved in all aspects of front end design. Code reviews and performance tuning. Build and deploy database scripts and packages from Development TestingStaging Production. Installs and update database drivers for databases (SQL server, Netezza, Postgres, Oracle) Highly proficient with Eclipse, Oracle SQL Developer, Cygwin Bash, Fujitsu InterstageXWand, MobaXterm, Postgres, SQL Server, Python IDE and, OxygenXML, and TortoiseSVN tools. US Department of the Treasury
Data Integrity Data Mapping Business Requirements Data Warehousing Java Linux Microsoft Excel MS SharePoint SDLC SQL System Design SSIS XML ETL Developer
Remove Skill
SQL Database Developer/ETL Developer
Banking/Financial
Jul 2016 - May 2017
Washington, DC
The OCC charters, regulates, and supervises all national banks and federal savings associations as well as federal branches and agencies of foreign banks. The OCC is an independent bureau of the U.S. Department of the Treasury.
ETL ETL Developer SQL
Remove Skill
(Part-Time Consultant)
Information Technology
Jan 2016 - Jul 2016
The United States Department of Energy DOE is a Cabinet-level department of the United States Government concerned with the United States ' policies regarding energy and safety in handling nuclear material and whose mission is to advance energy technology and promote related innovation in the United States.
No skills were added
Remove Skill
SQL Database Developer
Information Technology
Oct 2014 - Jan 2016
Ellicott City, MD
The Intersocietal Accreditation Commission (IAC) provides accreditation programs for vascular testing, echocardiography, nuclear/PET, MRI, diagnostic CT, dental CT, carotid stenting and vein treatment and management. The IAC programs for accreditation are dedicated to ensuring quality patient care and promoting health care and all support one common mission: Improving health care through accreditation.
SQL
Remove Skill
(Part-Time Consultant)
Information Technology
Apr 2015 - Jun 2015
Columbia, MD
No skills were added
Remove Skill
Banking/Financial
Feb 2011 - Oct 2014
Rockville, MD
an RR Donnelley Company. EDGAR Online is a leader in the business information industry specializing in the extraction, packaging and distribution of public company information contained in SEC filings. Senior XBRL Financial Developer and SQL Developer
  • Developed and deploy reports using SQL Server Reporting Services
  • Create and manage database objects such as stored procedures, functions, cursors, views and tables
  • Supported software developers with their database needs such as T-SQL queries and stored procedures.
  • Performed backup and restoration of databases
  • Developed SSIS packages to extract, transform and load data from various sources into databases
  • Identified and troubleshot database issues such as data types, data sizes, duplicates
  • Create a customized taxonomy document using a client's recent filing with the SEC as well as the US GAAP Taxonomy.
  • Ensure on time delivery of final approved XBRL (eXtensible Business Reporting Language) financial statements for customer.
  • Apply knowledge of current SEC requirements for evolving XBRL compliance requirements and address client questions related to their specific compliance requirements.
  • Validate taxonomy using Xcelerate software are Review tools like Tagfinder.
  • Managed the workflow process from Development to Quality Control to Final Review and Delivery to Client to subsequent Filing.
  • Worked in collaboration with Front End Developers to correct and trouble shoot any rendering issues.
  • Managed work flow processes off
  • shore team in India for the delivery of final XBRL packages.
  • Key Individual in the training of off shore teams in India and SriLanka.
Database Backups SSIS Stored Procedure
Remove Skill
Information Technology
May 2008 - Aug 2008
Mclean, VA
Freddie Mac's mission is to provide liquidity, stability and affordability to the housing market. Operational Risk Management Reporting Engineer
  • Performed key controls testing in compliance with Sarbanes Oxley (404,302) that resulted in successful compliance and dramatically reduced operational riskin the Multi
  • Family business segment.
  • Documentedaspects of the control environment for the various business segments (Multi Family, Single Family), providing senior management and the Board with an independent assessment of operational risk.
Risk Management
Remove Skill
Banking/Financial
Oct 2003 - Oct 2006
Gaithersburg, MD
Bank
No skills were added
Remove Skill
Banking/Financial
Oct 2003 - Oct 2003
  • Analyzed financial information including operating statements and net worth statements to determine appropriate loan size, terms, and pricing
  • Reviewed various reports including appraisals, environmental documentation, and engineering reports to determine compliance with investor requirements.
  • Performed Data Extraction and Analysis UtilizedSQL Server applications/tools to query portfolio data and extract data as needed for reporting analysis/development or for customer delivery.
  • Analyzed data for reporting development as well as trend identification, event impact analysis, process measurement/improvement, and observation/summarization for senior management attention.
  • Conducted research and analysis and examined risk elements of portfolio or public data to present trends.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Accounting
University of Maryland 2009
Information Systems/Accounting
Montgomery College 2002
Certifications
Microsoft Certified Professional-Database
EDX (MOOC) - Querying with Transact-SQL Certified
COMPUTER EDUCATION
Skills
SSIS
2021
7
SQL
2021
5
ETL Developer
2021
4
Business Requirements
2021
3
Data Integrity
2021
3
Data Mapping
2021
3
Data Warehousing
2021
3
Database Backups
2014
3
Java
2021
3
Linux
2021
3
Microsoft Excel
2021
3
MS SharePoint
2021
3
SDLC
2021
3
Stored Procedure
2014
3
System Design
2021
3
XML
2021
3
Agile Methodology
0
1
Data Marts
0
1
Data Migration
0
1
Data Mining
0
1
Data Modeling
0
1
Database Design
0
1
Database Management
0
1
Erwin Data Modler
0
1
ETL
2017
1
Hadoop
0
1
JSON
0
1
Oracle
0
1
Risk Management
2008
1
SSRS
0
1
Waterfall
0
1