SUMMARY

• Around 7+ years of IT experience in the Design, Development, working experience in MS SQL Server 2012/2008R2/2008/2005(SSIS, SSRS,SSAS), Database Migration, Database Administration, Physical/Logical Design, T - SQL, Performance-Tuning, Troubleshooting, Backups and Restore of databases.
• Strong foundation in T-SQL programming.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML).
• Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2012 and MS SQL Server 2005 to MS SQL Server 2008 using any suitable approach.
• Excellent Knowledge in RDBMS Concepts and Experience in Normalization of tables up to Third Normalization Form.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
• Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
• Proficient in writing distributed queries between SQL Servers by creating link servers.
• Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities and DMV’s.
• Improved query performance by adding covered indexes, adding file groups.
• Experience in Performance Tuning, Query Optimization using Indexes, Profile Traces for Dead Locks and using DBCC Utilities for Database Consistency Checks.
• Hands on experience in creating Parameterized reports, Cascaded Parameterized and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report and sub reports) in SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Strong Data Warehousing and analysis skills including OLTP, OLAP (MOLAP, HOLAP, DOLAP, and ROLAP), Relational and Dimensional modeling skills (star schema and snowflake schema).
• Developed SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in using Bulk insert and BCP utilities.
• Experience in source control tools like Visual Source Safe, Team Foundation Server.
• Experience with writing scripts in C#, ASP.NET, integrate information from multiple sources to execute effectively and efficiently in a dynamic environment.
• Excellent Interpersonal and communication skills. Quick learner in new technologies.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2005/2008/2008 R2/2012, Oracle 8i/9i

Data warehouse tools: OLAP, SQL Data Transformation Services (DTS)

Data Modeling and ETL tools: SSIS, ER/Studio, ERWIN

Languages: C, C++, Java Script, C#, PERL,T-SQL, PL/SQL, Oracle 9i and 10g,HTML,XML

Packages: MS Office, Visual Basic

Web technologies: HTML, VB-Script, DHTML, XML

MS technologies: MS Visio, Knowledge of ASP.NET 2.0, .NET Framework, MS Access, MS SharePoint

Operating Systems: Windows NT 4.0/, XP, Windows Server, UNIX.

Reporting Tools: Crystal Reports, Microsoft Reporting Server (SSRS).

Methodologies: Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling, Code Specifications, Visio, VSS.

PROFESSIONAL EXPERIENCE

Confidential, TN

Sr. SQL Server BI (SSRS/SSIS) Developer

Responsibilities:

• Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Developed SQL scripts to Insert/Update and Delete data in MS-SQL database.
• Used Exceptional Handling and log in SSIS to handle errors and track the package execution.
• Configure SSIS Package for run time Parameters and Config file.
• Worked on ACCDS tool to track the production tickets.
• Intensively involved in Prod Support.
• Scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler).
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Used Try Catch Finally exception handling extensively to avoid circumstances leading to abnormal program termination.
• Provide direction to layout technicians regarding circuit implementation through the use of Electronic Design Automation (EDA) software.
• Maintained error logs for the Stored Procedures.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• 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/2008/2005/2000 , Visual Studio 2010/2012, TFS, VSS, Reporting Services (SSRS), Integration Services (SSIS), T-SQL, .Net, Excel.

Confidential, Harrisburg

Sr. SQL Server BI (SSRS/SSIS) Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented triggers and stored procedures and enforced business rules via check constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries
• Created views to restrict access to data in a table for security
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. sssand Excel formats using SSRS 2005.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Performed Full and Differential backup with simple and bulk-logged recovery models.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Designed and developed Power BI reports according to the requirements using Tableau and Power Map.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Implemented Snapshot and Transactional Replication models and Validation of Replicated data.s
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Used SharePoint API and ASP.NET to build custom Web Parts and Tool Parts to implement additional business requirements from and within the SharePoint site.
• Designed custom workflows using Visual Studio and SharePoint Designer using custom built content types to in corporate various business processes.

Environment: SQL Server 2005, 2008, Power BI 2013.Windows Server, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2008, Reports Builder, MS Analysis Service SSAS Developer 2000, XML, MS Project, MS Access 2000 & Windows 2K platform, VSS,ERWIN, MS Share Point, Crystal Reports, Oracle 9i, C#, ASP.Net.

