SUMMARY

• 12+ Years of professional experience as Database Developer. 10+ Years of professional experience as SQL Server Developer.
• Experience in leading the technical teams.
• Expert in Programming skills in SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers.
• In - depth knowledge of T-SQL (DDL, DML, and DCL).
• Mainly worked in Financial, Insurance, Telecom and Retail Domains.
• Clear and thorough understanding of business processes and workflow.
• Extensive knowledge of extracting and transforming data using tools like Bulk Insert, BCP, DTS and SSIS from heterogeneous databases like Oracle, MS Access, and DB2.
• Expert in implementing business logic in backend using dynamic stored procedures, effective triggers and useful functions.
• Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Programmed SQL 2000/2005/2008 Stored Procedures for Database Performance enhancements and provided user support.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS programs.
• Migrated SQL Server 2000 databases to SQL Server 2005 and SQL Server 2008 databases.
• Experienced in SQL Server Business Intelligence tools like Integration Services (SSIS 2005/2008/2008 R2), Reporting Services (SSRS 2005/2008/2008 R2) and T-SQL as a back end developer in various domains.
• Good knowledge of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture.
• Experienced working in all phases of Software Development Life Cycle (SDLC).
• Worked on the documentation of the System structure and the SQL Agent Jobs.
• Excellent organizational, interpersonal and communication skills with high level of adaptability and flexibility to adjust to changing work positions.
• Strong time Management skills and excellent team player.
• Willing to put in effort to make sure that assigned are completed in a timely manner, despite tremendous time pressure and long hours.
• Work produced is of good quality and keen to learn and is always looking for the better ways to improve methodologies.

TECHNICAL SKILLS

RDBMS: MS SQL Server 7.0 / 2000 / 2005 / 2008 , Oracle 9i, 10g, 11g, Teradata V2R5, MS Access.

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication.

Programming Languages: PL SQL, T-SQL, VB.NET, XML, C++, Java, VB 6.0.

ETL: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Informatica 7.1

Data Modeling: Erwin 3.5 / 4.0.

Scripts: JavaScript, VBScript, HTML and XML.

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express.

Applications: WebFocus 7.7.0, Microsoft Office, MSVisio, and Visual SourceSafe.

Operating Systems: Windows 9x / NT / 2000 / XP / 2003, Windows 7.

Reporting Tools: SSRS, Cognos Reportnet 1.1 MR3 and Crystal Reports 8.0 / 8.5.

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Sr. SQL Developer

Responsibilities:

• Creating Stored Procedures to pull out the data from FACETS tables and providing data and reports required to the client.
• Working in post production environment, making changes to the existing stored procedures as per the changed business requirements.
• As part of development in Health Care Reform team, generating list of Customers with their addresses, who failed to pay the premiums, for the business to send them the letters of termination or delinquency.
• Generating list of Customers in a pipe delimited format and sending email notifications to the business using Shell Scripts.
• Updating customers and their status in FACETS basing on the billing and payments and also the confirmation through inbound and outbound files to the Government.
• Developing code to Bill Pay Application, so that the users could manage payment capability.
• Developing code to E-Billing Application, to provide Employers access to view online billing information and invoices.
• Demoting and promoting code to various database environments using HARVEST Software Change Manager.

Environment: PL SQL, SQL Developer 1.5.5, Oracle 11.2.0.2.0 , FACETS R11, UNIX AIX 7.0, Web Services 1.1/1.3, HARVEST 12.1.

Confidential, Nashville, TN

ETL Developer

Responsibilities:

• Working in the Data Services Team to provide member procurement data to the Data Construction Team to provide the metrics to the management.
• Creating SSIS packages and Stored Procedures to move the data between source and target systems.
• Using Table Partitions to move huge amounts of data between different tables.
• Creating Users, Logins and providing permissions and necessary accesses on the Database Server.
• Interacting directly with the business to gather business requirements related to providing metrics, which helps the business, in their meetings with the clients.
• Creating reports for the business using SSRS to depict how profitable it would be to partner with Confidential .
• Creating Source to Target mapping documentation, low level and high level design documents depicting the source and target systems.

Environment: SQL Server 2008, SSIS, SSRS, T-SQL.

Confidential, Tempe, AZ

Sr. SQL Developer

Responsibilities:

• Working for Confidential Inc on multiple projects involving appraisal of the property, flood determination etc.
• Migrating existing SQL Server 2000 databases and DTS packages to SQL Server 2008 version databases and SSIS.
• Developing ETL solutions using SSIS, Stored procedures to populate the databases with required data.
• Developing new reports as well as modifying the existing reports for the business using SSRS.
• Creating end to end documentation of the project development.

Environment: SQL Server 2000 / 2005 / 2008 (SQL Server Management Studio, Query Analyzer), DTS, SSIS, SSRS, T-SQL, MS Visio.

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

• Working for the World Services Data Warehousing team on PRISM uplift project and AIU uplift project. WSDW captures Operational data from heterogeneous data sources (all domestic and international markets).
• Working closely with the Architects and Reference Architecture team to design the solution for both PRISM Uplift project and AIU Uplift project.
• Interacting with different teams to get the required infrastructure for the projects and the development team.
• Creating a consolidated data structure of all the PRISM related databases in various locations basing on the business needs.
• Documenting the source details, ETL process details of all the required PRISM database tables to design the new data structures.
• Upgrading all the required PRISM DTS packages to SSIS 2008.
• Using SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse.
• Restructuring the stored procedure, designing, coding and developing the same using the MS SQL Server Integration services (SSIS) as per the Amex standards.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services (SSRS 2005) that included paper-based and interactive web-based reports.
• Creating Adhoc reports, Parameterized reports, Toggle reports, Reports with Sub reports using SSRS.
• Building effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
• Got trained on the WebFOCUS, a new application that would replace the existing Telephone Service Center (TSC) and Centralized Call Management PRISM tool.
• Working on the upgradation of AIU databases and reports from SQL 2000 to SQL 2008.
• Managing offshore team for both PRISM Uplift and AIU Uplift to meet the deadlines.

Environment: SQL Server 2000 / 2005 / 2008 (SQL Server Management Studio, Query Analyzer), DTS, SSIS, SSRS, T-SQL, MS Visio, Informatica 8i, WebFocus 7.7.0.

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

• Involved in the successful execution of Proof of Concept which resulted in the approval of the project.
• Interacting with the business directly to understand the business requirements and working with the architects to design the system accordingly.
• Analyzing the business needs of the client and preparing technical requirement documents.
• Analyzing the Clarity database and creating stored procedures to produce reports that specify the statuses of the projects and the amounts and hours spent on the projects.
• Producing different sets of reports using stored procedures, SSIS and SSRS for AET Business and Finance team to help amortize their projects as assets.
• Extensively working with SSIS tool suite, designing and creating mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column.
• Working with different methods of logging in SSIS.
• Extensively using Event Handlers and Error Handling in SSIS packages and notifying process results to various users using send email Task.
• Creating AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Generating different SSRS reports at the Master Project level, Sub Project level as per the customer requirement.
• Working with the offshore team closely to meet the deadlines.

Environment: SQL Server 2005 / 2008 (SQL Server Management Studio, Query Analyzer), SSIS, SSRS, T-SQL, MS Visio.

Confidential, Charlotte, NC

Sr. SQL Server Developer

Responsibilities:

• Analyzing documents for the creation of FAC data mart and also the applications associated with the data mart.
• Researching the Oracle database (Clarity) to get the required data as no documentation was available.
• Interacting with the client directly to get the requirements and explain the project status.
• Creating Scripts to extract data from the source Oracle database.
• Creating Tables, Stored Procedures in the target SQL Server database.
• Creating SSIS package for the extraction of data from Oracle database and loading into a SQL Server database regarding the resource management.
• Using different transformations in SSIS to modify the source data from Oracle before loading into the target SQL Server tables.
• Creating ETL packages (dtsx files) to validate, extract, transform, and load data to target databases using SSIS.
• Creating Stored Procedure for the generation of data report depicting the allocated hours and actual hours for every resource and the project.
• Using Import/Export wizard to move the data between SQL Development and SQL Test databases.
• Developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports using SSRS.
• Various types of reports (Drill down, Matrix, and Navigating) with charts were created using SQL Reporting Services 2005 (SSRS).
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports using SSRS.

Environment: SQL Server 2005/2008 (SQL Server Management Studio, Query Analyzer), SSIS, T-SQL, Oracle 10g, TOAD, MS Visio.

Confidential, Columbus, OH

Sr. SQL Server Developer

Responsibilities:

• Developing migration scripts for movement of data between MC2Service and DSM databases.
• Developing all required database objects such as Stored Procedures, functions and triggers.
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic.
• Writing high level and detail design documents.
• Migrating data by applying business rules and logic based on the Model Types, Territories and Users.
• Migrating data based on the confirmed Customer’s, Technician's and Service Provider's.
• Working with the Unicode data related to the Service Provider's.
• Defining Certificates, Settings and Languages to all the Technician's and Service Provider's basing on the limited input data.
• Developing SSIS package to automate the script execution in the desired sequence by using Sequence Container and SQL Task.
• Implementing error handling and roll back process in ETL load using SSIS.
• Using various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column etc in SSIS.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.

Environment: SQL Server 2005/2008 (SQL Server Management Studio, Query Analyzer), SSIS 2005, T-SQL.

Confidential, Columbus, OH

Sr. SQL Server Developer

Responsibilities:

• Developed SSIS package for reconciliation of data between Schwab and Frontier.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent and later through Control-M job.
• Developed database triggers for keeping the audit logs
• Developed Stored Procedures for checking the data availability in the core tables (through nightly feeds) before running every file extract jobs.
• Created SQL Server Agent Jobs for running the jobs.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Extensively involved in writing Stored Procedures and functions to handle major business crucial calculations.
• Developed Stored Procedures, functions for extracting data from Frontier for creating Positions and Cash files.
• Migrated SQL Server 2000 databases to SQL Server 2005 and 2008 databases.
• Developed various reports using SSRS to generate Reports in HTML, PDF and Microsoft Excel formats.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
• Implemented Microsoft Reporting Services to provide critical reports for senior management as well as reporting for partners.
• Responsible for supporting Webfunds application which includes monitoring performance loads, assisting with user queries and resolving user tickets
• Extensively used SQL Loader scripts to export data from external fundstation files into Oracle Webfunds application database.

Environment: SQL Server 2005 (SQL Server Management Studio, Query Analyzer), SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), DTS, VB.NET, T-SQL, UNIX, Oracle 9i, TOAD.

Confidential, Maryland

SQL Server Developer

Responsibilities:

• Data transfers between various servers using BCP and DTS.
• Involved in requirements gathering and understanding the business flow.
• Developed SQL Server Integration Services (SSIS) packages for transferring data between different billing cycles.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Designed DTS packages for the data transfer from the customer feedback to databases for various purposes.
• Documented the System structure and the SQL Agent Jobs.
• Involved in writing the UNIX Shell scripts to execute the tasks.
• Involved in writing stored procedures for different tasks.

Environment: SQL Server 2005, SQL Server 2000, SQL Server Integration Services (SSIS), DTS, Windows 2003 / 2000, NT 4, UNIX Shell Scripting, AIX 5.3, ASP.NET, Visual Basic, ASP, Visio, Excel, WORD, MS Access.

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
• Involved in writing the UNIX Shell scripts to execute different tasks.
• Configured securities and accesses to production databases and database servers.
• Managed the integration of data and monitored exceptions of highlight data from customers.
• Involved in taking backups of databases, monitoring cluster environment and resolving issues regarding performance tuning, query optimization, security to help production DBA.
• Responsible for Migration i.e. moving from development to QA and then to Production.
• Writing migration scripts and taking care of efficiency.
• Performed various DDL changes in order to improve performance of database.
• Created and developed various reports using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2000/2005, Windows 2000 Server, SSIS, SSRS, Windows NT 4.0, Excel, UNIX Shell Scripting, AIX 5.1, MS Access, MS Visio.

Confidential

SQL Server Developer

Responsibilities:

• Designing schema for various Data Warehouse applications.
• Developing Database objects and applications using T-SQL.
• Designing and implementing database logical and physical Schemas using Erwin.
• Creating & maintaining relationship constraints in order to ensure data integrity.
• Tuning SQL Server Database.
• Working on DTS, Import and Export utility, for transferring data.
• Working with DTS package to process analysis services cubes & dimensions.
• Using DTS to integrate a business process & hence automation.
• Evaluating data storage considerations to store databases and transaction logs.
• Defining Indexes on the tables in order to ensure good performance during data retrievals.
• Developed database triggers for keeping the audit logs.
• Supporting production and development databases.
• Creating DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
• Documented all processes and dataflow involved in the database using Microsoft Visio.
• Extensive use of Profiler in detecting Production bugs.
• Extensively used DTS to Export / Import data from existing database to live database.

Environment: SQL Server 2000, TSQL, DTS, Erwin and Windows NT.

Confidential

Junior PL/SQL Developer

Responsibilities:

• Involved in writing SQL Stored Procedures to access data from Oracle 7i.
• Developed SQL queries to check the database.
• Creation of Triggers, Stored Procedures, Tables, Indexes, Rules.
• Coordinate with clients as needed for on-going system support and troubleshooting.

Environment: Oracle 7.1, PL/SQL, Developer 2000, Solaris.