We provide IT Staff Augmentation Services!

It Specialist And Etl Developer Resume

Washington, DC

SUMMARY:

  • Proven Data Operations and System Integration Engineer: Big Data, Cloud Architecture, Design, Enterprise Solutions, SQL, Web Development, SDLC, Agile, Scrum
  • Self - directed and driven database manager with a comprehensive background leading process automation, software integration and cross-functional teams to ensure success and achieve goals.
  • Known as an innovative thinker with strong big data, cloud computing and enterprise solutions acumen.
  • Demonstrated success developing and seamlessly executing plans in complex organizational structures.
  • Highly organized, creative problem solver who excels at guiding teams through complex projects by identifying goals and advising on implications.
  • Expertise includes developing and managing organization wide technology overhauls, system optimization and advising C-level executives.

EXPERTISE IN:

  • Big Data
  • Cloud Architecture
  • Enterprise Solutions
  • Product Strategy, Design
  • SQL Infrastructure
  • Database Management
  • Data Capture Modeling
  • SAS
  • Project Management(Agile,Scrum)
  • MCDBA, MCAD Certifications
  • System Design, Development
  • ITIL Process Improvement
  • Program Management
  • Data Development
  • Open Source Technology
  • Engineering Team Leadership

TECHNICAL SKILLS:

PROGRAMMING LANGUAGES: Transact SQL, C++, JavaScript, ASP, ASP.NET, HTML, SQL, VB.NET, Dynamic HTML, CSS, DTS, SSIS, Visio, And Visual Studio Bash, Python, Base SAS, Java, Postgres, Jira, Confluence, Tableau, JSON, Hive, Spark, Pig, Fortran, tAssertCatcher, tContextDump, tDie, tFileOutputDelimited, tHDFSConnection, tHDFSInput, tHDFSProperties, tJava, tJavaRow, tLibraryLoad, tLogCatcher, tSplunkEventCollector, tTableauExtractOutput, tJiraOutput, tJiraInput, tFileOutputParquet, tHdfsList.

PLATFORMS:

Microsoft: SQL SERVER, SSIS, SSAS, SSRS (2008R2 - 2014)

Talend: Talend Studio Big Data Enterprise, Talend Data Quality Enterprise, Talend Administration Center, Activity Monitoring Console, Talend Execution Server(Remote Job Server) (5.5,5.6,6.01, 6.2, 6.4.1)

SAS: SAS Platform Administration, Enterprise Data Integration, SAS Enterprise Guide (9.3, 9.4)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

IT Specialist and ETL Developer

Responsibilities:

  • Installed and configured Talend Studio for Big Data E nterprise accreditation in Linux and Windows environments 5.5,5.6,6.01, 6.2 in Windows 2012 and Redhat Linux 6 (RHEL 6).
  • Integrated Talend Studio for Big Data Enterprise with Hadoop infrastructure.
  • Stood up Talend job execution servers in Linux and Windows environments.
  • Configured and developed job design patterns using Talend Data Quality.
  • Orchestrated job design flow by following environmental best practices.
  • Administered SAS Platform.
  • Created ETL Automation processes for large datasets using SAS Data Integration Studio SQL Server 2012.
  • Created ETL automation and data profiling using SSIS 2012.
  • Tuned and optimized SQL Server 2012.
  • Automated data feeds using shell scripting and developed ad hoc reporting using SAS ODS.
  • Standardized metadata capture of integration feeds using data driven approach.
  • Created base SAS code library framework for SAS DI Studio to standardize automation practices. between systems so that all developers could standardize ad hoc ETL code.
  • Implemented a systematic data driven solution for SAS DI Studio and Talend by utilizing and standardizing metadata.
  • Let the implementation of metadata audit database for SAS ran feeds and reporting.
  • Applied mobile reporting solution to I-phone users by following researching and applying the following white paper to report on 81 feeds.
  • Researched and implemented Kerberos ticketing framework for Talend Data Integration jobs in Windows and Linux environments.
  • Collaborated and worked with to integrate Splunk and Talend to capture events.
  • Leveraged SnagIt 12 to screencast how-to documentation to publish to Confluence.
  • Created video documentation and tutorials for business analyst and organizational training material.
  • Setup activity monitoring console log capture, statistics capture, and flowmeter catcher capabilities within Talend Open Studio for Big data into Postgres database.
  • Configured, tested, and implemented the Data Quality Portal and Data Stewardship console.
  • Installed configured and deployed the Nexus Artifact Repository as Part of the Talend Studio.
  • Implemented dynamic data driven integration loads by using implicit context as integration points between various enterprise applications using Talend.
  • Brainstormed with stakeholders and peers using open source mind mapping software.
  • Standardized integration jobs before contractor roll off decreasing from a team of eight to three while workload increased.
  • Loaded data from various origins and formats into Hive database using Talend integration software.

