SUMMARY

• Professional Database & Software Developer in the telecommunications, finance, and supply chain industries. Expertise as a developer, data analyst, and software designer in all aspects of the software development lifecycle, Database, and business intelligence development expertise. Able to meet client expectations while keeping technical considerations in mind.
• Thorough and Meticulous Database & Software developer with around 3 years of experience in producing robust code for Fortune 500 companies. Passionate about helping businesses succeed.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery deadlines.
• Experience in Data flow diagrams, Data dictionaries, Database Normalization theory techniques, Entity relation modeling, and design techniques.
• Experience in working on projects involving Agile, and Waterfall methodologies.
• Expertise in Client - Server applications development using Oracle, PL/SQL, MSSQL, and PostgreSQL.
• Developed complex database objects like Stored Procedures, Functions, Packages, and Triggers using Oracle, SQL, and PL/SQL
• Excellent technical and analytical skills with a clear understanding of design goals of ER modeling for OLTP and dimensional modeling for OLAP
• Expertise in Dynamic SQL, Collections, and Exception Handling
• Experience in developing ETL applications using Snowflake ETL, SSIS, and Pentaho Data Integration.
• Developed ETL Mappings to load data from excel files into data warehouse using various ETL tools
• Experience in Snowflake cloud data warehousing and AWS S3 bucket for integrating data from multiple, source systems which include nested JSON formatted data into snowflake table.
• Professional knowledge of AWS Redshift.
• Experience in ETL techniques and Analysis and Reporting including hands-on experience with Reporting tools such as Power BI
• Programming skills in designing and implementing multi-tier applications using Java, J2EE, Spring boot, JDBC, Hibernate, HTML, and JavaScript.
• Experience in spring modules like Spring BOOT, Spring JPA, Spring AOP, JDBC, ORM, and Web Services using Eclipse and STS IDE.
• Expertise in implementing Web services using SOAP, and REST.
• Experience in various web and application servers like Apache Tomcat.
• Utilized Log4j logging API framework for logging Java applications.
• Expertise in writing Junit test cases using Mockito.
• Expertized in using JIRA software with Jenkins and GitHub for real-time bug tracking and issue management.
• Sound knowledge of designing and developing software applications with Microsoft .NET Framework using C#, ASP .NET, and ADO .NET

TECHNICAL SKILLS

Programming Languages: Java/J2EE, C#, SQL, PL/SQL, Oracle, JavaScript, HTML

Databases: Oracle, SQL, DB2, PostgreSQL, MySQL

Database Services: SSIS (SQL Server Integration Services), Snowflake ETL Pentaho Data Integration, SSRS, Power BI

Frameworks: Spring Boot, Spring REST, Spring Data JPA, Hibernate, Microsoft .Net, ASP .Net, ADO .Net

Cloud Platforms: AWS, Azure, Snowflake, Amazon Redshift

IDE’s: Toad, DBeaver, MySQL Workbench, SSMS (SQL Server Management Studio), Visual Studio Code, Eclipse, STS (Spring Tool Suite), IntelliJ

Operating Systems: Windows, macOS, Unix, Linux (Ubuntu, Red Hat)

Version Control: GitHub, Bitbucket

Methodologies: Agile, Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Missouri

Database Developer

Skills: Oracle DB, IBM DB2, SQL, Snowflake, SSIS

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data which helped the front-end team to easily extract the data from the database
• Created and modified several Unix-shell scripts according to the changing needs of the project and client requirements, this helped our project to create instances in Amazon EC2.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created SQL stored procedures, functions, and packages for moving the data from the staging area to the data mart which helped the business to extract the data directly from the views instead of going to each and every table.
• Created scripts to create new tables, views, and queries for new enhancements in the application using TOAD.
• Created records, tables, and collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used SSIS (SQL Server Integration Services) tool to build high-performance data integration solutions including extraction, transformation, and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Worked on SnowSQL and snow pipe and created snow pipe for continuous data load.
• Created reports in Power BI based on Snowflake connections.
• Experience working with AWS, and Azure Data Lakes.
• Good working knowledge of Amazon Redshift Databases.
• Good working knowledge of Azure Data Factory.
• Very good working knowledge of RDBMS topics, ability to write complex SQL, PL/SQL scripts.

