SUMMARY:

• Over 11 Years of software lifecycle experience in Design, Development, Testing and Implementation of database applications.
• Proficient as Data Modeler\Architect in designing Conceptual, Logical and Physical data models starting from business analysis to technical implementation.
• Experienced in handling Enterprise Data initiatives such as Data Governance, Metadata Repository and Data Quality.
• Expertise in designing, developing and maintaining Microsoft - SQL Server database applications.
• Fine balance of Data Architecture/Modeling and Database development efforts, ability to work with globally distributed teams and deliver assignments on time.
• Exceptional ability to learn new technologies efficiently. Creative, self-motivated, quick learner and a promising team player.

ARES OF EXPERTISE:

• Data Modeling and Architecting
• Data Architecture standards and methodologies, TOGAF
• Data Governance, Metadata Integration and Data Quality
• MS-SQL Server Database Development
• Team Leading / Management

PRIMARY SKILLS:

SQL Server Migration: I have worked on Database upgrade analyzer with notifications, scenarios, active, results and have worked with various phases of the database migration as to evaluate pre-migration (inventory/checks), Actual migration tasks, and post migration checks. Monitored the database application's performance post upgrades. Worked with various modes/approaches of upgrades (In place, Side by side installation, Rolling upgrade) Handled the transfer of users/logins. Verified the compatibility levels, addressed previous compatibility level discrepancies with Database Analysis Results tool feature. Developed an upgrade plan to cover to compare schema changes from non-prod to prod regions.

Data Modeler:: I have very good experience with OLTP and dimensional data architecting/modeling for various database applications like SQL server, Oracle, DB2 etc., Involved in redefining the enterprise modeling and architectural standards. Worked with various data front initiatives at the enterprise Reference and Master data management, Data Quality and Lineage and Data Governance. As a primary Data Modeler/Architect, I have worked on plenty of application data models to work on and review.

ETL: worked with Informatica Powercenter to define ETL workflow and framework for various lines of BI applications. Worked on data mapping and transformations from source and target ends. I have worked with validation of source, applying transformation logic, data loading and testing the cases.

Security aspects of SQL Server:: Server side, and user based security aspects, I have carefully reviewed and worked with Physical environment, operating system, Network and application. I have worked with server level and database level to implement roles and permissions. Also, worked on the Policies, patching and encryptions.

Collibra Data Governance Center: Configured Collibra Data Governance Center DGC based on client requirements and specifications. Created Collibra Data Governance Center (DGC) models including assets, relationships, domains and communities. I have developed application interface workflows using Groovy scripting in conjunction with the out of the box Collibra REST API's. Defined workflow, security and integration requirements. Done the Unit test and trained the user for UAT. Collaboration with cross functional teams regarding all areas of data development, consumption, and lifecycle management to ensure compliance and effective processing and controls of critical data elements. Managed basic administration on Collibra and Informatica tools by Creating Users, setting up LDAP authentication, roles, permissions, configuring Informatica repository, schedule of maintenance jobs to manage Informatica services, archive folders, purge Informatica temp files/logs, backup database objects.

TECHNICAL SKILLS:

Project Development Life Cycle: MS-SQL Server(2005, 2008, 2012, 2014 &2016) Oracle 11g, MS-Access(2007, 2010 & 2013)Databases Erwin Data Modeler(7.3,8.2,9.5)

Data modeling: Collibra(4.5.3), Informatica Metadata Manager-IMM(9.6.1) Informatica Data Quality-IDQ(9.6.1)

Metadata, Data Governance Data Quality - tools: TOGAF 9.1 standards (Level1 & Level2)

Architecture Methodologies: MS-Dos, Windows Server(2003, 2008), Red Hat Linux 6.4 and TANDEM

Operating Systems: SSIS, SSRS

Business Intelligence: IIS(7.0), Tomcat 8

Web Server: Transact-SQL, PL/ SQL, VBScript, VBA macros HTML and XML

Programming: Crystal Reports 11.5

Reports: Waterfall and Agile

WORK EXPERIENCE:

Confidential, New York

Lead Data Modeler/Architect

Tools: ERwin Data Modeler 9.5, SQL Server 2014

Responsibilities:

• Worked closely with business analyst and executives to provide data architectural service for various OLTP and analytical projects for Asset Servicing and Wealth Management lines of business.
• Worked with IT and other BI experts to model dashboards and solutions to enable business analyst and other business users to perform powerful analytics that provide critical insights into business processes and data in a timely manner.
• Developed data mappings for analytical projects to establish relationships between source and target tables including transformation processes.
• Published various data architectural artifacts and deliverables to share the core data definitions, business rules and data structures.
• Design and development process using T-SQL, Stored procedures, Functions and Triggers to enhance Portfolio Management Group applications provide straight through processing and reporting functionalities critical to the operation of the Corporate Treasury Investment Portfolio.
• Review the SQL deliverables and facilitate the review board process by benchmarking the performances.

