SUMMARY

• 8+ years of extensive experience in Database Design, Development and Administration of applications with MS SQL Server versions using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• Experienced in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc. Extensive experience in working with Tableau Workbooks.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports. In depth knowledge in T - SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos. Hands on experience in installing, configuring, managing, monitoring SQL Server.
• Involved in all the stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience with Fragmentation and Query analyzer for SQL Server and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• Experience in using recursive CTEs, CTE, temp tables, Views, Table Variables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database. Experience in Database Backup, Recovery and Disaster Recovery procedure.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot. Created complex expressions using the MDX scripting to solve complex designs.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Good knowledge of SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS. Familiar in Creating Secondary indexes, and join indexes in Teradata.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for reports using SSRS.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services (SSRS).
• Experience in Integrating SQL Server Reporting Services (SSRS) with MS Office Share Point Server (MOSS 2007).
• Good understanding in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning. Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio, Oracle SQL Developer for logical and physical data models. Good team player with strong analytical skills.
• Experienced in connecting multiple data sources in Power BIto implement working reports.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Having knowledge on maintaining and managing Power BIdriven reports and dashboards.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, CSS, ASP.NET, VB, C#

RDBMS: MSSQLServer, MS Access, Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables,SQLQuery Analyzer,ETL,SQLEnterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQLServer Reporting Services (SSRS),SQLServer Analysis Services (SSAS),SQLServer Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio CrystalReports

Operating Systems: UNIX, LINUX, Windows7/ NT & Windows 9x and MS-DOS

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQLServer Management Studio,SQLServer Enterprise Manager,SQLServer Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. SQL SERVER BI Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS). Created Pivot tables using Power Pivot and power Query.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.
• Performed Provider analysis and gave useful Insights about reliable Insurance group, claims, deposit details from the Power BI dashboards. Created report schedules on Tableau server.
• Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report). Created drill down and drill up in worksheets in tableau.
• Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server. Experienced in working with agile methodology.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Worked on Power BIand prepared dashboards using Tableau to make it more attractive
• Experienced in Data visualization and Data analyzation using Power BI.
• Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Created Calculated Columns and Measures in Power BIand Excel depending on the requirement using DAX queries.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SVN (source control), Tableau, Informatica, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server.

Confidential, Lauderdale, FL

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Analyzed the client requirements and translate them into technical requirements.
• Extensively worked on T-SQL for creating stored procedures, indexes and functions.
• Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning the database. Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Worked on SSRS 2008 to generate about 30+ reports for various user groups and developer groups.
• Developing Tabular Reports, ad-hoc Reports using SSRS Report Designer. Generating several types of drill down and drill through reports using SSRS. Implemented different types of constraints on tables.
• Developing complex SSRS reports using multiple data providers, global variables, expressions, user defined objects -, aggregate-aware objects, charts, and synchronized queries.
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS.
• Responsible for creating complex Cross tab, OLAP Cube report using Crystal Reports integrated with SSMS.
• Designed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle 11g, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS). Performance Tuning of SQL queries and stored procedures using SQL Profiler.
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks. Designing and implementing parameterized and cascading-parameterized reports using SSRS.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data. Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split and many more.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Successfully migrated SSIS packages from development to test and Production environments using SSIS Configuration files and deployment wizard. Used Cognos Scheduler to schedule the Reports.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Involved in migration of catalogs, Reports from Impromptu to Cognos8 & Report Net using Migration Utility.

Environment: MS SQL Server 2016/2014/2012 , SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SSAS, DB2, MS SQL Profiler, Crystal Reports, Oracle 11g, SQL Query Analyzer, Teradata, SQL Server Index Tuning Wizard, Visual Studio, Cognos, Windows XP, MDX C#, ASP.NET, XML, Erwin v4.1, MS Office 2013.

Confidential, Alpharetta, GA

