SUMMARY

• Over 8 years of Software Life Cycle experience in System Analysis, Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications, SSRS, PowerBI, SSIS, SnapLogic, SSAS and SQL Database Administration.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Involved on administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, dimensional database environments.
• Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Assessed the Netezza environment for implementation of the ETL solutions.
• Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re - Indexing.
• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, MS Access, and CSV files to the data warehouse.
• Database development for both OLTP and OLAP systems using MSSQL Server.
• Proficient in data modeling for OLTP (Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions) and Data warehouse applications (Snowflake and Star Schemas) including facts and dimensions tables.
• A well organized, flexible, enthusiastic, and project-oriented team player, to develop creative solution for challenging client needs and strong in management and leadership skills.
• Good logical, analytical, interpersonal skills and commitment to perform quality work as well as an excellent team player.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service. designing and implementing a fully operational production grade large scale data solution on Snowflake and Google Bigquery Data Warehouse.
• Experience extracting/querying/joining large data sets at scale.
• Experience in Database Backup, Recovery and Disaster Recovery procedures. Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Hands on experience in multiple cloud platform like Azure, Snowflake and Google Bigquery and Azure cloud services (PaaS &IaaS), storage, web apps, Active directory, application insights, logic apps, data factory, service Bus, azure monitoring.
• Expertise in DWH technical architecture, design, business requirement definition and Data Modeling.
• Experience in creatingHigh Level Design and Detailed Designin the Design phase.
• Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.

TECHNICAL SKILLS

ETL Tools: SQL Server SSMS Export Imports, SSIS, SnapLogic, SSAS, INFORMATICA, Mapping Designer, Workflow Monitor, Workflow Manager, Data Cleansing, Data Quality, Repository, Data Mart, OLAP, OLTP, SQL Server SSIS.

Data modeling tools: Erwin

BI Tools: Cognos, Business Objects

Databases: MS SQL Server (2008/12/14/16/19 ), MS Access, Oracle 11g/10g/9i/8i, Flat Files, Snowflake, GCP Bigdata

Other Tools: SQL Developer, Crystal Reports, SQL Assistant, Crystal Report, SQL Server 2012 Reporting Services (SSRS), Power BI

Programming Languages: SQL, PL/SQL, T-SQL, PowerShell Scripting

Job scheduling: SQL Agent, Shell Scripting

Environment: MS Windows 2016/2012/2008/

DBA Tools: SQL, Erwin, TOAD, PL/SQL, T-SQL, VMwareCloud PlatformsAzure, Snowflake, GCP

PROFESSIONAL EXPERIENCE

Confidential, Edison, New Jersey

ETL Developer/SQL Developer

Responsibilities:

• Interactive with multiple teams and getting data from multiple Data Sources to GCP Big query Dataset Tables.
• Importing and Exporting data from different sources to Bigquery Datasets and Google Storage Buckets.
• Writing complex SQL Queries based on requirements to perform export, insert and Update operations.
• Writing Python script to automate the process of ETL Activities based on requirements.
• Writing Python script to connect with cloud platforms Snowflake, GCP and perform operations and export into storage buckets.
• Interact with multiple application teams and work with them for sending and receiving required data and files.
• Expert design/coding skills, unit testing methodologies and techniques
• Demonstrated competency in all phases of business intelligence and data warehousing projects, from inception to production deployment.
• Worked on Migrating objects multiple RDMS/data sources to Google Bigquery dataset.
• Solid understanding of data warehousing principles, concepts, and best practices (e.g., ODS, Data Marts, Staging)
• Create projects on Jira and assign Jira Agile boards.
• Strong understanding of Release Management process and required applications.
• Worked on Migrating table DDL’s, views and stored procedures from multiple RDMS databased to snowflake.
• Participate in design meetings for creation of the Data Model and provide guidance on best data architecture practices.
• Involved in writing complex SQL Scripts using excel sheets for loading data into maintenance tables.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.
• Configuring MSSQL with TFS Server, Create recovery plan for TFS server.
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Define roles and privileges required to access different database objects.
• In-depth knowledge of Snowflake Database, Schema and Table structures.
• Define virtual warehouse sizing for Snowflake for different type of workloads.
• Created maintained various databases for Production, Development Servers using MS SQL Server Planning location data, indexes, Transaction log files on disk.
• Worked with cloud architect to set up the environment.
• Develop transformation logic using snow pipeline. Created data sharing between two snowflake accounts. Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Used SSIS, Import/Export to Copy, move data from one server to another, Excel to SQL Server.
• Created internal and external stage and transformed data during load.
• Hands on experience with programming languages/tools including Java, NodeJS, Python, Go, JavaScript, and Shell Scripts.
• Responsible for configuring, integrating, and maintaining all development, QA Staging, and production PostgreSQLdatabases within the organization.
• Experience in various methodologies likeWaterfallandAgile.

