SUMMARY:

• Over 20 years of IT experience with a sound background in complete project life cycle development, System Analysis, Design, Development, Testing, and Implementation of Software applications.
• More than 10 years of experience on Data warehouse / BI tools, SSIS, SSAS, SSRS, OLAP Cubes, MDX.
• Vast experience on ETL tools such as DTS, SSIS, Pervasive, Informatica
• Strong Database experience in SQL - Server, T-SQL, Stored Procedures, Oracle 9i, PL/SQL, MySQL, MS Access
• Data warehousing project development and maintenance experience.
• Implemented data warehouse security through active directory groups for large customer base.
• CMMI Level 3 Compliance quality procedures and documentation, Provided support for SOX (Sarbanes-Oxley) Audits and generated audit data reports and documented audit results and policies.

TECHNICAL SKILLS

Databases/BI: SQL 2008 / 2005 / 2000 / 7.0 / 6.5, Oracle 9i / 8 / 7.3, DB2, MS AccessT-SQL, MDX, DTS, Excel Pivot Tables, OWC, SSIS, SSRS, SSAS, MySQL

Designed and developed: OLAP, OLTP

ETL Tools: DTS, SSIS, Informatica, Pervasive

Languages: VB.NET, C#, Visual Basic 6.0/5.0, C, SQL, PL/SQL, SQL * Plus

Web: ASP / ASP.NET, JavaScript, VBScript, HTML, XML, DOM, SAX, SOAP, Web Services

Content: Vignette V6, Click Commerce RM 4.2

Tools and Applications: VS 2005 / Visual Studio 6 / Visual Studio.Net, Visual Interdev, Visual SourceSafe, Crystal Reports 9 / 8.5, Dreamweaver, MS FrontPage, MS-Office, MS-Access programming, COM+, MTS, ActiveX, ADO, VBA, DM9 Titanium Ore, Rational Team Concert.

OS/HW: UNIX, XENIX, DOS 6.22, NetWare 4.10, Windows XP/NT/2000/2003/2008

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Database Developer

Responsibilities:

• SQL Server 2008 R2 Database Development and Maintenance, Data Migrations and Data Transformations.
• MySQL Cloud Database Implementation and Development, Appian Web Interface Testing
• Database modeling, Validations, Performance Tuning, Stored procedures.
• Environment and Software: SQL Server 2008 R2, Oracle 10G, MySQL Cloud, MySQL Workbench, T-SQL, Subversion, Erwin tools

Confidential, Frederick, MD

Production Operations SME / Lead - ETL Development

Responsibilities:

• Design and Development of Data Transformation Processes using ETL tools such as Pervasive and SQL Server 2008 R2 Tools (SSAS, SSRS, SSIS) & DM9 Titanium ORE platform, Rational Team Concert,
• Data Mapping to DM9 Full Cycle using Pervasive ETL Tools, Legacy data conversion and management. Data comparisons and Migrations. Reports Development using SSRS
• Production Operations support and troubleshooting. Database design, management of large OLTP databases and administration. Development Lead for Monthly/Quarterly release management. Involved in requirements and designing OLTP databases.

Confidential MD

Sr. Database Developer

Responsibilities:

• Design and Development of Data warehouse/BI using SQL Server 2008 R2 tools. Developed OLAP and Data Marts.
• Architected and Designed Cubes from Scratch using SSAS.
• Created and Maintained SSIS packages using ETL tools such as SQL Server Integration services.
• Worked on Data warehouse modelling and Designed Analysis service cubes, BI Development using SSRS & MDX
• SQL Server 2008 R2 Database Maintained and developed OLTP Databases, Reports Development, Data Migrations.
• Database modeling, Performance Tuning, Stored procedures, Dimensional modeling, Data Warehouse development.
• Environment and Software: Microsoft SQL Server 2008 R2, T-SQL, SSRS, SSIS, SSAS, Erwin tools

Confidential

Software Engineer

Responsibilities:

• Duke-Energy is a major Gas and Electric company. Confidential is merged with this company. Administered and maintained a Data warehousing based application called Control Area Operations Reporting Mart (CAORM) which Extracts data from various input sources of Energy data and BI Reporting through custom web site using SSRS, MS OWC, and MDX
• Designed enhancements and developed OLAP Cubes for ever changing business requirements and contracts
• Worked in migration projects to enhance Data warehousing applications. Automated data extracts and organized ETL packages by upgrading various sources of data inputs to feed data warehouse applications.
• Involved in customer meetings and converted user needs to specifications. Interacted with customers and application users regularly. As an IBM onshore SME (Subject Mater Expert), who can exclusively communicate with customers, coordinated and trained offshore development teams on application / server configuration & development.
• Helped offshore development and testing teams in Quality assurance and CMMI Level 3 Compliance. Approved test plans using Remedy system and monitored testing documentation in share point folders.
• Maintained and Monitored multiple Data warehousing and electrical engineering support projects
• Enhanced and cubes for historical energy data and ETL (DTS package extracts and schedules to extract), verify and to update large data marts.
• Designed and developed OLAP and Cube based reporting using MDX queries, MS Office web components, XML

Environment: MS SQL 2000 / 2005 / 2008, SSIS, SSAS, SSRS, Informatica, OLAP Cubes, T-SQL, MDX, DTS, SQL Server Agent, Web Reporting, VB6, C#, ASP, XML, Web Services, MS Office WEB Components 10 & 11, IIS, Visual SourceSafe, Crystal Reports

Confidential, Concord, NC

Systems Analyst / Developer

Responsibilities:

• Confidential (Later Duke-Energy) is a major Gas and Electric company. Administered and maintained a Data warehousing based application called Control Area Operations Reporting Mart (CAORM) which Extracts data from various input sources of Energy data and BI Reporting through custom web site using SSRS, MS OWC, and MDX
• Designed and developed OLAP Cubes for ever changing business requirements and contracts
• Did Application development using VB, VB.Net, C#, Web services
• Maintained and Monitored multiple Data warehousing and electrical engineering support projects
• Enhanced and designed new cubes for historical energy data and DTS package extracts and schedules to extract, verify and to update large data marts. Developed BI Reporting using SSRS, MS OWC, and MDX
• Designed and developed OLAP and Cube based reporting using MDX queries, MS Office web components, XML
• Environment: MS SQL 2000, MS SQL Analysis Services, OLAP Cubes, T-SQL, MDX, DTS, SQL Server Agent, Web Reporting, VB6, C#, ASP, XML, Web Services, MS Office WEB Components 10 & 11, IIS, Visual SourceSafe

Confidential, Bethesda, MD

ASP.Net Lead developer / Database Analyst

Responsibilities:

• As an analyst and Team lead, involved in developing some of its highly secure and scalable web projects.
• Enhanced and Maintained ACC-CathKIT™ and ACC-WebNCDR™ product support web sites and their content management web tools using ASP. Net, VB.Net, Client side JavaScript, MS-SQL server stored procedures and XML
• Involved in development of web based discussion boards and statistical reports
• Developed windows service application for File transfer management in network environment using thread safe objects
• Developed ASP.net custom controls and used to generate dynamic grids and developed web demonstration and help systems for ACC web sites
• Environment ASP.NET, VB.NET, VS 2003, ADO.NET, JavaScript, HTML, XML, IIS, Visual SourceSafe, MS SQL Server 2000, T-SQL, DTS, Windows 2003

Confidential, Pineville, NC

VB and .Net Developer

Responsibilities:

• Developed ASP.NET pages using VB.NET. Developed and implemented windows applications using VB.NET / VB6
• Designed and developed compiled user controls in C#
• Worked on XML and Text file inputs from AS/400 system for generation of reports
• Worked with database connectivity, Performance issues.
• Responsibilities included Database/System Design, Coding, Implementation, Documentation, Customer friendly training guides, and User Training, connectivity and interfacing the existing AS/400 system and Synquest ERP system
• Carton Perforation Quality Data Capture and Analysis System: Captured and validated data from Perforation Stress Measurement device as direct input and Analyses.
• Programmed RS/232 COM port device and Data captured by MS-COMM control
• Carton Printing Die Board Quality and Performance Monitoring System: Took input from Press Machines and Repair shops to analyze Die Board and Its component positional life performance
• Designed and developed VB.NET windows application with user friendly screens
• Generated Exportable Reports using Excel macros and Crystal reports
• Quality Audit Management System: To implement various customer quality standards and to analyze rejections and Inspections.
• Developed and upgraded existing Access and VB applications to VB.NET
• Worked with Windows application with integration and optimization of tasks
• Did Sampling data analysis reports exportable to Excel work files
• Synchronized validation and verification of data in DB2, Oracle and MS Access
• Data Export Scheduling Agent: Scheduling tool to interface between Oracle 8 (Back End for Synquest ERP Manufacturing Software) and DB2 (AS/400 System).
• Maintained TSR programs those written in C Language and converted them to GUI based status display capable windows based applications using VB.NET
• Unattended error handling for periodical transfer of data from As/400 to Oracle database
• Intranet Web Application: for Order and Product Specification Management for specifying carton product manufacturing design and online production status
• Replaced existing Multiple Product Specification Excel Sheets with secure, query based and modifiable intranet web application using .NET
• Implemented by configuring IIS Web Servers and administering the site.

Environment: VB.NET, C#, VS.NET, ASP.NET, ADO.NET, JavaScript, HTML, XML, IIS, Visual Basic 6, Visual SourceSafe, Visual Studio 6, Crystal reports 8.5 / 7, Oracle 9i / 8, MS SQL Server 2000, T-SQL, DTS, Access 97, DB2/400, C, Windows

Confidential, Greensboro, NC

Web Developer Lead

Responsibilities:

• Developed patches for Extranet Security Management and developed solution documentation for Security holes.
• Developed Extranet Dealers’ Usage Statistical Reports using ASP, JavaScript, VB6, COM+ Components, XML and Click Commerce API for merging various scalar inputs to generate statistical and generated MS-Excel Worksheet Outputs. Handled large inputs of XML and Database Data for Merging and Summarizing web Reports
• Developed Customized Volvo Construction Equipment Product Line Security as a solution for filtering extranet web content by Modifying Click Commerce Relationship manager and by adding ASP Functions.
• Maintained Portal Glue for Extranet Applications and Click Commerce Relationship Manager by Installing, debugging, and testing to the adherence of Quality Standards

Environment: ASP, JavaScript, VBScript, VB6 / VB.NET, .Net Framework, Server side Jscript & Tcl, XML DOM 3, DHTML, XHTML, SAX, Click Commerce Relationship Manager 4.2, Vignette V6 Content management Suite, Site Minder, Visual Basic 6, COM+ Components, VBA, SQL-Server 2000, Site Server 4, LDAP, Windows 2000

Confidential, Charlotte, NC

Web Development

Responsibilities:

• Confidential are a leading provider of sales and services of Satellite and Security systems for homes.
• I Worked as Lead Member of Project development of their corporate intranet web site covering Customer Relationship Management, Inventory, Sales and Admin modules from the scratch.
• Developed Corporate Intranet web site for Customer Relationship Management, Inventory, Sales and Admin modules
• Designed and developed Active Server Pages and VB6 COM+ components
• Programmed web pages for Bar Code data management for scanned materials
• Worked extensively on Frames Programming using Winsock, HTA Behaviors
• Integrated web pages with Office Documents using VBA for MS-Excel reports
• Involved in system analysis and database design of the project.
• Successfully handled Project management and systems analysis also as additional responsibilities

Environment: ASP, JavaScript, VBScript, Visual Interdev, HTML, DHTML, XML, Visual Basic 6, COM+ Components, MTS, SQL-Server 7, FrontPage 2000, MS Excel