SUMMARY:

• Overall 10 years and 11 months of IT experience and Data Science with extensive knowledge on Data Analysis, SQL and BI development
• Important aspects of the profile are to develop a Business Intelligence platform on complex / legacy systems and automate the ETL load process leveraging the business logic for data driven decision making and reporting capabilities.
• The responsibilities include database design and development, develop ETL process and implement the applications and visualize the data/metrics in scorecards and dashboards on Microsoft SQL Server 2014 / 2012 / 2008 R2 /2005), Teradata and Oracle databases
• Actively involved as a Database developer in development, design and Architecture
• Extensive experience in T - SQL development which includes creating complex Tables, Stored Procedures, Views, Indexes, Triggers and User Defined Functions.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in using Microsoft Visual Studio, SQL Server and hands on experience in ETL Tools like Informatica, Data Stage, BODS etc.
• Pull data from Web Service using WCF with SSIS packages
• Extensive experience in developing and implementing Microsoft SQL Server Integration services (SSIS); Microsoft SQL Server Analysis services (SSAS), Microsoft SQL Server Reporting Services (SSRS) and MDX for data warehouse and data mart solutions.
• Expertise with performing various SSIS data transformation tasks like Look-ups, Fuzzy Lookups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
• Experience in data Migration (using tools like DTS, BCP) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Experience in Jobs, Sending Alerts using SQL Mail.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements and other database administration day to day activities.
• Flexible to work environment. Involved in Agile projects from the past 5 years.
• Convert the reports from OBIEE dash board to SSRS.
• Experience in creating simple and parameterized SQL Reports using SQL Server Reporting Services (SSRS), Business Objects (BOBJ) and Power BI.
• Experience in SSRS with Report management, Report Delivery and Report Security.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Good knowledge in OLAP, OLTP Design & Implementation.
• Experience in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Familiar with OLAP cubes and fact table, star and snowflake schemas.
• Experience in designing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models and Data Mart.
• Extensive Knowledge in MS SQL Server configuration manager, client/server connectivity, query optimization, back-up/recovery.
• Experience with .NET in interacting with Business users and the development team.
• Extremely diligent, strong team player with an ability to take new roles. Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation.
• MCTS certified: 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• Hands on with Alteryx, Denodo and working knowledge with Teradata
• Creates artifacts in IBM Rational Requirements Composer and perform all responsibilities in Agile environment through IBM Rational Team Concert.

TECHNICAL SKILLS:

Tools & Packages: SQL Server Management Studio, PL/SQL, Enterprise ManagerProfiler, SQL Server Business Intelligent studio (BIDS), DTSReport Builder 9.0, HP QC, Query Analyzer, SharePoint 2007Team Foundation Server, Autosys, Advanced Query Tool (AQT)

BI Tools: SSIS, SSAS, SSRS, Informatica, Alteryx, Tableau, Power BI, Sisense

Databases: MSSQL Server 2014/20012 R2/2008/2005

Language: Powershell, T-SQL, VB, .NETC, C++, Unix Shell scripting

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Work with team of software application developers to architect and implement new features and solutions besides assisting in data modeling and database development
• Documents the metadata definition for creating physical data model and creates database objects like schema, tables, views, procedures, user defined functions etc.
• Created users and assigned the appropriate roles to restrict the access on the database
• Used data modelling tools like Visio, Erwin etc. to create the ER diagrams, data models, flow diagrams, current & future state diagrams
• Interacts with users to determine the requirements; convert to tech specs; assist in design, development and testing of the applications implemented
• Automated EDI transactions to push to SQL server, update the pricing on the orders and release the orders to fulfillment center; thus, reduce the time to fulfill the customer orders
• Developed data warehouse solutions for ERP and data marts for accounting (Acumatica), shipping (WMS), product and sales on SQL Server to enable the order to cash flow cycle
• Enhanced the OLAP applications - multidimensional SSAS cube to include new Measures and Dimensions and enable the reporting on sales warehouse
• Re-designed accounting applications like Acumatica upgrading to newer versions of SQL server; data migration from legacy applications
• Automated the invoice load process to Acumatica, publishing the invoices and distributing the invoice register eliminating manual processes with SQL Server Integration Services / Data Tools (SSIS/SSDT) etc. on Azure cloud
• Designed and implemented ETL processes to push the product and pricing to the Amazon Web Services (AWS) cloud to access from Amazon portal and enabled the data steward to refresh on demand
• Performed database backup and restore to stage and dev environments
• Developed and automated daily reports and dashboards for metrics in SSRS with data driven subscription
• Created BI data models in Sisense and automated data loads to Sisense elastic cubes
• Visualized operations, customer service, revenue and performance dashboards for power users in Sisense and created alerts
• Performed data analysis to analyze the gaps in Product model and assisted product team in data cleansing and integrate to Ecommerce applications
• Implemented Perf, the daily reporting solution to leadership on the bookings, shipments, backlog etc. in SQL with SQL Server Management Studio and SQL Server Integration Services (SSIS) jobs
• As part of BI applications enhancement, worked on Sisense, Power BI, Tableau and QlikView to create advanced dashboards
• Implemented database applications to tariff and invoice the customer; check freight, tariff etc. and send acknowledgement to customers; capture change history etc.
• Assisted the backend database for Catalog management system, distributor portal, Sonar and Sonar embed pro which belong to the product management portal and ecommerce
• Improved the performance of the SQL queries and applications by creating partitions, indexes; Resolved the dead lock issues and performance bottlenecks
• Reviewed the code to enhance SQL query performance by determining the use of temporary tables vs table variables, filters and SQL joins etc.
• Reduced the time to develop with reusability of the stored procs and functions
• Knowledge in using C#, ASP and VB.NET for custom code and application development which helps to do basic debugging and resolve the data issues the users experience in the front end

