SUMMARY

• Over 8+ years of IT experience in Database Analysis, Design, Development, Debugging, Testing and Implementation of software applications as a SQL and BI Developer in Retail, Health Care domains.
• Thorough understanding of Software Development Life Cycle (SDLC), experienced in Requirements gathering, Analysis, Design, Development, Testing, Implementation and Application support.
• Experience in working with waterfall and Agile (Scrum) methodology.
• Extensive experience in installing, configuring, managing, monitoring and troubleshooting in MS SQL Server 2000, 2005, 2008, 2012 & 2016.
• Expert in Microsoft Business Intelligence technologies (MSBI) like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de - normalization.
• Extensive knowledge of EMR systems and web-based applications software for healthcare technology.
• Excellent experience in migration of data from Excel, Flat file to Microsoft SQL Server.
• Extensive experience with T-SQL, creating Functions, Views, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Extensively used performance monitor/SQL profiler to improve the query performance.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Good Knowledge in working with Tableau.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server.
• Experience in working with TFS tool as Version Management .

TECHNICAL SKILLS

Languages: T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS: SQL Server 2016/2012/2008/2005/2000 , Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

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

Tools: & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services,TFS.

Big Data: Hadoop 2.x, Hortonworks HDP 2.2, Cloudera CDH 5.4, MapReduce, HDFS, Yarn, Pig, Hive, HBase, Sqoop, Flume, Ambari, Knox, Elastic Search, Hue, QlikView, Qlik Sense, Kafka, Storm, Spring-XD, Falcon.

Cloud: Amazon Web Services, Google cloud.

OS: Linux, Unix, Windows NT/XP/ 2007/2003/2000 ,Windows 9x and MS-DOS, Redhat, Centos, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential

Sr. SSIS/SSRS Data Analyst

Responsibilities:

• Gathering requirements from business users, analyzing and designing the solutions
• Analyze Data requirements, map current systems and formats to logical and physical data models, propose standard ways for this information to be communicated between systems and databases
• Writing complex SQL statements using joins, sub queries and correlated sub queries.
• Managed all the repots using TFS.
• Designing and normalizing databases, writing T-SQL Queries and creating different objects like Tables, Views, Stored procedures, User defined functions and Indexes.
• Working on performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor
• Develop highly reliable, efficient processes for extracting, transforming and loading data to and from disparate software systems and databases
• Migrating visual themes/reports/dashboards built on Tableau into Microsoft SQL Server Reporting Services (SSRS)
• Designing various new reports like Matrix reports, Tabular reports, Chart reports, link Reports and Drill down reports.
• Designing dash boards for executive users, field operators, ASMS, Accounting, Marketing and Sales groups
• Modifying and improving existing Reports and SQL Stored procedures in SSRS 2016.
• Supporting and managing existing Zoes restaurant applications and troubleshooting complex issues by applying deep understanding application knowledge
• Providing feedback and suggestions for data quality and process improvements
• Documenting requirements, designing test cases and working through project development life-cycle
• Working with Aloha insight (Point of Sale) to reconcile sales data with SQL server Database
• Loading daily Grind files from CMC to SQL server using FTP and SSIS
• Creating and scheduling Smart connect maps to integrate with GP and managing ZKSales, ZKRollup and DW databases.
• Designing the labor dash board reports using Menu Link database

Environment: MS SQL Server Management Studio 2012 & 2016, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Power BI, Windows XP,.Net Framework, Tableau, Power BI.

Confidential

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created complex SQL queries, stored procedures, functions, triggers, joins, CTE, Sub queries.
• Worked with SharePoint to publish and share reports for various clients.
• Created SSIS jobs to automate the reports generation.
• Worked with TFS for Version Management.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel into SQL server for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Worked with SSIS Variables, event-handlers, package configurations and deployment.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Extracted the data from Excel files to SQL Server using SSIS as ETL tool as per the client requirement.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created SSIS package to send the automatic emails to the customers.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service ( SSRS ).
• Developed Matrix report to display past 6 months data according to the client requirement.
• Wrote the expressions in SSRS wherever necessary .
• Developed an SSRS Tabular report to display the data on different pages for each Loan Group.
• Created Subscriptions for SSRS reports in SharePoint.
• Design, develop and deploy SSRS reports and SSIS packages as per client requirement.
• Migrated some of the dash board reports from Tableau to SSRS.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Experience in PostgreSQL Development
• Involved in Unit testing, User Acceptance testing to check whether the data is loaded into target system from different source systems according to the client requirements.

Environment: MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Power BI, Windows XP,.Net Framework, Tableau, Power BI.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Extracted the data from SQL Server to CSV files using SSIS as ETL tool.
• Migrated the data from XML and CSV files to SQL Server.
• Created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table.
• Migrated the DTS packages into SSIS.
• Transferred data by adding Derived column Transformation, count of records, merging of data has been done while pulling data from Source to the Target.
• Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages.
• Created complex Stored Procedures and Views to pull data into reporting services from the Databases.
• Worked on removing duplicates while migrate the data using joins and Row number by partition clause.
• Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored procedures, User defined functions, Indexes.
• Created SSIS packages for data migration to process multiple flat files coming from utility server and loads into different database tables.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Used various transformations in SSIS packages to modify the data from the source.
• Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed
• Created the documents and packages in Team Foundation Server as a version control.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Managed all database servers in development, staging, test and production environments.

Environment: MS SQL Server 2008/2012, SSIS, XML, T-SQL, Stored Procedures.