Summary:

• Over 8 years of IT experience with a strong background in Data warehousing development projects and ETL experience using SQL Server SSIS and generated reports in SSRS.
• Expert in planning, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 97-2007 databases.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Over 3 years of experience as an application engineer in the fields of distribution and project management
• Solid hands on experience with Data warehousing tools, Data Mapping and Process Documentation.
• Estimate, schedule and track ETL projects throughout SDLC.
• Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• Experienced in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from, SQL Server and Flat File sources and load into various Business Entities.
• Extensively worked on variables, expressions, groups , dynamic paging in SSRS
• Experienced in TSQL, DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in PL/SQL programming to create SQL Procedure, Functions, Cursor and Triggers.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Good Exposure in SQL Server 2012 in my recent project
• Very good knowledge in scheduling and deploying reports on report manger.
• Experience with high level of accountability, demonstrated initiative and innovation and ability to manage competing priorities, varying workload yet still achieve results.
• Self-learning ability and Leadership Quality.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Experienced in data analysis and problem solving techniques
• Excelled in troubleshooting, decision analysis in a multicultural environment
• Proficient in understanding and utilizing operational research methods to optimize man power and equipment capacity for maximum yield and minimum cost

Technical Skills:

Database Tools : SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL,
Security Manager, Service Manager
ETL Tools : Data Transformation Services (DTS), SQL Server
Integration Services (SSIS), Extract, Transfer and Load,
Import Export Data, Bulk Insert, BCP.
Data Modeling Tools : ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1
Programming Language : T-SQL, PL/SQL
Web Tools: MS-Front Page, MS-Outlook Express.
Reporting Tools : SQL Server Reporting Services (SSRS), MS Access, MS Excel.
Databases : SQL Server 7.0 / 2000/ 2005/2008
Professional Experience:

Confidential, San Jose, CA Oct 2011 - Present
MS SQL Server Developer

ARC 3.7 Project - ARC project will be developed for Medical Coding community. Medical coders are essential in the health information industry. Without medical coders - who assign specific codes to medical procedures and services - doctors, hospitals and other healthcare providers would not get paid. This project is mainly focused on database synchronization to one of the highly recognized healthcare industry leaders located in CA, US. Client has recently acquired another firm and they are in the process synchronizing the data and applications which is present across their and the acquired firm.

• Providing standardization and consistency among databases with a plan and design to implement server to server data synchronization
• Involved in Database design and structure changes based on the client requirements
• Technically analyzed, developed & documented Data Synchronization Engine that would perform all the initial synchronization and alterations in future with rollback on the distributed transaction using linked servers
• Created Complex stored procedures to perform data synchronization among databases residing in different servers by utilizing views
• Maintained integrity constraint while performing inserting and updating data among the databases by using Linked server application
• Backed up Database in BKZ(Backup db) format and extracted/restored in SQL Server 2012 for project loading
• Designing database schema, data insertions and retrievals, procedures, scripts and queries with abilities to prioritize and operate proactively
• Developed different test cases to test the views, stored procedures on a regular basis at different stages of data synchronization
• Scheduled the Main stored procedure on bi-weekly basis by creating a SQL Server Job agent and also implemented efficient error handling techniques
• Performing DB backups, restores, clean-up and database maintenance activities like integrity checks, performance tuning & re-indexing
• Flattened database for reporting needs
• Created SSIS package that extracts loads and transform flat files to a FTP location on a daily basis
• Created SSRS reports(Tab/Matrix/Sub reports) to analyze the data and also to check on the performance of the Synchronization Engine
• Extensively utilized Expressions, variables, grouping, custom code, page break in SSRS reports
• Created SSRS reports that requires dynamic page numbering based on the group expression with page break option
• Created Dynamic SSSIS packages that results in flat files on a monthly basis to analyze the data
• Automated the project loading part on a daily basis based on the frequency of the incoming projects using SSIS package
• Scheduled SSIS jobs on daily/weekly basis
• Implemented SSIS packaged that extracts data pertaining to a particular client and exports as a pipe-delimited TXT files
• Sourced e-commerce chart level data on a regular basis to the management team
• Proposed technical solutions when faced with a new complex design or process issue, where little or no precedent exists.

Environment: MS SQL Server 2005/2008, SSIS, SQL server Reporting Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, e-Commerce.

Confidential, Mountain View, CA July 2011 - Oct 2011
MS SQL Server SSIS Developer

Confidential, is recognized as a leading provider in healthcare industry with comprehensive, technologically advanced automation that enables healthcare facilities to acquire, manage, dispense, and deliver medications and supplies more effectively. The main objective of the project is to create an interface between Omnicell systems and the client for purposes of automating the manual leave of absence (LOA) process currently being used in HR.

Responsibilities:

• Extensive work in gathering business requirements from different level of people involved in the project
• Review and analyze the identified information requirements, create and model a logical design to support the creation / modification of databases
• Developed user defined functions and stored procedures which were executed in SSIS packages using T-SQL
• Automated the process of extracting the latest flat files (csv, txt ...etc) from different sources like FTP, SFTP (Secure FTP) etc.
• Extensive use of expressions, variables, Null Functions, RowCount in SSIS packages
• Merged tables with different columns where the data was written row-wise with a specific sequence into the flat file using Data Conversion, SORT, Union All functions in SSIS
• Developed SSIS packages for creating a position-wise flat files from the data processed from different sources
• Utilized third party tools like WinSCP for sending flat files to secured FTP site
• Extensive use of Script task in the SSIS package utilizing VbScript on the variables to perform reading the files , extraction and writing into the tables based on specifications
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts and schedule SSIS Packages.
• Data validation and cleansing of staged input records (SAP , ADP , HR data) was performed before loading into production environment
• Identified different test conditions on a regular basis based on the specifications and developed test plans and test cases.
• Developed internal data analysis report solutions using SSRS Report Designer for the SSIS packages and hosted on Microsoft SharePoint Server
• Scheduled the monthly/weekly/daily reports to run automatically
• Managed SQL Server databases by implementing backup and alerts
• Managed and optimized schemas, tables, indexes and views
• Prepared and revised technical design document for the automation project.

Environment: MS SQL Server 2005/2008, SSIS, SQL server Reporting Services 2008, SQL Analysis Server 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

BI Developer

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Generated data validation reports in SQL Server Reporting Service (SSRS).
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Wrote Stored Procedures to capture updated and deleted data from OLTP systems.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.
• Configured and Deployed different reports in the Servers using SQL Server 2008 Reporting Services.

Environment: SQL Server 2008 Enterprise Edition, SQL BI Suite (SSIS, SSRS), MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000.

Confidential, Minneapolis, MN 06/2010 - 12/2010
SQL Server Developer

Responsibilities:

• Modified current database by adding tables and relationships to support online system.
• Defined Constraints, Rules and Defaults.
• Was Involved in Database Normalization.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Analyzed the impacts of incorporating data from new sources and the migration of the data warehouse to Teradata.
• Created SSIS packages to capture the Incremental changes for the Data ware house.
• Built SSIS packages to process Cubes, Dimensions and partitions.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Created and managed SQL Server login, database users and Roles.
• Scheduled jobs for backup, and created alerts for error reporting.
• Data migration (import & export - BCP) from Text to SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Participated in different testing and debugging for the system.
• Documented all processes involved in maintaining the database for future reference.
• Develop various reports using Reporting Service (SSRS) as required.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, ODBC, Teradata.

Confidential, WI 06/2009 - 05/2010
SSRS Developer

Responsibilities:

• Created database and worked on estimating practices, scheduling and coordination for Workgroup'10 Suite
• Performed activities such as database creation, performance planning, backup planning and database administration
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS)
• Created adhoc SSRS reports and performance tuned the database based on the analysis from the report
• Developed Charts and Tabular reports in Excel using SSRS

Environment: SQL Server 2005/2008 Enterprise Edition, SSRS.

Confidential, Dearborn, MI 08/2008 - 05/2009
SQL Server / ETL Developer

Team Detroit is a joint venture comprised of WPP's Detroit-based agencies, including JWT, Y & R, Wunderman,Ogilvy and Mindshare.The WPP agencies restructured their service offerings in Detroit to provide best-in-class talent and more effective marketing partnerships to its client base, the largest of which is Ford Motor Company. The Team Detroit concept was devised to provide access to WPP's very best global marketing and communications talent in a seamless fashion.

Responsibilities:

• Installed and Configured SQL Server 2005/2008 enterprise edition per client request.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions in SQL Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005/2008.
• Experience in creating SSIS packages with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Excellent knowledge in creating reports using SSRS.
• Migrated SSRS 2005 reports in to SSRS 2008 reports - database warehouse application for the reports was connected to their teradata data warehouse application for importing and analyzing data.
• Involved in creating different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc and deployed them to the report manager using SSRS.
• Done performance tuning to optimize the run time.
• Changed stored procedures according to the new hierarchy.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Configure backup/recovery strategy per client request. Full Backup database on specific time, transaction log backup using different check point per client request.

Environment: Microsoft SQL Server2000/2005/2008, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), T-SQL, PL/SQL, Erwin 7.3, Dundas Reporting Services Dashboard Bundle, ER Studio 8.0.1, MS Excel, T-SQL.

Confidential, Bangalore, India 01/2008 - 07/2008
SQL Server Developer

Confidential, is the leading UPS distributor in Bangalore, India. It serves all over Southern part of India with its distribution network and has strong hold with a huge database of customers.

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
• Worked with Implementation team and closely moved with end users to implement optimized solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Created reports using stored procedure that involved in scheduling, creating snapshots and subscriptions for the reports (SSRS).
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.

Environment: T-SQL, SQL Server 2000/2005, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Erwin Data Modeler.

Contracted Experience 01/2006 - 12/2007

SQL Developer for Confidential, India

Responsibilities:

• Documenting data models and metadata definitions of database entities and attributes
• Working with data teams to coordinate logical and physical database designs
• Worked with System Administrators and Network Engineers to ensure there was enough disk space
• Analyze stored procedures with Database Engine Tuning Advisor and implement suggestions such as creating indexes
• Developed a logical and physical data model by using ERWIN with the data provided by the client
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Conducted needs analysis and sourced requirements on weekly basis to provide correct resources
• Preparation of project documentation.

Environment: T-SQL, SQL Server 2000/2005, SSRS, Query Analyzer, DTS,MS Access 2000, Erwin Data Modeler.

Confidential, India 08/2000- 12/2005
Data Analyst

Responsibilities:

• Assisted in developing ER diagram for the sales data
• Gathered requirements and documented all the procedures and design
• Collected, analyzed and reported on various internal and external metrics and processes.
• Analyzed complex data models and their relationship to the business process and systems involved
• Created and queried tables using MS SQL 2000 for data analysis
• Created SQL Server database Alerts for indicating when product inventory threshold is reached
• Analyzed and resolved database issues related to data integrity
• Managed process of delivering customer specifications to the production team to assure 100% accuracy by creating formal procedure for the team members
• Utilized SQL to code logic in order to extract , manipulate , transform and aggregate data

Environment: T-SQL, SQL Server 2000/2005,Query Analyzer, DTS,MS Access 2000, Erwin Data Modeler.

Education:

• M.S. in Technology Management
• B.E in Computer Science

References:
Available upon request