Summary:

• 9 years of experience in IT as Sr MS SQL Server Developer working in various domains such as Finance, Insurance and Healthcare in 2012/2008R2/2008/2005/2000 Windows Environment.
• Extensive experience in T-SQL, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Online Transaction Processing System OLTP , Data Warehouse OLAP , Client/Server, RDBMS and Web Based Application working in Agile, Waterfall, RUP environment
• Expertise in Data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , Data Transform Services DTS , Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services SSIS and Data Transform Services DTS .
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Extensive experience in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• Experienced with Transact-SQL DDL and DML operations and optimizing the database by creating various Clustered, Non-clustered indexes.
• Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services SSRS .
• Expert in Database Normalization, Denormalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cubes using SSAS.
• Expert in calculating measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions.
• Experience in creating reports using SSRS SQL Server Reporting Services , Crystal Reports, SSAS SQL Server Analytical Services objects and OLAP including Interfaces with BIDS Business Intelligence Development Studio .
• Experience in designing Database Models using MS Visio and ERwin Data Modeler.
• Experienced in planning and implementing MS SQL Server Security and database Permissions.
• 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:

Professional Experience:

Confidential

Sr MS SQL Server Developer

Confidential is a global leader in Assurance, Tax, Transaction and Advisory services providing insights and quality services to deliver help build trust and confidence in the capital markets and in economies the world over. I was responsible for delivering our core business solutions and participating on key architecture initiatives.The Scope of the project is to develop a SQL Server based Global CostRate Application is solution developed to automate the calculation of hourly bill rates and cost rates which are required in the resource allocation process and ability to calculate and process direct and shared cost allocations as planned out to the countries/areas. The solution will help to plan certain elements in local currency which will convert to USD using current year planning rates.

Responsibilities:

• Involved in Planning, Defining and Designing database on business requirement and provided documentation.
• Created / updated / contributed to the living and breathing Solution Design Document SDD for Global CostRate application.
• Updated / Created various UML diagrams using MS Visio 2010 and embedded in SDD.
• Developed complex T-SQL 2012 code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables calculations from different databases.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Worked on Agile Scrum Methodology and attended Sprint planning and estimation meetings
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse, Data Mart Databases and generate XML Files.
• Created 21 different SSIS package of medium to high complexities for ETL by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension tasks in Data Flow Transformations.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages developed to update the database on Daily basis using Control-M Workload Automation Tool
• Designed, Developed and Deployed reports in MS SQL Server 2012 environment using SSRS.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2012, T- SQL, PowerPivot, MS Excel 2010/2007, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Analysis Services SSAS , SQL Server Business Intelligence Development Studio BIDS 2010, Team Foundation Server TFS 2010 / Visual Source Safe VSS , ERwin 8.0/MS Visio 2010, Control-M Workload Automation., Oracle 9i

Confidential

SQL Developer

Confidential is a premier Investment Banking and Financial company offering services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity. The Global Technology Infrastructure GTI group serves as the central provider of technology infrastructure to JPMC. Distributed Technology Services unit is responsible for managing firm's global server and storage portfolio across plan/build/operate functions.Scope of the project is to improve and enhance the support of Oracle database technology on behalf of JPMC's various Lines of Business LoB's . The project spans the areas of Insurance Claims, Deficiency Claims, Collateral Insurances, Property Agents and Investors information, Property and outstanding Loans.

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Perform all SDLC phases related to extract, transform, and load ETL processes using SQL Server Integration Services SSIS and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions Loan Position, Commitment Schedule , Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan , Account, Portfolio, Property, Business Unit, Borrower , Journal Entry Demographic , Journal Entry Line Item etc. to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: MS SQL Server 2012, T- SQL, PowerPivot, MS Excel 2007/2003, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Analysis Services SSAS , SQL Server Business Intelligence Development Studio, Team Foundation Server TFS ,Visual Source Safe VSS , ERwin 8.0/MS Visio 2010, Oracle 9i

Confidential

SQL / SSRS / SSIS / SSAS Developer

Confidential is the largest pharmacy benefit management organization in US. It processes pharmaceutical claims for members at network pharmacies and at their own mail order pharmacies. It provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services.The goal of the project was to modify the existing packages and create new packages using SSIS to Extract, Transfer and Load data into Data Warehouse, analyze the metrics using cubes in SSAS 2008R2 and create reports using SSRS 2008R2 for reporting purpose and to increase the efficiency of the transaction OLTP system for 835/837 transactions.

Responsibilities:

• Worked with Business Analyst and Business Users in requirements gathering phase actively cataloging and supporting various issues and providing their solution.
• Involved in Designing, Developing and Testing of the ETL Extract, Transformation and Load strategy to populate the data from various source systems feeds using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Designed Supported daily, weekly, monthly batch processes using SQL Server Agent.
• 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.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table ,established joins and created Clustered , Non-Clustered indexes whenever necessary.
• Generated various kinds of reports such as Patient History, Physical Examination Report, Consultation, Operative, Radiology, Pathology, Laboratory, Emergency reports and complex SOAP Subjective, Objective, Assessment, and Plan reports using SSRS 2008R2 from SQL Server 2008R2 Database OLTP and SQL Server Analysis Services OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Created different Parameterized Reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly and monthly basis.
• Deployed and configured the reports in the Report Server.
• Created Claims and Enrolment OLAP Cubes for various measure groups and dimensions for analysis of Per Member/Per Month cost to meet the business answers for the client needs using SSAS
• Designing and implementing dimensional data structure like star and snowflake schemas and virtual fact tables and constructing the dimensional hierarchies, calculated members and measures, actions and MDX using SSAS based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measure needs that are calculated from existing measures.
• Involved in identifying and creating Data Sources and Data Source Views DSV in SSAS.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity within the measure group and drill through action using SSAS.
• Created and managed users, roles and groups and handled cube security.
• Designed and Developed efficient SSIS packages for processing fact and dimension tables with complex transformation as well as done with dynamic creation yearly partition and processing cube using SSIS package.
• Designed dynamic creation, yearly partition and processing cube based on adjustment occurring using SSIS package for improvement in performance while browsing the data from cube.
• Designed, developed, created and tested Excel Pivot Table / Power Pivot reports based on OLAP cubes and offline cube files for business analysts.
• Provided documentation about database /data warehouse structures and updated functional specification and technical design documents for cubes, reports and SSIS Packages.

Environment: MS SQL Server 2008R2, T- SQL, MS Excel 2010/2007/2003, PowerPivot, Microsoft SQL Server Integration Services SSIS 2008R2, Microsoft SQL Server Reporting Services SSRS 2008R2, Microsoft SQL Server Analysis Services SSAS 2008R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool , Erwin 8.0/MS Visio 2010, Oracle 9i

Confidential

SQL Server / BI / VB.Net Developer

Confidential is a privately owned firm that provides Puerto Ricans with access to the Medicare Part D Prescription Drug Plan. The plan is a Confidential government program that subsidizes the cost of prescription drugs for Medicare beneficiaries. PICA works with an extensive provider network of more than 900 pharmacies in Puerto Rico and thousands more in the Confidential where people can fill their Medicare Part D prescriptions.Scope: - The scope of the project was to implement MS SQL 2008R2 RDBMS to support their new BI Solution and deploy SQL Server 2008 R2 Reporting Services and Report Builder 3.0 for both Internal and External reporting purpose and to optimize the transaction OLTP system for transactions such as 837/835, 270/271, 997/999

Result: - Reports were delivered 300 faster without IT Staff support. Client expects ROI in less than 2 years.

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation.
• Designing and creating Screens and User Interface using Microsoft Visual Basic .NET.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Designed the Forms, templates created Reports using SSRS 2008 reporting services.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Developed interface store procedure to upload Insurance Record from XML format to Customer Insurance System.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Successfully migrated old data from legacy systems FoxPro and external system including excel and oracle into SQL Server 2008 using SSIS Packages.
• Developed code for various screens in Visual Basic .NET.
• Performed Unit testing for the screens and code in Visual Basic .NET and SQL Server 2008.

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Visual Basic .Net, Query Analyzer, SQL Server Profiler, ERwin 7.3/MS Visio 2007

Confidential

SQL / SSIS / SSRS Developer

Confidential is one of the largest VISA and MasterCard credit providers in the United States, needed to enhance scalability and performance for its BI/data warehouse and OLTP databases. The company enhanced its BI infrastructure by upgrading its Data Warehouse to Microsoft SQL Server 2008 Enterprise 64-bit , on server computer with 16 Intel Itanium 2 processors. The upgraded deployments provide a better view of the business, enterprise-grade scalability, maintenance without scheduled downtime, and easier database management.

Responsibilities:

• Actively Participated in weekly team meeting with business analyst and project team to discuss projects, issues and best practices.
• Efficiently used Microsoft SQL server 2008, SQL server management studio and Business Intelligent Development Studio.
• Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.
• Created SSIS packages to Extract/Transform/Load multiple sources data such as AS400LS, Oracle and DB2 to staging and staging to data mart by reducing level of effort in generating routine reports.
• Used BRD's documents which include the Business requirements for Base Population as well as give the details of calculated and non-calculated fields to support the project and allow for efficient use of resources for creation of Data Marts and other core activities.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, Lookup, Multicast, Derived Column, union all, Source, Excel Source, Flat File Source, OLEDB Destination, Flat file destination.
• To achieve business requirements, used For-Each Loop Container, Sequence Container, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Provided Dynamic Configuration, Custom Package Logging, and Error Handling to SSIS template package.
• Created deployment utility to deploy SSIS Packages.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Build the T-SQL scripts based on SQL Server Coding Standard, rules and templates based on business requirement.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created various database objects including Tables, User Defined Functions, Procedures, Packages, Triggers, Indexes and Views based on user requirements.
• Developed and maintained enterprise reporting SSRS Reporting Service based on specifications and business needs and modified existing reports as needed.
• Enhanced the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented into SQL Server 2008.
• Use temporary table to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.
• Identified and defined the Datasets for the report generation.
• Defined the report layouts and formatted the reports using the Global Variables and Expressions.
• Developed several detail and summary reports including Parameterized report, Sub-reports, Drill-down reports, Matrix or Crosstab reports according to business requirements using SSRS.