Confidential, Missouri

Software Engineer

Skills: Java, Spring Boot, MS SQL, Hibernate, HTML, JavaScript, CSS, Maven, Git, Postman Developed web applications using Java, Spring Boot & Hibernate.

Responsibilities:

• Have good experience and exposure to most of the J2EE technologies like Spring Boot, Web Service, Hibernate, JDBC, JSP, XML, and JavaScript.
• Experience in SOA and developing Web Services using SOAP, REST, and XML.
• Extensive experience in the development and implementation of ORM framework Hibernate/ Hibernate with Spring Data JPA
• Developed tests using Postman and performed validation of data for APIs. Transformed Spring application to RESTAPI to retrieve configuration JSON data and test the connection via Postman
• Used Swagger Framework, actualizing the Restful API and Swagger 2 gives the rich UI to test API.
• Used Spring Boot at the back end which helped to develop the application with ease.
• Used Spring with Hibernate to build server-side for daily transactions and used JDBC to process End of Day jobs to improve the performance.
• Implemented OAUTH (Rest service authentication) in our application to communicate securely with other protected resources by exchanging access tokens for authentication instead of using username and passwords
• Good Knowledge of Object-Oriented Programming (OOP), Analysis and Design (OOAD) concepts, and designing.
• Created ETL pipelines, data flows, and complex data transformations with manipulations in Azure Data Factory.
• Working with different data storage options including Azure Blob, ADLS Gen-1, Gen-2.
• Azure Data Factory (ADF) pipelines extract the data from Relational sources like PostgreSQL, Oracle, SQL Server, DB2 and non-relational sources like Flat files, JSON files, XML files, Shared folders, etc.
• Build Azure Pipelines for E2E solutions.
• Experience in bulk importing CSV, XML, and Flat file data using Azure Data Factory.
• Working knowledge on Azure Synapse.
• Did a fit gap on the customer requirements and customized existing data models and Data warehouse.
• Debugged complex errors that occurred in the production environment.
• Extensive production support, monitoring the application, debugging & defect fixing.
• Wrote test cases and submitted them to team members for testing as well as tested code myself automated under JUnit Mockito.
• Used Git branching strategy for the inspection and for the version control maintenance and also handled GITHUB and Bitbucket for version control along with Source tree, and JIRA for defect tracking.
• Participating and contributing to Agile Ceremonies that of Daily Scrum, Backlog Refinement, Sprint Planning, Sprint Retrospectives, Sprint Review, and Demo.
• Worked with the technology team in understanding the requirements and then translating them to the technical design and detailed design documents.

Confidential

Data Analyst

Skills: PostgreSQL, Pentaho Data Integration, Power BI, MySQL, SSIS, SSRS Involved in analyzing unstructured data and its formats.

Responsibilities:

• Involved in designing the Data warehouse and data loading to the target tables.
• Hands-on experience in Data warehouse Star Schema Modelling, Snow-Flake Modelling, FACT & Dimension Tables, Physical and Logical Data Modelling.
• Designed and debugged complex code using PostgreSQL, and MySQL.
• Involved in developing custom ETL Mappings to load data from excel files into the data warehouse.
• Monitored and scheduled ETL jobs using Pentaho Data Integration.
• Designed and developed various SSIS packages (ETL) to extract and transform data and was involved in Scheduling SSIS packages.
• Created, maintained, and updated ETL packages loading from/to both OLTP and OLAP database tables.
• Developed reports and dashboards using Power BI.
• Created Technical Design and Data Lineage documents.
• Proficient in writing Confidential - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors, and Query Optimization Used T-SQL to create reports for ad-hoc requests.
• Interacting and coordinating with the development, testing team, and users on a regular basis to understand the system, thus making sure the functionality is intact.