Deepthi Boosa
Herndon,VA
Summary
Results-driven Data Analyst/ETL/Business Analyst with over 15+ years of experience in data analysis, specializing in financial reporting, data warehousing (DW), and business intelligence (BI) using methods such as Agile and hybrid methods, data governance, Informatica Data Quality, AXON, EDC, metadata management, CDC, IDMC, and IDQ. Proven track record of delivering projects on time and within budget across diverse industries, such as banking, finance, retail, and telecom. Core competencies include Agile methodologies, data governance, Informatica Data Quality, and effective systems integration. Recognized for strong problem-solving abilities, and collaboration skills that enhance productivity and efficiency in software development. Delivered successful projects within budget and set time frames. Expertise includes design, development, testing, reporting, and project management. Writing technical specifications to be provided to the developers; supporting ETL-related project development; producing code; using Informatica standards; implementing data integration best practices and conventions; performing tuning and partitioning; being responsible for deployment; helping with data architecture, data warehousing, and data mart modeling; identifying potential issues; and working closely with database administration team members to handle concurrent ETL and reporting query jobs. Innovative professional in software development, known for productivity and efficiency in completing projects. Possess strong skills in algorithm design, system architecture, and code optimization. Excel in problem-solving, communication, and teamwork, ensuring successful collaboration on complex projects.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Senior BI/ETL Reports Developer
United States Courts
DC, USA
08.2022 - Current
- Company Overview: The PACT360 is a law enforcement-led community prevention education system designed to address existing drug issues and rapidly respond to emerging drug threats.
- The goal is to help reduce illicit drug use and its accompanying criminal behavior, thereby improving the safety and quality of life of the community.
- Website: https://www.uscourts.gov/.
- Working a lot with Snowflake Cloud Data Integration, on-premises ETL tools, and automated scripts.
- Data governance, IDMC, Informatica powerCenter, Snowflake, ETL data loading and transformations, Informatica Data Quality, AXON, EDC, Metadata Management, SQL Server, Teradata, Oracle, Netezza.
- Has experience with enterprise data management application packages (data discovery, data modeling, data integration, data quality, metadata management) like IBM Information Server 9.1 Analyzer, IDA, Metadata Workbench, Business Glossary, FastTrack, Information Governance Catalog - IGC, and Data Replication - CDC (Change Data Capture), as well as Informatica Power Exchange CDC, IDQ Metadata Manager, AXON, EDC, and Talend.
- Has solid experience in visualizing the data analytics using SAP BO and Tableau.
- Has broad understanding and experience with real-time analytics and business intelligent platforms. Also,
- Strong interpersonal and excellent committed, result oriented, hard working with a quest and zeal to learn new technologies
- Documentation of the user requirements based on functional specifications
- Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio
- Involved in writing complex SQL scripts that include transaction statements, validation of database objects and exception handling to facilitate functionality in various modules
- Handled errors using exception handling extensively for easy debugging and display of error messages in the application
- Created audit tables and implemented complex business logic using triggers. Used cursors and cursors with dynamic SQL to retrieve data and process it
- Maintained table performance by following the tuning tips like normalization, creating clustered and non-clustered indexes and collecting statistics
- Converted the complex business logic and calculations into coding. Created ETL packages using heterogeneous data sources Snowflakes, SQL Server, ORACLE, Flat Files, Excel source files, XML files etc
- Works a lot with data visualization reports and dashboards (SAP BOBJ, QlikSense, Tableau, Power BI)
- Good experience with Rest API components and PostMan
- Good experience with data modelling, data analysis. Develop and maintain technical documentation and operational procedures for the changes and new solutions.
- Ensure data integrity and quality across the ETL pipeline by automated error handling and validation procedures. Create and maintain technical documentation for ETL workflows, processes, and jobs.
- Create test cases and perform Unit Test, System Integration test and document the results and errors
- Collaborated with DBAs to create aggregate tables to support universes and dashboards. Involved in review of various objects and created test case and test plans in different environments.
Senior ETL/reports Developer
Skuld
Newyork, USA
01.2016 - 07.2022
- Company Overview: In the SKULD company, we have a hierarchy for the guidelines and requirements depending on the product and product line, they are further segregated into several GL accounts
- Depending on these GL accounts, the policies and claim amounts are distributed
- Website: www.skuld.com
- Build multiple ETL jobs to follow the hierarchical structure of the company and reports based on business requirements
- Has experience on enterprise Data Management application packages (Data discovery, Data modelling, Data integration, Data quality, Metadata management) like IDMC, IBM Information server 9.1 Analyzer, IDA, Metadata Workbench, Business Glossary, Fasttrack, Information governance catalog - IGC and Data Replication - CDC (Change Data Capture) and Informatica Power Exchange CDC, IDQ Metadata Manager, AXON, EDC and Talend
- Extract, transform and load data from multiple sources into QlikView and Power BI
- Perform data and system analysis to translate business needs into technical code
- Interacting with clients to conduct business analysis and finalizing Component Design, functional and technical specifications in various subject areas
- Suggesting appropriate as well as technology-based solutions for the customers in various verticals resulting enhancing functional efficiency of the organization and achieving business excellence
- Contributing to the design, work estimation, development, testing, troubleshooting, hands on experience in Performance Tuning, ability to manage project issues and risks
- Collaborated with Analytics and BI teams to develop globally adopted calculations and reporting on demand solutions
- Lead development and implementation of ETL processes
- Carry out data cleaning and preparation tasks
- Maintain and support code Troubleshoot issues with existing data model and dashboard
- Coordinate with business to design an operating model that integrates business processes with technical solutions
- Define and evaluate strategies and rules for pension calculation for different types of customers
- Exported reports to Repository to make resources available to users
- Coordinate handover between project and support team after release
- Published and scheduled business reports for users using publication
- Sets up SQL queries to improve performance to report update time
- In the SKULD company, we have a hierarchy for the guidelines and requirements depending on the product and product line, they are further segregated into several GL accounts
- Depending on these GL accounts, the policies and claim amounts are distributed
- Website: Not provided
Senior BI-analytics and Project Lead
State Of Wisconsin
USA
01.2011 - 01.2016
- Company Overview: Website: Not provided
- Design, create, manage and troubleshoot Informatica workflow processes
- Should have experience in scheduling the Informatica mapping using the Informatica workflow manager
- Should have knowledge of Data Modeling / Data warehouse Designing concepts
- Experience in analysing SQL plan
- Document details of Informatica processes and coding
- Strong skills in writing Stored Procedures, Packages, triggers, Views
- Provide performance improvement related guidance to the Informatica team members
- Developing web service integrations on Informatica Cloud Integration Hub (Current Version)
- Perform systems/data analysis to implement Informatica mappings and workflows, shell scripts and stored procedures
- Flexibility and the ability to work independently
- Hands-on experience in Oracle & SQL
- Stored procedures
- Design, develop and unit test Informatica ETL processes
- Experience with requirement analysis, design, development, testing and documentation including version control practices and technologies
- Communicate with business users to collect and understand requirements, socialize ideas among peers, and document work products
- Worked as a BI / BO consultant and collected business requirements and deliveries for reporting requirements together with functional end users in the business areas
- Analyzed and identified business content and data sources for the Enterprise Data Warehouse
- Created and maintained documentation of deliveries from Universe and SAP Business Objects
- Worked with several data operators and connected these data providers based on the requirements
- Involved in establishing hierarchies and linking universes (linked)
- Developed queries using SQL programming to improve report performance using complex searches
- Created new universes in XIR2 from scratch, from universes migrated from XIR2 and upgraded from XIR2 to XI R3
- Created financial reports, charts using Universes as the main database provider
- Reports such as quarterly variance, regional, actual versus forecast, balance sheet etc
- Were developed
- Developed scorecard reports and Deski reports with freehand SQL
- Wrote extensive validation SQL for data validation and quality assurance
- Involved in reviewing various objects and creating test cases and test plans in different environments
- Website: Not provided
Senior BI-analyst and developer
St. Jude’s Medical
USA
01.2010 - 01.2011
- Company Overview: Website: Not provided
- Skilled in analyzing user requirements, comparing the old and new requirements, documenting results, and communicating gaps and possible problems to the relevant groups as an analyst
- Extensive knowledge of SQL for data validation and quality assurance
- Project manager for a team of four people with direct interaction with the US client
- Design and develop business intelligence solutions
- Provide performance improvement related guidance to the Informatica team members
- Developing web service integrations on Informatica Cloud Integration Hub (Current Version)
- Perform systems/data analysis to implement Informatica mappings and workflows, shell scripts and stored procedures
- Created new universes in XIR3 from scratch
- Converted more than 400 reports from Desktop Intelligence to Web Intelligence in BOXIR3
- Created new Ad-hoc reports using Desktop and Web Intelligence
- Involved in training and educating business objects, XIR3 capabilities, navigation specific information and significance to move to Web Intelligence from Desktop Intelligence
- Worked on hierarchies, Global filters and Universe filters
- Interacted with users to analyze the changes for improvement they needed in existing reports, and developed the reports to satisfy their needs and requirements
- Website: Not provided
SAP BO/BI developer
S V Technologies Inc
USA
06.2009 - 08.2010
- Company Overview: Website: Not provided
- Created and maintained documentation of deliveries from Universe and SAP Business Objects
- Worked with several data operators and connected these data providers based on the requirements
- Involved in the establishment of hierarchies and interlinking of universes (connected)
- Developed scorecard report and Deski reports with freehand SQL
- Extensively involved in production support by monitoring Daily/Weekly/Monthly data and loading these uppp in the BI system from various source systems
- Worked a lot with formatting of the reports according to user requirements
- Used Web Intelligence to create, edit and specify various options for the company's documents
- Website: Not provided
SAP BO developer and customer service
ICICI Bank Ltd.
India
06.2007 - 04.2008
- Company Overview: Website: Not provided
- Designed and developed Business Objects applications using BOXI
- Developed user interface screens using data list and grid view based on requirements
- Know how to create WSDLs using Query as a Web Service (Qaaws) from different data sources
- Understand design, development, distribution and maintenance of universes using Business Objects designer
- Created Universe for Ad-hoc and Canned Reporting purposes based on DDL
- Developed scorecards report and also Deski reports using freehand SQL
- Involved in performance tuning and optimization of Business Objects reports
- Website: Not provided
Education
Master’s - Business Administrasjon
California
USA01.2010
Bachelor’s - engineering
JNTU
India01.2006
Skills
- Informatica Powercenter
- Snowflake data Integration
- IDMC
- ETL-development
- Oracle
- Teradata
- Netezzza
- SQL server
- SAP Business Objects
- Power BI
- Analytics
- Software Life Cycle SDLC
- Agile/hybrid methods
- Data modeling
- Business intelligence
- Metadata management
- Technical documentation
- Rest API
- Application development
Personal Information
Title: Senior BI/ETL Reports Consultant
Languages
- English, Fluent
- Norwegian, Good level
- Indian, Native
Certification
- PowerCenter Data Integration 10 Developer – Informatica 10.1.1
- Informatica Cloud Professional
- Power BI Data Analyst Associate
- SAP BusinessObjects Business Intelligence Platform 4.2
Reference Projects
- United States Courts, Senior BI/ETL reports developer, Washington, DC, 08/2024, Present, IICS (Informatica Cloud/PowerCenter), BI-development, Snowflakes, Oracle Database, SQL, SAP BOBJ
- Skuld, Senior ETL/reports developer, New York, NY, 05/2018, 07/2024, IICS (Informatica), Oracle Database, PL/SQL, POSTMAN, API’s, Power BI, Python, Kimballs principles and methodology, Visual studio 2019, QlikSense, Azure
- KLP, Project Leader, Oslo, Norway, 07/2013, 04/2018, IICS (Informatica), Oracle Database, PL/SQL, Qlikview, Data Vault 2.0
- State Of Wisconsin, Senior BI-analytics and Project Lead, Madison, WI, 01/2011, 12/2013, Informatica, SAP Business Objects, DWH, SAP Administration, Training to super users and users
- St. Jude’s Medical, Senior BI-analyst and developer, Memphis, TN, 01/2010, 12/2011, Informatica, SAP Business Objects, DWH, SAP Administration, Training to super users and users
- S V Technologies Inc, SAP BO/BI developer, USA, 06/2009, 08/2010, Informatica, SAP Business Objects, DWH, SAP Administration, Training to super users and users
- ICICI Bank Ltd., SAP BO developer and customer service, Mumbai, India, 06/2007, 04/2008, SAP Business Objects, DWH, SAP Administration
Additional Competencies
- Informatica Powercenter
- IDMC
- ETL-development
- Snowflakes
- Oracle
- Teradata
- Netezza
- SQL server
- SAP Business Objects
- Power BI
- Analytics
- Software Life Cycle SDLC
- Agile/hybrid methods
Affiliations
- School clubs (e.g., debate club, chess club, science club)
- Tutoring for free on weekends
- Event Organizer
Languages
English
Full Professional
Norwegian
Professional
Telugu
Native/ Bilingual
Hindi
Native/ Bilingual
Swedish
Professional
References
References available upon request.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Senior BI/ETL Reports Developer
United States Courts
08.2022 - Current
Senior ETL/reports Developer
Skuld
01.2016 - 07.2022
Senior BI-analytics and Project Lead
State Of Wisconsin
01.2011 - 01.2016
Senior BI-analyst and developer
St. Jude’s Medical
01.2010 - 01.2011
SAP BO/BI developer
S V Technologies Inc
06.2009 - 08.2010
SAP BO developer and customer service
ICICI Bank Ltd.
06.2007 - 04.2008
Master’s - Business Administrasjon
California
Bachelor’s - engineering
JNTU
Similar Profiles
Selma BarimacSelma Barimac
United States Pretrial Services Officer at United States CourtsUnited States Pretrial Services Officer at United States Courts
Deborah A. CatoDeborah A. Cato
Senior Legal Secretary at United States District CourtsSenior Legal Secretary at United States District Courts
Ana Lilia AldreteAna Lilia Aldrete
Operations Clerk at United States Federal Courts - District Clerk's Office - Del Rio DivisionOperations Clerk at United States Federal Courts - District Clerk's Office - Del Rio Division