Hello Tech,
SQL/PLSQL Developer are ready to work on Hybrid or Onsite
Name : Rakesh
Technology: SQL/ PLSQL Developer
Summary:
• Over 5+ years of Software Life Cycle experience in Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications, SQL, PL/SQL, SSIS, SSRS, Power BI on HealthCare, Insurance & Payments.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.
• Over 5 plus years of programming experience as an Oracle, SQL, PL/SQL developer in analysis, design and implementation of business application and Expertise in client server application development using oracle 11g/10g/9i/8i, PL/SQL
•Worked on Migrating table DDL’s, views and stored procedures from hive to SQL, Netezza to snowflake, Teradata to snowflake. designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.
• Experience in designing, developing, analyzing, and implementing client-server, web and desktop-based applications using C# language.
• 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.
• Able to create CLR function in a database object inside an instance of SQL Server that is programmed in an assembly created in the Microsoft .NET Framework common language runtime (CLR).
• Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge Join and Sort.
• Database development for both OLTP and OLAP systems using MSSQL Server.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• 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) and PL/SQL 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.
• Strong understanding of Release Management process and required applications.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Able Design schema for big query.
• Extensive experience in implementing projects using Agile (Kanban) and waterfall methodologies
Technical skills:
ETL Tools
Informatica 9.6.1 and SQL Server SSIS
Databases
Oracle 11g/10g/9i/8i, MS SQL Server (2008, 2005, 2000, 7.0, 6.5, 6.0), MS Access, SQL Server Assistant, Snowflake and Teradata
Other Tools
SQL Developer, TDM, Power BI and Airflow
Programming Languages
SQL, PL/SQL, UNIX Shell Scripting and Python
Job scheduling
Active Batch and Control M
Environment
MS Windows 2012/2008/2005 and UNIX
DBA Tools
SQL, PL/SQL and T-SQL
Professional Experience
Client: Cigna Health Spring, Nashville, TN June 2022 - Present
Role: Sr. SQL Developer
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 incorporate 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.
· Worked on creating the DAGs in Dev and other environments.
· Created the schema, implemented all stored procedures and 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.
· Developer and administrator of socio-economic application using PostgreSQL, PHP, XML and database design and modulation environment management using PostgreSQL.
· 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.
· 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. Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
· Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
· Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
· 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.
· Created the PL/SQL scripts to extract the data from operational database into simple flat text file using UTL_FILE engines.
· Developed advance PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic using SQL Navigator. wrote conversion scripts using SQL, PL/SQL, Stored procedures, functions and packages to migrate data from SQL server database to oracle database.
· Built complex queries using SQL and wrote stored procedures using PL/SQL.
· Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables.
· Involved in moving the data from flat files to staging area tables using SQL loader.
· Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus, SQL developer, and toad.
· Enforced data integrity using integrity constraint and database triggers.
· Proficient in advance features of Oracle 11g for PL/SQL programming like using records and collections, bulk bind, ref. Cursors, nested tables, and dynamic SQL.
· Written with object-oriented Python, SQL, Linux, Sublime Text and GIT.
· Experience using Microsoft visual studio for projects involving C#, entity framework. Designed a user interface using web forms, server controls and visual studios.
· 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: Oracle 11g, UNIX, PL/SQL, SQL* PLUS, Informatica Power Center 9.6.1, TERADATA 14.0, SQL Server Assistant, TDM, (Turbo Data Mover), Airflow, MS Excel, Active Batch V12 Console, SQL server Management studio 2016, GIT, SQL and Jira.
Name: Ashok
Technology: SQL Developer
SUMMARY:
· Extensive 7 years of experience in using T-SQL (DML, DDL) in SQL Server 2012/2014/2016 platforms
· In-depth knowledge of the Microsoft Azure framework and Azure Cloud platform
· Experience in Creating API’s using C#
· Experience working with terabyte to petabyte scale data
· Experience in creating Tables, Complex Query, Stored Procedures, Views, Indexes, Triggers, CTE, and ices (SSRS)
· Skilled in creating several reports such as Drill Down reports, Drill through reports, Parameterized reports, Sub reports, Matrix Reports, Chart reports using SQL Server Reporting Services. Worked on Standard and Data-Driven Subscription in SSRS
· Strong understanding of Object Oriented Programming (OOPS) concepts. FX, MVC.
· Experience with Star Schema and Snowflake Schema in Data Warehouse.
· Experience in Backup/Restore, Disaster Recovery.
· Experience in Data Modeling using Erwin, MS Visio.
· Expertise in developing advanced PL/SQL code through various procedures, functions, cursors, triggers, packages and materialized views.
· Experience working with different IDEs like Visual Studio, Eclipse etc.
· Strong understanding of Cloud services like Amazon Web Services (AWS), Derivatives, and Azure.
· Strong time management, analytical and problem-solving acquisitions coupled with excellent written, verbal and interpersonal communication skills.
· Experienced in performing database activities like backup, recovery, installing software, setting permissions to users, deploying SQL code to prod environment and setting up new environment on new servers.
· Proficient in using Extract, Transform and Load (ETL) solutions using SSIS Containers, Data transformations like For Loop, For Each Loop, Execute SQL task, Derived Column, Conditional Split, Sort and Merge Joins, Lookup, Multicast Transformations.
· Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008/2012 using SSIS tools like Import and Export Wizard
· Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
· Hands on experience in full/diff backup and restore in SQL Server 2012/2014/2016
· A well-organized, goal-oriented, highly motivated and effective team member with excellent analytical, troubleshooting, and problem-solving Skill.
· User Defined Functions in observing Business needs
· Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
· Skilled in Business Intelligence tools like SQL Server 2012/2014/2016, Integration Services (SSIS), Reporting Service
TECHNICAL SKILLS
· Databases: SQL Server 2008/2012/2014/2016, Oracle 12c, HANASIDECAR
· Languages: TSQL, PL/SQL, C#, ASP.Net
· IDE & BI Tools: MS Visual Studio 2015/2019, Red Gate Sql Tools, Erwin
· Tools: Visual Studio 2019, SSIS/SSAS/SSRS, Data Stage, Informatica, Power BI, Microsoft Excel
· OS: Windows/ Unix
PROFESSIONAL EXPERIENCE
Client: Genesis Financial Solutions, Beaverton, OR August 2021 to till date
Role: SQL Developer
· Design and Improve database/SQL centric software products for Sales Department which includes multiple phases of development such as design, coding, testing of technical solutions using SQL Server
· Design/Implemented efficient Database solutions and optimize existing Database architecture to make them more proficient based on technical requirements using T-SQL programming
· Developed SSIS ETL packages to load/process data from multiple sources into SQL Server for analysis.
· Created API services using C#
· Involved in Performance tuning and recommend various options such as Index tuning and SQL query optimization techniques to improve the application throughput by analyzing the query plan
· Act as POC between UI team and other software development teams, assist them by architecting database solutions, and recommend latest Database technologies within the scope of product
· Performing hands on Database Development and design while serving as POC for multiple teams across the organization and handling multiple projects simultaneously
· Created and Maintained different versions of SQL code, Dtsx packages and Report rdl’s in TFS.
· Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
· Tested various reports using SQL queries.
· Contributed in creating ETL designs and provided end users an easy accession to data marts.
· Maintained data marts up-to-date and in accordance with company’s requirements and practices.
· Deployed Azure SQL databases and other Azure settings using PowerShell and JSON
· Developed various SQL scripts for running the reports and the jobs on time.
· Test and debug SQL code.
· Employed Oracle database to create and maintain Data Marts.
· Azure Storage development and design utilizing Blobs, Pages, Queues, Tables and VM's.
· Established connection from Azure to On-premises datacenter using Azure Express Route for Single and Multi-subscription connectivity.
· Developed and implemented a migration tool to automate projects creation and migrated projects and data from Plan View and Excel to Azure SQL.
· Good working experience in Azure App Service, Azure Logic apps, Service Bus, Document DB, Azure Cosmos DB and SQL Database.
Looking forward to working with you..!
Thanks & Regards
Jyothi
Sales Recruiter
TechSmart Global Inc.
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.