Confidential, Washington, DC

Lead Integration Engineer

Responsibilities:

  • Led ETL development supporting Phase I stand-up of Confidential ’s data services.
  • Analyzed, inspected, loaded and manipulated data sets.
  • Audited and tracked all processes performed for various ETL .
  • Set up SAS Data Integration for administration and also to ingest data sets into a SQL 2008 R2 Server backend.
  • Created and presented solutions using PowerPoint slide decks to publish to Confluence and SharePoint.

Confidential, Washington, DC

Lead Database Administrator

Responsibilities:

  • Implemented high availability solutions using Database mirroring in SQL Server 2008R2.
  • Maintained, optimized and tuned 1+ terabyte database(s).
  • Reconfigured database backup and restored design plan standards to Microsoft's best practices.
  • Centralized ETL processes using SSIS from ad hoc distributed processes.
  • Created metadata framework to capture data quality information.
  • Deployed SQL Server stored procedures for data quality checks.

Confidential, Washington, DC

Data Operations Engineer

Responsibilities:

  • Automated data ingestion of CMS data feeds using Network Automate 6 software, SSIS and SSRS.
  • Created technical documents specifying best practices, standards, guidelines for operational activities and processes.
  • Implemented security audit logging using SSIS, SSMS and SSIS expressions.
  • Led design of Data Mart Star Schema for CMS (Centers for Medicare and Medicaid Services) reporting.
  • Triaged, optimized, and debugged very large incremental loads within data warehouse.

Confidential, Washington, DC

Administrator, SQL Database

Responsibilities:

  • Administered 32 SQL Server 2000/2005 boxes.
  • Developed data conversion and migration routines using SQL server utilities in various environments.
  • Managed data and data distribution in all production and non-production databases and replication servers.
  • Installed, configured and upgraded from MS SQL Server 2000 to MS SQL Server 2005 databases.
  • Converted DTS SQL Server 2000 to SSIS packages SQL Server 2005.
  • Implemented high availability solutions such as Log Shipping, Transactional Replication and Double Take.
  • Created Standard Operating Procedures for Database administration, development and data process flow.
  • Implemented disaster recovery solutions for SQL Server 2000 and SQL Server 2005 using transaction replication, log shipping and also third-party tools such as Double Take.

Confidential, Washington, DC

Programmer Analyst

Responsibilities:

  • Installed scheduling software on client user base and created technical documentation manuals for proper usage.
  • Performed testing, debugging, and daily backup procedures for scheduling software database in SQL Server 2000 environment.
  • Delivered training to the ( Confidential Police on software usage and best practices.
  • Implemented backup and system maintenance for SQL Server 2000 applications running on Windows NT/2000 platforms.
  • Created PowerPoint decks for rollout of ad hoc scheduling software.
  • Orchestrated and scheduled self correction SQL Server agent tasks.

Engineer

Confidential

Responsibilities:

  • Supported, scripted and debugged MH-53 flight simulator using C and FORTRAN in UNIX environment.
  • Created UI to retrieve data from Access database using ASP.
  • Revamped intranet applications for Naval Air Warfare Center using ASP, IIS 5.0, and Access 2000 for back end from Cold Fusion.
  • Created form user interface Dashboard using .NET 1.1 to mine Naval Air Warfare data for users.

Web Developer

Confidential

Responsibilities:

  • Designed and deployed data driven web pages for Department of Public Health and the Health Alert Network using CSS, ASP, HTML and JavaScript.
  • Assisted in development of local and state systems for rapid receipt and broadcast of urgent health alerts by proposing and implementing user friendly web UI.
  • Created templates and graphics using Paint Shop Pro v.6 for mouse overs and website navigation.

Confidential, New Milford, CT

Web Developer

Responsibilities:

  • Developed and updated intranet and internet sites using FrontPage 98, Cold Fusion and Lotus Notes.
  • Expanded use of internet scripting languages using dynamic html, css and cfm.

Hire Now