We provide IT Staff Augmentation Services!

Database Consultant/etl Developer Resume

Boston, MA

SUMMARY:

  • 12+ years of experience in Systems Analysis, Data Analysis, Database Designing, Data Modelling, Data Warehousing, Testing Database Development and production support in Client/Server systems and applications across multiple domains which includes Banking and Payment Systems.
  • Highly experienced in applications which includes Debit Card Reconciliation and Accounting System (DCRS), Customer Relationship Management (CRM), Inter - Banking Mobile Payment Service (IMPS), ATM Reconciliation, General Ledger Management (GL), Cash Management, Transaction Monitoring System (TMS), Billing, Human Resource Management System (HRMS) and other reconciliation products with PCI DSS compliance.
  • Comprehensive experience in different areas of Design, Production System Support, Data Conversion techniques, Implementation, System Configuration and Customization of Oracle Applications.
  • Detailed study of client’s business processes including understanding their policies, system and statutory compliance requirements and mapping same in Oracle Applications with required fine tuning.
  • Highly proficient with DBA activities such as backup of databases, activity monitor, checking dead locks, performance monitor.
  • Proven experience in Database design (RDBMS), Database Migration as well as performance optimization skills.
  • Strong knowledge in developing PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links & triggers.
  • Sound knowledge of software development life cycle (SDLC) with substantial experience with object-oriented analysis, design, development, testing, implementation, deployment & maintenance of projects with large data.
  • Expertise in Table partitioning, performance tuning of SQL queries & PL/SQL programs and Oracle file handling utilities such as SQL loader & UTL FILE.
  • Highly experienced in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
  • Strong experience in debugging procedures and working in a tightly version-controlled and process oriented financial corporate environment.
  • Expert in creating/designing, Data Flow Diagram (DFD), Entity Relationship Diagrams (ERD), Functional Specifications Document (FSD), Business Requirement Document (BRD), System Requirement Specification (SRS), Technical Specification Document (TSD), User Manual, Standard Operating Procedure document (SOP) and operational documents using Microsoft Visio, Word, and/or Excel.
  • Highly proficient in operating MS SQL Server 2017/2012/2008 R 2/2008/2005/2000 suite of products like SSIS(ETL), SSRS and SSAS.
  • Served as the key point of contact/Liaison between onsite and offshore and coordinated and follow up with the offshore team to accomplish the milestones as per the project time line.
  • Proven mentor, trainer and skilled at communicating at all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence.
  • Extensive hands on experience using Oracle12c/11g/10g, Oracle 9i and SQL Server databases and several of its tools.
  • Adhered to project management practices and communication between software development teams, leading to smoother and more efficient implementation and better utilization of time and budgets.
  • Strong conceptual, analytical, and design skills with leadership qualities. Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

HIGHLIGHTS:

  • Product development
  • Relationship management
  • Solution architecture
  • Documentation & reporting
  • Mentoring
  • Troubleshooting
  • Process improvements
  • Change lifecycle

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2017/2016/2014/2012/2008/2005 , Oracle 8i/9i/10g/11g/12c, MySQL

Languages: T-SQL, PL/SQL, UML

Operating System s: Windows 7/Windows XP/NT UNIX, LINUX/DOS/ Windows Server 2010/2012

Tools: Microsoft SQL Server Management Studio/ SQL Developer/ Toad /Putty/ WinSCP/ Beyond Compare/ Exam Diff/ Snagit / MS Office/ MS Visio/ Bugzilla/ MS Visual Source Safe/ Edit Plus/ JIRA/ TRAC/ FTP/ Qlik Sense BI/ Power BI/ Spago BI /DOMO/Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Database Consultant/ETL Developer

Responsibilities:

  • Worked with Business owners, Product Owners to understand the existing product and implementing new features.
  • Involved in various stages like development, system Analysis and design.
  • Suggested creating Clustered and Non-Clustered indexes on tables.
  • Involved in project planning with project managers.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes.
  • Created SQL queries, tables, stored procedures , Indexes and functions to develop new requirements in the product.
  • Worked on PL/SQL and created table partitions to improve performance in oracle.
  • Used Joins, Sub queries, Temporary tables, Session Variables while implementing new features.
  • Integrating data from different sources and moving it to a central database based on Functional Specifications using Informatica Cloud.
  • Created data warehouse, data marts for analytical purpose (OLAP environment) and generated various reports using these data sets.
  • Used Mapping Designer and Mapping configuration to integrate huge set of data.
  • Scheduled daily task flow in Informatica Cloud.
  • Extract Transform Load (ETL) development using MS SQL 2007 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Wrote batch script and phyton script for file handling and bulk load automation.
  • Used Domo BI tool to handle customer’s existing data sets and reusing it to our project stream.
  • Reviewed and analyzed all interfaces, reports, set ups, versions, and modifications.

Environment: MySQL, Informatica Cloud, Oracle 11g/12C,MS SQL server 2008/2017 Domo, AWS S3 Bucket.

Confidential, Arlington, VA

SQL Developer & Reporting Consultant / Data Analyst

