OBJECTIVE:

Build high quality and innovative Database designs and systems. Pursued Masters in Advanced Computing and Data Architecture from a reputed institution. Worked for almost 15 years in various technical areas of IT project execution.

SUMMARY

• 5 Years at RI - Confidential as Data Architect, Data Modeler, Data Engineering Lead
• About 2.5 Years at Confidential as Lead Data Specialist
• 4 Years at Confidential Limited, UK as Sr. Database Developer/ Data Modeler
• Over 3 Years at Confidential, UK as Lead Database Developer
• 1.5 Years at Confidential as Database Analyst/Developer

TECHNICAL SKILLS:

• Architecture /Execution: Technical leadership, System design, Vendor Data integration, Technical solution architecture, Enterprise architecture, Technical team coordination, Enterprise Data Management, Innovation, Product development, Understand schedules, Manage delivery, Assemble and build great teams
• Data: MS SQL Server, MySQL, Metadata Management, Data Integrity Data Quality, Master Data, Tableau, Red Gate, Oracle, DB2
• Design Tools: ER Studio, Erwin, Enterprise Architect, Visio
• BI/ETL: MSBI Stack (SSIS/SSAS/SSRS), Tableau, Crystal Reports, Informatica, Cognos
• Languages: Python, Stored procedures, SQL, PL/SQL, T - SQL, Visual Basic, C, C++, Visual C++
• Scheduling Tools: JAMS, SQL Server Job Agent
• Cloud: Microsoft Azure

PROFESSIONAL EXPERIENCE

Confidential, IT, RI

Responsibilities:

• The vision is to modernize various legacy applications to latest Cloud/ Web based optimal platforms, which requires strong, secure, high optimal Data Architecture and design, maintain high quality normalized data and user-friendly Data sharing/Reporting suites.
• The Data Architecture involves supporting various applications, multiple Online Interfaces and Scheduled Batches for RI DMV/Revenue/DO-IT departments, involving a hybrid approach consisting of RDMS designed through ERWIN supports Cloud/ Web based/ Windows platforms which involves designing normalized Enterprise Data models as well as De-normalized Data Warehousing for archived data.
• The Database Development, Data movement, Data migration activities are supported by SQL MSBI suite, and involves various kind of sources and destinations from all 50 states in USA that provides high-secured data through secured medium.
• Involved in directing teams on Data sharing/Reporting, which plays a major role, where the approach is designed based on Interface, application or Batch that is supported by various tools like Cognos, Tableau, Informatica, SSRS etc.
• Gather Business and technical Requirements, develop Data design documents, design Data Diagram for detailed discussion and analysis with Developer teams
• Lead team of 9 Developers to discuss, perform approach for ETL activities from various sources and destinations supporting multiples Interfaces and Batches.
• Responsible for ensuring Data Governance principles are being followed within projects, such as Metadata Management, Data Integrity and Data Quality, maintain security of PII (Personal Identifiable Information) Data.
• Handle Logical and Physical Data Modelling for the specified requirements. Checking with the existing Domain models from the Information Architects to ensure mandatory attribution and Keys are maintained.
• Design Normalized SCD Type 4 Database model handling various database Schemas to support the application(s) and interfaces with optimal performance.
• Develop and maintain Data design and model notes for every deployment and generate Data Dictionaries to meet Service Level Agreements.
• Ensure Naming Standards are in place for the designed models.
• Review and maintain Database coding standards and make sure the standards yield maximum optimization.
• Ensure data security is identified for specific data elements following the security compliance standards.
• Setup, maintain and control service administrative accounts for different Data objects that are being exposed to external sources.
• Standard Practice of Pre- deployment and Post-deployment Data modelling activities, Database Object comparisons, Static Data comparisons for every regular deployment.
• Design ETL, schedule and automate daily overnight schedules for Data migration and other Batches and ensure success or failure notification deliveries.
• Provide the data model PDFs, DDL, Metadata information to developers.

Confidential,

Primary Responsibilities:

• Partnered with development teams through the lifecycle of the project through data analysis for current state, data modeling and ensuring data standards during design, data quality and integrity checks etc.
• Modelling required logical and physical Database Objects in various schemas and structures based on the Data design documents and suggest best practices.
• Leading team of Developers to perform ETL, Database Development, Reporting, Data migration, Data Warehousing activities.
• Responsible for performance requirements, implementing partitioning and indexing, tuning of Stored Procedures.
• Responsible for Data Governance activities such as Conceptual, Logical and Physical design, Metadata management, Security standards, Data Quality.
• Design, Develop and maintain Overnight Job Schedules, Develop and maintain procedures for Error Handling
• Deployment of SSIS packages to various environments through best practices.
• Monitoring overall synchronization of data between different databases and servers.
• Working with Data Warehousing teams to migrate archive data into Star Schema Data Warehouse structures from Transactional Database.
• Participating actively on Clients Calls, meetings with Project Managers to discuss and suggest alternatives of Database issues.
• Continuously monitoring Database performance, identify necessary Indexes and tuning approaches, discuss, educate and execute the approach to optimize performance.
• Handling large amount of data through TSQL programming, SSIS packages, SSRS Reporting for various applications

Confidential,

Responsibilities:

• Data modeling, Logical and Physical models.
• Re-engineered the legacy ETL process by designing the enhancements to include; bad data management & email notification (failure & success), effective logging, improving the performance
• Involved in designing of complex ETL solution based on the Customer need that involves various stages of the data flow from different sources to staging area, cleansing the data, loading to the fact tables and then aggregating the data for reporting purpose.
• Set up the Reporting framework using MS Reporting Services (SSRS). Configured the Reports Server and Designed and developed multiple reports.
• Management of logging and configurations of SSIS packages.
• Taking the responsibilities of the overall tasks and guided the team to have very good understanding on project’s requirement and Business for delivering the work as committed.
• Supervision of data migration between various databases.
• Automated scheduled jobs and continuous delivery.

Confidential,

Responsibilities:

• Prepared the Design & Process Flow Documentation for development of ETL Process to get source data from various sources.
• Responsible for implementing the ETL solutions using SQL Server Integration Services
• Responsible for writing T-SQL queries, Stored Procedures, User-define-Functions and creating views, Indexes and Dynamic Queries.
• Discussions with Services Team & Application Team to create and update database Objects for the new requirements.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful non-clustered indexes.
• Requirements analysis and documenting the Technical specifications.

Confidential,

Responsibilities:

• Involved in migrating the data from various files and heterogeneous systems into the database and from the database into various files by using SSIS.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Developed the ETL packages using MS SSIS for different dimension, fact and aggregate table loads
• Closely worked with the deployment teams in providing walk through during releases.
• Prepared the release artefacts and participated the release review presentations.
• Executed the test cases, documented, and interpreted the test results.