SUMMARY

• Technical Lead/Consultant /Data Architect with over eleven (11) years of experience and extensive experience in designing, developing and maintaining data integration, data warehouse and OLTP applications using MS SQL Server, Oracle and related tools
• Experience in all SDLC phases including requirements gathering, analysis of requirements, designing applications, developing and testing deliverables, implementing and maintaining them
• Experience in data architecture and data modeling using Erwin, ER - Studio and SQL data modeler
• Worked with Erwin to design and create Logical/Physical data models, data dictionaries and automation using Erwin API’s, Query Tool and Erwin Macros
• Hands on experience designing OLTP applications with multi-language support: processed culture specific data
• Experience writing complex queries, stored procedures and SSIS packages. Analyzed the execution plans and performance counters for performance tuning and query optimization
• Created dynamic SSIS packages and integrated with ASP.NET Web applications for on-demand/ad-hock feed processing
• Worked with third party vendors and teams to establish data integration channels between applications
• Experience in SQL Server environment setup and maintenance including creating databases, implementing access privileges, scheduling back up jobs, restoring databases, generating and analyzing execution plans and maintaining the server instances and applications
• Designed backup and recovery strategies for point-in-time recovery and disaster recovery and lower RTO
• Created Excel VBA macros to integrate ER/Studio, web services, MS Outlook and SharePoint
• Worked on DataFlux to assess and monitor data quality issues by creating profiles, integration jobs and scheduling them using DIS service
• Integrated third party web services with DataFlux using C#.NET and scheduled on-demand data processing and validations
• Flexible, versatile and adaptable to new environments, and proficient in managing multiple projects
• Well-organized, goal-oriented with an ability to perform individually and in a group

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008/2005/2000/7.0, MS Access and Oracle 12c/8i

Data Modeling: Erwin 9.2, Oracle SQL Data Modeler, Embarcadero ER/Studio 7.5/7.1

Language: VB.NET, C# .NET, VB6.0, VBA, Power Shell

Tools Technologies: SSIS, SSRS, DTS Packages, Informatica Data Integration, DataFlux 7.1/8.0, DataFlux

PROFESSIONAL EXPERIENCE

Data Architect

Confidential, Ann Arbor, MI

Responsibilities:

• Analyzed the different data sources that feed data to the BIDM system
• Created staging and ODS data models and generated scripts from forward engineering
• Reverse engineered data models from variety of sources into Erwin data models
• Applied and maintained modeling standards in Logical and Physical models
• Compared the different data models to capture changes and synchronized into Erwin
• Extracted, compared and updated the data dictionary for Erwin models
• Worked with Oracle SQL data modelers and DMD data models
• Used Erwin API and VBA macros to automate Erwin model updates
• Implemented and maintained QA Tools in Oracle PL/SQL to compare multiple versions of data models
• Maintained the Erwin datamart

Environment: Erwin 9.2, Oracle 12c, Oracle SQL Data Modeler, Rally and SVN

Technical Lead

Confidential, Schenectady, NY

Responsibilities:

• Created the data models specific to the integration projects and maintained the corporate application data models using Erwin
• Gathered and analyzed the requirements from business users along with the business system analyst
• Worked closely with BSA to gather, review and document the requirements, prepared estimates and reviewed implementation timelines. Created the conceptual data model and high level designs of the solution
• Reviewed the solution design approach with the code review-teams and created dS2T mappings for the data extracts
• Worked with the vendors to establish data flow channels for the integration, analyzed source systems to create target mappings and transformation rules

Environment: Erwin, Facets 5.2, Sybase, SQL Server 2008, Control-M, Remedy and MKS

Technical Lead

Confidential, Chase, Jersey City, NJ

Responsibilities:

• Responsible for the design and overall health and performance of the application
• Created new data models and maintained the existing data models for application components using Erwin
• Designed and developed the solution using SSIS and Stored Procedures and integrated with the batch processing
• Scheduled monthly enhancements and carried out impact and data integrity analysis for all enhancements
• Redesigned and implemented the data partitioning and data archival process to improve application efficiency
• Implemented pre and post data load validations and maintained the Bloomberg reference data process
• Worked with in-house and with third-party data providers to setup the new data channels to Source Data, standardizing the feed layouts and performed gap analysis between different data sources
• Implemented the schedules for index rebuild/reorg, statistics updates in-line with the batch processing, used active-passive clustering for high availability with automatic failover, redesign full, differential and log backup schedules
• Implemented and adhered to the MAS auditing standards for the application and migrated Pearl scripts to bulk-insert and SSIS
• Maintained HA cluster and mirroring to sync the data between production and DR environment
• Implemented change control management and performed builds and deployments on a daily basis

Environment: SQL Server 2005/2008, Power Shell, SSIS, SSRS, SVN, BMC Control-M, HP ALM and Erwin.

Database Lead/Consultant

Confidential, Warren, NJ

Responsibilities:

• Analyzed the execution plans and performance counters for performance tuning the application
• Designed SQL framework for financial modules as a part of redesigning
• Used XML data type to log application audit events and then processed offline
• Designed complex and critical financial processes such as CAP credits and WIP/FAR balance sheet review tools
• Processed the ad-hoc bulk requests to process GOC rates or activate system GOC’s
• Followed agile methodology using monthly release sprints for application maintenance
• Analyzed the requirements, estimated the efforts and time lines, created user stories, tasks and assigned to the developers
• Migrated DTS packages to SSIS packages, tested and coordinated with the quality assurance team
• Implemented change control management and daily builds and deployments
• Migrated the application database from SQL Server 2005 to SQL Server 2008

Environment: SQL Server 2008/2005, SSMS, BIDS, SSIS, SSRS, PVCS, TFS and Erwin.

SQL Server DBA

Confidential, MD

Responsibilities:

• Refreshed the databases between development, system tests, beta release, sandbox and pseudo production
• Scheduled and monitored backup jobs, rebuilt the indexes and updated the statistics
• Troubleshot connectivity and performance related issues, performance tuning and optimization of the queries
• Reviewed the application code changes for standards and best practices and assisted the developers on database issues
• Verified the server status and backup jobs on a daily basis, backup transaction logs on demand and point in time recovery
• Configured management, monitored the servers for high availability and promoted database builds and patches

Environment: SQL Server 2008/2005, TFS and Red Gate

SQL Server Consultant

Confidential, NY

Responsibilities:

• Identified the entities and relationships and designed the logical and physical data models
• Designed and implemented different access levels by creating different user roles, roles and market department driven approval hierarchy
• Migrated data from different cultures including Simplified Chinese, Traditional Chinese, Spanish, Korean, Thai, Hindi and English languages from Excel to SQL server
• Processed XML data between front end application and database applications
• Responsible for implementing the ETL (Extract Transform Load) process using SSIS packages
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime
• Created web services to enable the remote execution of SSIS from the database server
• Integrated the web service with the web application to allow users to submit ad-hoc extract requests from intranet/internet web application
• Analyzed the execution plans, performance counters and fine-tuned the SQL codes for better performance
• Used SQL Server Profiler to debug the application execution flow and dynamic queries
• Created and debugged SQL stored procedures, created indexes on the existing tables and updated the existing indexes over a period of time

Environment: SQL Server 2005, VB.NET, SSIS, SSRS, Excel VBA and Windows Server 2003

SQL Server Consultant

Confidential

Responsibilities:

• Responsible for implementing the ETL process by creating new SSIS packages, maintaining the existing SSIS packages, analyzing and loading new data sets on a periodic basis. Used VB.NET codes to achieve customization in SSIS
• Implemented error handling mechanism to handle the errors that could occur during execution
• Designed and developed the CDC (Changed Data Capture) process to capture changes in the data between the previous refresh and present refresh using dynamic Stored Procedures
• Created and maintained database models in ER/Studio and maintained the ER/Studio repository service, license manager service and the ER/Studio Repository database on SQL server
• Published the ER/Studio repository diagrams in the Sharepoint portal in the form of HTML diagrams
• Exported the data from MS Access tables into SQL Server by using SSIS packages
• Created complex queries in MS Access to retrieve the data from multiple tables and linked tables
• Used high availability (Active Passive) cluster at OS level in production using SAN drive implemented disaster recovery
• Prepared technical and high level design documents for the existing and newly created applications
• Created VB.NET custom components and used excel VBA scripting for application integration
• Created new Webpart pages in Sharepoint portal and used VBA applications to dynamically update the webpart file

Environment: MS SQL Server 2000/2005, Embarcadero ER/Studio 7.5, SSIS, DTS, VB.NET, MS Access, VBA Macros, VB Script, Remedy and Windows Server 2003

Sr. Systems Analyst

Confidential

Responsibilities:

• Created DTS packages to handle Extraction, Transformation and Loading to upload the CSV reports into the staging area
• Responsible for analyzing the competitor’s site, designed an approach to automate the URL collection and developed VBA applications to prepare reports
• Responsible for extracting the data from downloaded web pages and generated reports in CSV format
• Responsible for cleansing the extracted data which is exported to the staging area
• Responsible for writing complex stored procedures to analyze and perform the product matching
• Exported the data dynamically from SQL Server tables to the MS Access database by using OPENROWSET command
• Wrote dynamic Stored Procedures to divide 14-15 million records into smaller subsets and load into different MS Access database files. Used VB scripting in DTS to achieve customization
• Responsible for analysis, design, development, coding and implementation of the crawling web tool
• Implemented the mechanism to create ODBC System DSN automatically by creating the necessary registry keys in Windows registry

Environment: MS SQL Server-2000, DTS, VB6.0, MS Access 2000, Crawling and Extraction tools, VBA Excel macros and Windows 2000/XP/2003