Environment: Google Big query, Python, SSIS, Snowflake, TSQL, Oracle 11g, Azure, PL/SQL, SQL* PLUS, TOAD, MS Excel, SQL server Management studio 2016. Power BI

Confidential, New York, New York

ETL Developer

Responsibilities:

• Expert knowledge of Terada platform and associated tools
• Expert design/coding skills, unit testing methodologies and techniques
• Demonstrated competency in all phases of business intelligence and data warehousing projects, from inception to production deployment.
• Solid understanding of data warehousing principles, concepts, and best practices (e.g., ODS, Data Marts, Staging)
• Strong understanding of Release Management process and required applications.
• Worked on Migrating table DDL’s, views and stored procedures from hive to SQL, Netezza to snowflake, Teradata to snowflake, Teradata to synapse, PostgreSQL to snowflake.
• Writing Automation code to translate the code using java script in eclipse phrase tree to automate the code translation from various database could environment.
• Participate in design meetings for creation of the Data Model and provide guidance on best data architecture practices.
• Involved in writing complex SQL Scripts using excel sheets for loading data into maintenance tables.
• Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Loaded of tables from DB2 to SQL Server performed every night across multiple systems.
• Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
• Experience with Snowflake Multi - Cluster Warehouses.
• Conducted ETL development in the Netezza environment using standard design methodologies.
• Involved in requirement analysis, ETL design and development for extracting data from source systems like DB2, Oracle, flat files and loading into Netezza.
• Define roles, privileges required to access different database objects.
• Created automated solution using windows PowerShell to manage the backup of the primary file server and programmatically notify the administrator via email of the backup’s success or failure.
• In-depth knowledge of Snowflake Database, Schema and Table structures.
• Created maintained various databases for Production, Development Servers using MS SQL Server Planning location data, indexes, Transaction log files on disk.
• Worked with cloud architect to set up the environment.
• Develop transformation logic using snow pipeline. Created data sharing between two snowflake accounts. Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Moderate and contribute the support forums (azure networking, azure active dorectory, azure storage) for microsoft developers network including partners and MVPs.
• Used SSIS, Import/Export to Copy, move data from one server to another, Excel to SQL Server.
• Created internal and external stage and transformed data during load.
• Hands on experience with programming languages/tools including Java, NodeJS, Python, Go, JavaScript, and Shell Scripts.
• Design, develop, test, implement and support of Data Warehousing ETL using Talend.

Environment: SSIS, SnapLogic, Snowflake, TSQL, Oracle 11g, Azure, PL/SQL, SQL* PLUS, TOAD, TERADATA 14.0, MS Excel, SQL server Management studio 2016. Power BI

Confidential, Cary, NC

Sr. SQL Developer/Data Engineer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Worked with DBA team on TDM process which is Data Acquisition TDM tool will help rapid development of ETL process which we can copy one or more tables from SQL server or flat files to any TD core system.
• In the TDM Development tool which includes ABC metadata entries, creating tables/views Generation, Active batch development.
• Analyze requirements provided, design and develop integration packages as per the client request and automate them.
• Wrote complex queries to in corporate the business logic and retrieve all the certification and candidate details for further reporting purpose.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Created the schema, implemented all stored procedures and 4 SSIS packages Created the deployment scripts and managed the code in Microsoft Team Foundation Server.
• Performed unit tests on all code and packages.
• Updated existing and created new reports using Microsoft SQL Server Reporting Services. Team consisted of 2 developers.
• Performed front line code reviews for other development teams.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server and Oracle databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Created custom fully automated solution using windows PowerShell to export individual mail boxes from the exchange environment and save them as separate PST files.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Solved the issues associated with ETL Data Warehouse Failure.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like lookup, merge, merge join, script component and slowly changing dimension.
• Created Stored Procedures and handling the Query Performance Issues
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
• Experienced field Unit Testing have tested codes of T-SQL SSIS packages testing environment.
• Configured DB mail for sending automatic mails to respective people when SSIS process fails.
• Administered MS SQL Server creating User Logins with appropriate Roles, dropping, and locking the logins, monitoring User Accounts, granting privileges to users.
• Additional projects included automation of a manual process as the start of a data warehouse project.

Environment: SSIS, SQL Server, Flat Files, Power BI, SSMS, Power Shell, Oracle, MS Excel, GIT, SQL, Jira,AWS.

Confidential, Nashville, TN

Sr. SQL/ETL Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Involved in Analysis, Design, and Development and Testing phases.
• Worked in a team with DBAs in Installation, backups, and recovery.
• Involved in table partitioning and index partitioning.
• Enhanced existing customized reporting utility to meet evolving client needs and time constraints.
• Involved in setting up development standards for the BI project.
• Experience with performance tuning new and existing stored procedures.
• Developed and modified SQL queries and stored procedures to meet business requirements.
• Performed tests and produced results to ensure accurate compliance with project request requirements.
• Created automated solution using windows PowerShell to manage the backup of the primary file server and programmatically notify the administrator via email of the backup’s success or failure.
• Analyzed the business requirements from the given specifications.
• Writing of Stored Procedures and Functions using SQL Server 2012 and T-SQL.
• Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2012 Performed the Server optimization, tuning of the indexes and the queries and Consolidation of SQL Server environment Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component.
• Design and implementation of Security Model, policies, and procedures.
• Query Optimization using Query Analyzer, Profiler, show plan, Index Tuning and Stats Time Tool.
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
• Extensively used Teradata SQL Assistant to write different queries to understand the data in source tables.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Coded various stored procedures for the purpose of application development.
• Design and implement data access stored procedures and triggers for automating tasks.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
• Created Stored Procedures, Triggers, Views, Functions for application.
• Migrated the legacy Databases in SQL Server 2000 to SQL Server 2005 using SSIS.
• Wrote T-SQL statements for retrieval of data involved in performance tuning of TSQL queries and Stored Procedures.
• Troubleshot complex queries and stored procedures.
• Implemented and enforce best practices, standard operating procedures, etc.
• Reviewed code to identify SQL changes to improve system performance.
• Handled performance tuning and break/fix of existing T-SQL code.
• Troubleshot Reports by cross checking Report Layouts, Stored Procedures and SSIS Packages.
• Developed several Complex Reports using SQL Server Reporting Services (SSRS).
• Created Ad-hoc Reports, Drill-Down Reports, Pivot and Tabular Reports.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files databases MS SQL Server 2005 using SQL Server Integration Services (SSIS).

Environment: SSIS, SnapLogic, Snowflake, TSQL, Oracle 11g, Azure, PL/SQL, SQL* PLUS, TOAD, TERADATA 14.0, MS Excel, SQL server Management studio 2016. Power BI

Confidential

Sr. SQL /ETL Developer

Responsibilities:

• Effective Communication with data architects, designers, application developers and senior management to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
• Effectively involved in allocation & review of various development activities / task with onshore counter apart.
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports.
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal
• Maintain and Tune Teradata Production and Development systems
• Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion
• Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: SSIS, SnapLogic, Snowflake, TSQL, Oracle 11g, Azure, PL/SQL, SQL* PLUS, TOAD, MS Excel, SQL server Management studio 2016. Power BI