SUMMARY

• 7+ years of professional experience on design, development and maintenance of database using tools of MS SQL Server 2005/2008, TOAD / SQL Developer as a Developer.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005.
• Experienced in client requirement Analysis, Physical, Logical design, development Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 , DTS, SSIS, SSAS and SSRS 2005/2008.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2000/2005/2008 .
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader to download and manipulate files.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience of working with SQL Server SSIS packages that include designing and implementing end - to-end ETL packages involving data extraction from multiple heterogeneous sources like SQL Server, Excel.
• Expert in developing and deploying cubes using MS SQL Server 2008/2012 Analysis Services involving multidimensional data.
• Very strong T-SQL skill in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers.
• Experience in deploying complex packages from development to production environment using proper package configuration.
• Sound skill in implementing ETL strategies to Extract, Clean and Deliver Data to the destinations like Dimensions and facts tables on different schemas such as a star or a snow flake schema
• Hands on experience working with SSRS designing different types of reports, parameterized reports, cascading parameterized reports, drill down reports, drill through reports, sub reports, and Ad-hoc reports
• Experience in configuration of report server and report manager scheduling, permissions to different level of users in SQL Server Reporting Services (SSRS).
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008 , Access 2000/2003, Oracle 8i/9i/10g/11g, Teradata

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, Visual Studio 2008/2010/2014 , Team Foundation Server (TFS).

Reporting Tools: SSRS 2005/2008, Crystal Reports

Modeling Tools: MS VISIO.

ETL Tools: DTS,SQL Server Integration Services (SSIS 2005/2008)

Office Suite: MS Office 2000/2003/2007

Operation Systems: Windows Server 2000/2003/2008 , Windows NT 4.0, Windows XP/98

Languages/IDE’s: C/C++, T- SQL, VB 6.0, ASP.NET, VB.NET

PROFESSIONAL EXPERIENCE

Confidential - Baltimore - MD

PL/SQL Developer/MS SQL/MSBI

Responsibilities:

• Production support of two major applications - Data Warehouse (Oracle) and Database (Oracle).
• Production support of forecasting platform based on MS SQL Server (2000, 2005, 2008, 2008 R2), spanning across 8 servers.
• Develop performance enhancements leveraging Packages, Stored procedures / Views, DBMS jobs, SSIS, SSRS and SSAS.
• Used SSIS for ETL packages (.dtsx files) development to extract and transform data from MS SQL Server 2005/2008/2012 and Oracle Data warehouse to destination database of SQL Server 2008.
• Created SSIS Packages which involved in complex data flow tasks and further created Analysis Services CUBE’s for business reporting.
• Developed and deploying cubes using MS SQL Server 2008/2012 Analysis Services involving multidimensional data.
• Hands on experience in creating the Reports using SSRS (Created over 20 reports).
• Worked extensively on performance improvement for Oracle Database applications.
• Created PL/SQL Views, Stored Procedures, Packages as per the business requirements. Also, worked on existing packages, procedures, views which involved both minor and major changes.
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete System Development Life Cycle.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing.
• Performed modifications on existing PL/SQL packages, procedures, triggers, functions, Indexes as per change request and maintained it.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Used Materialized Views, Packages and Dynamic SQL.
• Interacted with business users and the Analysts during problem resolution.
• Develop / Maintain and support SSIS packages and building the SSAS cubes as per business needs and requirements.
• Worked with the Front-end developers extensively for all major/minor enhancements in the GUI which required database enhancements to the packages/stored procedures, views etc.
• Improve performance of Retail Forecasting process.
• Develop capacity usage level forecasting for retail positions thereby improved Portfolio Analytics.
• Develop sales segment reporting from data warehouse.
• Manage Data warehouse (Oracle) and Database application which are an ongoing support activities in addition to the project deliverables.
• Development & testing major/minor enhancements for Oracle Data warehouse application.
• Develop & test interfaces for two applications PRiMERA and CERDW as needed.
• Review & Maintain application health, monitor daily jobs.
• Investigate production issues.
• Collaborate with business users on enhancement requests and gather requirements as necessary.
• Actively participate in prioritization discussions with business users.

Environment: PL/SQL, TFS, MS SQL Server 2000/2005/2008 /2008 R2/2012, T-SQL, SSIS, SSAS, SSRS, C#. NET, MS Excel, SharePoint 2010.

Confidential - Sioux Falls, South Dakota

PL/SQL Server Developer/MSBI Developer

Responsibilities:

