SUMMARY

• Experience as SQL/PLSQL Programmer Analyst in designing goals of ER modeling for OLTP and dimension modeling for OLAP, Data Ware Housing Applications, and Oracle Reports Developer.
• 6+ years of programming experience as SQL/PLSQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Relational Database Management System (RDBMS).
• High proficiency with SQL Server Architecture (Fundamentals of SQL Server Architecture, Features of SQL Server, Oracle Relational Database Components, Database Architecture, Relational Database Engine Architecture, Administration Architecture, Application Development Architecture).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong Transact - SQL/ PLSQL(oracle) Queries writing skills (DDL- data definition language and DML- data manipulation language).
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Maintained and developed ETL through successfully migrating data from external system including flat files, excel, MS Access and oracle into SQL Server 2008 using SSIS packages
• Excellent conceptual knowledge in developing SQL/PLSQL Stored Procedures, effective user defined functions Functions, Packages, appropriate Database Triggers, Views and Oracle Built in Packages to implement various business logic.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Used Bulk Copy Program (BCP) extensively for flat file import and export operation to/from SQL Server.
• Experience in implementing ETL using SSIS, SQL Server import and export wizard, Oracle PL/SQL, sql loader, Toad automation designer and utl file.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Utilized Data Transformation Services (DTS), SSIS, SSDT tools effectively for data migration from various databases like Oracle, Flat files, Excel files,SQL Database.
• Scheduling and monitoring jobs, daily incremental, alerts, ETL Packages in SQL server.
• Extensive Programming experience in designing reports using SSRS tool and designing database objects in Oracle and SQL Server databases.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL server.
• Knowledge of business intelligence/data warehousing practices and tools including MS SQL Analysis Services (SSAS).
• Experience in creating complex SSRS reports using queries with stored procedures, functions, dynamic T-SQL, CTE’s and using openrowsets to pull data from Oracle databases and to join with SQL tables.
• Good experience in performing all aspects of database administration, including data modeling, backups andrecovery.
• Hands on experience include administering Databases, Database Design, Normalization, Replication, Mirroring, Log Shipping, Full - text indexing, and Database Application Development using varied development tools.
• Involved in creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in documenting the packages, scripts and jobs created to migrated data from legacy system to SQL Server in Implementer friendly format; placing them along with necessary executables on corporate level staging environment as required for operational support.
• Strong interpersonal skills, learning, problem solving and conceptual skills, self motivated, quick learner and determination to learn new technologies, strong Team player, ability to interact with people at all levels. Good communication and presentation skills.
• Supported integration and end user testing with efficient defect management process.
• Experience in Creating Roles and Assigning Permissions to the users.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2012 (SSMS), Oracle 11g/10g/9i/8i/8.0/7.0, MS-Access 97/2000/07/10 , Mysql 5.02, Teradata

Database Tools: SSMS,SSIS, SSRS, SSAS, SQL Assistant 12.0, Toad, SQL Developer, SQL Loader, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, BCP, Teradata.

Languages and Technologies: T-SQL, PLSQL, C, C++, C#.Net, DS, MATLAB, VHDL, VERILOG, PSPICE, MODEL SIM, HTML, XML,Java, UNIX, VB Script.

Operating Systems: Win 2003, Win 2000, Win NT 4.0 & XP, UNIX, Win Vista, Win 7

Other Tools: Microsoft Visual Studio 2012/2008, Microsoft Visio2003

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP,ETL Tier

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Oracle & SQL Server Developer

Responsibilities:

• Developed new SSRS reports using SQL Server Data tools (SSDT) and uploading the reports to production server where users can access it.
• Developed Excel pivot Reports using Datasources embedded with Oracle Databases and sent the reports to the LOB’s (Line of Business) on daily basis.
• Developed stored procedures and functions and created new tables in Toad for Oracle database in production server as per the requirements.
• Worked with the LOB’s (line of business) to deliver them right amount of data upon their request.
• Automated jobs using action palette in automation designer for importing, exporting data to flat files and to run daily scripts.
• Modified and reformatted queries according to business requirements and used the queries to generate reports in excel by changing data connection properties, and exporting it to flat files by running the queries in Toad.
• Running monthly procedures to load data into month end table which collects data of every last day of month.
• Compared and validated the tables structure of SQL Server Databases with existing Oracle database tables and reported to DBA’s to modify upon the requirement.
• Imported and Exported data to and from tables in Microsoft SQL Server using SQL server import and export wizard.
• Created complex SSRS reports using queries with stored procedures, functions, dynamic SQL, CTE’s and using openrowsets to pull data from Oracle databases and to join with SQL tables.
• Documented MS Access database process flow which is having huge amount of data in tables which is processed using forms, macros having queries, linked queries, linked tables from Oracle tables, procedures and functions in VB script
• Documented the process flow of forms in MS Access which has Macros, Queries, Linked Queries, Linked Tables, Tables, Procedures, and Functions.
• Developed the Process Flow Diagrams for each Form of MS Access database respectively for a project.
• Developed SSIS Packages in SSDT tool to import and export data from various databases like Oracle, Flat files, Excel files to SQL Database.
• Worked on the pilot launch of JIRA tool for report request by the client and also tested the tool to see the functionality and have written test cases.

Environment: SQL Server 2008/2005 (SSMS), Windows 7, SSRS, SSIS, SSDT, BIDS, T-SQL, JIRA, MS Excel, MS Access 2002, Visio, Teradata, Oracle, Report Builder, SQL Loader, TOAD, SQL Developer.

Confidential, Irving, TX

SQL Server Developer

Responsibilities:

• Conducted offshore meetings with my peers and have given knowledge transfer to get involved into new projects and existing data in data warehouse.
• Project planning and created documentation including requirements gathering, system design, data flow diagrams, project plans, and testing
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Documented SSRS reports and scheduled SSIS jobs having history data in data warehouse
• Modified existing SSRS reports and SSIS packages based on requirements.
• Imported data from different files like flat files, csv, dat oracle databases to sql server
• Worked on creating entity related (ER) diagrams
• Worked with data analyst to document the process flows of existing data warehouse data
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Performed ETL operations to support the data loads and transformations.
• Designed and created SQL Database, tables, indexes, and views.
• Created User Defined Functions, Stored Procedures, and Triggers.

Environment: SQL Server 2008/2005 (SSMS), Windows XP Professional Server, DTS/SSIS, SSRS, Microsoft Visual Studio2010, C#.Net, BIDS, T-SQL, MS Excel, MS Access 2002, Visio, Teradata, Oracle.

Confidential, Irving, TX

SQL Server Developer/DBA

Responsibilities:

• Responsible for the design and maintenance of reporting databases and applications; completion of ad hoc reporting as requested.
• MS SQL development including T-SQL, Reporting Services, and Integration Services
• FTP and SFTP utilization for data acquisition and transferring data to and from flat files in SSIS
• Created SQL Database, tables, indexes, and views.
• Designed, developed and maintained User Defined Functions, Stored Procedures, and Triggers.
• Used SSIS for data population from different sources and created SSIS packages for data conversions and load data from flat files and vice versa.
• Created packages with different kinds of transformations, and creating variables and changing the values by using the script transformation coding with VBscript in it.
• Installed and configured SQL Server Reporting Services (SSRS) and provided application administration, maintenance of the Reporting server and deployed Reports using Business Intelligence Development Studio (BIDS).
• Created Ad hoc reports utilizing advanced MS Access/Excel skills
• Migrated data from different kind of sources like Teradata, flat files to SQL Server
• Project planning and created documentation including: requirements gathering, system design, data flow diagrams, project plans, and testing
• Responding to customer inquiries in a timely fashion
• Initiated suggestions to continually improve customer satisfaction for internal and external customers

Environment: SQL Server 2008/2005 (SSMS), Windows XP Professional Server, DTS/SSIS, SSRS, Microsoft Visual Studio2010, C#.Net, BIDS, T-SQL, MS Excel, MS Access 2002, Visio, Teradata, Oracle.

Confidential, Memphis, TN

SQL Server Developer

Responsibilities:

• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Troubleshoot failed jobs on the server which involved stored procedures/SSIS packages.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Transferred data from Oracle to SQL server using SSIS.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Deployed and managed reports through SQL Server Reporting Services (SSRS).
• Creating new procedures using Dynamic SQL and Table Variables.
• Assist Developers in writing and tuning new procedures.
• Experience in documenting the Release notes, Release scripts in Implementer friendly format; placing them along with necessary executables on corporate level staging environment.
• Work with DBAs, QA and systems support personnel in elevating and automating successful code to production.
• Created ODBC connections to Teradata and transferred lot of data from Teradata to different destinations like flat files, SQL servers etc.
• Provide on-call support to production system to resolve any issues.

Environment: SQL Server 2005/2008(SSMS), Windows XP Professional Server, DTS/SSIS, SSRS, Microsoft Visual Studio2008/2005, C#.Net, BIDS, T-SQL, MS Excel, MS Access, Visio, Teradata, Oracle.

Confidential, Houston, TX

SQL Server Developer

Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Mentor front end users about SQL Queries.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using SSIS from flat files.
• Created documentation as required for operational support.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Performed daily back up of entire database and recovery.
• Designed and deployed various complex reports using MS Reporting Services.

Environment: SQL Server 2000/ 2005, Windows 2003 Server, DTS, SSIS, Erwin, SQL Profiler, MS SQL Server Reporting Services.

Confidential, Dublin, OH

SQL Server Developer

Responsibilities:

• Designed and implemented stored procedures, views and triggers for automating tasks in TSQL.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.
• Created permanent tables, temporary tables, table variables and indexes.
• Involved in translating business requirements into technical design specifications.
• Designed and deployed various complex reports using MS Reporting Services (SSRS).
• Created and generated reports to display data.
• Used Query Profiler to optimize SQL queries.
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Loaded data from flat files and XLS files into SQL Server 2005.
• Developed and executed several optimized queries in SQL.

Environment: SQL Server 2005(SSMS), Windows 2003 Server, DTS, T-SQL, MS Office 2003,SSIS, MS SQL Server Reporting Services.

Confidential

SQL Server Developer

Responsibilities:

• Installed and maintained MS SQL Server 2000.
• Responsible and for logical and physical design of database.
• Designed and created SQL Database, tables, indexes, and views.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Used SSIS for data population from different sources and create SSIS packages for data conversions and load data from flat files and vice versa.
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Mentor front end users about SQL Queries.
• Transferred data from Teradata to SQL server by creating SSIS packages
• Written stored procedures to generate the reports for marketing departments etc.
• Provided on-call support for various projects.
• Performed daily back up of entire database and recovery.

Environment: SQL Server 2000(SSMS), Windows 2003 Server, SSIS, SSRS, Microsoft visual studio2005, Teradata.