SHYAMALA HITHERSAY

• Delegate tasks to programmers and software developers, Coordinate code inspection protocols to test the performance.
• Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
• Establish deadlines for team members to achieve milestones for the projects, Made executive decisions to provide direction for the project management team
• Attend meetings with clients, stakeholders and upper management to discuss the project objectives
• Assess the technical skill set of team members to assign tasks effectively
• Monitored organizational spending during the project to maintain the budget
• Evaluated the success of projects after completion
• Automated the import, extract and query activity using automation studio
• Used Dynamic content for subject lines, build nightly automations to create data retention extensions and data created in different file formats to be loaded in Heritage database system
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary
• Reviewed and fine-tuned stored procedures and triggers before production migration
• Responsible for creating Azure Data Factory pipelines/SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources from different third-party companies and exact target
• Developed Power BI reports, Matrix Reports, Tabular Reports, and Drill Down and Parameterized reports using RDL for executive analysis of auction sales and customer purchase behavior
• Worked with Business Users gathering their requirements and actively supporting various issues and providing their solution
• Handle team meetings as a team coordinator for cross teamsand also worked in the role of event manager for data team which helped a lot with team collaboration
• Streamlined internal processes through the implementation of project management tools, improving overall efficiency within the marketing department.
• Collaborated with cross-functional teams to develop cohesive marketing strategies, resulting in improved company performance.
• Created many data extensions to accommodate custom scenarios, configured and designed Journey’s using Journey builder
• Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.

Environment: SQL Server 2012-2022 , Azure Data Factory, Power BI, Exact Target – salesforce email marketing tool, Visual Studio 2012-2022, VFS, VSS

• Analyzing design documentation requirements and business scenarios, which are to be implemented according to the business specs
• Created SSIS packages to download data from FTP sites and populating into different databases and tables
• Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
• Created SSIS packages to load data from the excel sheets that are generated daily and accurate mapping tables created in the database with correct referential integrity and avoid any mismatch with data, this process was monitored to eventually replace the excel sheets
• Deployed packages on different servers and also performed scheduling packages with daily/monthly jobs, data validation, email notification on error and correction/formatting of incoming data
• Analyzed existing SQL queries to identify opportunities for improvements.
• Created Triggers to enforce data and referential integrity
• Created SSRS reports which would help users to view data required in different formats with filtering capability to gain ability to look at granular level data- types of reports includes Matrix Reports, Tabular Reports, Drill Down and Parameterized reports using RDL

Environment: SQL SERVER 2008, C++, .Net, SSIS, SSRS, VSS, Management studio 2005, Business Intelligent studio

• Analyzing design documentation requirements and business scenarios, which are to be provided by the issue under test
• Creating SSIS packages to perform the ETL transformations and load into an intermediate scorecard database which will eventually be used for dashboard graphs
• Scheduling packages with daily/monthly jobs, data validation and correction/formatting of incoming data
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using T-SQL
• Created SSIS packages to download data from FTP sites and populating into different databases and tables
• Communicated with revenue team, third party vendors, Product Managers and gathered the information for the project requirements

Environment: SQL SERVER 2008, C++, .Net, DTS, SSIS, VSS, Management studio 2008, Business Intelligent studio, Business Objects XI (3.0), Remedy

• Closely worked with different business analysts, App team and QA team to analyze understand and gather business requirements, develop project plan
• Used Agile project methodology and involved in sprint planning and scrum meetings to meet project deadlines
• Worked with scrum master to create user stories and provide detailed approach plan to work on each solution
• Collected baseline data for different costumers in different environments (QA/Prod) for all the ETL and reports related to the app to have a gauge for the performance of the reports, also helped in estimating the scope for tuning
• Worked on analysis/assessment of current database design and redesigned the database to allow scalability, performance and future redesign – worked with architect to come up with a design which was user centric/customer centric approach so that the dataset to use during any user setting changes in the application would require very less processing time
• Developed dynamic Sql/indexed views and tables to allow create customer specific objects which aid in run time calculations - when the user changes preferences on the fly
• The response time for certain reports were reduced from a min to as low as 5 sec using this kind of approach
• Performance tuned stored procedures, created user defined functions, clustered indexes on fact tables and batch processes which would be used for pre-aggregating some analytical data for nightly processing, worked with QA team to help resolve any data discrepancies
• Environment: SQL SERVER 2000, SQL SERVER 2005, SQL SERVER 2008, SSAS, SSRS, Management studio 2005, Business Intelligent studio, SQL profiler

