SUMMARY:

• Over 15 years of experience in analyzing, designing, tuning, and developing Client/Server, and various segments of Software Development Life Cycle, using MS SQL Server 2005/2000 DTS/SQL Server Integration, Reporting Services.
• Extensive SQL Development experience in Retail, Dotcom, healthcare and Aerospace industries with a strong understanding of data & analytics.
• Experience in database Migration, Normalization, De - normalization, Design,Analysis and Performance Tuning.
• Extensive experience in using T-SQL (DML, DDL) and PL/SQL in Oracle 11g.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Data Analysis, Relational Database Models and Data Integrity in observing Business Rules.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability. Experience in ETL using DTS, MySQL, SSIS, Dell Boomi.
• Experience with large volume of data (2TB or more) and data transfers.
• Extensive experience in Web based applications using ColdFusion 4.5, 5, MX 6.1, Custom tag, CF Components and Error Handling Techniques, HTML and PHP. Experience using VSS, management studio, Fusebox Technology and Net chart
• Worked closely with customers and consistently won appreciation for work quality
• Database design and migration
• Writing Scripts and Procedures and Triggers and Performance tuning
• Data Analysis, Machine Learning and Data Science

TECHNICAL SKILLS:

KNOWLEDGE: Windows 2000/NT/XP, LINUX Coldfusion 9, 5/ MX/ MX6.1/8, PHP 5, ASP, HTML, CSS, Perl Script SQL Server 7/2000/ 2005/2008/ 2012 , Sybase, MySQL, Postgres SQL, Oracle 9i, Oracle BI Publisher 11g, Toad, SSIS, SSRS, Microsoft Visual Studio Apache, IIS, Coldfusion Server Fuse box Technology 2/4.1/5.1, JavaScript, Net charts Tool, tlog/ POS Log, XML/XSD, Excel, dell boomi VSS/ Cute FTP/ Visio/ Microsoft Project/JRUN/Macromedia, ER Studio, Redgate tools

PROFESSIONAL EXPERIENCE:

Confidential (San Francisco, CA)

Sr Database Developer

Tools: SSMS, SQL Server 2000/2012, SSIS, ER Studio, XML Spy, Redgate, Boomi

Responsibilities:

• Database Migration, Database re design and Creating ER Diagrams based on XSD
• ETL, Data cleaning, Database Security and Backup
• Resolve the prod tickets on database issues and Deploy Database to various environments

Confidential (San Ramon, CA)

Consultant

Tools: Oracle 11, Toad, ColdFusion 9, HTML, CSS, VPMO

Responsibilities:

• Understand the ER; create a document for the steps of resolution.
• Implement the changes on UI and DB Side for scripts(PL/SQL) and Create Packages
• Create Test document with all options and do a complete testing including regression testing.
• Mark the files to be loaded onto next level and send scripts (PL/SQL) to server.
• Create Reports that shows the progress\cost\resource requirements etc. of multiple projects

Confidential (San Jose, CA)

Sr Software Engineer

Tools: BI Publisher 11g, Oracle Reports Builder, Excel template, rtf template, pdf template, Oracle Toad, Putty, FileZilla, MySQL

Responsibilities:

• Develop Reports in BI Publisher and Write Procedures/ Triggers and Other functions in BI Publisher.
• Review the Reports created by team mates, find solutions to complex problems
• Help in documenting the processes and standards, Generate excel template and manipulate the template with pivot tables and formulas
• ETL, Poslog / tlog/ Perl Script, Pivoting, Data Analysis

Confidential

Sr Consultant

Tools: MS SQL Server 2000, ETL, ColdFusion MX 6.1, Java Script, DHTML, HTML, Dreamweaver, CSS, VSS, Excel.

Responsibilities:

• Create ER Diagrams and Functional and Technical documents.
• Database design changes and impact analysis on changes, ETL using SSIS
• Design database schema, table creation & indexing and Generating SQL Procedures, triggers & views, Dashboards. Conduct performance tuning on the queries and procedures.
• Creating the ColdFusion templates and implementing JavaScript Validations
• Generate excel files and create formulas and pivot table based on business requirements
• Writing DHTML and CSS for interactive and visually sophisticated elements to website.
• Writing CFC’s for connecting to web services and grab the information

Confidential (Seattle, WA)

Team Lead

Tools: MS SQL Server 2000, SSRS, ColdFusion MX 6.1, Fuse Box 4.1, Java Script, HTML, Dreamweaver, CSS.

Responsibilities:

• Coordinating customer meetings and gathering requirements.
• Conducting team meetings and discussing the project reports and creating reports.
• Handling the operations like: database design, table creation & indexing
• Generating SQL Procedures, triggers & views, Cursors, SQL Scripts and Performance tuning. ETL to get data from Enovie database
• Creating the software specification template and the database specification template.
• Creating the basic fuse box templates for the project and Scheduling the pages in ColdFusion admin to load data from pop3 mailbox to the database
• Scheduling the pages to priorities packages in SQL tables based on SQL scripts.
• Providing technical support to the application developers and resolve application problems.

Confidential

Project Lead

Tools: MS SQL Server 2000, ASP, MySQL

Responsibilities:

• Meet with the customer and gather requirements.
• Create Prototypes and discuss with team members and divide the work among team members.
• Database re design based n requirements and creating Procedures and the associated UI.
• Validate the work done by team members and test.

Confidential

Programmer

Tools: Sybase, MySQL, SQL Server 7, Postgres SQL, ColdFusion 6.1 & JavaScript.

Responsibilities:

• Create Procedures, Views and Cursors, Transaction management
• Create the UI using Coldfusion, JavaScript, HTML, CSS.
• Manual Unit testing the modules created