SUMMARY

• A Microsoft certified Professional with 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2012/2008/2005.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced and seasoned as MYSQL Developer with proven record of strong database.
• Good knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/ 2005/2008/2008 R2/2012.
• Good knowledge in healthcare domain claim adjudication rules and provider matching and member matching rules.
• Experience in healthcare applications like FACETS data model and FACETS online claim processing.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Created and managed Indexes and optimized queries using query execution plan.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000/ 2005/2008/2008 R2 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experience in using Try Catch block for error handling in SQL introduced in SQL Server 2005.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports, Matrix reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms
• Extensive knowledge in ETL Process &Progressive knowledge in using DTS/ETL/SSIS utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS/ETL Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400,DB2 to MS SQL Server by using Import Export Wizard, DTS/ETL SSIS, BCP & Bulk Insert utilities
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/2005/2008/2012 , MS ACCESS.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator

Languages: T-SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML

Web Technologies: HTML, DHTML, XML

O/S: Windows 2008/2003/2000/ NT Servers,XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Worked with JavaScript, ODSI, OSB, web logic, JDeveloper, to build Service Oriented architecture
• Knowledge of software architecture, software development, project management is also included in this project
• Involved in supporting the backend database data of ISAAC Project.
• Extensively involved in ETL Processes development, support and
• Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Wrote T- SQL code/Stored procedures to create datasets for SSRS reports.
• Created Views to store aggregated values for reporting purpose.
• Developed ETL Packages using SQL Server 2012 Integration Services to populate data from different sources, for example flat files/SQL/Oracle Server to the Staging Database and then into the Data Warehouse.
• The packages created included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion
• Done testing using TDP for developed stories.
• Experience with HTML, CSS, JavaScript, JSON, XML, MVC technologies. Experience in web services- preferably RESTful web services with JSON.
• Worked on performance tuning, OLTP, PL/SQL & T-SQL programming, Reporting
• Coordinating with other product lines and Software Quality Assurance (SQA) team.
• Done some part of the manual testing of the stories which developed.
• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers which were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Written triggers, stored procedures and manipulated the data using DDL and DML functions.

Confidential, Irvine, CA

SQL Server BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Installed SQL Server 2012 on Development and Production Servers, Setting up databases, users, roles and permissions.
• Worked with business owners and analysts to define and implement new requirements for a more scalable and stable data processing application.
• Involved in writing Stored Procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
• Involved in writing various DB Objects like User defined functions, Views, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Worked on analyzing and Performance tuning queries by looking Confidential the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by Performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups,Derived Columns, Merge, Join, Conditional Split, Data Conversion with Multiple Data Flow tasks.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools.
• Configured, Installed and Administered Reporting Services 2008/2012.
• Handled allReportrequests forCrystalReports/SSRSand/or SQL based reporting needs.
• Strong Experience with MYSQL integration services
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Worked on SSRS to generate hierarchical reports, drill down and drill through reports and tested using Management Studio in SQL server 2012/2014.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report)
• Created various Dashboards for business users using Periscope Dashboard
• Created Dashboards for data Inventory Locations for Business Partners
• By using Visual intelligence build various QlikView data models
• Created many reports using QlikView
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Converted query based crystal Report s to query/stored procedure based SSRS Reports
• Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Worked on Key Performance Indicators (KPIs), design of Star schema and Snowflake schema in Analysis Services (SSAS)
• Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

Environment: Microsoft SQL Server 2012/2014, Periscope Dashboards, Agile Methodology, SQL Server Integration Services 2012(SSIS), SQL Reporting Services 2012 (SSRS), MYSQL Workbench, SQL Server Analysis services 2012 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.

Confidential, Orlando, FL

SSIS, SSRS and MS SQL Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality Confidential the database side for performance improvement.
• Configured and Maintained MYSQL Servers
• Design and implementation of Security Model, Policies and Procedures.
• Performed MYSQL query plans and making sure each and every query is using appropriate useful Indexes
• Enthusiast and Experienced QlikView developer - the pioneered in-memory Dash boarding tool.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Various KPI graphs were drawn. Kept eye on QlikView best practices.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Created database objects like Pivot Tables
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Created Adhoc reports and data exploration using Power View.
• DevelopedAggregations,partitionsand calculated members forcubeas per businessrequirements.
• Defined appropriate measure groups andKPIs&deployed cubes
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), Agile, MYSQL Workbench, MSSQL Server Analysis Services (SSAS)MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential, NYC, NY

SSIS, SSRS and MS SQL Developer

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load Confidential package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Responsible for ongoing maintenance and change management to existing reports and optimizereportperformance in SSRS-2008.
• Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients.
• Extensively worked in migrating office writer reports to SSRS-2008.
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams.
• Interacted with the Business Admin and gather the requirements and analyzed them.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 7 Enterprise Edition, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008, Agile, Microsoft Visio, MS-Visual Studio.

Confidential, Broadway, New York

MS SQL Developer

Responsibilities:

• Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
• Written complex SQL queries using joins, sub queries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
• Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
• Deployed and Published the Created Reports to Microsoft Share Point Server and also uploaded them to Microsoft Performance Point Server.

Environment: Microsoft SQL Server 2008 R2, SSIS, SSRS, SQL Server Profiler, UNIX, Perl, MS Excel, Edit Plus, WordPad, PL/SQL.

Confidential, Ohio

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views and Queries with best execution plan
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
• Created projects to transfer data from MS Excel to SQL Server in SSIS.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• DDL Scripts for generating Tables, Views, Functions.
• Analyzed and designed software and database solutions.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: MS SQL Server 2008 R2, Windows 2003, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008.

Confidential, Chantilly, VA

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Created logging for ETL load Confidential package and task level to log number of records processed by each package and task in a package using SSIS.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients
• Extensively worked in migrating office writer reports to SSRS-2008.
• Participated in Databases Architecture and data modeling design.
• Interacted with the Business Admin and gather the requirements and analyzed them.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.