• Migrated data from one standard database for loans created to diversified destinations for auto loans, student loans, and home loans using SSIS packages.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular loan type in given period and created report models for Ad hoc reports when the end user wants to see the reports on fly.
• Effectively made use ofIndexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Packages and Stored Procedures.
• Analyze the Business Requirements and create detailed Interface Agreements, Functional design documents and Technical design Documents for all the business interfaces.
• Manage Data warehouse (Oracle) ongoing support activities in addition to the project deliverables.
• Development & testing minor enhancements for Oracle Data warehouse application.
• Created database objects like tables, views, indexes, stored-procedures, Packages, triggers and user-defined functions using in PL/SQL as per the business requirements.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Implemented conditional formatting in reports to get a list of customers who have improper payment history.
• Wrote T-SQL queries, created dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input.
• Involved in creating a stored procedure to calculate loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to AMS.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Environment: MS SQL Server 2008 R2/2008, T-SQL, SQL Server Integration Services (SSIS), SSRS, DTS, C#. NET, MS Excel, DB2, Windows XP.

Confidential - Sacramento, California

PL/ SQL Server Developer/SSIS Developer

Responsibilities:

• Used SSIS for ETL packages (.dtsx files) development to extract and transform data from MS SQL Server 2005 databases to destination database of SQL Server 2008.
• Fine-tuned PL/SQL queries for maximum efficiency and performance.
• Dynamic behavior was achieved of SSIS packages by using package variables; variables were containing configurations like credentials, StartDate and EndDate etc.
• Several Control Flow and Data Flow components were used during SSIS packages development like Execute SQL, Sequence Container, Data Flow, Script Task, Lookup Transformation, Derived Column, Script Component, OLEDB Source and Destination components.
• Created PL/SQL Views, Stored Procedures, Packages as per the business requirements. Also, worked on existing packages, procedures, views which involved both minor and major changes.
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Staging database was involved to perform data cleansing by using T-SQL and stored procedures which made this process row burst.
• Loaded the data using the SQL loader, Imports & UTL files based on file formats.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query etc.
• Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
• Created Oracle Tables, Views (Materialized), Constrains, Synonyms, Sequences.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Scheduled jobs with logging for executing the stored SSIS packages which were developed to update the database on daily basis.
• Scheduled Code review meetings with team leader and manager on weekly basis.
• Preparing the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Involved in performing Unit testing on Test server and preparing Unit testing document showing the testing results.
• Developed several SSIS Packages to handle the outbound files to the Mainframe.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Created complex stored procedures to use as the datasets for the Report Design, to generate Ad- hoc reports using SSRS.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked closely with ETL Data stage Developer for gathering data to load in the database using .NET
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases. Created Test Cases Manually and Test Plans for System Testing.

Environment: SQL server 2008/ SQL server 2008 R2, Windows 2003 Standard Edition, SSIS, SSRS, SharePoint 2010.

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2005.
• Involved in migration of SQL 2000 to SQL server 2005 using Upgrade Advisor.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard. Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Tested successfully all store procedures on SQL 2005 server Environment: SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, Windows 2007 Server, Enterprise Manager, Query Analyzer, SQL Profiler
• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Created complex script to load UltraRev operational data to Support Direct Mail and Email Campaigns.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment: SQL server 2005, MS Excel, SSIS 2005, SSRS 2005, T-SQL.

Confidential

Business System Analyst

Responsibilities:

• Interacting with various departments within the OTC like Pre-Settlements team, Post Settlements team and Cash Management.
• OTC Settlements is responsible for the management of cash flows generated on the back of the OTC Derivative Confirmation agreements.
• Investigating on the discrepant coupon settlements and finding out the root cause of the issues which are common and frequent.
• Raising the discrepancies to the Middle Office / Front Office and trade life cycle management team to resolve the settlement breaks and discrepancies by raising JIRA requests and coordinating with the technical team in order to resolve the issue permanently.
• Liaising with clients via e-mails and telephone, in order to provide highest possible standard to resolve the issues on the trades.
• Handled almost all high profile clients and also the sensitive client.
• Worked in automization of the pre-settlement e-mails that are sent to the various sensitive Clients and Banks for confirmation of the coupon settlements in Rates asset class.
• Maintained good rapport with external and internal clients.
• Worked on the static data - Settlement Instructions of various sensitive clients and banks.
• Sound product knowledge in different products in OTC Derivatives like, Vanilla Swaps,, Mark-to-Market (FX Resettable), FX Forwards, Credit Default Swaps, Cross Currency Swaps, Swaptions, Inflation Swaps, OIS, Structured products etc.
• Sound knowledge in ISDA (International Standard Derivatives Association).
• Sound application knowledge in using PEGA (Investigation tool), KASYMIR (Reconciliation tool), TLM (Reconciliation Tool).
• Formulated the Straight Through Process (STP) method in pre-settlements team for Rates and Equities teams which has helped in clearing the coupon settlements and has helped in reducing major junk.
• Designed standard operating procedures (SOP’s) and training manuals for Rates department.
• Documented the complete process manuals for certain applications most widely used in Settlement process (Pre-Settlements/Post Settlements and AVI teams) like KASYMIR, TLM, DELTA, PEGA, MEMPHIS, OBOE, EROS etc.