Sr. MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Creation and maintenance of SSIS Packages (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database. Used data sources like SQL, SSAS cubes and files to generate reports in Tableau.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS. Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
• Populate or refresh Teradata tables using Fast load & Fast export utilities for user Acceptance testing and loading history data into Teradata. Migrate the data from an Access database to SQL Server 2008.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to the business requirements. Used VB.Net Code to create embedded functions in SSRS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
• Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports. Prepared technical documents like High Level Design
• Involved in Business Analysis & Requirement collection. Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
• Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
• Developed web application for reporting portal using .NET, ASP.NET, C#, VSS.
• Designed the packages to extract data from SQL SERVER, flat files and loaded into Oracle database.
• Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN PLAN. Worked as an administrator on Cognos suit of products.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Customized Cognos Connection with appropriate reports and security measures.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Oracle 10g/11g, DB2, MS SQL Profiler, SSAS, SQL Query Analyzer, Crystal Reports, SQL Server Index Tuning Wizard, MDX, Visual Studio, Teradata, Windows XP, C#, ASP.NET, BizTalk Server, JavaScript, XML, Erwin, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server, Cognos.

Confidential, Scottsdale, AZ

SQL Server Reports Developer

Responsibilities:

• Performed server installation and configuration using SQL server2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements. Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions and Maps etc. Built complex formulas in Tableau for various business calculations.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Involved in designing calculated measures using Multi-Dimensional Expression (MDX).
• Implemented custom SSRS Reports to Internal operation team by reading data from the QNXT Database.
• Created Full client, Web I and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements.
• Added new users and applied roles in the QNXT UI in the Development and UAT Environments.
• Created Reporting interface for Customer service team by reading the data from QNXT Claim, Claim Detail tables. Responsible for testing to optimize the procedures and triggers to be used in production.
• Implemented ETL Application to load Claim Payment information to QNXT Financial tables and provided access to financial team by creating custom roles in the security management.
• Creating, Approving and Modifying PA in both Portal and QNXT and Involved in Adding Contracts to the Provider in QNXT and associating Providers in Portal while creating claims.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS. Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS. Monitored performance and optimized SQL queries for maximum efficiency.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012
• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose. Worked in Enterprise Manager for job scheduling and batch queries.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Planned Backup strategy based on projects requirements.
• 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. Extensively worked and Managed on OLAP cubes using SSAS.
• Involved in project planning also schedule for database module with project managers.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Crystal Reports, SSAS, Oracle 9i/ 10 g, DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, MDX, Windows XP, C#, ASP.NET, BizTalk Server, QNXT, JavaScript, XML, Erwin v4.1, MS Office 2013, Tableau Desktop 9.0/8.3, Tableau Server.

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Analyzed the functional specs provided by the business users and created technical specification documents.
• Active part in maintenance of data cubes for OLAP. Involved in migration of crystal reports to SSRS 2008.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives. Wrote PowerShell scripts to automate Excel Macros and generate various reports.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008. Involved in Migration of SSRS 2005 to SSRS 2008.
• Created Triggers, Views for Audit and security purposes. Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Worked with POWER SHELL to automate SSIS Package and create report in Excel.
• Involving in creating the packages by using Control Flows, Data Flows and script tasks.
• Scheduling the ETL jobs to run some of them daily and some of them are monthly once
• Fixing the defects in QC as per the tester comments. Launching the report builder for ADHOC reports.
• Extensively working in loading fact and dimension tables in Data warehouse.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing. Extensively used Excel PowerPivot and Slicing and Dicing concept
• Created reports to retrieve data using Stored Procedures, MDX Queries that accept parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports
• Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema. Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results. Used Type 1 and Type 2-dimension models for loading multiple dimension.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX queries, VB.NET Scripts, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications. Integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2005/2008.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Designed and written the queries in the query builder for retrieving the data.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS 2008. Used data profiling task in SSIS 2008 to identify poor data and repair it.
• Created and worked with drill down reports and identified the report parameters.
• Writing extensive T-SQL Programming, SQL Server Scripts, ETL (SSIS) packages, SSRS reports and SAP BOBJ reports, deployment feasibility, cost and time requirements, compatibility with current technologies and system capabilities to integrate new business functionalities
• Generating various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports in customer level, manger level, vendor level using Microsoft and SAP technologies.

Environment: SQL Server 2008/2008R2, Microsoft SharePoint Server (MOSS), T-SQL, SQLCrystal Reports, (SSIS) SQL Server Integration Services, MS Visual Studio, ASP.Net, C#, VB.Net, Ado.Net, TFS, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, Business Object XI, SAP Suite,ETL, MDX,Erwin, SQL Profiler, MS Excel 2003, BI stack, PowerShell, MS Visio, informatica, Visual Studio, .Net

Confidential

SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
• Installed and Configured Microsoft SQL Server 2008 R2 on different domain servers like dev, QA, UAT and production on Windows operating system.
• Worked independently on multiple projects with minimal supervision and in agile SCRUM environment.
• Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments.
• Designed, Developed and tested packages to extract, transform and load data using SQL Server SSIS.
• Developed advanced ETL import packages using SSIS, T-SQL Scripts, T-SQL scripts for Execute SQL task and Expressions in ADO.NET sources to transform and import raw index data into database tables and to staging by executing business logic, rules and client requirement.
• Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
• Manage, operate and enhanced a data eco-system that allows for data sets (indexes and images) to be updated and managed daily.
• Continue to improve ETL automation of processes enhance the import speed accuracy and quality of daily data updates. Running various DBCC commands for administration of database objects and system performance.
• Developed data importing processes and designed processes/applications to help increase automation, efficiency, flexibility and extensibility by creating T-SQL Scripts, Stored procedures, functions Etc.
• Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis.
• Implement code changes, bug fixes and configuration changes (if needed) and other development and administrative activities.
• Created Snapshot and Transactional replication and performed backup and restore operations as well.
• Technical support to users for various purposes like Access change, performance issues and storage space
• Work in cooperation with other teams and business analysts for achievement of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.
• To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
• 24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.
• Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.

Environment: Windows, MS-SQL Server, T-SQL, Visual Studio, LINQ, WCF, Team Foundation Server (TFS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDX queries, Red gate, SQL Profiler, Auto Sys, System Monitor/ Performance Monitor, DTS, Performance Tuning, trouble shooting, Clustering, Microsoft Office.

Confidential

SQL Developer

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules. Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to Consolidate date from various data Sources and Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XL to SQL reporting (SSRS).
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors. Wrote complex queries, triggers and stored procedures, views and user defined functions.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups. Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Design and implement database logical and Physical Schemas.
• Responsible for database tuning using normalization and application tuning.
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Query tuning, Index Tuning and performance tuning.
• Creation and maintenance of databases, objects. Users and user group creation and maintenance.
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting. Created and modified stored procedures to Create Reports.

Environment: Windows 2000 Server, MS-SQL Server 2000/7.0, Visual Basic6.0, ASP, VB Script, Java Script, IIS, Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), Visual Source Safe and Internet Information, Server 4.0, Crystal Reports, Microsoft Access FTP Communication.