EXPERIENCE SUMMARY:

• 17 years of experience in enterprise-scale architecture design, integration of business applications data, technology services across varied business domains including automotive, healthcare, transportation, commodity trading, etc.
• Strong experience in driving business ROI through architecting database solutions and web-based applications per domain-specific requirements
• Proven Leadership qualities with extensive experience as mentor to team of architects and developers in initiatives focused on enterprise grade, highly scalable and highly dynamic database environments

TECHNICAL SKILLS:

Databases: SQL Server 2012, 2008 R2/2005/2000/7.0, Oracle 9i/8i, MS Access

BI/DW: SSIS, DataStage, DTS, Data Marts, Enterprise DW

Languages: ASP.NET/ASP, JavaScript, VBScript, DHTML, HTML, CSS, and T-SQL

GUI/Tools: ER Studio, Visual Studio, MS Visio, PVCS, Visual SourceSafe

OS: Windows 2008/2003/XP/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential

Designation: Sr. Data Architect

Responsibilities:

• Legacy system data profiling, staging database design, security design/setup and entire end to end solution design for staging the legacy data for SAP Implementation
• Logical and physical data modeling using ER Studio
• Extracting data from various legacy systems into staging area, apply all the business rules and transformations, data cleansing, data quality check and produce a pristine data for SAP to consume.
• Master data management, Data validations, Automate Data verification process
• Architecting standards, design best practices, code reusability, easy code maintenance, Quality check T-SQL scripts automation and documentation
• Hand on development on complex stored procedures, Complex T-SQL scripts, Data load/transformation, SSIS packages

Environment: ER/Studio, SQL Server, ETL, SSIS, Complex T-SQL, Stored Procedures, HPQC

Confidential

Designation: Sr. Data Architect

Responsibilities:

• Enterprise wide SQL Server migration from 2000 to 2008 R2.
• Migration Planning and Design, Best practices and standards, Quality Improvement
• Database design, Data modeling logical/physical design, capacity planning, security design
• Architecting standards for Data migration, extraction, quality assessment, data cleansing, validation and loading
• Architecting/Development of enterprise wide stored procedures, T-SQL scripts, User defined Functions, Data load/transformation, quality check T-SQL scripts

Environment: SQL Server, Enterprise Data Warehouses, Data Marts, SSIS, DTS, T-SQL, Stored Procedures

Confidential

Designation: Sr. BI Architect

Responsibilities:

• Lead a team of DBAs, System Analysts, Quality Analysts on daily operations of Large private cloud environment which includes support and various maintenance activities
• Database Management, Weekly maintenance plan, backup/recovery, production support
• Database design, Performance tuning, query optimization, coding standards, best practices
• Planning and migration of huge databases, security design using Active Directory
• Security configuration/management, deployment of warehouse/data mart across DEV, SIT, UAT and PROD environments with high level of security granularity

Environment: Private Cloud 60TB, VM Ware, Oracle 10g, SQL Server 2008 R2, Data Warehouse, Data marts, SSIS, T-SQL, Stored Procedures, Visual Studio 2008, Windows Server 2008

Confidential

Designation: Technical Architect

Responsibilities:

• SQL Server DB architecture, design, development, administration and Performance tuning
• Design/develop data models - Conceptual, Logical and Physical database design using ER/Studio
• SSIS, Data migration, extraction, quality assessment, data cleansing, loading and validation
• Data warehouse architecture design, development and maintenance
• Migration experience from SQL Server 2000 to 2005, SQL Server 2005 to 2008
• Complex highly performance tuned Stored Procedures, Functions, Triggers and T-SQL Scripts
• Define and implement best coding practices, standards, conventions, readability reusability
• Engaged in innovative concepts and programming techniques Agile Extreme Programming on how to develop high quality software and still maintaining shorter time to market

Environment: SQL Server 2008 R2/2005/2000, Data Warehouse, SSIS, SSRS, T-SQL, Stored Procedures, ER/Studio, Visio, ASP.NET, VB.NET, XML, JavaScript, DHTML, HTML, CSS, Visual Studio 2008, PVCS, IIS 6.0 and Windows 2003

Confidential

Designation: Technical Architect

Responsibilities:

• Sr. Technical Lead responsible for Client-Stakeholder interactions
• Database/Web Architecture design and development
• Design and develop data models - Conceptual, Logical and Physical database design
• Define and implement best coding practices, standards, conventions, readability reusability
• Led the delivery of all stages of the Software Development Life Cycle using .NET Architecture Technologies

