| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
EMAIL AVAILABLEOBJECTIVESeeking a position as Database Administrator to utilize my strong technical skills, problem-solving abilities, and commitment to excellence.EDUCATION
Bachelor of Science in Computer Science, University of Windsor, Ontario, Canada
CERTIFICATIONS
Oracle9i-certified Database Administrator, 07/2004
Oracle9i-certified Developer (PL/SQL and Forms & Reports Developer), 05/2004
PROFESSIONAL EXPERIENCEBANK OF AMERICA, Charlotte, NC July 2021 July 2023Tableau Administrator- DeveloperPrimary Responsibilities: Serve as an integral member of the team responsible for the following: Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance. Perform reports deployment, schedule data refresh and monitor background activities. Troubleshoot MS SQL queries through Tableau data connectors to facilitate report s data retrieval efficiently. Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment. Assist developers setting up database driver s connections and best practices for writing SQL codes for ultimate data retrieval with allowed time window. Translate business needs into data analysis, business intelligence data sources and reporting solutions. Develop visualizations for dashboards and reports using various data-sources with visualization such as charts, filters, calculations and parameters. Worked closely with lines of business and developers to troubleshoot reports and identify enhancements using Tableau Desktop. Review, assess current state and identify improvement opportunities and best practice recommendations. Build dashboards and reports using Tableau Desktop. Serve as a primary point of contact for Production Support issue resolution. Apply policy changes in Tableau server across sites to achieve maximum performance and stability. Serve as a one of the primary point of contacts for production support issues and resolution.BOSTON SCIENTIFIC, Marlborough, MA Oct 2020 July 2021Oracle Database Architect - DeveloperPrimary Responsibilities: Responsible for helping with the implementation of next generation cloud-based ClinicalTrial Management System (CTMS). Write system requirements configurations, test and validation plan.
Develop and troubleshoot ETL packages using Microsoft SQL Server Integration Services (SSIS) and bulk-loading utilities.
Performance Health-checking, Troubleshooting SQL Server including performance issues.
Assist in designing, planning and managing the data migration process. Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements. Prepare data migration plans including migration risk, milestones, quality and business sign-off details. Manage assigned risks and monitor potential impacts as part of the data migration plan. Perform source system data analysis in order to manage source to target data mapping. Perform SAP Business Objects development and scheduling reports. Create and maintain Tableau reports and maintain related administration duties.BANK OF AMERICA, Charlotte, NC June 2020 Oct 2020Tableau Administrator - DeveloperPrimary Responsibilities: Serve as an integral member of the team responsible for the following: Perform development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment. Research and identify needs, goals, and business models by collaborating with the end users, stakeholders and support partners. Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance. Serve as a primary point of contact for Production Support issue resolution. Review, assess current state and identify improvement opportunities and best practice recommendations. Define, establish and lead effective routines and reporting mechanisms to drive the maturation of service operations. Build comprehensive dashboards and reports using Tableau Desktop.UNIVERSITY OF ALABAMA MEDICINE, Birmingham, AL June 2017 February 2020Business Intelligence Administrator - ETL Developer Developed, maintained and supported an enterprise data warehouse system and corresponding data sources, including Tableau, Talend, SAP Business Objects, and Informatica. Performed Tableau server upgrade (v2019.1). Added users and groups and provided security access across the organization.
Helped identifying problems causing Tableau server crashes and resolved them successfully.
Monitored scheduled BusinessObjects reports and Tableau extracts to ensure the maximum uptime and performance. Modified weekly and daily Tableau server backup scripts on windows servers scheduler. Created Users, Groups and User access levels and provide access to users on request of the Application SAP BI team and Tableau server. Monitored daily Business Object running reports, Informatica nightly load, Talend ETL jobs and PL/SQL Daily running jobs for error checking and assisted in identifying and resolving issues. Overseas the operation of Clinical Trials Management Systems. Create, modify and enhance existing PL/SQL codes in Oracle 12c to resolve business requirements. Fixed code issues in PL/SQL running in Oracle 12c related to Billing and Unix cron scheduled jobs to add additional required fields. Wrote efficient SQL queries and modify UNIX scripts to enhance existing reports. Tracked error codes in informatica related to PL/SQL ETL nightly jobs and resolved them. Performed Weekly meetings and communications with other departments to perform QA testing. Migration of reports/ universes/ users along with security settings from one DEV/QA stage to PROD Environment using Promotion Management tool following the Change Management Process.Tools Used: PowerInsight BusinessObjects, Tableau, Talend, TOAD for Oracle, SQL Developer, UNIX SunOS.WELLS FARGO BANK April 2016 May 2017Database Architect - Developer Analyze and Designed Oracle database in relation to customer complaints. Work with Micro Strategy reporting team to conduct weekly/monthly and yearly dashboards. Analyze and write complex SQL queries with performance tuning and data retrieval. Write views, functions and procedures in PL/SQL in order provide data to different groups across the bank while preserving security and access controls through roles and privileges. Work closely with DBAs in order to refresh data from production to lower environments (DEV, UAT, and IST). Monitor data replication through Golden Gate and ensure data flow is occurring in real time for best results.
Communicate with DBAs, Business analysts and project managers in order to define projects in scope and expected resolutions. Work with reporting managers and developers in order to maintain coding best practices and data retrieval in the most efficient way possible. Work with UAT testers and business users in order to complete their sign off on testing plans and results. Construct logical and physical designs across multiple databases and provide recommendation, tools used Toad data modeler and MS Access. Resolved issues through JIRA tickets and communicate with different partners to achieve a proper solution. Attend daily meetings including weekly status and various discussions.Tools Used: TOAD for Oracle 12c, SQL Developer, JIRA, SUBVERSION, Golden Gate, Toad data modeler.INFINITY PROPERTY & CASUALTY CORPORATION, Birmingham, AL August 2015 March 2016Database Developer Architect Implement ETL solutions for data warehouse models. Analyzed and implemented oracle PL/SQL stored procedures and Pentaho PDI jobs to determine extraction methodologies and loading to operational data models & data marts.
Communicated with Business users to ensure data is accurately loaded into the data warehouse and expected results are met. Worked with different level of developers and management to ensure all enterprise data warehouse standards are applied and maintained properly. Monitored daily and monthly jobs in the dashboard and resolved data load issues whenever occurred. Attended training and conferences (Pentaho, Vertica). Created and resolved PL/SQL bottlenecks and transferred successfully to Pentaho jobs Helped in designing and implementing new dimensions into the warehouse.. Monitored and applied fixes to daily/monthly scheduled ETL jobs.
Created reports to compare DDL differences between Oracle database and Vertica. Tools Used: Pentaho, PL/SQL, SQL ServerBBVA COMPASS BANK, Birmingham, AL April 2013 July 2015Data warehouse Developer Analyst Supporting implemented DW solutions by monitoring, tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues. Tuned MS SQL Queries to enhance ETL operation performance. Monitored database workloads real-time to ensure optimal performance and no blocked sessions. Worked on design and implement reverse engineering mart and history data from the Credit risk database to the source as part of CCAR project completion.
Applied fixes to key elements essential for CCAR and the bank s ability to build models accepted under federal regulations. Resolve long running processes by developing new retrieving methods.
Develop and test PL/SQL procedures, functions and package. Transform long running SAS codes into utilized Oracle procedures/functions. Develop SQL server procedures to enhance reporting purposes.
Perform a basic informatica mapping to stage tables and measure output for accuracy.
Test and resolve ETL processes bottlenecks, schema mapping and data inconsistency.
Gather requirements and architecture solutions for PL/SQL project. Track product development issues and tasks with JIRA, interact with Business analysts and QA testers to achieve required fixes/enhancements or new requirements. Provide training, guidance, and assistance to other developers and DBAs if needed.QUALIFACTS SYSTEMS INC, Nashville, TN December 2011 November 2012Team lead Developer - Administrator Standardized Documentation Progress Report (MSDP) state forms and reports in the behavioral health industry for the state of Massachusetts. Oracle application architecture and database design with Mod PL/SQL, XML/JavaScript/HTML. Data modeling, SQL, Advanced Queues, PL/SQL development, Development of Stored procedures, Triggers. Work closely with IT manager as well as other team members to produce specifications which can be executed and reviewed and validate the deliverables. Work on application development projects as well as enhancements and maintenance of existing applications. Worked with Pentaho reports and resolved critical bottlenecks which enabled the capability to map state reports to be available on real time forms submission. Work on JIRA tickets promotion, track and resolve issues raised by QA testing and help in promoting codes to various environments (i.e. QA, UAT, IMP, CERT and Production). Performance tuning - analyzing query plans and query tuning, partitioning, optimizer hints.VANDERBILT UNIVERSITY, Nashville, TN July 2011 November 2011ETL Developer Tuned PL/SQL packages and views to optimize performance and resolve bottlenecks, problems and space utilization in acceptable time frame. Implement and test DTS packages utilizing project deployment outputs. Troubleshoot and apply corrections for availability and performance of database objects such as views and packages. Create universe reports using universe designer to utilize BI reporting requirements. Implemented data replication using Golden Gate and code replication using materialized views and conversion of ETL processes to mask the business layers which dropped ETL process time more than 100%. Create and maintained meta-data repository for version control and definition/maintenance of database code and objects. Participate in peer-based design reviews and technical reviews and Troubleshoot performance issues. Implement and monitor controls, processes and technologies to ensure high availability and reliability for the production database environments for database systems.CROWN CASTLE INTERNATIONAL, Pittsburgh, PA October 2010 July 2011Database Administrator - Developer Apply Oracle relational database modeling both logical and physical including reverse
Engineering to resolve business problems (Tools: Erwin). Work collaboratively with project managers adhering to DBA team standards, and contribute to leadership discussions. Work with DBAs to implement UNIX scripts to automate database refresh process for different databases (Oracle 11g) across different environments. Monitor and plan for database space utilization and growth. Create Databases, tables, table spaces, indexes, FKs, sequences and triggers. Work on SQL & PL/SQL tuning, packages, materialized views, PL/SQL stored procedures, triggers and functions. Built and developed reports with Business Objects Universe Designer in multi-dimensional star schema database structures. Worked on oracle packages, procedures, triggers and functions to utilize web focus reports and meet BI requirements.MAYO CLINIC, Rochester, MN June 2010 October 2010ETL Developer - Administrator Controlled migrations of scripts, stored procedures, schema changes, reference data changes and menu changes through the development life cycle. Install, migrate and upgrade oracle database environments (10g to 11g) aligned with corporate standards. Validation and performance tuning of SQL and PL/SQL scripts to enhance system performance and reduce memory clogging, hard disk read/write and efficiency of various transaction systems and reporting servers. Modified and tuned queries running to produce Business Objects reports. Some in which were mission critical. Modified and tuned queries running in internal portal application in which doctors and nurses used across mayo clinic to get quick access to best practices and procedures they would need to perform when a patient is brought to the emergency with life threatening condition. Worked closely with Java developer to make sure sessions and cursors are managed correctly with minimum impact on database performance. Table loads with Oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process. Extraction of data from different excel files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting. Implemented Basic Replication using materialized views. User creation and enforcing security using privileges and roles. Worked closely with data architect to ensure definitions fit within Mayo standards. Created and managed schema, objects, roles, and privileges and ensured data integrity. Administered all schema objects, including tables, clusters, indexes, views, sequences, synonyms, grants, triggers, packages, functions and procedures. Monitored and optimized the performance of the application within the schema and offered assistance to developers in optimizing their applications, queries, etc. Worked with SysDBA in tuning database/instance. Build, enhance and define Crystal Reports specifications to help BI department be more efficient and solve various issues.
Batch loading of data into production tables from approved data files given by development staff of vendors or applications. Ensured data load into ORACLE tables is as accurate as the data source. Data exception-handling process and bulk loading, export and import utility. Propagate data from test/development to production in a controlled process. Worked as part of a team and provides 7x24 supports when required. Provided training to junior members of the DBA team on various database aspects.
CLAIM SECURE INC. Sudbury, Canada April 2009 April 2010ETL Developer - Reporting BI Administer, create, upgrade, maintain and monitor sessions/locks using MS SQL Server Management Studio (SSMS) and customize manually and using SQL Queries. Developed and designed technical unit testing SQL Server stored procedures to implement Crystal Reports assigned by BI reporting development objects. Managed user schemas, indexes, table spaces, and triggers. Performed query tuning, index building and gather statistics. Modified, maintained and developed SQL codes to resolve reported problems. Developed and troubleshoot oracle PL/SQL packages, procedures, triggers. Worked with Web Applications ASP.NET in a .NET Framework/IIS to enhance and tune performance. Performed system rules and validation using SQL, XML and file conversion. Performed Data zaps and unit testing promotion to production. Assisted in production data refresh to UAT and Development. Database monitoring for deadlocked process and maintaining logs/Backups using Imp/Exp Utilities.US STEEL, Pittsburgh, PA April 2008 March 2009Database Architect - Administrator Participated in data modeling of various modules across applications (Erwin). Performed query writing/tuning and provided technical recommendations. Developed cross validation rules to ensure accuracy. Utilized programming in PL/SQL to create procedures, functions and packages. Worked with developers and provided various DB support.
Worked on converting legacy system to Oracle ERP standards through MES Architecture Worked on complex SQL queries built under Cognos reports to enhance performance and retrieve data with satisfaction to BI requirements.
Involved in the definition and transition strategy between Oracle Enterprise Business Suite (EBS) and Oracle MES architecture to leverage equipment identifications between Oracle financials and their legacy system. Maintained consistency on the daily Messaging Queues transformation across ERP system and MES database.NORTHROP GRUMMAN, Pittsburgh, PA January 2007 January 2008Database Architect/SQL Analyst Developed and performed quality assurance activities and unit testing. Modified and maintained oracle procedures using SQL and Cold Fusion. Interacted with BI team in fine Tuning SQL and creating WebFocus reports. Wrote database scripts & PL/SQL stored procedures, functions and triggers. Developed SQL Reports using advanced queries in OLTP system and WebFocus. Participate in the development of an automated testing strategy and deliverable. Performed advanced queries on views, which was used in the metric reporting tools.UNITED REAL ESTATE May 2004 September 2005Oracle Developer/DBAON-LINE BUSINESS ASSOCIATES (OBACOM), Farmington Hills, MI June 1997 June 1998Oracle Analyst/DeveloperPROFESSIONAL SUMMARYORACLE/MS SQL Server DBA: Over 10 years experience as Oracle/MS SQL Server DBA on Windows and UNIX. Extensive expertise in Oracle database v9i, 10g, 11g and 12c.
Extensive expertise in MS SQL Server 2008, 2009, 2012, 2019.
Experience in SQL server administration and DTS packages implementation. Performed installation, deployment and maintenance of Oracle/SQL Server databases. Performed Data Modeling, Database Tune-up, and Query optimization. Solid business practice relational modeling and Data warehousing. Performed table and interface design, development of logical and physical data model/database (Erwin) in creating logical and physical design.
Proficient in DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table, table partitioning, index, sequence), space management (table paces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity). Experienced in managing features like Oracle Managed Files, Auto Space / Undo Management, creating materialized views for query optimization and reporting environments. Extensive Versatile team player with excellent analytical, communication and interpersonal skills.
ORACLE/MS SQL Server DEVELOPER: 25 years of experience designing, developing and supporting Oracle/MS SQL Server systems. Oracle Certified Professional: Oracle OCP9i PL/SQL, Forms and Reports. Proficient in SQL optimization and data retrieval with high performance, scalability and reliability. Complete project development, from analysis, design and building through to implementation and live running production. Acted as consultant on application projects and SDLC strategies. Experience on ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements. Strong advocate and user of SQL.
Extensive experience knowledge in creating and Tuning SQL queries for optimum performance and tuning database activities. Provide database performance tuning expertise to software development team in design, development and maintenance of core applications.
Extensive expertise in writing database scripts & PL/SQL Packages, stored procedures, functions and triggers.SKILLS SUMMARY Operating Systems: Windows XP/2000, HP/Solaris UNIX SunOS. Programming Languages: SQL, PL/SQL, Oracle Forms, C, JavaScript, .NET, ASP, JSP, Visual Basics, Cold Fusion, HTML, SAS platform. Databases: Oracle 9i, 10g, 11g, 12c, MS SQL Server2008-2019, Access, Vertica. Application Tools: Oracle Forms (Developer Suite 9i, Developer/2000), SQL Developer, TOAD, PL/SQL Developer, SQL *Plus, Informatica 9.1, MS SQL Management Studio, Pentaho, Kettle 5.2 (ETL Development). Reporting Tools: Crystal Reports, Business Objects, web Focus, Pentaho Reports, Oracle Reports, Cognos Reports, Micro Strategy, Pentaho PDI, and Tableau. Other Tools: Erwin, CVS, Star team, Clear case, Serena, JIRA, Toad Data Modeler 5.5. |