Confidential

Data Architect\Modeler

Tools: ERwin Data Modeler(9.5), Collibra(4.5.3), SQL Server (2008, 2012), Informatica, Metadata Manager 9.6, Informatica Data Quality 9.6, Linux, Oracle 11g, Crystal Reports 11.5

Responsibilities:

• Created and Maintained the conceptual, logical and physical data models by defining information requirements for management and business intelligence purposes. Enterprise application data models were designed as per the strategy of Enterprise Data Services and Architecture(EDSA) standards.
• Strong understanding of database design and modeling, complex queries, and stored procedures.
• Developed customized ERwin macro scripts to validate the naming standards, abbreviations, classwords, logical to physical, physical to logical, data type/domain validations.
• Performed admin activities on ERwin Model mart.
• Provided graphical views and model visualizations (as artifacts) to facilitate information exchange and collaboration among the different stakeholders.
• Implemented the design and development process for SQL Server applications Legal Agreement Repository, Debt Services Operations and Access Control Facility. Design, develop, debug and maintenance of T-SQL Stored Procedures, Functions, Triggers, SQL CLR, Users, Tables, Views and other objects.
• Carried out Performance optimization of SQL Stored Procedures, Functions, SQL Agent Jobs using SQL Profiler, DB Tuning Advisor, Query Plans, DMOs etc.,
• Handled advanced SQL concepts - Transactions, Deadlocks, Partitioning, Change Data Capture, Query Plans, Dynamic Management Views, Row and Column Store Indexing etc.
• Involved in SQL database migration with DBA to schedule and perform test migrations by clearly defining the roles and processes during migration.
• Performed Import/Export data from various data sources like Excel, Oracle, DB2 and Flat file using SSIS, also handled Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems.
• Managed basic administration on Collibra and Informatica tools by Creating Users, setting up LDAP authentication, roles, permissions, configuring Informatica repository, schedule of maintenance jobs to manage informatica services, archive folders, purge Informatica temp files/logs, backup database objects etc..
• Knowledge of Data Quality and Data Profiling tools.

Confidential, New York, NY

Technical Lead

Tools: SQL Server 2005, Crystal Report 11

Responsibilities:

• Designed the payout data structures and developed stored procedures to process system/user calculated parameters.
• Payout calculation process is based on diverse levels defined by Institution Admin and they were encompassed the design and development of various database objects -Tables, Indexes, Views, Stored Procedures, Functions and Triggers.
• Configured database mail to automate alerts for Account Executives to follow up payout measures remotely.

Confidential

Tools: SQL Server 2005/2000, IIS, Crystal Report 10, C#.net, VBScript

Responsibilities:

• Worked as the Technical Lead in this effort for an external client of the European Bank’s Mutual Fund product.
• Enhanced the Mutual Fund system to support data integration between the Bank’s and client’s systems.
• Developed the stored procedures and XML encodings for a major database enhancement to reconcile their internal account and to import client data with Bank’s internal system in a periodic manner.
• Worked on basic database administration tasks to ensure availability of data assets and no data loss in non-prod regions. Scheduled Database backups and transaction log backups for non-prod regions.

Confidential

Systems Analyst

Tools: SQL Server 2000/2005, Confidential Virtual Works(1.4), Erwin data modeler(7), SSIS, Crystal Reports 10

Responsibilities:

• Analysed the business requirements and reverse presented to the team members.
• Co-ordinated with all the Stakeholders to finalize the interface design, input & output requirements.
• Implemented and tested various stored procedures and functions for SafeAir project on “Configuration Management”, “Maintenance Setup” and “Capacity Planning” business process areas.
• Performance of SQL Stored procedures were a bottleneck during SQL 2005 migration. They had been analysed and fixed using Common Table Expressions feature, which was a major exercise during the migration projects.
• Involved in Software Configuration Management process to operate and administer the version control for deliverables. Extended the support to facilitate deployments in Integration Testing, UAT and Prod regions.
• Led four-member development team at offshore.
• Status updates to Client Managers and user support group on a weekly basis.

Confidential

Software Engineer

Tools: GoldenGate (Extract and Replicat)

Database: SQL Server 2000, Oracle 9i, Sybase 12.0 and Tandem Enscribe

Responsibilities:

• Analysed the business requirements and documented the technical implementation in detail.
• Handled Extracts\Replicats setup in GoldenGate software to validate the replication of transaction log across heterogeneous database environments in real time for various banking clients.