Environment: SQL Server 2000, ASP.NET, VB.NET, C , XML, JavaScript, DHTML, HTML, CSS, IIS 5.0 and Windows 2000.

Confidential

Designation: Sr. Software Engineer

Responsibilities:

• Requirements gathering, business users interactions and project planning management
• Design the architecture of the application and database design
• Programming the application using ASP.NET, VB.NET, C , ADO.NET, XML, XSL, JavaScript, HTML, DHTML, CSS using Visual Studio.NET
• Written SQL server stored procedures and designed SQL server 2000 Reports
• Written SQL scripts, SP's and DTS package to import data into STOR database.
• Designed ETL jobs Sequencer using DataStage to import data from centralized databases
• Quality assurance testing, Production plan, roll and support.

Environment: ASP.NET, VB.NET, C , XML, XSL, JavaScript, DHTML, HTML, CSS, SQL Server 2000, DataStage7.5, DTS, Microsoft Visual Studio.NET, Visual Source Safe, IIS 5.0 and Windows 2000.

Confidential

Designation: Sr. Software Engineer

Responsibilities:

• Business requirements, Analysis and Architectural design of the application
• Tech Lead for the team of 6 developers
• Automated data load into Oracle from mainframe on daily, weekly and monthly basis
• Created, documented implemented the best coding practices for web development.
• Coding in ASP, VBScript, JavaScript, Oracle PL/SQL procedures, SQL, DHTML, HTML CSS.
• Tools used are Visual Interdev6.0, PVCS version manager and PVCS tracker.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle9i, PL/SQL, SQL Navigator, IIS 5.0, Windows 2000, Microsoft Visual Interdev6.0, PVCS Version Manager and PVCS Tracker.

Confidential

Designation: Sr. Software Engineer

Responsibilities:

• Interacted with Business Analyst and Users to understand the business rules of the system.
• Designed user interface screens with HTML, DHTML and JavaScript using Visual Interdev6.0.
• Development of the application includes client side validation in JavaScript, Server side scripting in ASP with VBScript, Database connections with ADODB and OLEDB.
• Written PL/SQL Packages in Oracle8i and invoked from ASP.
• Assisted in writing test scripts, testing of the application and deployment in production.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle8i, PL/SQL, IIS 4.0, Windows NT Server 4.0, Microsoft Visual Interdev6.0 and PVCS.

Confidential

Designation: Sr. Software Engineer

Responsibilities:

• Understanding the business rules and applied them in the development of the application.
• Client side validation is written in JavaScript, Server side scripting in ASP with VBScript, Database connections with ADODB and OLEDB, development environment is Visual Interdev.
• Written PL/SQL Packages in Oracle and invoked from ASP.
• Involved in the Testing and implementation phase of the application.

Environment: ASP, JavaScript, VBScript, DHTML, HTML, Oracle8i, PL/SQL, IIS 4.0, Windows NT Server 4.0, Microsoft Visual Interdev6.0 and Visual Source Safe.

Confidential

Designation: Software Engineer

Responsibilities:

• Involved in user requirement analysis, prototyping, database designing and Quality assurance
• Front end designed using ASP, HTML, DHTML, JavaScript using Visual Interdev
• Designed/written Business/Data Layer COM components in Visual Basic and deployed in MTS
• Designed written Stored Procedures in SQL Server 7.0
• Involved in preparing test scripts, testing of application and production deployment.

Environment: ASP, Visual Basic, ActiveX DLL COM , XML, JavaScript, VBScript, DHTML, HTML, SQL Server 7.0, IIS 4.0, MTS, Windows NT Server 4.0 and Microsoft Visual InterDev.

Confidential

Designation: Software Engineer

Responsibilities:

• Worked in several web development projects using HTML/DHTML, JavaScript, VBScript and SQL Server
• Administration maintenance of production web server
• Setup and maintain Domain Names, FTP and Email Services
• Migration of web server from IIS 3.0 to IIS 4.0
• Install, Configuration, Setup and maintenance of IIS, DNS, WWW Services, ISAPI, CGI Scripts, FTP, NT Authentication, Extranet, SSL, ODBC, SMTP
• Performance monitoring, analyzing server resources, data backups weekly/monthly

Environment: Windows NT Server 4, IIS 4.0/3.0, DNS, HTTP, WWW, FTP, SMTP, Web Development