SUMMARY

• Over 5 years of expert IT involvement in MS SQL Server Database Design, Development, Integration, Reporting and Analysis.
• Experienced in installing, updating and configuring SQL Server /2008/R2/2012/2014 on operating system windows 2000/2003/2008 server.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Domain Expertise in Banking, Finance, Insurance, Tele-communication sectors.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced in designing high-level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI),Inversion of Control (IOC), SingletonandMVC.
• Worked extensively onXML/XSLTand usingXMLbased properties in project.
• Expertise in installing, developing and deploying on application/web servers such as IIS 5.0/IIS 6.0/IIS7.0
• Database/T-SQL Development/ Microsoft Business Intelligence:
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and Transformation services.
• Well-versed in using database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at various stages of Migration/Cleansing process, Reports or Data Validation.
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance.
• Efficient in migrating MS SQL Server 2005 to MS SQL Server 2008/2012.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Excellent knowledge and experience on performance tuning, creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion, Pivot etc).
• Experience in error and event handling: precedence Constraints, Break Points, Check points, Change data capture (CDC), and Logging.
• Experience inMicrosoft Visual C#in script component of SSIS.
• Proficient in tuning SSIS packages by usingRow Transformations, Blockand Unblock transformations.
• Hands on experience in production/staging/test/development database administrative, Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R 2/2008/2005.
• Configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS).
• Hands on Experience about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Expertise in developing Drill through/Drill down reports, Cascading parameterized reports, Linked, Charts and Sub-reports and Log Reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.
• Scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using direct deployment and Uploading files using the Report Manger.
• Knowledge in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Star / Snowflakes Schemas with different architectures and data sources.
• Good knowledge of MDX Scripting to perform various tasks.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data in data warehouse.

TECHNICAL SKILLS

DBMS: MS SQL Server 2008/2008R2/2012, Access 2000/2003

Programming: T-SQL, MDX,C, C++, JAVA, C#

Developer Tools: SQL Server Management Studio, SQL server Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio 2005/2008, Team Foundation Server (TFS)

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

Reporting Tools: SQL Server Reporting Services (SSRS)

Data Modeling: MS Visio 2007/2010, ERWIN 7.1, ERWIN 4.1

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

Web Technologies: HTML, XML, JAVA SCRIPT, CSS

Business Intelligence: Business Intelligence Development Studio(Bids), Power BI(Power Query, Power Pivot, Power View, Power Map)

PROFESSIONAL EXPERIENCE

Confidential, IRVING, TX

Database Developer

Responsibilities:

• Developed Complex Stored Procedures and Views in SQL Server 2012 and 2014 environment.
• Developed numerous reports in SQL Server Reporting Services which is of high priority considering the project goal. Parameterized, graph reports and dashboard Reports
• Created Log Report which retrieves the access log of all reports deployed on Reporting server.
• Created packages in SQL Server Integration services which import the data from share point to reporting server database using connection strings.
• Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Scheduled jobs using SQL Agent to run on regular intervals for updating the data in the server.
• Involved in end to end migration from Source to destination and resolved any of the issues generated in the process of migration. The issues included data type mismatch, missing data type or missing delimiters.
• Involved in Performance Improvement of thus created reports and deployed reports onto Report Server and Report Manager and to SharePoint Server making those reports available for the end users.
• Handled Audit process for validating the data which includes round the clock monitoring and interacting with several teams over bridge.
• Hands on experience on share point front end.
• Created Entity Relationship (ER) diagrams based on requirements.
• Developed web pages for embedding deployed SSRS reports using ASP.NET
• Deployed and maintainedASP.NETapplications running atIIS 6.0.
• Data Access layer is implemented usingADO.NETto Communicate with theSQL Server Databaseand to access, update the data in the database.

Environment: Windows Server 2008/2012, MS SQL Server 2012/2014, T-SQL, SSIS, SSRS, HPQC,FILE ZILLA, MS OFFICE, .NET Framework 4.0, ASP.NET 4

Confidential - San Ramon, CA

SQL BI Developer

Responsibilities:

• Worked extensively on SSRS report with loads on integrated calculations with best on fly performance.
• Implemented ETL (Extraction, Transform and Load) for data migration and data staging using SQLServer Integration Services.
• Transformed the complex business logic and calculations into coding.
• Worked on agile sprint basis and successfully delivered various reports.
• Created Monthly/Historic automated load Using SSIS. Implemented various extra functionality and applications in SSRS reports.
• Supported other teams for the various SQL Agent Jobs/Packages/Reports.
• Developed Data-driven Packages in SSIS as a part of the automating the process.
• Designed and automated various manual data loads and successfully met the project deadlines.
• Improved SSIS packages performance by using non-blocking Transformations and row transformations.
• Created Report Snapshots to improve the performance of SSRS.
• Created reports for daily, weekly, monthly reports for various categories and regions based on business needs usingSSRS.
• Developed various reports for every on boarded and existing clients and also made various enhancements.
• Developed SSIS Packages and imported the data on daily basis from the OLTP system to SQL server.Created jobs, alerts to run SSIS, SSRS packages periodically.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Created and scheduled Batch Jobs and Stored Procedures which can exceed several hundreds of line of codes.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Troubleshooting issues, Documentation of Issue and its resolution.
• Involved in Query Optimization to increase the performance of the Report which were used in optimizing the company’s inventory based on actual usage.
• Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation

Environment: MS SQL Server 2008R2, MS SQL Server 2012 SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio, Power BI, XML, MS Office 2010, MS Visio 2007, Team Foundation Server

Confidential

SQL Server Developer

Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• ETL implementation using SQL Server 2012 Integration Services (SSIS).
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types and user defined functions.
• Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Involved in performance tuning of the database, which includes index maintenance optimizing SQL statements and monitoring the server.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Created Sub-Reports, Drilldown-Reports, Summary reports, Cross Tab reports using MS SQL Reporting Services 2008R2 & 2012
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.

Environment: Windows Server 2008, Windows XP, MS SQL Server 2008 & 2012, T-SQL, SSRS, SSIS, Oracle ERWIN, Flat Files, .NET

Confidential

SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design.
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Worked on Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of DatabaseServer.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Environment: MS SQL Server 7.0/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.

Confidential

Intern SQL Server Developer

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Learned SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.