Environment: MS SQL Server 2008, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , SQL Server Business Intelligence Development Studio, MS Visio 2007

Confidential

SQL / SSRS / SSIS / SSAS Developer

Confidential James Financial is a diversified holding company providing financial services to individuals, corporations and municipalities through its subsidiary companies that operate primarily in financial planning, investment banking and asset management. The goal of this project was to equip financial advisors to make fast, accurate, and cost-effective decisions, using their existing BI tools that advisors use to analyze vast stores of product, client, and market data. The company's BI platform is based on Microsoft SQL Server 2005 data management software and SQL Server 2005 Integration Services, Analysis Services, and Reporting Services.

Responsibilities:

• Actively participated in gathering business requirements and system specification from business users and business analyst.
• Used Microsoft SQL server 2005, SQL server management studio and BIDS and participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Created SSIS Packages to load data from transactional system DB2 SYSTEM21 , SQL Server 2005 Gateway System, D2L to staging ODS and staging to Enterprise Data-warehouse.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Created deployment utility to deploy SSIS packages over Production, QA and Local System.
• Created ad-hoc packages and used Import/Export utility to load data from QA to Dev Server, Dev to QA Server and Prod to QA for proper packages testing and data validation.
• Used complex T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Defined parent and child relationship by using common table expression for certain Dimension Load.
• Design SSIS package to load data in to DW along with dimensions facts with the use of slowly changing dimension and maintain the historical data too.
• Created/edited sales job module in SQL Agent in development and participated in production deployment.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2005.
• Created Chart and Gauge reports for weekly, monthly, quarterly and yearly sales for DSS system. Ran unit test on SSIS Package and Data validation to check business needs.
• Identified and defined the Datasets for the report generation.
• Managed various reports through Report Manager.
• Created Report Model project, specially designed for end business users so that they can create new and modify the existing ad-hoc reports using Report Builder.
• Created release notes/documents for Mapping, Staging Packages, EDW Packages and EXT Packages, and Deployment Procedure.

Environment: MS SQL Server 2008, Windows server 2003, ERwin Data Modeler, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio, Team Server 2008, MS Visio 2007.

Confidential needed to design and enhance its database to SQL Server 2005 running on Microsoft Windows Server 2003 Data Center. The Project task was to implement and enhancement of existing databases to SQL Server 2005 using Integration Services and Extract, Transform Load ETL tools. It involved Data Loading, Data Parsing, Data Scrubbing and Data validation. SQL Server Reporting Services was used for generation of Reports.

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the database logical design to the physical design by creating tables.
• Analyzed the existing data and performed the appropriate changes in SQL Server 2005 by following the Normalization standards to maintain data consistency and by performing data validation.
• Designed SSIS packages to load the data from SQL Server 2000/2005 to the ETL tier.
• Transferred Flat files from different sources to the ETL tier by using BCP and SSIS Packages.
• Created SSIS Packages by using advance tools i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate .
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy /exact lookups and String manipulations.
• Enforced the Business Rules to filtered bad data from system by using Complex T-SQL Statement, and implemented various Constraints and Triggers for Data Consistency.
• Created and scheduled Microsoft SQL Integration Services SSIS packages which monitors the jobs and sends the notification when the job fails.
• Designed SSAS cube based on DW data. Designed different hierarchy on time and geography dimension. Used parent child hierarchy on GL general ledger dimension.
• Standardized company reports by implementing SQL Server Reporting Services.
• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated the various kinds of reports using Graphs and Images
• Develop Functional/Technical specifications for SQL Server Reporting Services reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Defined the sequence for the tables involved in import based on foreign key constraints.
• Increased query performance, necessary for statistical reporting by more than 25 after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Integration Services SSIS , XML, SQL Server Business Intelligence Development Studio.ITS Data-Solutions Pvt Ltd IDSPL is a premium Oracle training center and IT consulting company inThe project was to Extract and loading data to data warehouse, creating reports and cube.

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2000.
• Wrote various Stored Procedures for the purpose of application development.
• Tuned SQL statements e.g.: using Indexes and Stored Procedures.
• Maintained disaster recovery and database maintenance plan.
• Worked on replication of data Transactional method used .
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Performed job scheduling and alerts.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the databases/servers on a real-time basis.
• In-Depth working knowledge of ODBC.
• Created many complex Stored Procedures and user defined functions.

Environment: SQL Server 2000, Management Studio, DTS, Windows 2003/NT.