Chanikya Sairam Gopisetty
Little Elm,TX
Summary
- 12 Years of overall professional experience in Datawarehouse, Business Intelligence and analytics, Data Pipelines, and ETL/ELT areas.
- Experience in Software Development Life Cycle(SDLC) Agile & Scrum methodologies involving requirement gathering and story pointing, application design, data modeling, development, testing, maintenance, and documentation with timely delivery against aggressive deadlines.
- Well-versed in ETL design and coding for Data Validation, Data Loading, Data Cleansing, and Data Integration for Enterprise Data Migrations.
- Detail-oriented engineer designs, develops and maintains highly scalable, secure and reliable data structures.
- Experience in using AWS Data share for collaborations between organizations.
- Sound domain knowledge in Finance, Banking, Survey Research, Medical, and Media Information Systems. Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL Server, MySQL, Amazon Redshift, and Oracle.
- Proficient at developing logical and physical Data Modeling using normalizing Techniques and Data warehouse concepts.
- Hands-on experience in developing flexible solutions that can add functionality through adding/changing SQLs without the need for any further development or DDL changes, high level of parameterization.
- Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models.
- Effective team player with process orientation and a very good troubleshooter.
Overview
11
11
years of professional experience
Work History
Senior Data Engineer
Oportun
03.2022 - Current
- Accountable for working with a diverse set of business data domains to design and build data solutions for analytics and business data users
- Develops and implements unified customer models across products from disjoint data sets
- Implement the AWS data share process to enable data sharing between the acquired companies
- Create and review technical and user-focused documentation for data solutions (data models, data dictionaries, business glossaries, process and data flow, architecture diagrams, user guides, etc.)
- Design and develop DBT models and utilize best practices to extract, transform, and load the data into the Databricks platform
- Develop and enhance Python scripts for multiple processing parallel executes of the SQL
- Responsible for creating and maintaining scripts needed for importing and matching the members between Digit and Oportun.
Data Engineer
The MSR Group
06.2017 - 03.2022
- Accountable for developing high quality, customer-friendly BI solutions, as evidenced by taking ownership for data quality, report quality and customer satisfaction
- Develops and implements complex reporting and analytical processes
- Perform Data Modeling and Data Profiling to ensure the proper storage of data and data integrity
- Design and develop data models and utilize best practices to extract, transform and load the data into a data warehouse
- Develop and enhance TSQL stored procedures, triggers, functions
- Responsible for creating and maintaining Alteryx workflows and MS Integration Services (SSIS) packages to generate the data used for end user reporting
- Generate customized reports/ dashboards using Tableau and embed them into an application
- Automate and schedule the extracts from the source systems using the source systems embedded extraction tool and FTP to various downstream servers
- Create manual and automated testing strategies to ensure the deliverables are complete and error free prior to delivering them to the customer
- Design and develop performance monitoring system that measures customer satisfaction of major financial institutions
- Involved in database design and writing database queries with emphasis on performance
- Also use API’s for quicker and faster access of data
- Create, design and update technical documentation such as user’s manual and training materials, as necessary.
Software and Database Engineer
University of Nebraska Medical Center
10.2016 - 06.2017
- Storing the research data on MSSQL Server and Maintain the Oracle databases for the researchers
- Create web interfaces for the users to interact with the data using NodeJS
- Gather the requirements from the researchers for their new projects using Agile methodology
- Perform ETL operations using SSMS and SSIS
- Formulate queries and stored procedures for data de-identification
- Generate reports from the extracted data
- Used SVN for source control management.
BI& ETL Developer
Tata Consultancy Services
12.2012 - 10.2015
- Involved in SDLC gathering requirements from end users
- Ensure consistent delivery of deliverables per the agreed upon schedules
- Worked extensively on different types of stages like Sequential file, Dataset, ODBC, Aggregator, Transformer, Merge, join, Lookup, Sort, Funnel, Filter, External Filter etc for developing jobs according to business requirements
- Worked to enhance the performance of job using performance tuning techniques like filtering, partitioning the data using suitable partition technique
- Used the Data Stage Director extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics
- Created backups for Data stage jobs using DsImport/DsExport created .dsx and .Isx files
- Actively involved in the Informatica power center development and administration
- Extensively worked on Address Doctor in IDQ
- Conveyed analysis results to clients and stakeholders through creative data visualizations, reports using Tableau/Cognos
- Developed stored procedures triggers and exceptions to facilitate consistent data entry into the database
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
Education
MS - Management Information Systems
University of Nebraska
Omaha, NEBachelors - Computer Science and Engineering
Jawaharlal Nehru Technological University
Skills
- Tools: DBT, Alteryx, Informatica, MDM, IDQ, Datastage, SSIS Cognos, Tableau, Power BI
- Databases: Databricks, Microsoft SQL, Oracle, MySQL, Postgres
- Programming: Python, C#, PHP, Javascript, C, C
- Source Control: SVN, GIT, TFS
- Data Curating
- Advanced SQL
- Data Pipeline Design
- Data Modeling
- Data Warehousing
- ETL Development
- Database Management
- Performance Tuning
- Data Analysis
Timeline
Senior Data Engineer
Oportun
03.2022 - Current
Data Engineer
The MSR Group
06.2017 - 03.2022
Software and Database Engineer
University of Nebraska Medical Center
10.2016 - 06.2017
BI& ETL Developer
Tata Consultancy Services
12.2012 - 10.2015
MS - Management Information Systems
University of Nebraska
Bachelors - Computer Science and Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Heidi BarronHeidi Barron
VP of Store Development, Facilities & Procurement at OportunVP of Store Development, Facilities & Procurement at Oportun
Carmen AraujoCarmen Araujo
Loyalty Representative at OportunLoyalty Representative at Oportun
Anthony Steven LopezAnthony Steven Lopez
Bilingual Customer Service Representative at OportunBilingual Customer Service Representative at Oportun
Maria ToledoMaria Toledo
Member Loyalty Reepresentative at OportunMember Loyalty Reepresentative at Oportun
Patrick ShieldsPatrick Shields
Assistant Aquatics Technician at The Cove at The Lakefront - Town of Little ElmAssistant Aquatics Technician at The Cove at The Lakefront - Town of Little Elm