We provide IT Staff Augmentation Services!

Senior Principal Consultant, Senior Sql/database/etl/bi Developer Resume

0/5 (Submit Your Rating)

Headstrong, NY

Hire Now

SUMMARY:

  • Seasoned IT Professional with extensive experience in Data Architecture, Data Modeling, System Analysis, Data integration, Data Warehousing, Master Data Management, ETL and backend Database Design & development and Performance Tuning and Query Optimization.
  • Implemented several Data Warehousing solutions of various complexities from ground up. Architected several Data Models for data warehouse, reporting and operational/ transactional applications. Developed backend SQL processes for Datawarehouse /BI implementations, and Client - Server applications capable of handling large volumes of data using Microsoft Technologies.
  • Experienced in various SDLC methodologies including Waterfall and Agile /SCRUM.

TECHNICAL SKILLS:

Databases: SQL Server (OLTP/OLAP), Oracle, Sybase IQ, MS Access, MySQL.

Languages: T-SQL (SQL Server 7-2017), PL/SQL, VB, Excel VBA, C#, VB.NET.

ETL/BI Tools: MSBI (SSIS, SSRS, SSAS), Talend Open Studio (Talend Certified). Snow Flake.

IDE: Visual Studio, (C#, VB.NET) Sybase Central, SQL, SQL Developer.

Operating Systems: Windows, Unix, Linux.

Cloud Technologies: AWS (EC2, RDS, S3), Familiar with Azure Data Factory, Hadoop, Hive.

Other Languages familiar with: Python, Java.

Source Code Management/Automation Tools: TFS, GIT/GitHub, SVN, Control-M, Autosys.

Other Tools: Jira, Service-Now.

PROFESSIONAL EXPERIENCE:

Confidential -Headstrong, NY

Senior Principal Consultant, Senior SQL/Database/ETL/BI Developer

Technologies: SQL Server, SSIS, C#, VB.NET, SSRS, SSAS

Responsibilities:

  • Designed and developed the backend processes for ETL and data integration using SSIS and backend processes using T-SQL Procedures for Journal creation for submission to Peoplesoft.
  • Build configurable rules to accommodate new sources/businesses.
  • Design and build ETL and business logic to calculate Accumulated Depreciation, PWC Data.
  • Integrated Direct Capital and OWB, 2 new acquisitions by CIT into the ARC system by ETL(SSIS) processes/SQL Procedures.
  • Optimized the data load and query performance by implementing database partitioning, compression, index alignment and Partition switching in packages as well as query optimization in T-SQL.
  • Made Enhancements to the Rules Engine to automate the Manual Journals. The Rules Engine creates dynamic SQL based on the Rules Metadata.
  • Analyze new business requirements and come up with design enhancements/updates to accommodate new rules and create new standard or custom rules.

Confidential

Senior Programmer Analyst/Software Engineer

Technologies: SQL Server 2008/2005, SSIS, SSRS, C#, VB.NET, SSAS

Responsibilities:

  • Architected the databases for the operational systems and the data warehouse for reporting.
  • Designed and developed the Database Objects for ETL and the SSIS packages for data import.
  • Designed and developed fully configurable and extensible order import and verification engine capable of receiving orders synchronously, asynchronously, direct from data entry screens and OCR.
  • Designed and developed fully configurable and extensible rules based Order Validation Engine with over 70 business rules.Implemented procedures to verify data quality, de-duplication, data cleansing, merging and updating of HCP records from various data sources to create a Master Data Source.
  • Implemented procedures to extract marketing lists from the Master Database based on client provided criteria using SSIS/SQL Procedures.
  • Designed and developed configurable and customizable business rules engine that validated each HCP and ascertained their eligibility for receive marketing information and samples using T-SQL Stored procedures.
  • Implemented processes to perform address cleansing, CASS standardization, delivery Point Validation and other USPS processes.

Confidential

Application Developer

Technologies: SQL Server 7 & 2008, SSIS, SSRS, Sybase IQ, VB, VB.NET, Excel VBA, C++, DTS, Crystal Reports.Client: Alliance Bernstein, New York, NY Alliance Bernstein is a global Asset Management Firm providing solution-based diversified investment management to Institutional Investors.

Responsibilities:

  • Analyze the data structures, build data models and mapping and build the database Objects for data warehouse.
  • Design and development of SSIS packages/stored procedures for ETL for core business functionality.

Confidential, Stamford, CT

Responsibilities:

  • Maintained EMATS Database System including ongoing development (Stored Procedures, Triggers, Performance Tuning, Indexing, and Merge Replication) and maintain all EMATS Interfaces and their ongoing development. Support Fixed Income Research team and the trading/sales. ng Excel VBA.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship