SUMMARY

• Over 7+ years of experience in IT, as MS SQL Server 2008/2005/2000/7.0, Oracle 9i, 10g, 11g Database Developer in Windows environment in financial, insurance and retail companies.
• Expert in designing dimensional/relational database model and implementation as per business requirements.
• Extensive experience in Data warehousing methodology especially Ralph Kimball methodology and Dimensional modeling using Star and Snowflake schemas.
• In - depth knowledge of Transact-SQL DDL and DML, Stored procedures, Indexes, Views, Synonyms, CTE's, Derived Tables & User defined functions.
• Expertise in Oracle PL/SQL (Stored Procedures, Functions, Packages and Triggers).
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Expert in creating ETL Packages using DTS Import Export Data, SSIS/DTS Packages, Informatica 8.0, 8.6.
• Knowledge of all phases of ETL (Extraction, Transformation, and Loading) by developing Star Schemas, Programs, Procedures and Solutions for Data Acquisition, Extraction, Cleansing, Transformation, Formatting, Integration and Loading and having working knowledge with Informatica.
• Good knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Experience in designing Database Models using MS Visio and ER-win.
• Experience in developing MDX queries and OLAP cubes using SSAS (SQL Server Analytical Services)
• Expertise in generating reports using Performance Point Server, Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Experience in version control tools such as Microsoft Visual Source Safe, Team foundation server etc.;
• Expert in creating dashboards/scorecards using ProClarity, SSRS etc.;
• Handled project as team leader implementing Agile Methodologies in order to get best end product after whole Software Development Life Cycle (SDLC)
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 3.x/9x/ME/NT/2000/XP/2003

Databases: MS SQL Server 2008/2005/2000/7.0 /6, ), ORACLE 9i/10g/11g, MS Access

ETL Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services, Informatica 8.6/8.5/8.0

Database Tools: SQL Profiler, SQL Query Analyzer, PL/SQL Developer 5.1, Toad 6.3 Management studio, Index Analyzer, DTS Import/Export, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.

Languages: ASP .Net 2.0, C ++, C#

Reporting Tools: SQL Server Reporting Services (SSRS), ProClarity 6, Crystal reports 8.0/9.0/10.0, MS Excel.

Data Model Tool: ERWIN, Oracle Designer

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Sr. SQL Server Developer

Responsibilities:

• Configuring the package for QA, Production environments.
• Mapping data between Sql Server tables and Oracle tables.
• Created tables in Sql server as per oracle staging area Table structure.
• Developed procedures and functions to pull the data from oracle purchase order, sales order.
• Pull the data related to customers and vendors and loaded the data into Sql server mapped the data according to system requirements.
• Involved in Unit testing, system integration testing.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Developed database objects such as SSIS Packages, Tables, Triggers and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Config file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• De-normalizing database using Stored Procedures for a single row feed to legacy system.
• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front end application.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Develop SSRS Reports for Managers.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2005 database, then from legacy database to SQL Server Database and vice versa.

Environment: MS SQL Server 2008/2005, SSIS/SSRS/SSAS, ProClarity, Microsoft Visual Source Safe, Windows Server 2003, Oracle 10g/11g, PL/SQL Developer.

Confidential, Washington DC

SQL Server Analyst

Responsibilities:

• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created Stored Procedures using T-SQL to evaluate result for the repots to implement using Management studio.
• Generate Ad hoc reports using Business object and SSRS.
• Developed different Scripts for the Data analysts for Verification of reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked on SSIS Package, Import/Export for transferring data between SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Participated in migration from SQL server 2000 to SQL server 2005 using SSIS.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Used Pivot table to provide structure to Reports in proper manner like months etc.
• Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
• Scheduled the DTS Packages for migration data from old system to MS SQL 2005.

Environment: Microsoft SQL Server 2000/2005 Enterprise Edition, SQL Server Reporting Services(SSRS), Management studio, Business Object XI, Crystal Report, Windows XP, Ms excel 2003, Microsoft Visual Studio 2005.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering System Requirements & Analysis of Requirements.
• Involved in preparing Project related documents like System Requirement Documents, Technical documents, Detail Design and Test plans.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Build ETL mappings to pull data from Oracle, Sql server, DB2, flat files to target Oracle database.
• Designed and developed mappings with optimal performance using Aggregator, Java, Joiner, Normalizer, Rank, Sequence Generator, SQL, Transaction Control, Un-Cached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union, XML Transformations, etc
• Created sessions and workflows to help schedule nightly loads and process data from all source terminal Data Collection points.
• Involved in Database Design and Maintenance.
• Involved in creating stored procedures, packages, functions and user interfaces.
• Tested and implemented of relevant modules.
• Created reports using Reports 6i/8i
• Coordinated between Development team and QA team

Environment: Oracle 6i/8i, Informatica Power Center 8.6/ 8.0/8.5/7.1, Oracle Reports 6i/8i, Toad, Visual Basic, C++, JAVA, Windows 98/XP and UNX

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Functional responsibilities have included business process analysis, requirements gathering and Analysis, functional gap analysis (between RMS screen and the corresponding Mainframe screens and preparing documentation for the same), application design and configuration.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers
• Used the query Tuning Methodologies to fine-tune the SQL and PL/SQL Codes.
• Pull the data related to customers and vendors and loaded the data into Sql server mapped the data Informatica Transformations.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Developed mappings/sessions using Informatica Power Center 8.5/7.1.3 for data loading
• Creation of temporary tables for loading the legacy data and validating the data using PL/SQL to base tables.
• Developing interfaces by using PL/SQL and maintaining shell scripts
• Maintaining a Test & Development Database at offshore with daily refresh of data from production.
• Customized custom forms using Forms 6i.
• Created multiple custom reports using Reports 6i.
• Converting the form6i and report 6i from client server to web sever.
• Involved in writing Test plans and Test cases.

Environment: UNIX Shell scripts, Oracle 9i, Oracle 9iAS, PL/SQL, Oracle Developer 6i, SQL Server 2000, Informatica Power Center 8.0/8.6/ 8.5/7.1.

Confidential, New York City, NY

SQL Server Developer

Responsibilities:

• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed and analyzed databases.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in System testing.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: Windows NT, Microsoft SQL Server 2000, Microsoft Excel, SQL Query Analyzer, Crystal Reports