Confidential

Responsibilities:

• Involved in database design to define metadata for creating physical data model and source the data from multiple environments including file systems, database and web applications
• Knowledge on Visio to create the data model, flow diagrams and current state diagrams
• Gained skills on obtaining meaningful metrics from data by text analytics, location analytics with modern reporting tools like Power BI, Sisense, Tableau etc. to help with identifying potential opportunities
• Familiar with requirements, user stories and story cards in agile environment
• Involved in data migration, data profiling and data integration with SQL Server Integration Services (SSIS/SSDT), Informatica etc.
• Has expertise in using T-SQL & PL/SQL with SQL Server Management Studio, Advanced Query Tool and Teradata SQL Assistant
• Created dashboards for metrics/error reports in SSRS. Familiar in using the SSRS, Tableau, QlikView and Power BI reporting tools
• Perform data analysis, downstream impact analysis for the changes in existing system or ETL mappings to add/modify functionality that save time by reducing the load time and improving the intelligence capabilities for reporting and data mining
• Knowledge in using C#, ASP and VB.NET for custom code and application development
• Sourced data from the application database and developed solution for performance bottlenecks caused by the functions and procedures.
• Developed functional/mapping specifications for extracts and BI reports.
• Involved in the requirements analysis to revise the existing logic as necessary.
• Developed functions, complex stored procs, views and ETL jobs (SQL Agent)
• Evaluated data source, the application database and validated the data for anomalies.
• Collaborated with analysts and multiple vendors to define the metrics before designing the ETL process and documented the technical aspects, data requirements in the functional specifications for assisting the development.
• Researched data sources internal and external to the application and validated the data for corrective course of action in case of anomalies
• Assisted business users in system integration testing and user acceptance testing for defect resolution and ensured data quality/accuracy of the BI metrics.
• Worked in Unix, Linux and Windows servers to handle data from multiple source systems
• Has knowledge in Powershell, Perl and Unix shell scripting
• Created SQL Agent jobs and performed routine DBA activities: indexing, profiling, performance optimization and database backup.
• Assisted DBA in automating the job execution and task completion/failure notifications.
• Assisted in retiring the old application database with downstream impact analysis.
• Involved in activities related to data integrity, data quality and communicated the anomalies to the business and identified the solutions to fix any issues.
• Experience in visualization and location analytics with geographic maps using the Reporting Tools - Power BI, Tableau etc.
• Got expertise in performance optimization, audit and controls logic. Knowledge in using SQL Profiler, SQL Query Analyzer and resolve the performance issues
• Hands knowledge on Ultra Edit to SFTP/manage the files in Unix environment

Confidential

Responsibilities:

• Requirement gathering business requirements and convert to functional & technical specifications for end user in client applications engineering and capacity planning.
• Working as a Consultant (BI/ETL) developer in a Team that focus on obtaining the usage summary and performance metrics by pulling data from multiple sources such as database, flat files, csv, web applications and database like Oracle, DB2 etc.
• Automate the process of collecting logs from the instruments spread over different locations on various networks.
• Parse the log files to obtain the metrics using T-SQL and PL/SQL to calculate the durations using SSIS on the SQL Server Data Tools 2014
• Optimize the views and stored procs and reduce the cost and processing time.
• Migrate certain database tables, views and stored procedures from SQL Server
• Design, create and deploy the ETL Packages using SSIS
• Create the reports to visualize the performance metrics and host the reports on the report server
• Created dashboards and score cards reports along with tabular, matrix, chart, drill down reports, parametric, cascaded reports in SSRS according to business requirements.
• Enable the Live monitoring of the instruments
• Involve in design, development and deployment activities
• Co-ordinate with the other teams to integrate the application and especially with the testing team to validate the reports.
• Actively involved in data modelling, schema creation
• Grant and restrict access to users and user groups on data
• Create sensors and monitor the system on PRTG Network Monitor, a third party tool and fix the failures if any and maintained security and data integrity of the database.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL Server 2014, SQL Server Data Tools, Informatica Power Center, PL/SQL,T-SQL, Visual Studio 2013 on Windows 7 Ultimate, SSIS, SSRS, Oracle, PL/SQL, C#,VB.NetXML, MS Visio 2007, PowerShell, PRTG

