SUMMARY

• Database Developer with 5+ years of experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, ETL Design using SSIS, Reporting using SSRS, Testing and Implementation of Data warehouse/Business Intelligence, SQL Server Performance using SQL Profiler, Database Tuning Engine, SQL Performance Monitor.
• Proficient and Skilled in Oracle 9i,11g,10g, MS SQL Server 2012/2008, (database triggers, materialized views, In - line views, Packages, stored procedures, functions, and database constraints), PostgreSQL.
• Recognized by Centers for Disease Control and Prevention (CDC) with an excellence certificate for leading the crisis mitigation team to update and facilitate the smooth running of legacy systems belonging to the National Notifiable Diseases Surveillance System (NNDSS) Modernization Initiative (NMI).

TECHNICAL SKILLS

• Microsoft SSIS - Design and Implementation
• Microsoft SSRS - Design and Generate Reports
• Orion Rhapsody Integration Engine
• Informatica to SSIS
• ETL Spec generation and Conversion
• PostgreSQL
• SQL Server Management Studio
• SQL Developer
• TOAD 11.6.1
• Project Management: TFS
• JIRA
• Web UI: HTML
• CSS
• JavaScript
• Languages: C#
• T-SQL
• PL/SQL
• Visual Basic 5.0/6.0
• SQL Server 2008/2012
• MS Access 2000
• Oracle 9i
• 10g/11g RDBMS
• SDLC Methodologies
• Agile
• Waterfall
• Kanban
• HL7 Message standards

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Developer/ETL Developer

Responsibilities:

• Designed and implemented database objects in SQL Server 2012 to assist in the ETL process
• Developed Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
• Formalized and developed SSIS packages based on business requirements and ETL Spec
• Consolidated the release and deployment process for all database objects and SSIS Packages
• Engineered the entire error handling and message sequencing process for the project
• Decreased execution time of the deployment by over 100secs, resulting in increased efficiency
• Customized views and utilized them in SSRS reports to correctly capture required front end data
• Oversee and solve all production and support issues involving all database related objects
• Rebuild Indexes and Tables as part of Performance Tuning Exercise
• Getting trained in implementing Red Gate Suite for a Continuous Integration & DevOps

Confidential, Atlanta, GA

SQL Developer/Database Implementer

Responsibilities:

• Designed and coded procedures, functions and BI Packages for Microsoft SSIS & Oracle 10g, 11g to interface between the Actimize AIS/RCM server and the Database
• Implemented multiple Actimize database solutions such as CDD (Customer Due Diligence), WLF (Watch-List Filtering), SAM (Suspicious Activity Measurement) into client environment and interfaced them with respective tables from Application and Profile Database in SQL Server & Oracle 11g.
• Responsible for the development, implementation, documentation, creation of test cases, defect resolution, testing, packaging, delivering code drops and patches to clients for Actimize’s debit fraud solution and integrated fraudmanagement platform, resulting in smooth go-live in production
• Increased the overall efficiency of the project by creating robust code, reusable components and scripts to reduceoverhead in future deployments of the product
• Worked closely with Business Analysts, Solution Architects and Project Managers to extract the information from theprevious phase of the project to enhance the solution’s capabilities and performance
• Continued to provide support and have increased customer satisfaction and trust by understanding their issues andproviding immediate assistance

Confidential, Tampa FL

SQL Developer/ Programmer

Responsibilities:

• Created SQL procedures, functions in Oracle 9i
• Migration of databases from one version to the other versions and applying patches
• Writing Packages for various functional areas
• Understanding the structure of new tables and transitioning the old queries with new tables
• Creating SSIS Packages to load data from flat files/Excel into tables
• Created and configured multiple instances for development and production environments
• Using SQL for querying and to diagnose the various operations of the database.
• Analyzing and debugging SQL queries for performance reasons.
• Setup remote LAMP servers at client location and build web interface applications between ‘MAESTRO’ and local PLC hardware
• Design & development of Web UI using HTML, CSS, JavaScript and jQuery

Confidential - Tampa, FL

Intellectual Property Right Database Administrator

Responsibilities:

• Maintain and administer data into a star schema data mart in MS SQL Server 2012 containing sensitive data related to intellectual property evaluation, Prior Arts, market analysis, marketing slicks, license agreement comparisons.

Confidential

Database Administrator

Responsibilities:

• Administered MS SQL Server 2012 database including backups/restores, performance monitoring, disk usage, and report gathering using T-SQL
• Operated the entire client database using MS Access 2000
• Operated the entire orders database using MS SQL Server 2012
• Responsible for generating reports to submit to the Wireless Planning Commission(WPC) of India