SUMMARY

• MS SQL Server Developer with 9+ years of strong experience in various domains like Financial, Healthcare, Retail and insurance with expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Developed Logical and physical data model using ERWIN, ER Studio and mapped the data into database objects.
• Introduced best practices for Data Services andCrystalReportsdevelopment.
• Expert CrystalReports, stored procedures and Share point on SQL Server database
• Strong MS SQL Server 2012/2008/2008 R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).
• In - depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Experience in integration of various data sources with multiple relational databases like Oracle,SQL Server,Sybase, Mainframes, COBOL files, XML Files.
• Extensive experience in Migration of data from DB2, Oracle, and Sybase to MS SQL Server.
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP technologies.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Designed and built SQL dashboardfor reporting to allow ad hoc reports for management and Intelligence.
• Extensive Knowledge in SSASstorage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX, DAX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes withSSAS 2008 and in adding calculations using MDX, DAX.
• Developed reports &Dashboardby using excel services and business Intelligence.
• Affluent in Web Technologies like HTML, CSS, XML, JavaScript, JSP, core Java etc.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as a developer, business Intelligence.
• Experience in developing applications using C#. Net, VB.Net. / Share point technologies.
• Designed front-end inVB.Net2008 for crystal report for live core banking project.
• Experience building various web and desktop applications under .Net Framework using ASP.Net, C#,ADO.Net,ADO.Net, and Entity Framework to SQL Server.
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
• Expert in Microsoft Business Intelligence Studio 2010/2008 (SSIS/SSRS/SSAS).
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• Visual studio 2010/2008 (SSAS/SSIS/SSRS)
• Microsoft Access 2007/2003
• Microsoft Excel (Pivot Table)
• OLAP and OLTP
• Outlook
• MS SQL Profiler
• SQL server Query Analyzer
• Index Tuning Wizard
• C#. Net
• VB.Net. / Share point
• CrystalReports8/ 9/10
• ADO.NET
• ASP.Net Frame Work 2.0
• C#
• MDX
• MDM
• Oracle
• DB2
• Dash Board by Crystal report
• Erwin8/7.3/3.5
• Windows 2007/2005 Advanced Server/Professional
• Window XP
• MS Access
• Java
• My SQL
• CADIS 8.1

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SQL Server/ ETL Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed complex T-SQL 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.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Designed and built the ETL for mass uploading of product attribute changes into a custom-built analyticalMDMsolution.
• Developed Subject Areas forMDMusing SQL Business Intelligence
• UsedADO.NetEntity Framework to connect, retrieve a manipulated data with database operation by implementing Data Access Layer. Data access layer implemented usingADO.NETwith Database.
• ImplementedADO.NETconcepts to connect to the database. SQL .NET Data provider, Data Adapter and Data Set were used to retrieve and access data.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager

Confidential, San Diego, CA

SQL Server TSQL/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan,SQLProfiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS. Developed business objects using ASP.Netfor various modules. Prepare Unit Test Plan and Integrated test Plan with interface modules.
• In Client site, front end was also developed in ASP.Netwith SQL database in that authorized users can attend exams and check their own results.
• Developed ASP.Netapplications and used third party web services to retrieve grantees' legal information and validate the information against the data in current system. Developed SSRS report to show the discrepancy.
• Developed SQL scripts to handle different databases of insurance applications and created front end application inVB.Net2005 to achieve desired results and data.
• Design and develop Windows Forms usingVB.Net, SQL Server 2000 and Infragistics.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Data quality done by using the Data cleansing by using ETL development
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Worked on different Data Interfaces, Data Warehouse,SQLServer, Sybase, Oracle Server, and SQL-Div. tool.
• Responsible for database tuning using normalization and application tuning.

Confidential, San Francisco, CA

SQL Server T-SQL Developer /SSRS/DBA

Responsibilities:

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Design and createdashboardreports which illustrate the data in tabular format and well formatted charts.
• Created different types of reports andDash-boardreports by using Crystal Reports.
• Automating theDashBoardprocess to retrieve information on failed jobs on all the servers.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Confidential, Sacramento, CA

MS SQL Developer/ SSRS, SSIS, SSAS Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP and OLTP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Analyzed the database schema structure of theOLTPdatabase and designed ETL processes.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Extensively involved in the SSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS200R2 and in adding calculations using MDX.
• Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Generated Crystal Reports using XML data
• GeneratedCrystalReportsvia Campus View Database
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Confidential, Dallas, TX

SQL Server Developer/ SSIS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.
• Generated ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such asreplicationand log shipping.