Network Monitor

Confidential

Responsibilities:

• Gather requirements and convert to technical specification documents for end user in client applications engineering and capacity planning.
• Working as a SQL developer in a team that focus on obtaining the performance metrics from SQL server embedded on the advanced medical equipment/machinery.
• End to end automation to improve the process by collecting logs from the instruments and parse the data to obtain meaningful metrics using command shell, PowerShell commands, T-SQL, SSIS on the SQL Server Data Tools 2014
• Optimize the views and stored procs and reduce the cost and processing time.
• Migrate certain database tables, views and stored procedures from SQL Server
• Designed the ETL Packages using SQL Server Data Tools and did file deployment and Server deployment
• Create the reports to visualize the performance metrics and host the reports on the report server
• Created dashboards and score cards report along with tabular, matrix, chart, drill down reports, parametric, cascaded reports in SSRS according to business requirements.
• Enable the Live monitoring of the instruments
• Involve in design, development and deployment activities
• Co-ordinate with the other teams to integrate the application and especially with the testing team to validate the reports.
• Actively involved in data modelling, schema creation
• Grant and restrict access to users and user groups on data
• Create sensors and monitor the system on PRTG Network Monitor, a third-party tool and fix the failures if any and maintained security and data integrity of the database.

Confidential

Sr. SQL Server Developer

Responsibilities:

• Requirement gathering business requirements and convert to functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Lead a team of six members and three of them from offshore
• Train, provide work direction and coordinate the schedules and activities of assigned personnel; assist in training new employees by planning Knowledge Transfer (KT)
• Bridge between the users and developers and review the deliverables.
• Integrate the independent modules to one within deadlines by tracking sheets
• Develop Test Cases before UAT and do the test run before UAT and smoke test/regression test after UAT.
• Involved in database Schema design and development.
• Migrated Database from SQL Server 2005 to 2008 R2.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Load policy data to tables from Web Service using WCF with SSIS packages
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploy the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis with custom error handling and worked with different methods of logging in SSIS..
• Expert in SSIS Deploying and Scheduling and BATCH loads
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQLServer Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS and BO for report generation to create various types of reports and to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Scripting in C# and VB.Net
• DBA activities of creating users, assigning roles and permissions, replication, creating linked servers, import and export, restore and backup and other maintenance activities.

Environment: SQL Server 2005/2008 R2 Enterprise Edition/2012, Informatica Power Center 7.1, PL\SQL, Oracle 10g, Business Objects, Windows Communication Foundation (WCF), QNXT, SSIS, SSRS, MS PowerPoint, OBIEE,MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007

Confidential

Senior Software Engineer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintaining Referential Integrity
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Plan, design and implement database code objects, such as creation of tables, constraints, adding indexes on required attributes, stored procedures, user defined functions (UDFs), complex query, query tuning
• Created Indexes, partitions and worked on the performance issues.
• Involved in re-design and development of backend SQL Server database.
• Created Stored Procedures and User Defined functions and also reviewed many T-SQL issues using management studio for better performance.
• Using SSIS Performed Migration of databases from SQL 2000 to SQL 2005 and transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Moved the static data from various sources like Oracle, MS Access and MS Excel and text files to SQL Server 2005 database using BCP and dynamic SSIS packages.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and developed the business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front-end application.
• Created complex SSRS reports from OLTP and OLAP data sources based on the functional requirements such as the reports with Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards report (SSRS) according to business requirement and distributed with data driven subscription.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Designed and developed classes using C#.NET, ADO.NET, XML for connectivity.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between homogenous and heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created Crystal Reports.
• Has knowledge in wiring MDX scripts and created reports by on the SSAS cube.
• Used SSIS 2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Improved the performance of long running views and stored procedures by adding indexes, removing unnecessary columns in the inner views
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Dataflow from database to and from Webservices and WCF and Oracle-On-Demand etc.
• Involved in database Schema design and development.
• Migrated Database from SQL Server 2005 to 2008.
• Experience in using SQL Server 2012 and T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development to production server.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files with custom error handling and logging.
• Expert in SSIS Deploying and Scheduling.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: and Tools: MS SQL Server 2012/2008/2005 , T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),Visual Studio, MS Excel, Flat File, Oracle 10g,Erwin, SQL Profiler,C#.NET, VB.Net, Windows XP, Windows 2000, Visual Studio, WCF, IIS, XML, SQL Profiler, Erwin, Query Analyzer, Excel, DTS, DB2, PL/SQL, T-SQL, Visual basic, Visual studio 2005 etc.