MANI CHOWDARY Email: ramravi207@gmail.com Phone: 216-264-6066
PROFESSIONAL SUMMARY: • Over 7 years of Experience in Designing, Developing, Maintaining Client/Server and Business Intelligence (BI) database applications using SQL Server 2008R2/2008/2005/2000/Integration Services (SSIS)/Analysis Services (SSAS) /Reporting Services (SSRS). • Expertise in creating complex T-SQL Stored Procedures, (DML/DDL) Triggers, User Defined Functions, Cursors, Views and indexes (Clustered, Non Clustered, Unique) maintaining ACID rules and database normalization. • Extensive knowledge of Relational Database Management Systems (RDBMS). • Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD. • Extract, Transform and Load (ETL) data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages. • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues. • Extensively worked in migrating (ETL) data from Excel, Oracle, CSV file sources to Oracle, DB2, Sybase and MS Access, MS SQL Server and vice versa by using Data Transformation Services (DTS), Import/export data, Bulk Copying Program (BCP) and SSIS utility. • Expert in creating jobs using SQL Server Agent to schedule, configure and deploy SSIS Packages daily/weekly basis which generate Alerts, Mail (SQL Mail Agent) when having errors. • Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan,