PROFESSIONAL SUMMARY:

• SQL Server Developer with over 9 years of experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/Server applications using Confidential Technologies.
• Extensive experience with all phases of Software Development Life Cycle in Different Environments like Banking, Insurance, Engineering and Information Technology.
• Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Expert in writing T - SQL, working on DTS, Data Cleansing and Data Migration.
• Involved in migrating and upgrading SQL server 2005 to SQL Server 2008.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008.
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Used DTS/SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Experience in implementing Dynamic ETL.
• Deployed several SSIS packages using package configurations.
• Loading data into Dimensions and fact tables using SSIS
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Expertise in developing reports using SQL Server 2008 Reporting Services (SSRS).
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option.
• Developed interactive reports using Crystal Reports and SQL Server Reporting Services.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Experience in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access. .
• Expertise in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Great Knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Wrote MDX Queries and expressions in Cubes for use in front end Business Intelligence applications.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.
• A quick learner with an attitude for taking responsibilities.

TECHNICALSKILLS:

Languages: SQL, T: SQL, HTML, XML, JavaScripts, C, C++, C#.NET, UNIX Shell Scripting

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

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Excel

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.Net, Java

Testing: Unit Testing

Other Software: MS Office: 2013/2007/2003

Data Modeling: ERWIN, MS Visio

Operating Systems: Windows 2000/2003/XP/7

Database Tools: SQL Query Analyzer, Management Studio, SQL Server 2005/2008R2/2012, Query Editor, Solution Explorer, Analysis Manager, Tableau, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

MS SQL Server / MSBI Developer

Responsibilities:

• Configured 2 node Active-Active and Active-Passive clusters for production server.
• Analyzing existing application and preparing technical requirements for migration.
• Implemented solutions like always-on, transactional replication and log shipping in both production and non-production environments.
• Migrating database schema and data using SSMA and SSIS.
• Converting Shell Scripts, Perl Scripts into SSIS packages to perform ETL process for batch loading.
• Created Maintenance standards like Index Reorganization, Tuning, Update Statistics, Maintenance plans etc.
• Security issues related to logins database users and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like Visual Basic, Java and MS Access, which query the databases. Troubleshooting JDBC and ODBC issues between the application and the server
• Database Administration and Support of MS SQL Server 2012, MS SQL Server 2008 and Oracle in Production, QA, Test, Development.
• Writing Stored Procedures, Triggers, and Cursors and creating indexes.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.

Environment: SQL Server … Enterprise, Windows Enterprise Server 2012, .NET, Confidential Visio, SFTP, Confidential Reporting Services, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Vb.net, Windows Server 2008

Confidential, Oakland, CA

MS SQL Server / MSBI Developer

Responsibilities:

• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics and project coordination.
• Implemented various constraints for data integrity like Referential integrity using primary and foreign keys relationships.
• Worked on different requirement gathering documents like FRS, BRS, and Data Mapping.
• Worked with different team to collect functional and technical requirements for successful implementation of the job.
• Involved in the development of online order application. It is a website developed using C#, ASP.NET, SQL Server 2012/2008R2/2005 and SQL CUBE Responsible for creating scripts for mass updates, deletes and inserting the records using transactional statements i.e. commit and Rollback feature.
• Imported the data provided in flat files and spreadsheets into various table using Import-Export wizard of SQL Server.
• Worked on initial data and responsible for Data scrubbing and data profiling using SQL scripts and functions.
• Created scripts for millions of records and optimized the query using indexing strategies and partition schemas.
• Interacted with business people to finalize the requirements and implemented them.
• Worked on SSIS packages for automated reports and data migration for dev to production.
• Involved in installing and migrating legacy databases to SQL Server 2012.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
• Created billing components classes in C#, ADO.NET, LINQ and MS SQL
• Designed ETL packages dealing with different data sources (SQL Server, Excel Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used Change Data Capture (CDC) functionality of SQL Server 2012 alongside SSIS to populate the destination tables with inserted updated and deleted data.
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, and FTP.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS) 2008R2, Business Intelligence Development Studio (BIDS), MS Access, Oracle 11i, T- SQL, MS Excel 2010/2007/2003 , Confidential SQL Server Reporting Services (SSRS) 2008R2, Confidential SQL Server Analysis Services (SSAS) 2008R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), ASP.Net, C#, Erwin 8.0/MS Visio 2010.

Confidential, Union city, CA

SQL Server BI Developer/SQL DBA

Responsibilities:

• Involved in installing and migrating legacy databases to SQL Server 2008 R2.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
• 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).
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, and FTP.
• Updated database statistics, Re-indexed and fine-tuned of database objects and server.
• Extensively worked on DTA, DMV’s, Online indexing, Data Partitioning and tuning of long running stored procedures and complex queries Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
• Performed the Tuning of some existing ETL. The process time was reduced from 8 hours to approx. 6 hours. This was 25% gain in performance.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Involved in testing the SQL Scripts for report development, Tableau reports.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: MS SQL Server 2008 R2/2005, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Tableau, DTS, MS Visio, Erwin

Confidential, Redmond, WA

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Deploying new Database objects in production environment.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (Power BI) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Develop Parameterized, Drill down & Drill through Financial based Reports using Crystal Report.
• Writing SQL stored procedure in order to normalize the data & using within report application like SSRS, Crystal reports.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Testing and loading the data on Development and Production.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Worked with project manager and technical leads for resolution of technical issues.
• Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in effective handling of fraudulent activity.
• Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which have 3 months’ worth of data which pull data from data warehouse.
• Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
• Monitoring jobs to pull huge data into real-time server for analysis purposes.
• Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
• Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on the server to ensure safety to sensitive data.
• Created cube for daily calculations of customer feedback based on different attributes and figuring out the satisfaction of customer and time and money spent on handling the call.
• Enhanced and developed UI functionality using C#, ADO.Net and HTML.
• Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Added filters, columns, parameters, color coding to existing reports for user - friendliness.
• Monitored report manager granting access to end users based on level they need to look data at and providing the end-user with a clean and easily understood user-interface.

Environment: MS SQL Server 2014/2012 SQL Integration Services 2012, SQL Reporting Services 2012, Crystal Reports, Confidential Visual Studio 2012, SQL Server Management Studio, MS Excel, T-SQL, Tableau, ERWIN.

Confidential, San Rafael, CA

MS SQL Server Developer/MS Business Intelligence Developer

Responsibilities:

• Created a proper data entry system that will collect all the data required in student Information System.
• Designed and programmed a method getting data from various external data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements into University Database.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS using various features like data conversion etc.
• Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Responsible for developing a SQL Server Integration Services (SSIS) Framework for Providence Health Plan (PHP) - Dual Framework Phase in Extracts Database.
• Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check
• Enhanced and developed UI functionality using ASP.Net and HTML.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Implemented Micro strategy objects such as attributes, facts, hierarchies and complex metrics that conform to the dimensional and De-normalized data models.
• 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed different Parameterized Reports 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).
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Environment variables to configure the SSIS packages.
• Created various reports to analyze the data collected, reconcile with the data imported into student information system, and other reports as determined as necessary.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, BizTalk, Oracle 10g/9i.

Confidential, Overland Park, KS

MS SQL Server Developer/MS Business Intelligence Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS using various features like data conversion etc.
• Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Working on Biz Talk and MS SharePoint
• 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Enhanced and developed UI functionality using C#, ASP.Net and HTML.
• 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).
• Developed the packages with monitoring features and logging so that audit information of the Packages and their execution results are loaded in to the audit table.
• Used Team Foundation Server (TFS 2010) to track the changes in code.
• Used Environment variables to configure the SSIS packages.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, BizTalk, Oracle 10g/9i. Team Foundation Server 2010, Dynamics AX

Confidential, Quincy, MA

SQL Server BI Developer/C# Developer

Responsibilities:

• Involved in installing and migrating legacy databases to SQL Server 2008 R2.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Involved in the development of online order application. It is a website developed using C#, ASP.NET, SQL Server 2008 and SQL CUBE.
• Set up ETL Jobs to run on a nightly basis into the Data marts using SQL Server Agent.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
• Created billing components classes in C#, ADO.NET, LINQ and MS SQL
• 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).
• Used Change Data Capture (CDC) functionality of SQL Server 2008 R2 alongside SSIS to populate the destination tables with inserted updated and deleted data.
• Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, and FTP.
• Updated database statistics, Re-indexed and fine-tuned of database objects and server.
• Extensively worked on DTA, DMV’s, Online indexing, Data Partitioning and tuning of long running stored procedures and complex queries Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing, Cleansing, and Parsing etc.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, cross tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 R2.
• Performed the Tuning of some existing ETL. The process time was reduced from 8 hours to approx. 6 hours. This was 25% gain in performance
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: MS SQL Server 2008 R2/2005, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), MDX, DTS, MS Visio, Erwin

Confidential, Herndon, VA

SQL Developer/BI Developer

Responsibilities:

• Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
• Implement Type I, II changes in slowly changing dimension tables
• Built physical data structures like tables, views, constraints & Indexes
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data.
• Implemented SSIS for data transformation logic process.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures, using MS SQL Server.
• Configured product meta-data tables to support client data reporting needs.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Working with Different methods of taking Database Backup and Recovery procedures.
• Generated database SQL scripts and deployed databases including installation and configuration
• Worked on Stored Procedures and Database Triggers.
• Worked on large number of business analytical functions.
• Working with different types of Replication Models like Snapshot, Merge and Transactional.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non
• Production database code as well as T-SQL code from developers and QA.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used Confidential Source Safe for version control and configuration management.
• Tuning the Performance of Database (SQL Profiler), Query Optimization and Application tuning.
• Generated various reporting services RDL’S using reporting services for Account Aggregation reports.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, DB2, Sybase, Active X, Confidential Source safe, Windows 2003.

Confidential, Chicago, IL

SQL Developer/DBA

Responsibilities:

• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Configured IIS and Deployed Reports and Analysis Project in to server.
• Extended Data to XML and Excel Spread Sheet.
• Developed reports using SSRS 2005 and Crystal reports, used table control, matrix control forcross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.
• Assisted end users in USER ACCEPTANCE TESTING, by explain all the functionality of the data warehouse and its applications.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Writing and testing stored procedures

Environment: Visual Studio 2005, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports, Office, Excel.

Confidential

SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL, PL/SQL, SQL Loader.