Sr. Etl Developer Resume
Sandy Spring, GA
SUMMARY
- Extensive years of experience with Business Intelligence, Data Design, Database and Development, SQL Server 2000/ 2008/2012/2014/2016 /2017 , T - SQL, Performance Tuning, Team foundation system TFS 2013, SQL Profiler, Troubleshooting, SSIS SSDT/DTS Package Configuration, Power BI, SSRS, SSAS, SQL development with Oracle 11g, Postman 7.20, WinSCP, Microsoft Azure Storage Explorer, Attunity, Azure DevOps, Toad for Oracle 12.10/12.12 and Data-warehousing.
- Hands on experience in SDLC (Software Development Life Cycle), gathering requirements, design, development, implementation, and testing of projects before moving to production.
- Experiences with T-SQL in constructing Triggers, Sub Queries, Tables, stored Procedures using Global variables, Functions, Replication, Index, Views, User-defined functions, Common table expressions (CTEs) and cursors, User Profiles, Data Dictionaries, and Data Integrity.
- Excellent understanding of Relational Database Systems, Normalization/de- Normalization, logical and physical data modeling used tools like Erwin.
- Strong Knowledge of databases in clustered and non-clustered environments.
- Transformed data from one server to other servers using tools like Bulk insert, Bulk Copy Program (BCP) for OLTP and DSS (Data Mart/Data Warehouse) environment, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Extensively used SSIS Import/Export Wizard for performing the ETL operations.
- Worked in Logical modeling using the Dimensional Modeling techniques. Data modeling, creating star and snowflake schemas in SSAS.
- Proficiency in creating diverse types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
- Expertise in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts, OBIEE, Crystal Reports and Dashboards.
- Extensive experience in performing administrative functions including performance tuning, client/server connectivity, query optimization, memory cache utilization, backup and recovery, indexing, SPIDs and DBCC.
- Expert in automation of packages, Scheduling jobs, error reporting using Alerts, SQL Mail Agent.
- Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and understand business requirements in various domains.
- Experience in creating Technical documents using Confluence and Jira story.
TECHNICAL SKILLS
Operating Systems: WINDOWS 2008/2000/NT Servers, XP, Vista, UNIX and MS-DOS 6.22
RDBMS: MS SQL Server 2000/2005/2008 R 2/2012/2014/2016 , SSDT, Visual Studio 2015/2017, MS Access, OLAP, OLTP, Teradata, My SQL, SQL Developer for oracle, Toad for oracle
Programming languages: T-SQL, Oracle PL/SQL, COBOL, JAVA, C#, Visual Basic, XQuery, Python
ETL Tools: SSBI Development Studio, SSIS, SSRS, SSAS, DTS, DSS, ADF (Azure Data factory) Import/ export wizard, Bulk Insert, BCP, Talend 5.6.1, Redgate, Bitbucket, octopus
Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder 1.0/3.0, POWER BI, OBIEE, QlikView, Cognos, Dashboard, Tableau, Excel
Database Tools: BIDS, Management studio, Visual Studio, Visual Basic, Configuration Manager, SQL Query Analyzer
Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access, Teams
PROFESSIONAL EXPERIENCE
Confidential, Sandy Spring, GA
Sr. ETL Developer
Responsibilities:
- Involved in analyzing, designing, developing, installing, configuring and deploying SQL Server Integration Services.
- Created Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.
- Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.
- Build and deployed multiple SSIS/DTS utility to importing/exporting data between different sources like Flat/Oracle/Access/Excel/XML/SQL as well as big data platform like AWS and Hadoop to different targets (DB/Files).
- Created error and event handling: precedence Constraints, Break Points, check points, Logging, Auditing and creating metadata reports.
- Scheduled and notified the status of the package by creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
- Created configuration files to deploy the SSIS packages across all environments.
- Expert in creating SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Involved in usage of various SSIS components like Script Task, For-loop, For-each loop, Fuzzy lookup, using variables, configurations, parameters, and expressions in SSIS packages.
- Analyzed current Micro strategy reports and created new reports in Power BI.
- Used Azure technologies and security framework;
- Experience managing SQL in Cloud (Azure). Created ADLS Pipeline, datasets and dataflow. Validated and debug the pipeline.
- Deep knowledge and understanding of Azure-based tools and services that support data storage, e.g. Azure SQL, Blob and Table Storage, Cosmos DB, Azure SQL Data Warehouse, Azure Data Lake
- Data Pipeline, and related understanding of data ingestion, movement, and transformation across Cloud services
- Using Azure Data Factory, the data was managed on both on-perm and in the cloud.
- Created scheduled job to put data from Global scape to Azure Storage explorer.
Environment: SQL Server 2012, Microsoft Visual studio 2016, SSDT 2012, ODBC Query tool 64 bit, WinSQL 64 bit, MS Office 2016, Azure.
Confidential, Marietta GA
Senior MS BI / Power BI Developer
Responsibilities:
- Involved in analyzing, designing, developing, installing, configuring and deploying SQL Server Integration Services.
- Provided support to Data Analysts in File Validation and data analysis using TOAD for oracle 10.6.
- Expert in writing Migration query and hand it over to Accounting and finance department using SQL developer for Oracle version 18.1.0.
- Created Tidal job to pick the file and load it into UNIX server using shell scripts.
- Developed database encryption, security, and auditing strategies.
- Monitoring daily/other database jobs and data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting
- Analyzed current Micro strategy reports and created new reports in Power BI.
- Extensive hands on building & maintaining Power BI reports/Power view reports and Dashboards.
- Identified possible improvements and efficiencies to the existing Power BI reports and dashboards using DAX and MDX.
- Expert with the setup and configuration of Power BI (Power Query, Data Management Gateway, SSAS Tabular Connector)
- Leveraged more benefits of Power BI to business in terms of performance reporting and mobility.
- Experience working in Scrum and agile Environment.
- Documented day-to-day events for tracking and review, process documentation, Preparing SOP-Service Operation Procedure documents, Creating and maintaining technical knowledge base
Environment: SQL Server 2012, Microsoft Visual studio 2016, SSDT 2012, ODBC Query tool 64 bit, WinSQL 64 bit, MS Office 2016.
Confidential
Senior SQL Developer
Responsibilities:
- Expertise in TSQL programing writing Stored Procedure/Functions/bulk insert to extract data from Legacy (or CSV files), linked server to SQL server
- Experience with disaster Recovery, Continuity of Operations, and Contingency Planning.
- Monitored and maintained SQL strategies and solution for backup, restoration, and replication for database. Developed database upgrade and migrations strategies.
- Query and Solution performance tuning and database optimization.
- Reviewed query performance interprets complex execution plans and creates tuning solutions involving T-SQL and Indices.
- Worked on code versioning tools such as Git and Bitbucket
- Good knowledge in Teradata concepts and Logical/physical database design.
- Managed roles, users, and permissions as well interface with internal & external technical teams.
- Experience in an object-oriented programming language
- Expert in recognizing business challenges and create effective solutions for those challenges.
- Worked as self-directed with minimal supervision and learn unique environment quickly.
- Took a role as managerial which involved in project management, Team meeting every week, offshore on-site coordination and knowledge transfer KT’s.
- Maintained customer confidence and protected operations by keeping information confidential and secure.
- Ability to perform in 24 x 7 Environment in shift roaster and to attend calls on-call basis whenever assigned.
- Experience working on ticketing tools like ServiceNow, Agile Ticketing, and Pier.
- Knowledge of oracle golden gate
Environment: SQL Server 2014/2016, Visual studio 2008/2012/2016 Teradata SQL assistant 15.00, SharePoint, Informatica 9.1.0, 9.5.1, Azure, OEM, PowerShell, SQuirreL, Agile/Waterfall, OBIEE, T-SQL, MySQL, SQL Analyzer, VMware, Toad for Oracle, SQL Developer for oracle, and MS Office.
Confidential
Senior ETL/SSRS Developer
Responsibilities:
- Involved in installation and configuration of SQL Server 2016 from 2014 and Visual studio 2017 as well as assigned permissions to different levels of users in SSRS
- Moved Reports from Access database and Excel database to SQL Server Reporting Services.
- Involved in loading, processing, and converting very large datasets into statistical data with accuracy, repeatability, and speed.
- Experience writing complex SQL queries and stored procedures for SSRS Reports
- Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients, and managers with proficiency using Report Designer as well as Report Builder1.0 and 3.0. Created OBIEE reports and Dashboards
- Created various SSRS dashboard reports for commission, sales, and profit analysis
- Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
- Expert in generating writing parameterized queries, Drill through and Drilldown reports, Scheduled Reports, and formatted SQL server Reports in SSRS 2014/2016 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
- Created cascading parameterized and Sub reports with respect to client requirement.
- Built and deployed reports to local shared servers and Microsoft Office SharePoint Server.
- Creating reports using SQL Server Reporting Services SSRS for customized and ad-hoc Queries.
- Involved in designing, developing, debugging, and testing of reports in SSRS.
- Created custom report, dashboards, enhanced UI features using filters, Master-Detail linking, and visualizations such as pie charts, Graphs, Pivot tables groupings and multi-value parameters.
- Expert in designing reports using SQL Server Reporting Services (SSRS 2008/2012/2014/2016 ),
- Operating and troubleshooting with data sources.
- Identified and added the report parameters.
- Ability to drive/ manage repot development with minimal supervision as well as Effective communication and client interaction skills
Environment: BIDS, SSMS 2008/2014/2016 , SSRS, Access, SharePoint Server, VS, Agile/Waterfall, OBIEE, T-SQL, SQL Analyzer, Report Builder, PFE32 and MS Office 2013/2016.
Confidential
SQL BI Developer/DBA
Responsibilities:
- Maintained existing Interchange and VMF/INF data loads. Current data loading processes use a combination of SSIS, Excel / VBA macros and Oracle SQL Loader routines.
- Performed day-to-day database administration with an emphasis on producing and evaluating performance monitoring report to maintain peak performance, written stored procedures, indexes, triggers, functions, and data manipulating using DDL and DML.
- Managed and developed Oracle scripts, Java Script, UI development and T-SQL, SSIS script task, look up transformations and data flow tasks using T- SQL and VB scripts.
- Implemented quarterly ETL process by pulling large volume of data from various data sources systems including MS Excel, MS Access, Flat Files, CSV Files, FTP, PFEs, OLEDB to SQL Server using SSIS/DTS using various features like data conversion etc.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
- Scheduled the SSIS jobs using SQL server agent for daily, weekly, and monthly loads as well as scheduled the jobs to run automatically.
- Deployed different SSIS packages on development, test, UAT and production servers.
- Designed graphical interface to build complex queries against multiple data sources and working interchangeably between the graphical query builder and the SQL editor
- In-depth knowledge and hands-on experience on database specifically Teradata
- Worked on the Data Warehouse Design and Analyzed/Forecasted approaches for maintaining dimensions and facts in the process of building data warehousing apps. The environment at Munich Re is in between 5-6 TB of data.
- Worked on OLAP Data Warehouse from a modeling, design, and implementation perspective. Heavily involved in building on cube structure optimization for MDX query performance within Analysis Services.
- Worked on the data warehouse design and analyzed various approaches for maintaining dimensions and facts in the process of building a data warehousing application, Star schema, Snowflake Schema, OLAP cubes, Multi-dimensional modelling, Data Cleansing and others.
- Designed highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization, and Tuning.
Environment: BIDS, SQL Server Management Studio 2008/2008 R2/2012/2014, Visual Studio, Agile/Waterfall, OBIEE, Java, T-SQL, SQL Analyzer, SharePoint Server, Visual SourceSafe 6.0, HEDIS, Toad for Oracle 10.6, Access, Excel, Report Builder, PFE32, Team foundation system TFS and Office.