SUMMARY

• 11+ years of professional experience on design, development and maintenance of database using tools of MS SQL Server 2000/2005/2008 as a Developer.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000 .
• 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 .
• 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.
• Expert in SQL Server Import/Export wizard to migrate teh Heterogeneous databases such as Oracle and MS Access database, flat files to SQL server 2005.
• Expert in designing complex reports like reports using Cascading parameters, Drill - Through Reports, Parameterized Reports and Report Models and Adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Excellent experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Highly experienced in creating, configuring and scheduling teh Dynamic SSIS packages using containers and variables.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS).
• Expert in developing and deploying cubes using MS SQL Server 2005 Analysis Services involving multidimensional data.
• Experienced in defining queries, generating drill-down report, complex formulae, sub-reports, on-demand reports in Crystal Reports.
• Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
• Very strong T-SQL skill in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers.
• Hands on experience in performance tuning, query optimization, and database optimization
• Good working experience in optimizing T-SQL and complex stored procedures using tools like SQL profiler, and database tuning Advisor(DTA)
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support teh existing applications.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Experience of working with SQL Server DTS/SSIS packages dat include designing and implementing end-to-end ETL packages involving data extraction from multiple heterogeneous sources like SQL Server, Excel.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using DTS and SSIS services.
• 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 teh destinations like Dimensions and facts tables on different schemas such as a star or a snow flake schema
• Understanding of Data mining algorithms for teh real-time validation of data against a set of data
• 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
• Used various expressions to calculate, group, filter, parameterize and format teh contents of a report.
• 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

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, Data Transformation Services, Team Foundation Server (TFS).

Reporting Tools: SSRS 2005/2008, Crystal Reports

Modeling Tools: Erwin,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

MS SQL /PL-SQL Developer/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. Involved in creation/review offunctional requirementspecifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of teh automating teh process for teh Referral Process.
• Teh packages created included a variety of transformations, for exampleSlowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008, 2012.
• Hands on experience in creating teh 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 teh 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 teh testing needs of teh 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 teh 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 teh Analysts during problem resolution.
• Develop / Maintain and support SSIS packages and building teh SSAS cubes as per business needs and requirements.
• Worked with teh Front-end developers extensively for all major/minor enhancements in teh GUI which required database enhancements to teh 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 teh 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

MS 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.
• 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 teh end user wants to see teh reports on fly.
• Created database objects like tables, views, indexes, stored-procedures, triggers and user-defined functions using T-SQL scripts.
• Implemented conditional formatting in reports to get a list of customers who has improper payment history.
• Wrote T-SQL queries, created dynamic Stored Procedures dat calculates teh loan sanctioning details taking teh 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 teh jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling teh 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

MS SQL Server Developer/MSBI 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.
• 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.
• Staging database was involved to perform data cleansing by using T-SQL and stored procedures which made dis process row burst.
• T-SQL tuning and optimization was done for queries dat take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005/2008.
• Performed T-SQL tuning and optimization of queries for reports dat take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2005.
• Scheduled jobs with logging for executing teh stored SSIS packages which were developed to update teh database on daily basis.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Scheduled Code review meetings with team leader and manager on weekly basis.
• Preparing teh Migration document showing teh 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 teh testing results.
• Developed several SSIS Packages to handle teh outbound files to teh Mainframe.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from teh Flat files on monthly and weekly basis.
• Extensively involved in designing teh SSIS packages to export data of flat file source to SQL Server database.
• Created complex stored procedures to use as teh datasets for teh 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 teh reports.
• Worked closely with ETL Data stage Developer for gathering data to load in teh database using .NET
• Helped teh users to test teh reports created and optimized teh performance of teh 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

MS 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 teh customer details, connection details, payment history by giving teh 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 teh 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 dat 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 teh OTC like Pre-Settlements team, Post Settlements team and Cash Management.
• OTC Settlements is responsible for teh management of cash flows generated on teh back of teh OTC Derivative Confirmation agreements.
• Investigating on teh discrepant coupon settlements and finding out teh root cause of teh issues which are common and frequent.
• Raising teh discrepancies to teh Middle Office / Front Office and trade life cycle management team to resolve teh settlement breaks and discrepancies by raising JIRA requests and coordinating with teh technical team in order to resolve teh issue permanently.
• Liaising with clients via e-mails and telephone, in order to provide highest possible standard to resolve teh issues on teh trades.
• Handled almost all high profile clients and also teh sensitive client.
• Worked in automization of teh pre-settlement e-mails dat are sent to teh various sensitive Clients and Banks for confirmation of teh coupon settlements in Rates asset class.
• Maintained good rapport with external and internal clients.
• Worked on teh 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 teh Straight Through Process (STP) method in pre-settlements team for Rates and Equities teams which has halped in clearing teh coupon settlements and has halped in reducing major junk.
• Designed standard operating procedures (SOP’s) and training manuals for Rates department.
• Documented teh 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.
• Installed and Configured SQL Server 2000, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to teh database.
• Involved in assisting QA team in deploying and testing teh application, which uses SQL Server as a database.
• Involved in creation of stored procedures, triggers using T SQL and also performance tuning and optimizing for SQL Server Applications using performance monitor.
• Created Views to reduce database complexities for teh end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports dat take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 200.
• Generated reports using SSRS dat could be used to send information to different Primary Vendors, Clients, and managers.