SUMMARY

• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading. Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Used Informatica Tool to create ETL Packages to validate, extract, transform and load data from different sources like MS Excel and Toad for Oracle into Enterprise data warehouse environments like Teradata
• Generating complex Transact SQL (T - SQL) queries, Subqueries, Correlated subqueries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs). Writing heavy Stored Procedures, Audit Trigger Views, creating SQL scripts for data loads and upgrades for data migrations and data validations.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages. Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS. Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages. Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization. Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adapt quickly new technology with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

• Windows 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX, Windows 7 & 8.
• MS SQL Server 2014/2012/2008 R2/2005, MS Access, MySQL
• MS-SQL, My-SQL, Teradata SQL, Oracle, MS VBA Scripting, XML, MDX
• Word, Excel, PowerPoint, Access, Visio, Outlook, Google Docs
• SQL Server Enterprise Manager, MySQL Workbench, Toad SQL /Oracle, RazorSQL, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SSMS, SSAS, Index Analyzer, SQL Client Utility, Teradata SQL Assistant.
• SSRS, TFS, Tortoise Git, GitHub, JIRA, PowerPivot, Tableau, Rally
• Informaica, DTS, SSIS, Erwin v 4.0, Visio 5.0
• SQL Server Management Studio, Visual Studio.
• Internet Information Server (IIS 5.0 / 6.0), FTP,TCP/IP

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Developer/ Data Analyst

Responsibilities:

• Trained and Certifiedin Scaled Agile (SAFe) Product Manager/Product Owner (PMPO) Certification at Confidential Systems Inc.
• Worked on transforming the data from different Oracle Apps environment like Hyperion and transformed the data usingMSVBAscripting through building macros. Migrated the transformed data to Oracle database environment using Toad for Oracle.
• Worked on Teradata SQL using Teradata SQL Assistant in building complex queries and built views in projectingdashboardsusingTableau for reporting purposes on the business requirements provided by BRD owner or business lead.
• Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
• Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Used Informatica Tool to create ETL Packages to validate, extract, transform and load data from different sources like MS Excel and Toad for Oracle into Enterprise data warehouse environments like Teradata.
• Developed dashboards using leverage data from diverse sources like custom Oracle tables, Teradata and flat files.
• Worked on the needs of the business and demonstrated good business knowledge of Advanced Services with particular focus on CSAT, Project Profitability, etc.
• Developed new and innovative ideas to improve user experience and executive level dashboards by optimizing the query performance through tuning SQL queries.
• Worked and developed Multi-Dimensional Reporting, Data Correlation, Data Analytics, Middleware/Application Development, Data Visualization, Proof of Concept (POC) Development, and Ad-Hoc Report Development.Collected, Analyzed, Monitored reports on KPIs metrics, and driver tree analysis research and statistics.
• Applied analytical and research skills to monitor trends and elevate issues due to data variances and conducted data analysis, such as probability, regressions, predictive modelling, etc.
• Communicated findings and recommendations on critical initiatives and influence leaders to take action on those findings.Formulated conclusions and provide summary analysis and interpretation of data for management.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Worked with business gathering requirements. Performed Data Mapping and screen to screen mapping by using the data dictionary of the OLTP server and OLAP Server access.
• Used MySQL Workbench tool in Extraction and Implemented Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS. Deployed differentSSIS packages on development, stage and production servers. Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task. Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments. Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures. Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation. Created Clustered and Non- clustered Indexes on tables for performance optimization of complex stored procedures. Involved in performance tuning of T-SQL queries and Stored Procedures. Created Joins and Subqueries for complex queries involving multiple tables.
• Handling of Errors and Runtime Errors using VBA. Experience in creating conceptual, logical, and physical database designs. Created Linked Servers to retrieve data from other databases.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Performed Data Mapping and screen to screen mapping by using the data dictionary of the OLTP server and OLAP Server access. Involved in business meetings with the stakeholders and with the business analysts for the project requirements using agile methodology.
• Creating Schema Database diagrams, Tables structures and maintain the relationships with constraints and indexes as per business logic.
• Created Stored procedures, User Defined Functions (UDF), views, Joins and system defined functions, Temp Tables, Table Variables etc.
• Written complex T-SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
• Increase the queryperformance, Handling the errors in script level and used Transactions.
• Preparing the release/rollback scripts as per productiondeployment process.
• Using transformations like DerivedColumn, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Experience in creation of validation and Ingestion packages as per the business logic
• Extensively working in Data Extraction Transformation and loading into staging tables, validate the records on staging tables through validation process then valid records are insert into productiontables through ingestion process. Experience on rendering the Reports in the form PDF, Excel and .CSV formats
• Developed Systemlogging and Customlogging on task and package level.
• Performed Unit Testing and integration testing on the completion of Development for requirement.
• Preparing Technical design documents (TDD), Code Review, Promotional and Deployment Process Documents. Implemented Package Template and Package configurations.
• Involved with the client interaction for functional and Technical clarifications and solutions.
• Involved in resolving the Production issues and deployment Process with DBA's while deploying to different environments.

Confidential, Salt Lake City, UT

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
• Written complex SQL queries using joins, subqueries and correlated sub queries to retrieve data and Triggers to carry out various tasks from the database.
• Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Imported and Exported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• OLAP design (SSAS 2008) for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.
• Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
• Deployed and Published the Created Reports to Microsoft SharePoint Server and also uploaded them to Microsoft PerformancePoint Server.
• Aware of working with different ticketing workflow systems like JIRA and SRS.

Confidential, Nashville, TN

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc. Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For-Each Loop, Conditional Split, Union all, Script component.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).Created Drill-down, Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards with executive summary dashboards using MS Office PerformancePoint server 2007 Dashboard designer that display performance monitoring measures.
• Performed DBCC checks and fixing data corruption in Application databases.Scheduled Backups and performed Restore operations for system test data.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Written complex stored procedures, User Defined Functions, Triggers using T-SQL.
• Created DTS packages for data transfer between the two environments.
• Security issues related to logins, database users, and application roles and linked servers.
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Resolved any deadlocks issues with Databases/Servers on a real-time basis.
• Generated reports in SQL Server Reporting Services (SSRS) using table control, matrix control for cross tab reports. Developed Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
• Defined Report Layouts for the report design as per the need. Installed SSRS, Configured the Report Server and Deployed Reports.