SUMMARY

• 7 years of development, administration and IT experience MS SQL Server 2008/2005/2000, in Production, QA and Development Environments.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Expert in designing relational and multidimensional database model and implementation as per business needs.
• Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, Bulk Insert, BCP, Mirroring and Replication.
• Proficient in developing, debugging, deploying SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Oracle, Flat Files etc.).
• Expert level skills in Replication, Data Modeling (Physical and Logical), Star Schema, Snowflake schema, Data Mapping, Installation and Configuration, up gradation from previous versions, Table Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, Objects creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Schedule DTS Packages.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience in working with package configurations, variables and writing expressions, scripts used by the script task.
• Experience in creating Check points, user defined variables, logging techniques etc.
• Experience in working with different containers, tasks, sources and destinations in order to design the SSIS packages.
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using SSIS and Informatica.
• Experience in working on Data analysis and project documentation etc.
• Experience in working on OLAP/OLTP data warehouse models.
• Overall database design, such as creating normalized databases, query tuning, assigning proper indexes, constraints, creation of triggers, and stored procedures.
• Extensively use table partitioning, creating indexes, constraints on tables based of the requirements, Common table expressions etc.
• Expertise in creating the huge table/non-clustered index on the separate file group to improve the performance.
• Had a good knowledge of working with Source Control, bug tracking tools etc. for project coordination.
• Experience in Creating Ad-hoc Reports and interactive reports using SSRS for the management.
• Very good experience in using data modeling tools like ER-win, MS Visio etc.
• Extensive Knowledge in HTML, XML, IIS, website design, software development life cycle.
• Experience in working difference programming environments like ASP.NET, ADO.NET, C# .NET.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008/2005, Oracle 10g, MS Access

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor

ETL Tools: SSIS, Informatica 8.6

Reporting Tools: SSRS

Languages: T-SQL, PL/SQL, HTML, XML, ASP.NET, ADO.NET, C, C++, C#.

IDE: Microsoft BIDS, Microsoft Visual Studio 2000/2005/2008

Operating System: Windows 98/XP, Windows server 2003 Vista, UNIX

Applications: Microsoft Share point, MS excel, word, power point, MS Visio, MS Outlook 2007, Open office 2.0/3.0

Testing Tools: Load Runner 9.5

PROFESSIONAL EXPERIENCE

Confidential, Walnut Creek, CA

SQL/SSIS/SSAS developer

Responsibilities:

• Worked as a data engineer throughout the Production - Staging - SAP Data Imports cycle.
• Key player in solving the data related issues in e-payments.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Designing and developing SQL Server 2008 Databases, Tables, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Worked on project specification documents, participated in data analysis meeting etc.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Generated reports according to business requirements using reporting services 2005.
• Had a good knowledge of working with Source Control, bug tracking tools etc. for project coordination.
• Migrate the data from an Access database to SQL Server 2008.
• Employed SVN for code coordination.
• Worked on the designing the data warehouse in SQL server.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Worked closely with data ware house architecture group.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Written the C# code for the SSIS packages.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, MS-Excel, Windows server 2003.

Confidential, Roseville, CA

SQL/SSIS/SSAS developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse and disability claim systems import data feeds.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Worked on project specification document, participated in data analysis meeting etc.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Generated reports according to business requirements using reporting services 2005.
• Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
• Migrate the data from an Access database to SQL Server 2008
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Worked on the designing the data warehouse in SQL server.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Worked closely with data ware house architecture group.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: SQL Server 2008, Oracle 10g, DB2, SSIS, SSRS, SQL, T-SQL, MS-Excel, Windows server 2003.

Confidential, CA

SQL developer

Responsibilities:

• Participated in meetings with the client and team members.
• Developed user needs and user requirements, identified risks (risk management) and process changes (change management); defined resource needs, work breakdown structures, and functional design around database technologies (Microsoft SQL Server).
• Created use cases, user guides, programmer documentation, application administration, and process flow diagrams.
• Created database for the application, keeping the rules of normalization and business requirements intact.
• Designed data warehouse in Microsoft analysis services environment.
• Worked on Performance tuning and index tuning for improving the performance.
• Used ER-Win for data modeling.
• Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
• Performed complex joins to extract data from various tables in the databases
• Created partitioned views to obtain the data from different servers as per the business requirements.
• Developed triggers and stored procedures to in corporate the business logic and process.
• Indexed views, dimensions and stored outlines for optimal performance
• Utilized SQL Profiler and Database Tuning Advisor to improve and optimize the queries and stored procedures.
• Creating SSIS Packages and built Reports using SSRS.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Created SSRS reports with complex calculation fields.
• Worked on fixing the reports exporting issues and paging issues.
• Developed a number of stored procedures useful for reports.
• Involved in design, programming, deploy and Unit Testing of requested Reports.
• Prepared product compliance documents. Prepared QA compliance plans and interacted with clients / customers in explaining the testing process.

Environment: SQL Server 2008, T-SQL, ER-Win v4.0, Windows 2003, Informatica, SQL Server 2008 Reporting Services, SQL Server 2008 Integration Services, Load runner.

Confidential, AZ

SQL, BI Developer

Responsibilities:

• Active participation in the business requirement meetings with the client.
• Involved in the creating of the design document of the process
• Actively involved in designing the logical and physical architecture for MGIC investment Corporation group database.
• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
• Designed the cubes, by designing dimension and fact tables as per the specifications using Informatica tool.
• Involved in designing of Snow Flake schema with the help of the informatica tool.
• Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined Functions.
• Handling database objects with Enterprise Manager and Query Analyzer
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non Clustered Indexes on tables, views, and columns.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Profiler.
• Designed the crystal reports based on given requirements.
• Performed data conversions from flat files into a normalized database structure.
• Generated reports by using Crystal Reports and Excel spreadsheets
• Analyzing the Database Growth and Space Requirements. Handling Users, Logins or User Rights.

Environment: SQL Server 2008, MS Visio, C#.NET, Crystal Reports, MS Access, Excel, Load runner, OLTP, OLAP

Confidential, TX

SQL/SSIS Developer

Responsibilities:

• Migrated databases from SQL Server 7.0 to SQL Server 2000 using DTS
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Designed the database for production and marketing purpose.
• Created simple to complex SSIS packages.
• Implemented package configurations, logging, scheduling, error handling, variables etc. while creating the packages.
• Created check points to notice the point of failures.
• Created tables, indexes and constraints.
• Created Triggers, Stored procedures for implementing the business logic.
• Used data conversions to convert different data types
• Created Views for Extracting Data.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Developed stored procedures, triggers, views, adding/changing tables for data load and transformation, and data extraction.
• Created monthly reports using reporting wizard with Visual Studio
• Assign Reports to Report Folders in SQL Reporting Services
• Managed Database files, transaction log and estimated space requirements.
• Managed ongoing activities like importing and exporting, backup and recovery.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Used complex expressions to filter and parameterize, and format the contents of a report.
• Defined stored procedures for module integrity and application.

Environment: SQL server 2005/2000, SSIS, Visual Basic 5.0, Crystal Reports 8, Win NT

Confidential 

SQL Server Developer

Responsibilities:

• Actively participated in gathering User Requirement and Online System Specification.
• Actively involved in different stages of Project Life Cycle.
• Worked on writing the test scripts for the database objects.
• Involved in the creation of the databases and designing Normalized database objects.
• Developed Indexes, Stored procedures, Views, Triggers and user-defined functions as per business requirement.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules and defaults.
• 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 stored procedures and functions to support efficient data storage and manipulation.
• Create the SSRS reports.
• Fixed the reports exporting issues and paging issues.
• Created interactive reports as per the business requirements using the stored procedures, expressions, filters.
• Scheduled jobs for backup, and created alerts for error reporting.
• Tested the DTS packages.
• Optimized the performance of queries with modification in index system for online system.
• Tested the performance and load effect on the web application which has SQL database backend using Load runner tool.

Environment: SQL Server 2000, DTS, Transact-SQL, Windows NT, MS-Excel, .NET, Microsoft SQL Reporting Services, Load runner