We provide IT Staff Augmentation Services!

Senior Developer / Senior Bi Developer Resume

SUMMARY

  • 1 year of Snowflake Developer Experience with 15 years of MSSQL server Consultant/DataArchitect/Developer experience in HealthCare, Financial, Manufacturing & Gaming domains.
  • In - Depth understanding of Snowflake Cloud technology, snowflake Multi-cluster and credit Usage
  • Experience in Virtual Warehouse, Performance tuning Snow sql queries
  • Good Knowledge and Hands on experience on Data Migration of SQL & Netezza Database Objects to Snowflake and Worked on extracting the data from various source systems like DB2 to Snowflake & Transforming data as per Business requirements (ELT)
  • Experience in loading the on-premise SQL & Netezza data to Azure Blob Storage using Azure Data Factory and then to snowflake using, Snow sql
  • Experience in Building snow pipe and Data sharing in Snowflake.
  • Experience in using snowflake clone and Time Travel.
  • Experienced in extracting streaming JSON data, flattening, performing data profiling and transforming JSON to Data-mart as required for the business reporting using the snowflake sql.
  • Very good exposure and rich experience in ETL tools like Alteryx, Matillion & SSIS
  • ETL-SSIS-BI Data Integration/Modeling Specialist.
  • Strengths in stored procedures, OLTP, performance tuning and high volume batch-processing techniques. Development and maintenance experience of complex T-SQL code stored procedures for implementing thousands of business rules and workflow processing. Proven record in large size millions of records per batch and Terabyte DB sizes online batch processing OLTP development and using best performance tuning techniques in a multi-server, multi-product, high latency, real time and batch environments.
  • Unique experience in re-architecting existing databases for performance and scalability.
  • Proficient in using SQL Agent, DTS & DTSX Packages and BCP, Meta Data, Disaster Recovery, TSQL, DTS, SSIS, SSDT, performance monitoring and tuning.
  • Experience on Report Development through POWER BI & Tableau
  • Good work experience with dashboard objects like Tiled and Floating and dashboard layout and worked on creating Actions like Filter, Highlight and URL.
  • Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Good work experience with dashboard objects like Tiled and Floating and dashboard layout and worked on creating Actions like Filter, Highlight and URL.
  • Solid experience interfacing with business users with respect to analyzing business requirements and translating those needs into functional specifications.
  • Possesses effective interpersonal communication and organizational skills.
  • Self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working

TECHNICAL SKILLS

Database: Snow SQL, MS SQL Server

ETL Tools: Alteryx, Matillion & SSIS

Languages Scripts: Classic ASP, JavaScript, CSS, HTML, XML, MS

IDEs: MS Visual Studio VS 2012, SQL Server Business Intelligence Studio, SQL Server Management Studio SSMS

Data Analysis: R, RStudio

Tools: SSMA Data migration Tool, SQL LiteSpeed

Project Management: MS Project, MS Visio, Work Items and Agile Scrum

Source Control: MS Team Foundation Server TFS, Visual SourceSafe, Git

Methodologies: Waterfall Model, Agile SCRUM

Technologies: MS MQ, Web Services, ADO.NET, BizTalk Server.

Report Tools: PowerBI, SSRS, Tableau 10.2, 2018.1, 2019.2v

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer / Senior BI Developer

Responsibilities:

  • Worked with the Business to understand the Business Model of risk scoring Mechanism
  • Loaded the tables from the DWH to Azure data lake using azure data factory integration run time.
  • Loaded the tables from the azure data lake to azure blob storage for pushing them to snowflake
  • Used Matillion tool blob storage component and loaded the tables to snowflake Stage layer
  • Performed the data quality checks and determined the frequency distribution of the tables loaded to snowflake, validated them with existing DWH
  • Developed the snow sql scripts to load the final core tables from the stage tables
  • Created snow pipe for continuous data load and used copy to bulk load the data.
  • Configured the ADF jobs, SnowSQL jobs triggering in Matillion using python.
  • Handled the audit table loading, email configuration using python on Matillion.
  • Scheduled all the staging, intermediate and final core tables load to snowflake on the Matillion tool
  • Unit tested the tables loaded to snowflake for random days by validating them with the on-premise Oracle DWH tables.
  • Worked on both maximized and auto scale functionality.
  • Design Data Mart Solution for Consolidation of multiple database servers located throughout USA
  • Migration of LMS Data from Netezza to SQL Server
  • Design & Build Business Intelligence and Data Warehouse solutions for casino database and Migration Procedures for Integrating External System data to Project Database in SQL Server
  • Work Closely with System Architect, Business team and Architect Business rules Engine which would validate the monthly incoming Data from multiple client systems like Oracle/IBM Netezza and generate Tableau based report out of it for Marketing purpose.
  • Worked on Tableau/PowerBI based Dashboard development based on user requirements
  • Working on alteryx to Transform and blend data from different sources.

Confidential

Data Architect, Project Lead

Responsibilities:

  • Architect a data mart solution for the consolidation of multiple database servers located throughout the U.S. and Canada. Logical and physical data modeling with Erwin. Data driven ETL designed for optimal performance and recoverability.
  • Worked closely with the System architect, Data Management director, product manager and Architect Business Rules Engine which would validate the Monthly incoming data from multiple clients and format it and store information in single database and provide Analytics team a summary of data and compare with historical trends and mail the team on the analysis
  • Worked as Tableau Developer with expertise in Tableau Reports development for Primark Claim reporting project.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server/Teradata for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Implementing the Business Requirements in Tableau Dashboards. Involved in creating calculated fields, mapping, hierarchies, Action filters in worksheets and dashboards.

Confidential

Project Lead / Database Administrator

Responsibilities:

  • Database Administration of around 1200 MS SQL Servers
  • Installation, configuration and upgrading of Microsoft SQL Server .
  • Establish and maintain sound backup and recovery policies and procedures.
  • Database tuning and performance monitoring.
  • Setup and maintain documentation and standards.
  • Database migration was done for database from Production to Development and vice versa.
  • Performing routine DBA tasks like maintaining Database Space Utilization and troubleshooting the DB and solving the Incidents.
  • Data file addition and Migration of database from one disk to another.
  • Planning and implementing disaster recovery procedures to ensure minimal downtime and data loss
  • Implementing and administering various Database mirroring, Clustering, Replication and Log shipping environments.

Environment: MS Sql Servers 2012/2008r2, Windows Server 2008 SP2 Enterprise/Standard

Hire Now