Vishal Sinha Email & Phone Number

Washington, Dc, Us

Remote

Worked at US Department of the Interior (DOI) through CGI Federal, Inc.- Work as a Functional SME to gather requirements for Datawarehouse/ reporting application using Snowflake- Setup code repository and implement CI/CD pipeline to maintain and deploy code- Interface with Salesforce data and implment solution using MuleSoft

Reston, Virginia, United States

Worked at US Department of the Interior (DOI) through Allied Technologies (GenTech Associates)- Provide part time assistance as Chief Architect on an Agile Development Project supporting an Acquisition Workload and Data Application. - Provide guidance to modernize architectural framework for database driven applications.

Arlington, Virginia, United States

Lead a high-performance project team as they build a cloud-based data lake architecture that is efficient, flexible, and scalable and will allow the incremental delivery of analytics dashboards for the client. Initialize and facilitate engagements with various stakeholders and relevant system owners to navigate across system dependencies and prepare for implementation. Facilitate Tableau Server migration while configuring the system to ensure the client’s cyber security and network guidelines are met.

Washington D.C. Metro Area

Support Project Manager by leading client meetings, Solution discussions and provide my client with detailedTechnology/Solution expertise- Solution leader for my area of expertise within the company for various clients/projects- Build rapport with clients; understand client problems and translate them into a solution that will enable themto achieve their business goals- Support Delivery teams in developing solution training plans- Be responsible for the development of a repeatable offering to include artifacts and collateral for proposals andwhite papers- Lead proposal efforts to include writing RFI response and support in business development opportunities thatrelated to my subject matterTechnical Director, USDA – CTIS Modernization ProjectTo support USDA's initiative to modernized Commodity Treatment Information System (CTIS) that can tracktreatments on commodities and analyze treatment data to determine if commodities have met import/exporttreatment protocols, APHIS PPQ engaged TeraThink to develop and deploy a modernized CTIS system using an Agileapproach.- Solution leader involved with architecture and design of data-driven modern application- Responsible for the design, architecture, and development of database drive applications using MicrosoftAzure SQL- Create ETL packages using MuleSoft to import data from various cloud databases, including Salesforce- Support Project Manager by leading client meetings; solution discussions; and provide client with detailedtechnology/solution expertise- Develop reporting solution using TableauData Lead, USCIS POC- Architect and develop solution to load and transform third party and other external data in to database usedby the application and ElasticSearch solution- Develop database deployment process using Liquibase, Gradle, and Maven- Lead database development team

Washington D.C

Senior Data Architect for The Rock Creek Group

Bethesda, Md

Worked at US Consumer Product Safety Commission through TeraThink Corporation (now CGI, Inc.)- Responsible for the design, architecture, and development applications using SQL 2008R2 and SQL 2012- Upgrade existing MDS installation to SQL 2012 from SQL 2008R2. This involved re-architecting the database in MDS2012 and re-creating related ETL packages using SSIS and Microsoft SQL Server Data Tools

Bethesda, Md

Worked at HMSHost through Centennial Technologies. HMSHost is the world’s largest provider of food, beverage and retail services for travelers. • Responsible for the design, architecture, and development of a high volume throughput data warehouse system (10 TB)• Worked in conjunction with other business groups to understand functionality, scalability, performance, security and integration requirements and translate these requirements into the functional system• Was involved in Data discovery process to understand business needs that helped translate business strategies and requirements in to database related solutions. This will play a critical role in Advanced Analytics for trend analysis and projections• Created logical/physical design for data warehouse, ETL processes, and SQL development framework• Design hardware configuration using SQL 2012 Fast Track Data Warehouse Framework• Setup multi-node, multi-site SQL 2012 Failover Clustering with SQL 2012 AlwaysOn technologies• Generate database model using ERWin r9.5• Architect Operational Data Source (ODS) databases involving multiple ETL packages and SSIS Jobs to import data from multiple sources• Data Integration from multiple sources using complex SSIS packages to extract, transform, and load data in to the data warehouse• Metadata Management using Master Data Services and Data Governance processes to ensure system-wide accuracy and consistency• Setup source control using MS Team Foundation Server (TFS)• Optimize database performance and performance tuning of both the RDBMS as well as the underlying infrastructure and implemented performance tuning recommendations that improved system performance• Also architect OLTP database system that formed the supports online food and beverage ordering system at retail locations• Upgrade legacy data warehouse systems (SQL 2000 and SQL 2005) up to SQL 2012 using SQL 2012 Fast Track Data Warehouse Framework

Washington D.C. Metro Area

TMA Resources supports member-centric organizations as they strive to establish, strengthen, and grow mutually beneficial relationships for their members across barriers of time and geography.• Perform various roles for TMA Resources including Technology Evangelist, Database Architect, and Lead Database Administrator • As a technology evangelist, I help to set the direction for the product development team related to product upgrade path and technology suite selection• Mentor and train team members and clients on topics ranging from Query Performance Tuning to New Features in SQL 2012, etc.• Assist Sales team during the sales process by leading technical sales demos and prospect orientation programs• As a database architect, I design and implement enterprise data standards and software architecture across the organization• Liaison with clients, and product design teams to understand their requirements and then translate the business requirements to technical design models• Create and maintain ER Diagrams for the database system using Embarcadero ER/Studio• Architect Operational Data Source (ODS) databases involving multiple ETL packages and SSIS Jobs to import data from multiple sources• Design data warehouse system models and create MDX queries• As a lead database administrator, I assist in resolving critical production performance issues that need immediate attention and those that are causing the enterprise software to come to a standstill• Have successfully performance tuned database performance bottlenecks to that have improved performance exponentially (10X to over 100X improvements)

Baltimore, Maryland

Constellation Energy, headquartered in Baltimore, Maryland, USA, generates, trades, supplies, and distributes energy. The company operates over 35 power plants in 11 states (mainly Maryland, Pennsylvania, New York, West Virginia, and California) under its operating company Constellation Commodities Group and/or Constellation Generation Group. Constellation Energy is a Fortune 500 company, is one of the top electricity producers.• Upgrade all database servers in Production environment to SQL2005 from previous versions (SQL 7, SQL 2000)• Many of these database servers were in-place upgrades that had to be accomplished with minimal downtime• Monitor production database systems and SQL clusters and ensure 99.99% uptime and system availability• Create and maintain reports using SQL Server Reporting Services

Washington D.C. Metro Area

GridPoint, Inc., an established leader in smart grid software, enables utilities to easily manage the transformation to a Smart Grid.• Maintains and performance tune MS SQL (2005, 2008), PostgreSQL, and mySQL Databases, Stored Procedures, Tables, Indexes• Manages multiple Transaction Replication and SQL Cluster instances• Database Capacity Planning, Hardware configuration, System Architecture• Create and maintain ETL packages using SSIS for Operational Data Source (ODS) databases• Create and maintain reports using SQL Server Reporting Services• Install, configure and manage corporate-wide BackupExec (12.5) solution• Supervises team of DBA and SQL developers• Effectively supports in-house applications and solutions on various environments (QA, Stage, and Production) – IIS, DotNet, GlassFish, Java• Manages operations within established guidelines and oversees budget for department • Prod Ops lead in supporting applications and systems• Works closely with Configuration Management team and responsible for successful upgrade of multiple Stage and Production environments with new release of Software and Database code• Played a key role in Compliance related activities• Database Architecture, capacity planning, ETL package design, Reporting Services• SQL coding – DDL, DML, Stored Procedures, Triggers, Views, Functions, etc.

Reston, Virginia

Independent Contractor at Us Department of Justice through IMC Corporation.• Performance tune production databases for IMC’s client – Department of Justice. This database supports a multi-location, multi-user application system and optimum performance is very critical for DOJ related activities. I was brought in to resolve performance issues experienced by the system. I was able to improve performance of the database by over 80%

Washington D.C. Metro Area

Travelex Global Business Payments (now Western Union Business Solutions) offers a simple and cost efficient way for businesses to make and receive international payments, foreign currency wires, EFTs and drafts. Using their easy-to-use online payment service or directly over the phone, you can purchase foreign currency and initiate payments in over 130 currencies.• Maintained 6 Node SQL2000 Geo Cluster; Performance Tune Databases, Stored Procedures, Tables and Indexes• Managed and maintained multiple VLDBs (Terabyte) and Database Clusters and Replication Instances• Played a critical role in Database Capacity Planning, Hardware configuration, System Architecture• Developed ETL packages using SSIS• Create and maintain reports using SQL Server Reporting Services• Instrumental in the design of Global Data Warehouse system• Successfully led SOX compliance efforts• Upgraded Stage and Production environments with new release of in-house Applications

Washington D.C. Metro Area

Sage Payment Solutions has been making electronic payments easy for businesses for over 20 years. Our payment processing and business services are currently being provided to more than 140,000 companies, who are delivering improved customer experiences by accepting multiple forms of payment, including credit and debit cards, electronic checks, gift cards, and automatic recurring payments.• Started as Database Administrator (1 Year) moved up to Senior Database Administrator (3 Years) then to Director, Data Services (2 Years).• Played an active role in Project design and development, Project timeline, resource estimation/allocation• Established Compliance standards and achieved CISSP and SOX certification• Re-designed and developed production databases in SQL 2005• Managed multiple VLDBs (Terabyte)• Responsible for Database Capacity Planning, Hardware configuration, System Architecture and database design• Converted all DTS packages to SQL 2005 using SSIS• Performed budget analysis and management for department• Created database systems that reduced process time from several days to a few hours• Integrated multiple database systems into one common point of access

Washington D.C. Metro Area

• Held various roles: E-Commerce Solutions Developer, Network Engineer, Database Developer/ Administrator and CRM consultant for non-profit companies, associations and for-profit commercial corporations.• Managed database development and administration, maintenance and troubleshooting• Imported legacy customer data from various sources to database using DTS/ other ETL tools• Performed network engineering, maintenance, upgrade, troubleshooting of routers, switches and hubs• Performed internal database systems architecture• Managed Firewall• CRM – responsible for installation/configuration

Mba, It, Marketing

Be, Mechanical Engineering

Icse, Icse