Home

Ragini Puli - Sr. SQL Server (ETL/SSIS) Developer/PLSQL

[email protected]

Location: Raleigh, North Carolina, USA

Relocation: yes

Visa: H4 EAD

Resume file: Ragini_Sr. SQL Server Developer_1754567663335.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Ragini Puli (704) 337-0158 [email protected] Charlotte, NC SUMMARY: Having 11+ years of SQL Server Developer and Business Intelligence experience in Airlines, Communications and Banking domains with expertise in MS SQL Server 2019/2016/2014/2012 and Business Intelligence including SSIS. Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2016 and Access databases. Experience with Oracle. Ability to work in all stages of System Development Life Cycle (SDLC). Experience in Error handling and debugging coding issues. Experience in Store procedure Optimization and reducing data retrieval times by refactoring SQL code enhancing business logic and Indexing strategies. Automated and parameterized stored procedures, enabling scalable solutions for application data retrieval. Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Views, Functions, CTE s, Table Variables and Stored Procedures. Expertise in SQL Server 2016 Integration Services (SSIS) with performing various SSIS data transformation tasks like Lookups, Fuzzy Lookups, Conditional Splits and Event Handlers, Error Handlers, Deploying, Testing etc. Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables. Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS). Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages. Expertise in Extraction, Transformation, loading data from Oracle, DB2, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS. Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages. Expertise in Debugging, Error logging, Error Handling and Production support for SSIS Worked extensively on Extraction, Transformation, loading data from Oracle, Excel, and XML using DTS, SSIS. Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS). Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion. Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/2014/2016/2019. Good Knowledge in creating SQL server Reports using SSRS. Expertise in creating Report Models for building Ad hoc reports using SSRS. Proficiency in creating diverse types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them. Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS. Knowledge and experience in designing, developing and deploying Reports and Dashboards Have knowledge on PowerShell and JSON creation. Experience in handling, configuration of NoSQL database like MongoDB. Worked on architecture and capacity planning for MongoDB Cluster. Implemented scripts for MongoDB import, export, restore and dump. TECHNICAL SKILLS: Databases ORACLE, MS SQL Server 2012/2014/2016/2019, Studio3T, MongoDB Compass, NoSQL Manager. Programming Languages T-SQL, SQL, HTML, XML, PowerShell, JSON. Data warehouse tools SSMS, Business Intelligence Development Studio and SQL Profiler Reporting tools SSRS Tools/Methodologies MS Visio, Erwin, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling Operating Systems Windows Server and Linux. Version Control GIT and Bitbucket. EDUCATION: Master s degree from California State University Fullerton Fullerton, CA. Bachelor s Degree from JNTUH, India. PROFESSIONAL EXPERIENCE: Charter Communications - Charlotte, NC August 2023 - Till Date Role: Sr. SQL Server (ETL/SSIS) Developer/PLSQL Responsibilities: Spearheaded the design and implementation of stored procedures, views, and other critical application database code objects, contributing significantly to the enhancement of database efficiency and performance. Played a pivotal role in the LLM project, enabling high split locations by leveraging expertise in SQL Server Integration Services (SSIS) and ETL processes. Lead the Presale project enabling Highsplit locations in new communities using SSIS and ETL process in conjecture with Kafka services. Lead the project to enhance the run time of 30 existing procedures to reduce data retrieval times by at least 10%, re-writing the existing procedures to use the SQL best practices (such as table types, batch updates etc.) without making changes to table indexes. Utilized Visual Studio for code checking and Jira for ticket management, ensuring streamlined communication and coordination across project teams, particularly in defining requirements and making enhancements to existing tables. Maintained SQL scripts indexes and complex queries for analysis and extraction. Worked in tandem with the Kafka development team to define project requirements and implement necessary enhancements, for seamless integration within the database system. Design ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS). Analyzed existing database models to identify optimization opportunities, troubleshoot performance issues, and advise on the optimization of slow-performing queries, ensuring optimal database performance and responsiveness. Led quality testing and assurance initiatives for SQL servers, ensuring the reliability, accuracy, and performance of database operations through comprehensive testing protocols and procedures by developing in Dev environment promoting to UAT and then to production. Designed and implemented ETL packages utilizing SSIS, handling various data sources such as SQL Server, flat files, and XMLs, and performing diverse transformations to facilitate data loading into target data sources, including the data warehouse. Implemented table partitioning strategies to distribute data across multiple filegroups or partitions, improving query performance by reducing the amount of data that needs to be scanned or processed for query execution. Demonstrated proficiency in writing complex procedures for backfill projects, PNG project, and high split initiatives, contributing to the successful execution and completion of critical database projects and initiatives. Worked on database concepts such as Locking, transactions, sharding, replication, indexes, schema design. Implementing transactions and XML configuration files to SSIS Packages and in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Developed and implemented backout scripts for production deployments, ensuring the ability to roll back changes swiftly and effectively in case of deployment issues, thereby minimizing downtime and operational disruptions. Created comprehensive disaster recovery documents outlining procedures and protocols to mitigate risks and restore operations in the event of system failures or emergencies, contributing to the organization's resilience and business continuity. Led the Archer project, overseeing the ingestion of data from third-party sources, leveraging bulk insert techniques to efficiently load data into SQL Server. Implemented procedures to clean and prepare the data for integration with Archer functionality, ensuring seamless data flow and accuracy within the system. Environment: MS SQL Server 2014/2016, SSIS, SSRS, T-SQL, OLAP, OLTP, Data Mart, ETL, MS Office 2007, VM ware. LENDING TREE - Charlotte, NC September 2021 - July 2023 Role: SQL Server (ETL/SSIS) Developer/PLSQL/MongoDB Responsibilities: Designed and implemented stored procedures views and other application database code objects. Assisted in the definition of the database requirements, analyzed existing models looking for opportunities to improve their efficiency and troubleshoot various performance issues. Advised optimization of slow performance queries by looking at execution plan for better tuning of the database. Performed quality testing and assurance for SQL servers. Worked with stakeholders developers and production teams across units to identify business needs and solution options. Ensured best practice application to maintain security and integrity of data. Design, implement, deploy, and maintain the ETL process and data flow, including data quality and unit testing using SQL Server Integration Services. Design ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS). Used various SSIS tasks such as Conditional Split, Multi Cast, Fuzzy Lookup etc. which did Data scrubbing, including data validation checks during staging, before loading data into Data Warehouse. Responsible for implementation of Data viewer, logging, error configuration for error handling the packages. Using Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs. Developing and testing the SSIS packages by deploying them to local sandbox environment. Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion. Creating SQL Server Reports and developed query for generating drill down and drill through reports using SSRS. Experience in design and developing Application leveraging MongoDB. Extensive experience in deploying, managing and developing MongoDB clusters. Worked on creating various types of indexes on different collections to get good performance in Mongo Database. Worked on creating documents on MongoDB. Used GitLab for Version Control. Environment: MS SQL Server 2014/2016, Windows XP, SSIS, T-SQL, ETL, MS Office 2007, VM ware, MongoDB. FIS - Charlotte, NC October 2018 - August 2021 Role: SQL Server (ETL/SSIS) Developer/PLSQL Responsibilities: Implementing, developing, and maintaining SQL Databases (Tables, Functions, Stored procedures, Constraints, Indexes, Views, and complex SQL statements). Migrating and Transforming data from multiple sources to SQL/Oracle. Performing Extraction, Transformation, Load (ETL) of data from various sources. Maintained the application, using MS SQL Server 2016/2014/2012/2008. Transferred (Import/export) data between SQL and Access databases. Completed the analysis, requirements, conversion and mapping of client data to the data conversion staging and loading in the client databases (ETL). Loaded and processed different source files such as .csv, .xlsx, .txt. Created and modified SSIS and DTS packages. Developed and implemented multiple queries, stored procedures, views, and functions for deploying, integrating, tuning and maintaining databases (T-SQL). Work closely with business users to congregate and comprehend requirements. Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems. Optimized the stored procedures which are using cursors and increased the performance. Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database. Designed and worked on extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS. Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc. Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion. Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output. Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages. Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components. Migrated old data from MS Access and Excel into SQL Server 2016 using SSIS Packages in Business Intelligence Development Studio. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup. Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database. Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies. Administered and enhanced SQL Server Integration Services (SSIS) data loads. Effectively used various properties in SSIS package to improve the performance. Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging. Used PowerShell to generate JSON and deployed code in higher environments. Environment: MS SQL Server 2014/2016, Windows XP, SSIS, SSRS, T-SQL, OLAP, OLTP, Data Mart, ETL, MS Office 2007, VM ware. UNITED AIRLINES - Chicago, IL July 2015 - August 2018 Role: SQL BI Developer Responsibilities: Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules. Handling the duplicate data with the help of T-SQL. Involved in requirement gathering from business and end users and working closely with the project manager and data architect. Created indexes for fast retrieval of the data. Involved in performance tuning and query optimization using execution plan. Created complex queries involving Sub-Queries and joins. Generated Linked server query to retrieve the data from TERADATA. Used open query methods to extract data so it passes the actual query to the remote server and get consolidated results. Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts. Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting. Provided practice sharing on VMWare with SQL Server 2012. Created and executed SQL Server Integration Service packages to populate data from various data sources, created packages for different data loading operations for many applications. Implemented fine tuning of database objects and server to ensure efficient data retrieval. Used Enterprise Manager for job scheduling and batch queries. Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa. Monitored performance and optimized SQL queries for maximum efficiency. Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS). Environment: MS SQL Server 2014, Windows XP, SSIS, T-SQL, ETL, MS Office 2007, VM ware. Flasto IT Solutions, Hyderabad, India July 2013 - June 2014 Role: SQL Developer Responsibilities: Implementing, developing, and maintaining SQL Databases (Tables, Functions, Stored procedures, Constraints, Indexes, Views, and complex SQL statements). Handling the duplicate data with the help of T-SQL. Created complex queries involving Sub-Queries and joins. Developed and implemented multiple queries, stored procedures, views, and functions for deploying, integrating, tuning and maintaining databases (T-SQL). Created indexes for fast retrieval of the data. Involved in performance tuning and query optimization using execution plan. Performed quality testing and assurance for SQL servers. Environment: MS SQL Server 2012, Windows XP, T-SQL, MS Office 2007, VM ware. Keywords: business intelligence active directory information technology microsoft California Illinois North Carolina