Responsibilities:

  • Interpret data, analyze results using statistical techniques and provide ongoing reports.
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
  • Acquire data from primary or secondary data sources and maintain databases/data systems.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
  • Worked with Business owners, Product Owners to add new features and enhancements in the product.
  • Created T- SQL queries, tables, Views , stored procedures , Indexes and functions to develop new requirements in the product.
  • Used Joins, Sub queries, Temp tables, Common Table Expressions(CTE) while implementing new features.
  • Developed multiple Adhoc reports using T-SQL queries and Stored Procedures in SQL Server for CRM users on day to day basis.
  • Handling all the performance tuning issues for smooth functioning of the product.
  • Work with management to prioritize business and information needs.
  • Locate and define new process improvement opportunities.
  • Tested various BI Tools Power BI, Tableau, SpagoBI, Qlik Sense to get the best results of data visualization.
  • Worked on SQData to test real time replication performance.
  • Implemented Qlik Sense for analytics from start to end and support.
  • Created various data visualization reports in Qlik sense which will help user to understand the contents and trends and expected trend.
  • Created Business Requirement Document (BRD) , Functional Specification Document (FSD) , Document of Understanding (DOU) for the Qlik Sense Data Analysis Project.
  • Reviewed and analyzed all interfaces, reports, set ups, versions, and modifications.
  • Scheduled SQL server agent jobs, scheduled reports for daily, weekly, monthly.
  • Created automated process for collecting data based on data analysis from OLTP environment to OLAP environment for the ease of Business Intelligence Implementation.

Environment: Microsoft SQL Server 2008/2012 R2 Enterprise edition, MS Visual Studio, Cold Fusion, Qlik Sense.

Confidential

Lead - Database Developer

Responsibilities:

  • Successfully managed, lead team of developers, analyst and testers for providing solutions to meet the business requirements.
  • Business Analysis Planning and Monitoring.
  • Independently take ownership of an aspect, task or group of tasks on a project and complete them before agreed upon deadlines.
  • Elicit requirements using interviews, requirements workshops, surveys, business process descriptions and use cases, scenarios.
  • Identifying solution approach and defining solution scope.
  • Produce comprehensive documents outlining user specifications, business processes, functional specifications, test cases and system recommendations.
  • Created Database Objects - Tables, Views, User defined functions, Triggers, Stored Procedure, and Roles.
  • Created complex joins, sub queries and T SQL queries for generating stored procedure, User-Defined Functions (UDF), Common Table Expressions (CTE), Temp Table, Table Variable and Views.
  • Understand the business requirements and implement the same in the system through SDLC.
  • Prepared queries and Procedures and handling performance tuning for the same.
  • Extract Transform Load (ETL) development using MS SQL 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Automated SSIS data loading package using SQL Server Agent.
  • Prepared and maintaining Traceability Matrix.
  • Identified Use Cases from the requirements and created UML Diagrams.
  • Participation in review discussions and project meetings.
  • Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor.
  • Interacting with stakeholders, technical teams on Business Functionality.
  • Provide on-going training and documentation to key users as new functionality is rolled out.
  • Preparing Policy Procedures and doing Process Mapping.

Environment: Microsoft SQL Server 2008/2014/2012 R2 Enterprise edition, Oracle 9i & 10g, MS Visual Studio (ASP.net,C#), Edit Plus

Confidential

Lead Database Developer

Responsibilities:

  • Involved in gap analysis to understand the requirements from the business users and end clients.
  • Project Planning / Resource Planning and approval of the same from product manager / change management committee.
  • Preparation of Technical Specification and approval of the same from the product manager.
  • Analysis/Clarifications of various Input Files (raw data) required for reconciliation & accounting.
  • Back End Configuration of Raw files/data in various data objects in oracle DB server.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Imported data through various environments by using SQL * Loader.
  • Created scripts for SQL Loader programs and to kick the programs on regular basis.
  • Involved in database development by creating PL/SQL functions, procedures, triggers, packages.
  • Created database Tables, Views, Sequences in Development and Production environment using PL/SQL, SQL*Plus, SQL Developer Toad.
  • Used joins, temp tables, tables variables.
  • Developed complex SQL queries and advanced Oracle PL/SQL code
  • Actively scheduled meetings to monitor the status of the project.
  • Performed UAT with stakeholder’s/clients and Onsite Deployment and Implementation of System.
  • Prepared user level and system level maintenance documentation.
  • Provided back end support to the Java based applications with huge and complex data.
  • Involved in optimizing code and improving efficiency in databases including re-indexing, table partitioning, updating statistics, recompiling stored procedures, packages and performing other maintenance tasks.
  • Scheduled SQL server agent jobs and alerts, scheduled reports for daily, weekly, monthly.
  • Created an automated process for the activities such as database backup processes.
  • Developed automated process for mailing reports to management, data management and data purging to handle large sets of data.
  • Functional and Technical testing of system for various Reports/ Settlement Screens.
  • Interacted with the Business users directly for the creation of new reports, Involved in the meeting with the team for the improvements of the old reports.

Environment: Microsoft SQL Server 2008/2012 R2 Enterprise edition, MS Visual Studio, Edit PlusOracle 9i & 10g, Java(J2EE)

Hire Now