Name: RAKESH
Technology: Sr. SQL Developer
EXP: 5+
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.
Client: Conduent, Minneapolis, Minnesota Jan 2022 – May 2022
Role: Sr. SQL Developer
Responsibilities:
• Expert knowledge of Teradata 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)
• Experience working with and migrating applications from Visual Basic 6.0 and/or C++ to C#.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Responsible for creating and changing the visualizations in Power BI reports and hierarchies using Bar charts and Pie charts according to the client requests.
• Strong hands-on experience in designing and development of cloud-based applications that include large scale compute services, database services, ETL, queues and notification services.
• 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.
• 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 using Tool called SHIFT
• Validating data from SQL server to snowflake to make sure it has apple to apple match.
• Develop transformation logic using snow pipeline. Created data sharing between two snowflake accounts. Redesigned the Views in snowflake to increase the performance. Unit tested the data between Teradata and Snowflake, Netezza and snowflake, hive to TSQL.
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages. 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.
• Loaded of tables from DB2 to SQL Server performed every night across multiple systems.
• Developed software code using C# programming language to meet design specifications, and user requirements as well as delivered high-quality applications within specified deadlines
• Created internal and external stage and transformed data during load.
• Build a program with python and execute it into a cloud data flow to run data validation between source file and big query tables.
• Scheduling tasks on windows task scheduler to run the Python scripts to generate reports for frequent interval of times and also send email alerts.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling. 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.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Very good knowledge of RDBMS topics, ability to write complex queries, Stored procedures, functions packages, triggers using SQL, PL/SQL.
• Experience in oracle supplied packages, dynamic SQL records and PL/SQL tables. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in data loading using PL/SQL calling Unix scripts to download and manipulates the files.
• Experience in various methodologies like Waterfall and Agile.
• Experience in working on Unix/Linux operating systems.
Environment: T-SQL, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TERADATA 14.0, SQL Server Assistant, MS Excel, Active Batch V12 Console, SQL Server Management studio 2016, Snowflake, GIT, SQL and Jira.
Client: Next Pathway, New York Feb 2020 – Dec 2021
Role: Sr. SQL 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.
• Involved in setting up development standards for the power 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 and 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 and 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.
• Integrated custom visuals based on business requirement using power BI desktop. Converting all operational excel report into Power BI Reports. Worked on all types of transformations that are available in Power bi query editor. Scheduled Automatic refresh and scheduling refresh in power bi service.
• 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 and supported during QA/INT/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.
• Expertise in working with Teradata, SQL, PL/SQL Stored Procedures, Oracle Stored procedures, Packages, Cursors, Triggers, Tables, Constraints, Views, Indexes, Sequence, and Synonyms in distributed environment.
Environment: Oracle 11g, UNIX, PL/SQL, IDQ, Teradata V 13.0, SQL* PLUS, Teradata SQL Assistant and MS Excel.
Client: GE Healthcare, Hyderabad July 2017 – Dec 2019
Role: SQL Developer
Responsibilities:
• Effective Communication with data architects, designers, application developers and senior management in order 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 also 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
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.
Environment: Teradata SQL Assistant 12.0, Teradata V12, Oracle10g/9i, MS SQL server 2005/2012, SQL, PL/SQL, Unix Shell Scripting, Windows.
