SUMMARY:

• Almost 8 years of IT industry experience with Microsoft SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016 , SSIS/SSRS/SSAS, and OLAP as SQL Developer.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive working experience in:
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex Transact SQL (T - SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server .net- Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Performance tuning of Stored Procedures and T-SQL Queries.
• Implementing SQL Server Indexing and Query optimization using Indexes
• Logical & Physical Data modeling, data architecture designs etc.
• Understanding existing data models, data flows and data dictionaries
• Creating new data models, data flows and data dictionaries
• Normalization and De-Normalization techniques
• Involved in Backing up databases and refreshing Data across environments
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Creating data load and Upgrade scripts for data migrations, data formatting and data validations
• Implementing all high availability techniques like clustering, log shipping, replication.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Proficient at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQL SERVER destination.
• Experience using Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Wrote Complex SQL queries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Familiar with Agile development and waterfall methodologies.
• Extensive work experience on Web based and Windows applications using C#, VB. NET, ASP. NET.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports .
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spotfire.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX,C#, ASP (.NET), XML, HTML, DHTML, HTTP

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000,(SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Power BI, Visual Studio.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniquesPackages

MS Office: Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot. Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

.NET Technologies: ASP.NET 1.1/2.0/3.5, ADO.NET, LINQ, C#.NET, WCF, WPF, Silverlight, Web Services, Web Parts, .Net Framework 1.1/2.0/3.0/3.5/4.0

PROFESSIONAL EXPERIENCE:

Confidential, Addison, TX

SQL Developer

Responsibilities:

• Created a lot of complex stored procedures, triggers, functions, indexes, views with T-SQL statements in SQL Server Management Studio (SSMS).
• Responsible for technical design, development, coding, testing, debugging and documentation of databases and database applications to satisfy requirements of one or more user areas.
• Responsible for creation of data services and integrating the data service components.
• Collaborate with other developers in creating optimal, maintainable, and scalable architecture and design and actively promote quality in coding and other project activities.
• Create high quality, detailed technical documentation on the whole database for the Current Project.
• Responsible for the segmentation which runs daily where individual opens, clicks will be updated every day.
• Responsible for the database for the current project, where data is dumped into the database and scrubbed into the correct format per the requirement given by the client.
• Extensively used Joins and sub Queries to simplify complex queries involving multiple tables.
• Responsible for enterprise level solutions development including data warehousing, data marts and/or software applications.
• Responsible for high performance of data architecture and design including Star Schemas, Snowflake Schemas, and Dimensional Modeling.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.
• Developed CTE's, Constraints, and Complex queries to fetch the data from different servers.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database.
• Used T-SQL to create databases objects based on business specifications such as stored procedures, user-defined functions, views in SSMS.
• Developed C# code in SSIS (Script Task) to encrypt and decrypt the files the incoming flat files.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB, C#) scripts.
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS and Excel.
• Monitored the jobs run using Informatica Workflow Monitor and used to debug the job by setting up the log files and bad files.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object Oriented Methodologies for application development by using agile scrum methodology.
• Maintained Source definitions, Transformation rules and Target definitions using Informatica Repository Manager.
• Developing SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Filtered data from legacy system using T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistence in SSMS.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Built ETL workflows using Informatica tools to extract the data from feed files (with the formats like XML, TXT, DAT, XLS, Message Queues, etc.,) and load them into staging area and then to Data Warehouse.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Built different data visualization by using Power BI to turn data into charts/maps.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2016/2014/2012 , Clustering, SSIS, SSRS, T- SQL, Visual Basics, Visual Studio 2012/2015, Indexes, Cluster, Informatica, .Net Framework 3.5,C#, MS Office suite 2011,Cozy ROC 1.8,PowerBI.

Confidential, Raritan, NJ

SQL Developer

Responsibilities:

• Involved in beginning of the project, updated existing database from Oracle Servers to SQL server. Managed database security policy login using Windows and SQL server authentication mode.
• Created web application with ASP.net web forms and custom user controls.
• Working closely and regularly with Management, Business Analysts and Infrastructure Teams, and updating with regular reports and status updates.
• Developed complex queries to retrieve data from multiple sources, charts, tables and crosstabs using SQL Queries.
• Involved with other DBA team members with support, on-call, cross-training efforts, documentation, standards and naming conventions, and updating ERD diagrams.
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Added Bing, Mongoose, and Google Analytics tracking code to the project.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the OLAP data warehouse.
• Generated reports by using SSRS and provided them on web server Report manager.
• Worked with importing flat files and XML files, fetched data from other data source like PL SQL and ETL (Extract, Transform and Load) to the database.
• Delivered required Power BI report as internet link, embedding in Office Tools.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases like increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles and permissions to users on various database objects. Designed role-based security to managed user’s activities, Identified and created constraints on table columns.
• Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Worked on Informatica Power Centre tools Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Using Informatica Power Center created mappings to transform the data according to the business rules. Tuned the Informatica mappings for optimal load performance.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map, and Cross-join.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements .
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users

Environment: SQL Server 2016/2014/2012 , Visual Studio 2012/2015, ASP.net, SharePoint, Clustering, Tableau, SSIS, SSRS, T- SQL, Visual Basics, Indexes, Cluster, Informatica, .Net Framework 3.5, snapshot, Replication, MS Office suite 2011.

Confidential - Auburn Hills, MI

MSBI Developer / SQL SSIS SSRS SSAS

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Extensive work experience on Web based and Windows applications using C#, VB. NET, ASP. NET.
• Web module development and deployment using ASP.net.
• Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Stored Procedures, User Defined Functions, Views , TSQL Scripting for complex business logic.
• Created reports from complex SQL queries and MDX queries.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column , which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse .
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task .
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports , Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Customized Team Foundation Server as per project requirements.
• Customized and generated TFS reports to serve company needs.
• Integrated and customized TFS add-ins called 'Aggregator' to ensure automation.
• Problem identification , troubleshooting, resolution , and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine .
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Coordinated with web development team in .Net framework programming solutions.
• Integrated ASP.Net Web Pages to the SQL Server 2008 Back End.

Environment: MS SQL Server 2008/2012/2014 SSIS, SSRS, MS SQL Server 2012/2008, C#, ASP.Net, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007.

Confidential, Austin, TX

SQL Server Developer

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
• Created Database and Database Objects like Tables , Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks .
• Generated T-SQL code for creating cursor and handling the data validations.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS t he data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2005 .
• Implemented the calculations to aggregate physical measures using management studio.
• Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
• Developed and maintained MS Access database.
• Supported development of a speciation control documents for an MS Access Project Management Database.

Environment: SQL Server 2008/2005, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, SSIS 2005, SSRS2005/2008, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2005 on Window XP.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2008/2005, Windows 2000, MS Access, T-SQL, DTS, VB 6.0.