Cecilia Howard Email & Phone Number

Atlanta, Georgia, Us

• Support the migration and re-engineering of legacy Oracle Forms applications utilizing modern technologies, including C# .NET frameworks, containerization, and Continuous Integration/Continuous Deployment (CI/CD)• Reverse engineer Oracle database procedures and triggers• Convert requirements into epics, user stories, or features and input into Team Foundation Server (TFS)• Provide support to several web-based Oracle Forms legacy Financial applications• Conduct troubleshooting of user issues• Perform data analysis/cleansing by compiling/executing SQL commands against an Oracle relational database to identify potential data issues and/or redundancy.• Assisting in unit, integration & load testing, and assisting with production support issues on Atomic Jobs.

Atlanta, Georgia, Us

• Prepared High-Level Design (HLD) documents, which included functional system coding requirements, and data mapping for new and existing database tables to support both internal and external interfaces. • Worked on data mapping design deliverables from legacy to new supply-chain application.• Wrote ad-hoc queries for reports, maintenance and other database functionalities as needed. • Deployed database code through automated processes from lower environment to higher environments • Analyzed requirements, developed and maintained SSIS processes to import data from multiple sources into the Oracle ERP database and vice versa. • Fixed bugs in the existing Segmentation Tool and assisting the offshore team in making sure the code adheres to best database practices for optimum performance. • Developed database code and conducted complex analysis for departmental needs to integrate appropriate workflow logic, created forms to display and upload data and installed and configured Auto Import to upload documents onto Share point location. • Optimized existing stored procedures and code for optimum data processing time, quick access time thru applications to the clinics. • Assisting QA team for testing the deployment scripts and making sure they meet the standards and expected run times. • Ran scripts to implement the 'Go-Live' phase of the project and worked, with clients, on ad-hoc basis to transition them completely into production. • Prepared the Requirements Traceability Matrix to ensure all the Client/business requirements were completed. • Worked in development, testing and maintenance phases of SDLC in the interface development project.

Atlanta, Georgia, Us

• Performance Tuning in SQL Server using SQL Profiler and Data Loading • Develop SQL queries, views, triggers, stored procedures, call functions, Triggers. • Creation/ Maintenance of Indexes for various fast and efficient reporting processes. • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan) • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). • Generated Crystal report for Assert Recovery which is used by the York facilities to print the shipment labels. • Work in Progress data were pulled out from the CVision database which is integrated with different set of programs. It is then delivered to the Client to match the JOB Operations in the Oracle ERP System loading. • Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to SQL server. • Requirements gathering, Analyzing and design of all the client requirements. • Analyze the Business logic which is used for AR invoice in Great Plains and get information from client and support team. • Analyze AR Invoice doc for data mapping from SQL server environment to Oracle environment. • Analyzing the requirements and discussed with managers and leads on the functionality. • Created TSQL Scripts to get data for Migrating Data from Legacy system (CVISION) to ORACLE ERP systems for research using SQL. This script is loaded on monthly run basis. • Created a SSIS package which loads data from Excel Source to stage database and then move data into sandbox and finally move this data into Production database. • Creating visualizations and dashboards for pilot projects using Tableau 8.x/9.x built on impala parquet tables and publishing on to the server for clients.• Exported the result set from HIVE to MySQL using Shell scripts.

Ma, 01824, Us

• Generated Bar Code integrated reports using SQL Server Data Tool for scanning the Manufacturing parts in Camstar.• Created variety of dashboard using Chart view, Gauge view, and Tracker view and also created Menu Item in the Epicor Interface and also gave permission changes in Epicor.• Used Joins and Complex sub queries for multiple table from different databases to reconcile the two companies Manufacturing Datasets.• Worked on RDL source code to changes the style of the report in SSRS.• Experience with delivering OLAP data to end user using Excel or other Tools/ Services. • Created Packing Slip which includes the order details and the patient agreement using SSRS in Epicor for Shipping processes.• Created financial reports like Audit report, Vendor spending report, Hyperion Extract, Purchase Order Report etc. for financial department.• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.• Demonstrated understanding of relational database design and architecture.• Created reports with dynamic sorting, defining data source and Data Sets for the report. Generated variety of reports such as Linked report, Drill-down, Drill Through, Ad- hoc reports and Sub reports, and formatting those using SSRS.• In depth understanding of Tableau Desktop architecture for designing and developing dashboards, with experience in creating various visualizations using Bars, Lines, Pies, Maps, Scatter plots, highlight tables, etc. based on different situations to visualize data clearly.• Strong experience in using Tableau Desktop, creating highly interactive data visualization Dashboards and Reports using features such as Data Blending, Filters, Parameters, Calculations, Actions, etc. • Extracted large volumes of data from various data sources and loaded the data into target data sources by performing differet kinds of transformations using SQL Server Integration services (SSIS).• Developed, monitored and deployed SSIS packages.

Master'S Degree, Management Information Systems

Bachelor Of Technology (B.Tech.), Information Technology