• SCUSA, formerly known as drive financial company is a leading financial company, with its Drive and Santander Auto Finance brands, the company provides full-spectrum auto lead and lending programs on direct and indirect platforms, adding to the existing programs and new programs like cash back refinance and road loans are incentive customer programs introduced into the market, this involved ETL development to load incoming data in different formats into SCUSA system and provide processed data in requested format to the vendors, as part of the process various strategic and snapshot reports were developed for end users for analysis purposes
• Job scheduling and accuracy of transfer of files for processing of time sensitive jobs were handled by Control-M job scheduler, efficient job scheduling tool
• Responsibilities and Job duties: Closely worked with different vendors and business analysts to analyze, understand and gather business requirements, develop project plan, design and test methodology documents
• Involved in converting DTS packages from SQL server 2000 to SSIS, these legacy DTS packages are decommissioned for better execution and error checking
• Batch scripts/SSIS packages were developed for loading bulk data into database objects and vice versa, CMD scripts were also written to move/Copy/Rename/Delete files as well
• Deployed Control-M special features like providing customized calendars setup for each client for their regular scheduling jobs and also provide notifications to vendors when missing files or receipt of files
• Automation process has been set up for a lot of alerts which enhanced efficient utilization of server resources
• Transform and Load of Data from different sources to output sources like tables, files using analytical services (SSAS)
• Designed, Transformed and Mapped different graphs according business requirements in OLAP (SSAS)
• Created cubes using SSAS, by determining suitable candidates for dimensions and measures while creating fact tables (demoralized tables) for star schema
• Design and develop and deploy new reports and enhancements to existing reports using Microsoft SQL Reporting Services
• Create subscriptions to provide a daily basis report

Environment: SQL SERVER 2000, SQL SERVER 2005, SQL SERVER 2008, SSIS, SSRS, SSAS, CONTROL-M Job scheduler, VSS, Management studio 2005, Business Intelligent studio, SQL profiler

• Closely worked with end-users to analyze and gather report requirements-reports provided by the Supply Chain team
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Developed Matrix Reports, Tabular Reports, and Drill Down and Parameterized reports using RDL
• Generated Monthly and Daily Inbound and Outbound Reports which had different monthly and daily activity metrics which involve a very detail understanding of the definitions of the metrics and creation of formulas to generate the desired metric
• Modified the existing database by adding tables and relationships to support online transaction system
• Created various stored Procedures and modified existing stored procedures to enforce the business logic
• Created Triggers to enforce data and referential integrity
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers
• Deployed reports on the company’s report manager server and used SQL profiler to trace the log files and validate the ETL and report results

Environment: SQL SERVER 2005, SQL SERVER 2008, SSIS, Access reports, VSS, Management studio 2005, Business Intelligent studio, SQL profiler

• Analyzing design documentation requirements and business scenarios, which are to be provided by the issue under test
• Creating SSIS packages to perform the ETL transformations and load into an intermediate scorecard database which will eventually be used for dashboard graphs
• Design and develop and deploy dashboard and snapshot reports for different utilities –SMS, UIC, Metro Nav using Microsoft SQL Reporting Services for business analysis purposes- these reports help provide performance metrics of each product
• Developed several tabular reports, matrix reports, and lists, sub reports for different applications and data subsets
• Scheduling packages with daily/monthly jobs, data validation and correction/formatting of incoming data
• Developed stored procedures to achieve specific data needs
• Created SSIS packages to download data from FTP sites and populating into different databases and tables
• Communicated with Finance team, Business people, third party vendors, Product Managers and gathered the information for the project requirements
• Environment: SQL SERVER 2005, C++, .Net, DTS, SSIS, VSS, Management studio 2005, Business Intelligent studio, Remedy

• Capture events from the front end, extract, transmit and load data (ETL) from weblogs to data marts using SQL server Integration services
• Unit testing performed to confirm that the events flow through the data marts
• Web analytics used to parse and load data
• All the changes involve a lot event tracking, web logging and modifying existing reports/enhancing the existing ones
• Understand and develop business process and requirements as it pertains to data within the customer business center, responsible for source system analysis, data loading and data validation from source systems interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner
• Design and develop and deploy new reports and enhancements to existing reports using Microsoft SQL Reporting Services
• Involved in converting DTS packages and report from SQL server 2000 to 2005 to match with the QA and production environments and resolved errors/issues that arises during the conversion
• Communicate with project managers and involved in conducting scrum meetings as to the progress of open items and work with other developers as needed using knowledge of information systems infrastructure, used Dolphin tracking approach to track listing click and view events
• Environment: SQL SERVER 2000 and 2005, SSIS, VSS, Management studio 2000 and 2005, Business Intelligent studio, Remedy, Test Director 8.1

• Analyze existing crystal reports and identify consolidation and standardizing opportunities
• Developed several tabular reports, matrix reports, lists, sub reports
• Developed reports in BIDS that includes row-level data, groupings, subtotals, formulas, custom functions, expressions and report parameters
• Responsible for the design and deployment of the report using SSRS and MS Excel and Access
• Created Ad Hoc reports by building models in report builder using SQL 2000 model designer and report builder
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and enterprise Manager
• Developed DTS packages to extract, transform and load data from source systems onto target systems (fact and dimension tables) through ODS and staging databases
• Created ad-hoc reports using SSRS
• Environment: SQL SERVER 2000, DTS, SSIS, crystal reports, VSS, Management studio 2000, Business Intelligent studio, Remedy, Test Director 8.1
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.

• Involved in Requirement gathering from clients and designed IC test chip process for data loads
• Assisted in designing and developing software test plans
• Analyzed, designed, implemented and maintained moderate to complex initial load and incremental data storage jobs
• Lead Laboratory characterization and verification efforts for validating designs
• PCB Design using Allegro or other equivalent tools
• Mixed Signal DAC and ADC characterization
• Manual and automatic test execution, consultation with development engineers to resolve problems
• Environment: Switches, Routers, TCP/IP, C
• Adapted quickly to new technologies and programming languages, enhancing overall team productivity.
• Collaborated with cross-functional teams to ensure seamless integration of new features.