Confidential, Phoenix, AZ

Sr. SQL Server BI (SSRS/SSIS) Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2012/2014 and Flat files.
• Run the test cases written for integration and functional testing after the deployment of the databases on the DEVRSA environment.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated TSQL script for application.
• Used Visual Team Foundation server for version control, source control and reporting.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Fix any bugs arising out of SIT, UAT and any other test process.
• Involved in code review, writing Unit test case, and creating a platform to run and validate these Test cases.
• Experience in analyzing test results and submitting the bugs using Bug Tracking Tool Quality Centre (QC) & Team Foundation Server (TFS).
• Master deployment tools. Utilize team tools for change management. Advocate for architecture and design concepts that can enhance performance and reduce maintenance costs.
• Mentor or act as subject matter expert in assigned technologies (e.g.: Octopus, Azure, etc.).
• Co-ordinate with other Teams and integrate different applications on to common platform.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Mining models and deploying and processing SSAS objects.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Experience in developing 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.
• Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS).
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective
• Developed a High-level dashboard using SSRS 2012/2014.
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
• Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Involved in designing Web based ASP.NET applications.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• 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.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.

Environment: Team Foundation Serve, SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008.

Confidential, Raleigh, NC

SQL Server SSRS/SSIS/ SSAS Developer

Responsibilities:

• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Created complete documentation for the daily build process, daily loads and reports.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Designed dynamic SSIS Packages for Landing-Pad to transfer data between servers, load data from FTP, flat files, access and oracle into database, and archived data file from different DBMS.
• Involved in daily loads (Full & Incremental), Data Conversions into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Developed SSIS Templates with error logging and configurations which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Implemented SCD2 (Slowly changing Dimensions) by using different dataflow tasks in SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Used Cozy rock third party tool to generate Hash keys, to insert and update data in to data warehouse.
• Developed complex queries for generating drill down and drill through reports and worked with Parameters for parameterized and cascading parameterized reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified information requirements for Power BI projects by developing conceptual data models, as part of a coordinated effort with management and subject matter experts
• Troubleshoot Power BI Environment problems and tune for performance. Diagnose and resolve application bottlenecks and performance issues. Define and enforce coding standards in Power BI, design styles and best practices.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Generated various BI Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Uploaded BI reports on to the report manager and organized them into folders.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Created reports which generate multiple named tabs in excel and created data driven and standard subscriptions for different users using Report Manager.
• Managed permissions in the Report manger through Role based security.
• Used Transparent Data Encryption (TDE) to encrypt sensitive data.
• Daily builds, merging, branching source code to different environments using Visual Studio Team System.
• Every day SCRUM meetings and two week sprint.

Environment: SQL Server 2012 Enterprise, ERWIN, Windows Enterprise Server 2003, XML, MDX, Microsoft Visio, SFTP, SSRS, SSIS, SSAS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Power BI, Visual Studio Team System 2008, SharePoint, Cozy rock

Confidential, Irving, TX

SQL Server SSRS/SSIS SSAS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Develop, design, and generate call center reports for end users taking highly complex information and producing user-friendly reports using Cisco platform.
• Successfully upgraded from SQL 2008 to SQL 2012 with side-by-side approach.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key.
• Generate custom reports byworking extensively as the liaison between technical and operations teams.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented triggers and stored procedures and enforced business rules via check constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Writing SQL scripts for various daily database tasks like checking table fragmentation and reorganize/reindex, synchronizing data from one server to another etc.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries
• Created views to restrict access to data in a table for security
• Improved the performance of the application by 22% by creating proper clustered, non-clustered, covered indexes in a secondary file group (ndf) and partitioning.
• Configured SSRS in both Native and SharePoint mode.
• Configured Report Server and Report Manager in SQL Server 2008.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Created Cross-Tab, Drill-down, Cascaded Parameterized, Charts and Sub-Reports
• Created data models with Report Builder 2.0 to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables.
• Used Expressions, Functions and wrote custom code using VB.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2008.
• Created client side reports (RDLC) using Visual Studio 2008 for reports to be generated from session data
• Working experience with the Microsoft products & their Integration to different third party tools.
• Installation and Configuration and Testing of Team Foundation Server (TFS) 2010 & 2012.
• Experience in Technical and Functional side of the Team Foundation Server Components (Source Control, Work Items, TFS Builds, Reporting, SharePoint Built reports to generate in desired form (Word, PDF, Excel and XML) to present statistical information according to business requirement.
• Deployed the created reports into SharePoint and Report Manager, created data driven subscriptions for different users in desired format.
• Integrated the reports into web application using Report Viewer Control in Visual Studio 2008.
• Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).
• Created SSIS packages to import and export Account details in XML format from one server to another.
• Worked on Power Pivot to create ad-hoc reports based on user requirments.
• Used Triggers and the new Change Data Capture (CDC) to implement database auditing.
• Every day Agile/SCRUM meetings and two week sprint.
• Created Policies, Conditions and used Facets with Policy Based Management to configure and manage the SQL Servers.

Environment: SQL Server 2005/2008 Enterprise, Generate calls, MS VISIO, Windows Enterprise Server 2003, IIS 7.0, XML, Microsoft Visio 2003, SFTP, SSRS, SSIS, SSAS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Visual Studio Team System 2008, AJAX, Telerik RAD Controls, SharePoint, LINQ.

Confidential, Houston, TX

SQL Server SSRS/SSIS SSAS Developer

Responsibilities:

• Created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Created Jobs, Alerts using SQL Agent to run packages and maintenance plans
• Query Optimization and Performance Tuning of Stored Procedures, Functions etc.
• Partitioning the tables for increase in Performance and availability of data.
• Written different test Scripts for testing complex codes.
• Develop, design, and generate call center reports for end users taking highly complex information and producing user-friendly reports using Cisco platform.
• Implementing and administering database replication between SQL Server database
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and scheduling the reports through standard and data driven subscriptions.
• Formatted the reports using the Global variables and expressions.
• Performed Data Analysis for automating various Customers Order Reports utilizing SSRS 2005.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Implemented the project using ASP and VB-6 backend database as sql server.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• 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).
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Created master and child packages, package configurations and logging.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Implemented SCD2 (Slowly changing Dimensions) using Table Difference in SSIS.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked with EDI 837 Conversions.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Experience with Analysis services 2005 and made various cubes based on the reporting requirement.

Environment: SQL Server 20005/2008, ASP,VB-6, C#, Enterprise Edition, SQL,PL/SQL, Enterprise manager, SSRS 2005, SSIS,SSAS, Spotlight, MS SharePoint, MS Access, Excel, 2000 & Windows 2003/2000 Platform, Red gate.

Confidential

SQL Server SSRS/SSIS Developer

Responsibilities:

• Designed dynamic SSIS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• Involved in daily loads (Full & Incremental), Data Conversions into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Implemented the sliding window concept to manage time-based partitions and documented the sliding window process.
• Created complete documentation for the daily build processes, daily loads and reports.
• Used various Transformations in SSIS Dataflow, Control flow using for loop Containers, Script Task, ActiveX scripting and Fuzzy Lookups.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed and created Report templates, bar graphs, adhoc reports using Report builder 2.0 and pie charts.
• Designed and implemented Dashboards and Scorecards with business KPIs using SSRS and Performance Point Server, and published them Via Microsoft Office Share point Server (MOSS).
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Created data driven and standard subscriptions for different users using Report Manager.
• Managed permissions in the Report manger through Role based security.
• Synchronizing schema and data between development, test and QA servers using Red gate SQL Compare and Data Compare
• Worked on Cassandra to store big data.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor.
• Every day Agile/SCRUM meetings and two week sprint.
• Created Policies, Conditions and used Facets with Policy Based Management to configure and manage the SQL Servers
• Daily builds, merging, branching source code to different environments using Visual Studio Team System 2008.

Environment: SQL Server 2005/2008 Enterprise, MS VISIO, Windows Enterprise Server 2003, IIS 7.0, .XML, Microsoft Visio 2003, SFTP, SSRS, SSIS, VB .NET, ASP .NET and C# Microsoft Entity Framework, Cassandra, Visual Studio Team System 2008, AJAX, Telerik RAD Controls, SharePoint, LINQ.