SUMMARY:

• Over 9 years of IT experience in Database Design, Development and Support of MS SQL Server 2008R, 2000.
• Domain knowledge in Healthcare, Insurance and Telecom.
• Experience in ASP.NET/C# programming.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2008R 2/2008/2005.
• Expertise with DDL and DML statements, RDBMS, data dictionaries and normal forms.
• Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, Dynamic SQL, Triggers and Cursors.
• Profound knowledge and ability to write stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Created Try/Catch Block and @@error for error handling in SQL Server.
• Experience in writing complex T - SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Expert in SQL Server tools like SQL Server Reporting Services, SQL Server Integration services, SQL Server Analysis Services.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports, Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS 2008R2/2012.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expertise in SQL Server 2005 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Extensively used tools like SQL Profiler and Database Engine Tuning Advisor for monitoring and tuning MS SQL Server Performance.
• Good SQL server administration skills including, backups, database maintenance, user authorizations, database creation.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Excellent verbal, communication and interpersonal skills to understand business requirements in various domains and ability to interact with clients. Self learning ability and leadership qualities.
• Good knowledge of C# programming. Used complex C# coding in Script task.
• Involved in performance tuning of SSIS packages and SQL query tuning.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008/2008 R2/2012, Oracle 9i/10g, MS Access

Operating Systems: Windows Server 2000/2003/2008, Windows XP/Vista

Programming Languages: T-SQL, PL/SQL, HTML, XML, Oracle, MDX, C, C#, .NET, VB.NET, ASP.NET, ADO.NET

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008/2012, SQL * Plus, Toad, Ervin

Database Design Tools & Data Modeling: MS Visio, MS Access, MS SQL Server 7.0/2000/2005/2008, Star Schema/Snowflake Schema modeling. Physical & logical data modeling and De-Normalization techniques, Kimball & Inman Methodologies

Business Intelligence Tools: Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), DTS Packages, Performance Point Server, Visual Studio.

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential, Aliso Viejo CA

Sr.SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created several stored procedures, functions, triggers, views and cursors for building KPIs in dashboard
• Used sub queries, RANK function, CTEs, tem tables, while loops, union, SET operators, string functions, error handling and aggregate functions in different queries in SQL Server 2012.
• Used SQL Profiler to detect the problem areas and values being passed in the application to a stored procedure.
• Implemented HIPAA Compliance in various report and stored procedures.
• Created stored procedures for calculating co payment, denials. Implemented codes to reduce reimbursement errors and improve payment integrity.
• Created ERD diagrams using Open SphereModel and implemented concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Tuned the stored procedures/query to perform faster using less system resources by getting rid of sub query with the help of inner join. Converted Cursor with the help of while loop. Used Union ALL over 'OR' to improve performance.
• Created covering and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan, IO Statistics, IO Time. Eliminated key-lookups, table scan, modifying the query and converted index scan to index seek.
• Created maintenance script for indexes to be reorganized or rebuild depending upon fragmentation percentage
• Horizontally partitioned the database by creating and moving the files, file groups of same database in different disks.
• Implementation of EDI.
• Used SQL profiler and DMV queries to trouble shoot the queries and stored procedures
• Created SSIS packages to load data from different sources such as Excel, Flat file, DB2 to SQL server 2012 Data warehouse and SQL Server Transactional database.
• Used Control flow tasks such as Execute SQL task, Data flow task, For Each Loop, Sequence container, Execute Package Task, Execute Process task, Script Task, SMTP task and File System Task in SSIS package.
• Used data transformation like look up, Script component, Merge, MergeJoin, Mutlicast, Dervied column, copy column, condition split, sort, union all, data conversion, conditional split and row count to clean the data and modify it. Loaded the data in various destination like SQL server, flat file, excel in SSIS package
• Used C# for reading and writing variable in Script Task of SSIS
• Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
• Ran the SSIS package through SQL job.
• Built MDX queries used in reports of various clients’ legal related documents using tuples and sets.
• Designed and built SSAS complex cubes which include millions of records which were complex and deployed them.
• Worked on cube partitioning, refresh strategy and SSAS performance tuning.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• SSAS, Created relationship in both cube structure as well as in DataSource view. Created relationship like many to many, fact,, and regular. Used refresh strategy after the modification made to the cube in DataSource view.
• Assigned to roles to particular user to access the SSAS cube. Deployed and processed the cube.
• Created SSRS reports such as drilldown, drillthrough, subreports, tabular reports, chart reports, matrix report and document map.
• Created dynamic SSRS reports with the help of parameters which changes according to the user input.
• Created reports based on both cascading and standard parameters.
• Used standard and parameterized parameters in SSRS reports
• Created Group reports as well as controlled the number of records to be displayed in each page according to user.
• Added indicators, document maps to the SSRS reports.
• Created List report, dynamic report and enabling the sorting to the report
• Exported reports in SSRS to Excel, PDF and word document
• Created Subscriptions for SSRS reports both data driven and standard subscription.

Environment: MS SQL Server 2012, MS SQL Server 2008R2, SSIS 2008R2, SSIS 2012, SSAS 2008R2, SSRS 2008R2, SSRS 2012, T-SQL, VSS, Windows Sever 2008, SQL Server Management Studio, SQL

Confidential, Oakland CA

Responsibilities:

• Involved in gather user requirements and system specifications.
• Developed a Conceptual model using Erwin based on requirements analysis
• Created stored procedures for handling claims denials and payments.
• Used RANK, SET Operators, string functions in the stored procedures and queries.
• Maintained referential integrity and implemented complex business logic.
• Optimized the queries based Actual Execution plan, SQL Profiler and modifying the queries.
• Created indexes to make the queries use less resources and boost the speed of the data retrieval
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2005.
• Used Several control flows such as Data task flow, Execute Package Task, Execute Process Task, Execute SQL Task, File System Task, ForEach Loop Task, FTP task, Script Task, Send Mail Task
• Used several dataflow tasks such as Aggregate, Conditional Split, Copy column, Data conversion, Derived column, Look Up, Merge, Merge Join, Multicast, OL DB Command, Sort, OL DB Destination and Row Count
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2005 to achieve the efficiency of SSAS.
• Build MDX queries and data mining expression (DMX) queries for Analysis Services and Reporting Services.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Defined the d Relationships with the measure groups and fact tables.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Created SSRS reports such as drilldown, drillthrough, subreports, tabular reports, chart reports, matrix report, Group report and document map
• Design, deployment and maintenance of various SSRS.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Involved in developing logical and physical model of database using Erwin.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012, MS SQL Server 2008R2, SSIS 2008R2, SSIS 2012, SSAS 2008R2, SSRS 2008R2, SSRS 2012, T-SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio, TFS, #C, Erwin r9.5

Confidential, San Diego CA

Sr.SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created several complex stored procedures, function, triggers.
• Converted cursors into while loop to make the stored procedure run faster.
• Developed normalized Logical and Physical database models to design OLTP
• Created tables according to the specification.
• Used CTEs, while loop, sub queries, set operators, joins.
• Created indexes both non clustered and clustered indexes in order to maximize the query performance.
• Used Actual Execution plan to find and remove index scan, key lookup, hash join, table scan by creating covering index in order to improve the performance of a query.
• Modified queries and stored procedures to improve the performance.
• Created SSIS packages to create csv files and excel sheets.
• Created global temporary tables in the Execute SQL task and created reports based on the global temporary tables inside the data task flow.
• Used Package Configurations to make the SSIS Package reusable in any server.
• Used data flow transformation like Union All, multicast, Sort, Ole db Source, Ole db Destination, Look up, Ole db command, derived column, data conversion, conditional split and row count
• Used Execute SQL Task, Data flow Task, Sequence Container, ForEach Loop Container, File System Task, Execute Package Task.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements
• Used C# for reading and writing variable in Script Task of SSIS
• Created and used Package, Data flow task and sequence container.
• Ran the SSIS package every day by scheduling job in SQL server.
• Extracted, Integrated data from Sybase, Oracle, and DB2 database to SQL Server.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created SSRS reports like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created reports based on both cascading and standard parameters.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Designed and built cube using SQL server Analysis Services for salary analysis.
• Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
• Extensive experience in SSAS (SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.
• Experience in writing complex MDX queries for calculated members and measure groups.

Environment: MS SQL Server 2008R2, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T-SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio, MKS

Confidential

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked from the beginning of the SDLC which includes database design process such as analyzing the ERD diagrams and creating tables based on it.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created tables, Data mapping document to map data between Oracle and SQL server tables.
• Created data mapping document from source (DB2) to destination (SQL server).
• Created clustered and non-clustered indexes to improve the performance of database and tables.
• Created complex stored procedures, functions, views, and triggers.
• Used joins, sub queries, set operators, string functions and several other sql statements.
• Enhanced the performance of the existing stored procedures.
• Assisted team members in completing their tasks on time and solving complex queries.
• Created ETL packages to load data from source to destination.
• Used Data Flow tasks, Execute SQL tasks, Foreach Loop, Sequence container, File system Tasks, SMTP task and variables.
• Extracted, Integrated data from Sybase, Oracle, and DB2 database to SQL Server.
• Used Merge, MergeJoin, OleDB Command, Sort, UNION ALL, and Conditional Split, Derived column, data conversion and Look up transformations.
• Loaded to the data from flat file/sql server/ db2 to sql server/flat file/excel.
• Deployed the SSIS package in a particular folder and ran it as a daily job in SQL Server.
• Created several reports types like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created reports based on cascading and standard parameters.
• Exported reports in SSRS to Excel, PDF and word document.
• Involved in fixing errors in existing reports and stored procedures.

Environment: MS SQL Server 2008R2, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T-SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio, Lotus 8.0, Subversion 2.1

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for QNXT Plan/Products module.
• Ability to interpret benefit documentation, translate benefits and configure in QNXT
• Knowledge of QNXT database and back-end processes
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Generated complex custom Reports using SSRS 2005 as per the customer requirement.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions.
• Wrote DTS that extract data from database tables and write the data to text files.
• Migrated DTS objects to SQL Server Integration Services (SSIS) environment.
• Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
• Created Cubes using SQL Server Analysis Services (SSAS) according to business requirements.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Fine tuned SQL queries using hints for maximum efficiency and performance.
• Worked with application team and connected SQL Server with ASP.NET webpage.
• Coded simple logics in C# programming.

Environment: MS SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, DTS, T-SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0, ASP.NET, C#

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Documented the data flow and the relationships between various entities.
• Actively participated in gathering of User Requirement and System Specification.
• Created new Database logical and Physical Design to fit the new business requirement andimplemented the same using SQL Server.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Created Tables, Views and Indexes on the Database, Roles and maintained Database Users.
• Followed and maintained standards and best practices in database development.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Developed new Stored Procedures, Functions, and Triggers.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: Windows 2000 adv. server, Windows 2000/XP, MS SQL Server 2000, IIS, MS Visual Studio