Surendra Babu

571-***-****

ac1ybk@r.postjobfree.com

Professional Summary:

Over 10 years of IT experience in the Analysis, Design, Development, Implementation, perform and Testing Client/Server applications using Microsoft SQL Server 2000/2005/2008R2/2012/2016 and its BI.

Extensive experience with all phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging) in various domains like Banking, Retail, Health & Insurances.

Experience with Installation and Configuration of Microsoft SQL Server 2012/2008R2/2005/2000.

Excellent work experience in MS SQL Server development including designing logical/physical databases, DTS packages, with business intelligence suite like Microsoft Reporting Services (SSRS), Integration services (SSIS), and Analysis services (SSAS), performance tuning and Troubleshooting.

Hands on experience of T-SQL, OLTP, OLAP in designing database and data warehousing.

Experience in logical, physical and dimensional data modeling, data mapping and data normalization, well verse in ERWIN and Microsoft VISIO 2007/2010.

Experience in creating complex Stored procedures, Views, effective Triggers, and useful Functions to facilitate efficient data manipulation and consistent data storage to staging then to databases.

Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS2005/2008R2/2012 Packages with appropriate control & data flow elements.

Hands on experience in using of Control Flow tasks like Execute SQL Task, Data Flow Task, Script Task, SMTP Task, Containers(For Each, Sequence), precedence Constraints with SSIS (SQL Server Integration Services).

Experience in using SSIS (SQL Server Integration Services) transformations like Aggregate, Multicast, Data conversion, Merge Join etc in Data flow task based on multiple sources like flat files (.txt, .csv), excel files, SQL Server databases(OLEDB), ODBC, ADO.Net source, XML Source etc.

To deploy same SSIS packages on various domains used package configurations, Logging for status check, Event Handlers, package explorer, check points & Break point for SSIS Package Debugging.

Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, Power BI Reports, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports and from SSAS cubes as well.

Experience in creating Power Pivot data models to provide the data to Power View dashboards.

Created and implemented cubes, transaction to reporting solutions with SQL Server Analysis services.

MS SQL Server 2005/2008 R2 OLAP developments including KPIs, Data mining, working with slowly changing dimensions (Fixed, Changing and Historical) and MDX(Multidimensional), DAX queries.

Experienced on Master Data Services (MDS), Data Quality Services, Operational Data Sources (ODS).

Experience in Microsoft.net technologies using C#, ASP.NET1.1/2.0/3.0/3.5, ADO.NET, Language integrated Query (LINQ), WCF, WPF, Windows Forms, Windows Controls, XML, JavaScript, Web Services, Web controls, Web Forms, and Visual Studio.NET2005/2008.

Experience with Installation and Configuration of MS SQL Server 2012/2008 R2/2005/2000 and in planning and implementation of MS SQL Server Security and Database permissions.

Strong experience in SQL Server Database Administration, Management, Upgrading, Migrations and Development in Production\Nonproduction environment and clustered environments.

Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2012/2008R2/2005/2000 in OLTP environments.

Extensive work experience with Database Backup, Recovery and Disaster Recovery Procedures and in configuring Database High Availability techniques like Database Mirroring, Log Shipping, Clustering and Recovery on SQL Server 2005 and 2008R2.

Involved in DBA activities such as backups, restores, deploying in DEV/QA/UAT/PROD environments.

Education Qualifications:

Masters in Database design from Ferris State University in 2008.

Bachelors of Engineering from Andhra University, Vishakhapatnam, India in 2006.

Certifications:

Microsoft Certified Professional in developing and implementing web applications with .Net framework.

Skill set:

C/C++, C#, T-SQL,SQL Server 2000/2005/2008R2/2012, Oracle 9i/10g, PL/SQL, MS Management Studio, Business Intelligence Development Studio (BIDS), Microsoft SharePoint 2013, OLAP, OLTP, Query Analyzer, Data Tuning, DTS, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS),Data Quality Services (DQS), Master Data Services (MDS), MDX, BCP, Import/Export Wizard, Erwin 3.x/4.x/7.x,MS VISIO 2000/2003, ASP.NET, ADO.NET, LINQ, XML, HTML, Web Services, Web Intelligence, WSDL, SOAP,AJAX, .Net framework 3.0/3.5/4.0 with Windows Communication Foundation(WCF) / Windows Presentation Foundation (WPF), BizTalk Server 2004/2006, Crystal Reports XI/8.5/8.0, SAP Business Objects(BO/BOBJ), SAP HANA, Tableau 9.0,Microsoft Power BI, Visual Studio 2005/2008/2010, MS Visual Source Safe, MS Performance Point Server, Windows Server 98/2003/2008, Unix/Linux, MS Office 2000/2003/2007.

Projects Summary:

PROJECTS SUMMARY:

Fidelis Care, Buffalo, NY

Data Integration/Micro strategy Reports Engineer 03/2017 to Till date

Fidelis Care is the New York State Catholic Health Plan, providing quality, affordable, New York State-sponsored health insurance coverage for people of all ages and at all stages of life.

Responsibilities:

Supporting Guiding Care project includes Data validation, creating SQL Scripts and BI Reports Testing.

Started working on Facets – health care parallel data warehouse with different databases and schemas.

Created SQL script using PostgreSQL on FACETS with various schemas for Claims Header file generation, Sybase ASE for Unique ID and validated the results with ETL extract using SQLdbx.

Created SSIS ETL Package to load the file to SQL Server 2012 database using SQL Server Data Tools.

Analyzed the data w.r.to mapping document and BRD, validated results and logged defects in HP ALM.

Attended daily huddle meetings for status tracking and interacted with ETL Team to fix the defects.

Worked on Micro strategy reports for their data validation on UI vs SQL query based on requirements.

Validated Web-Focus reports adding test data in UI and thereafter reflected in reports on the next day after daily jobs run.

Hands on experience in designing, format changes, applying filters and prompting for the Micro strategy Reports as well as Web-Focus Reports of Day1/Day15/Day30 for Guiding Care Project.

Worked closely with Business Analysts, End users and Off-shore team to address the defects (more than 50) logged in HP ALM and requirement gathering for Micro strategy and Web-Focus Reports.

Environment:

Green Plum, FACETS, Microsoft SQL Server 2012, T-SQL, PostgreSQL, Sybase ASE, SQL Server Data Tools (SSDT), Visual Studio 2015, SQL Server Integration Services (SSIS), Micro strategy Reports, Web-Focus Reporting, JIRA, SQLdbx, HP ALM, Citrix, Microsoft Office 2016.

Q1 Tech/CareMetx, Chicago, IL

Sr. SQL Server (ETL/MDM) Developer 09/2016 to 01/2017

CareMetx, we tailor our services to the needs of each product and the patient population the product serves. We craft and customize the appropriate high-touch solution, staff our support team with highly-skilled and experienced professionals and support the program with our proprietary hub technology, CareMetx Connect.

Q1 Technologies is the implementation partner to deliver the best solution on Patients, Claims, Physicians, Pharmacy & their activity for Voyager using .net for website development & enhancement and SQL Server 2016 for data store, connectivity and centralized source of truth to be in sync with finance, accounts, operations, customer care and tracking of information using SSIS and MDM.

Responsibilities:

Installed and Configured Microsoft SQL Server 2016, Data Tools, Visual Studio 2015 and Version One.

Worked on Requirement gathering from SME along with a data architect over the phone by daily calls.

Have done the mappings between legacy system and staging database with logical assumptions.

Kept it available to the entire team for validation and understanding of legacy system and its data flow.

Designed and developed logical/physical database for staging using T-SQL of MS SQL Server 2016.

Created SSIS Package to load the data from source to staging by applying business rules using Control flow tasks like Execute SQL Task, Foreach Loop, Data Flow task, File system task, Look up task.

Used a third party tool COZYROC tasks like Table Difference, Lookup Plus task for speed and visibility in order to load the data in Slowly Changing Dimension (SCD-II) model for claim and grant activities.

Enhanced the development to CMX databases from staging with suitable mappings and T-SQL Scripts.

Created SSIS Package to load the data from staging thru Service Requests table which are used for inbound calls customer care and added to the ETL Solution and scheduled using SQL Server Agent Job.

Designed and developed a trust worthy centralized system to capture and to maintain data history, data integrity used for reports, customer care using Master Data (MDS) services and Data Tools-SSIS 2016.

Tested, verified and validated this MDM solution for its data quality and accuracy of dollar amounts in terms of claim accounts per accounts, grant amounts, approved amounts and lot more.

Helped and educated front end development and QA teams on MDM Solution and ETL process flow.

Hands on experience on services – connectivity of databases to the web portals developed by .net team.

Environment:

Microsoft SQL Server 2016/2012, T-SQL, Data Tools, Visual Studio 2015, SQL Server Integration Services(SSIS) 2016, Master Data Services (MDS), COZYROC,VISIO, VSF(Visual Source Safe), Source Tree, GIT – Source Control tool, Version One – Agile Tool, Microsoft Office 2007/2010/2013, C#, Web Services.

COMCAST, Philadelphia, PA

Sr. SQL Server BI Developer 08/2015 to 08/2016

Comcast is a one of the biggest organizations in Telecom Industry. Comcast Corporation is a global media and technology company with two primary businesses, Comcast Cable and NBC Universal. Comcast Cable is one of the nation's largest video, high-speed Internet and phone provider to residential customers under the XFINITY brand and also provides these services to businesses. NBC Universal operates news, entertainment and sports cable networks, the NBC and Telemundo broadcast networks, television production operations, and television station groups, Universal Pictures and Universal Parks and Resorts. Business Operations in Comcast Cable is one the core team to deal with all in and outs in terms of managing data flow and reports delivery based on customer requests & other teams. It deals with ETL, analysis and reporting of Voice (CDV), Video, High Speed Data (HSD) and Home security (XHS) services for all residential and commercial subscribers over the nation.

Responsibilities:

Worked in all phases of SDLC like Requirement gathering, Design, development and Implementation.

Hands on experience in solving JIRA (– a ticketing system) tickets for different Comcast Cable Services.

Created ETL automation processes to deliver weekly/monthly reports using SQL Server Data Tools 2012.

Designed and developed reporting process for a given input file with list of Models/Mac Addresses, in return customers get the required output files on Shared drive. It runs hourly for customer beneficiary using SSIS, T-SQL Stored procedures, SQL Server 2008/2012 and scheduled with SQL Server Agent.

Have done team analysis and produce ad-hoc reports for the JIRA tickets assigned for various services mainly for High Speed Data (Internet) Subscribers and their devices (cable modems, wireless gateways – XB2/XB3) along with start date, duration of service, active/inactive status & many more factors.

Also worked on few other tickets where got to gather requirement and detailed analysis from customer before going to implement reports on XHS (Xfinity Home Security) subscribers along with HSD Service.

Created various excel reports with Pivot tables and generated visualized ad-hoc reports using Power BI.

Worked in automated excel reporting with pivot tables from SQL Server Agent job run as per the schedule to run. Which auto-refresh the data and place the file on the SharePoint site.

Have done end-to-end installation, configuration of Master Data Services (MDS) on SQL Server 2008 R2 and created many stored procedures, views, functions to built a database in order to support reports and high quality, high speed OLTP environment.

Environment:

Microsoft SQL Server 2008/2012/2014, T-SQL, SQL Server Integration Services (SSIS), Visual Studio 2010, SQL Server Data Tools (2012), OLTP, MDS, Tableau, JIRA, MS Office 2007, Excel reporting with Pivot tables.

United Health Group, Horsham, PA

Sr. SQL Server BI Developer / DBA 02/2015 to 08/2015

UnitedHealthcare Medicare & Retirement is an integral part of our Health Benefits platform made up of UnitedHealthcare Medicare & Retirement, UnitedHealthcare Community & State and UnitedHealthcare Employer & Individual. Today, UnitedHealthcare Medicare & Retirement is the largest business in the nation dedicated to serving the health and well-being needs of individuals 50 and older. It is our mission to provide health services uniquely designed for the preventive, chronic and acute health care needs of our aging population. AMR is the team of developers working closely in order to provide a data mart to help the Micro strategy reporting team for its business request and to address policy holder’s questions & Analysis. Designed, developed, deployed and tested the application in SCRUM environment.

Responsibilities:

Extremely involved in Requirement gathering with Business Analysts, Architects, End users and finalized Business Requirement Document (BRD) by thorough understanding of entire process flow & application.

Created and maintained data structures for AMR Data mart on Enterprise Data warehouse (EDW) by creating, maintaining, optimizing database tables, queries, jobs and packages linked to it.

Developed code by using stored procedures, indexes on tables, views and ETL (SSIS) in the way from EDW to Data mart as per coding standards, data model; performance oriented and naming conventions.

Have done workshops with business users, MSTR team, and developed user stories, project documents.

Implemented new and enhancement of SQL Server Integration Services (SSIS) Packages for ETL, and utilized SQL Services Analysis Services (SSAS) for analysis in AGILE development environment.

Involved in design, creation of Micro Strategy &Tableau reports, and dashboards on multi dimensions.

Developed SSIS (ETL) packages and T-SQL Scripts to build universe using SAP Business Objects (BO).

Assisted with automation and deployment of SQL Scripts and SSIS Packages, SSRS reports and maintained daily jobs in different environments using SQL Server Agent & Tivoli Scheduler.

Worked with application developers to solve performance, change control (data/format), cross-functional and structural data problems w.r.to complex joins, indexes and in favor of ETL & reporting purpose.

Provided documentation for internal database structure, procedures and for monthly deployments in both technical and business prospective.

Environment:

Microsoft SQL Server 2008 R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2008/2010, SQL Server Data Services (2012), OLTP, OLAP, Micro Strategy Reports/Dashboard, Tableau Reporting, Crystal Reports, SAP Business Objects Universe, Microsoft VISIO 2007, Team Foundation Server (TFS), MS Office 2007, Tivoli Job Scheduler, HP Quality Center, Red Gate, Windows Server 2008.

BROADCOM, Irvine, CA

Sr. SQL Server BI (SSIS/SSRS) Developer 07/2014 to 01/2015

Broadcom Corporation (NASDAQ: BRCM), a FORTUNE 500 company, is a global leader and innovator in semiconductor solutions for wired and wireless communications. Broadcom is a retail and wholesale industry; its products seamlessly deliver voice, video, data and multimedia connectivity in the home, office and mobile environments. With the industry's broadest portfolio of state-of-the-art system-on-a-chip and embedded software solutions, Broadcom is changing the world by connecting everything. Here, IT group called Building Better Broadcom (B3) implementing a migration of multiple environments like People soft, Sales force to Microsoft SQL Server data warehouse and SAP ERP Systems.

Responsibilities:

Created lots of stored procedures, views, triggers, T-SQL Scripts for multiple applications.

Extensively worked on extraction of data from file systems, ODBC to SQL Server 2008 R2/ 2012.

Developed T-SQL scripts for Execute SQL task, Execute Package tasks and appropriate transformations using SSIS for the sake of automation of end-to-end ETL process and inputs to downstream systems.

Generating various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports in customer level, manger level, vendor level using Microsoft and SAP technologies.

Write documentation describing end to end business flow, data flow among different applications, program modification, automation processes for maintenance and to support business users.

Worked on SSIS Package names in a folder to admin tables using Bulk load processing, T-SQL Scripting, query optimization, indexing using SQL server 2008 R2.

Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases (VLDB) in terabytes.

Created SSRS & SAP BO ad-hoc reports for retail purchases of products like invoices, new vendors, Pos.

Tested and deployed thru various environments like QA, UAT using test scripts, test cases.

Environment:

Microsoft SQL Server 2012/2008 R2, Visual Studio 2010/2008, Microsoft Data tools, Business Intelligence Development Studio (BIDS), Remedy, Service Now, SQL Server Integration Services (SSIS), Visualization tool Microsoft Power BI,SAP Business Objects (BO/BOBJ), and SAP BI/BW 7.3, Windows Server 2008.

T-Mobile, Seattle, WA

Sr. T-SQL/SSIS/SSRS/SSAS Developer 01/2013 to 06/2014

T-Mobile USA is a national wireless communications, a provider of Voice; messaging and data coverage over 293 million subscribers around the nation. Business purpose of the SAP is to provide Comprehensive, Integrated & Centralized Data of all the T-Mobile Activities across the enterprise. T-Mobile has a huge database and very large data ware house for Pre-Paid (PRS) and Post Paid systems. Here PRS supports a wide range of operational and analytical reporting across various business groups. Downstream systems are Report Info – SSAS cube based reports, feeds to various SAP APO modules like Demand Planning and Supply Network Planning and actively involved in the life cycle implementation in SAP BW, HANA modules.

Responsibilities:

Lead responsibilities in scheduling KT sessions with End client, business to implementation partner.

Coordinate with offshore and onsite by providing in-detail analysis and explanation like KT, shadowing and reverse shadowing tasks.

Worked extensively on metadata driven database architecture for all environments, error logs, permissions, changes.

Worked extensively on ticketing system, user queries, production issues and its fixes thru Remedy.

Designed modified and maintained dimensions and measures on SSAS cubes, feeds from EDW and extracts to BO reports.

Designed and Developed SSIS packages for extracting the data from multiple data source and load into the appropriate tables in the database.

Expertise in using tasks like Conditional Split, Derived Column, Lookup, Merge Join etc.

Fetch the processed data from Data warehouse and feed it to SAP HANA database for high level reports.

Optimized Queries and used SQL Profiler to identify the bottle necks in scripts.

Designed and developed an automated process in SSIS to load data on a monthly basis.

Created reports from cubes and maintained SSAS cubes, MDX queries using SQL server Analysis Services (SSAS) on very large databases (VLDB).

Set up the SharePoint server 2013 and configured it to work with SQL server 2012.

Integrated SharePoint and Power Pivot by fetching data from SQL server 2012 and deployed them onto SharePoint site.

Created dashboards in Share Point using Power View to display the repots, Provided/configured role based securities for reports using SSRS, SAP BOBJ including BO Universes & linked universes and MOSS.

Created custom intermediate schema to store data pulled from original data source.

Created T-SQL Stored Procedures and Views which work on the basis of core business model.

Optimized existing stored procedures and tuned queries to run faster consuming less resources.

Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.

Handled and supported BO reports and SSRS reports by providing ad-hoc SQL queries and analysis on business changes.

Created maintenance reports by using various components like Grouping, Sorting, Filters, bookmarks and Navigation.

Worked extensively on unit testing, regression testing for each and every deployment and fix.

Environment:

Microsoft SQL Server 2012/2008 R2/2005/2000, T-SQL, Visual Studio 2010/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), EDW, MDX, PDW, Team Foundation Server (TFS), HP Quality Center, OLTP, OLAP, Microsoft VISIO 2003/2007, Data Quality Services (DQS), Windows Server 2012, Unix/Linux, SAP Business Objects (BOBJ), SAP HANA, SAP BI/BW, SAP BODS, Microsoft Share Point Server, Teradata, Informatica, Oracle 10g.

Wells Fargo Home Mortgage, Minneapolis, MN

Sr.SQL Server SSIS/SSRS Developer 03/2012 – 12/2012

Wells Fargo home mortgage is the organization maintaining the data of different varieties of retail home loans, funded loans, and third party loans. This application ‘CMO-AR’ (Capital Marketing Operations – Analytics and Reporting) provides business awareness to the investors and financial statistics and support to the board of directors. It helps a lot for decision making activities to Business Analysts. The entire end-to-end data flow service is implemented using SQL Server 2008 R2 and Business Intelligence suite (SSIS/SSRS/SSAS).

Responsibilities:

Extensively worked on the extraction of data from file load systems, transformed and loaded to the

Data ware house.

Designed and floated multiple report models on views (due to security issues) and deployed them on to the production reporting server.

Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using Microsoft technologies like SQL Server Reporting Services (SSRS) and SAP technologies like Business Objects.

Modified the stored procedures to get the new functionality depending on the business requirement.

Designed and created Excel based reports, crystal reports, SAP Business Objects (BO) reports, aggregate aware objects, restrictions, Universe maintenance, Linked Universes.

Involved in extracting the data from flat files in the development server and loading the clean data

To QA, UAT, production servers using SSIS

Involved in scheduling packages using SQL Server Agent.

Wrote SQL joins, sub queries, tracing and performance tuning for sophisticated SSRS and BO reports.

Used SQL Profiler for debugging issue, performance tuning whenever necessary.

Extensively involved in solving the production issues when dealing the sales force cases.

Gave 24/7 production support whenever required.

Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.

Managed, operated and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.

Continued to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates

Analyzed data importing processes and design processes/applications to help increase automation, efficiency, flexibility and extensibility.

Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.

Worked extensively with complex T-SQL queries, created functions, views and stored procedures.

Created many tables with the cluster and non-clustered indexes on columns.

Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.

Environment: Windows 2012/2008/2003/2000/NT4.0, Microsoft SQL Server 2008 R2/2005/2000, T-SQL, Visual Studio 2010/2008,Team Foundation Server(TFS), SAP Business Objects (BO), Crystal Reports, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Red gate, DTS, AS400, Unix/Linux, Performance Tuning, trouble shooting, Clustering.

IBM, Portland, OR 09/2011 – 02/2012

Sr.SQL Server SSIS/SSRS Developer / DBA

IBM is implementation partner for Fanniemae mortgage services. DINO is the nightly process run all the administrative work which is developed and modified by developers and customer care. It delivers daily/weekly/monthly calculations, statistics, payments, bills, e-mails, reports to the corresponding departments.

Responsibilities:

Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.

Installed and Configured Microsoft SQL Server 2008 R2 on different domain servers like dev, QA, UAT and production on Windows operating system.

Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.

Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.

Designed, Developed and tested packages to extract, transform and load data using SQL Server integration services (SSIS).

Developed advanced ETL import packages using SSIS, T-SQL Scripts, T-SQL scripts for Execute SQL task and Expressions in ADO.NET sources to transform and import raw index data into database tables and to staging by executing business logic, rules and client requirement.

Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.

Manage, operate and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed on a daily basis.

Continue to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates

Developed data importing processes and designed processes/applications to help increase automation, efficiency, flexibility and extensibility by creating T-SQL Scripts, Stored procedures, functions… Etc.

Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis.

Implement code changes, bug fixes and configuration changes (if needed) and other development and administrative activities.

Created Snapshot and Transactional replication and performed backup and restore operations as well.

Technical support to users for various purposes like Access change, performance issues and storage space

Work in cooperation with other teams and business analysts for achievement of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.

To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.

Running various DBCC commands for administration of database objects and system performance.

24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.

To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.

Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.

Environment: Windows 2008/2003/2000/NT4.0, MS-SQL Server 2008/2005/2000, T-SQL, Visual Studio 2010/2008, LINQ, WCF, Team Foundation Server(TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, Red gate, SQL Profiler, Auto sys, System Monitor/ Performance Monitor, DTS, Performance Tuning, trouble shooting, Clustering, Microsoft Office.

VISA Foster City, CA 02/2011 – 08/2011

SQL Server SSIS/SSRS/SSAS Developer/DBA

VISA IntelliLink Compliance Management (VICM) is an application that helps financial institutions, government agencies and other entities monitor and manage their cards programs to ensure that card use conforms to their policies and procedures as well as to identify instances of card misuse, specifically potential fraud.

Responsibilities:

Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2008/2005/2000. Enterprise database environment for multiple client sites.

Set up, oversee, and trouble shoot network architecture, server side configuration, client side configuration, connection, manager

Contact this candidate