SUMMARY

• Around 8 years of excellent experience with demonstrated success in the database design, development and deployment of large - scale enterprise applications
• Expert in SQL Server 2014/2012/2008 T-SQL and whole suite of products like SSIS, SSAS, and SSRS.
• Experience in report generation using SQL Server Reporting Services (SSRS) from relational databases and OLAP cubes.
• Expert in High Level Design of ETL Package for integrating data from heterogeneous sources like Oracle, Excel, CSV, flat file, Text Format Data.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates. Expert in performing database consistency checks using DBCC Utilities.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions.
• Skillful in creating Tables, Views, Indexes and other SQL joins and complex query writing.
• Proficient in Performance Tuning, Query Optimization and running Database.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, and Data Migration.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys and has experience in Web application.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Created a new SSIS package and added a Dataflow and a Script Component configured to Source.
• Business intelligence project work Expert with SQL and PL/SQL Experienced with SQL-Server databases
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Source code deployment experience using deployment tools such as CVS, clearcase.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Responsible for creating OLAP cubes for deep through analysis using SSAS 2014.
• Worked on Side by Side migration of multiple SQL 2010 instances to SQL 2012.
• Worked on stack and queue, heap tables in data structures.
• Worked on data compressions and backup compressions.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Crystal Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in designing InfoPath forms, form templates, template parts, master-detail forms and integration of these forms with Microsoft Outlook, SharePoint.
• Experience in developing various reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Experience checking code into source controls.
• Experience in VB.NET, C#, ASP.NET, ADO.NET and Web Services
• Strong inclination for finishing job before the project deadline.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2010/2012 , MySQL, Oracle 9i/10g

Operating System: Windows 2010/2013/2015/2017 , Linux, HP-UNIX

.NET Technologies: ASP.net, C#, VB.net

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL Jobs, Replication tools, Data visualization ( Composite tool).

Programming Languages: C, C++, Java

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, IIS

Database Access Technology: ADO.NET, DTS

Design and Development: Alteryx, Visual Studio 2017/2015/2013/2010

Reports: SSRS, Tableau, Crystal Reports, Cognos Reporting tool, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

SSIS Developer

Responsibilities:

• Designed SSIS packages to load the data from FlatFile, Excel, CSV and OLEDB by using transformations like Derived Column, Row Count, Conditional Split, Lookup, Data Conversion, Pivot and Script Component .
• Designed SSIS the packages for the mainframes files using Unpacked Decimal Component to load data to destination tables.
• Designed the SSIS Package to parse any data file using Script Task.
• Migrated existing Packages from SSIS 2012 to SSIS 2014.
• Created Dynamic ConnectionString and Dynamic variables expressions in the SSIS Package.
• Created the Event Handlers, Error handling and Custom Logging forSSISPackages.
• Deployed the SSIS Package using Xml Config File in App server for scheduled Jobs.
• Deployed the SSIS Package in windows task scheduler using Batch script .
• Created jobs for loading the data as daily, weekly, and monthly through the TWS (Tiwoli Workstation) job scheduler.
• Monitoring the jobs and fixing the problem based on the logs.
• Worked Closely with Business Analyst to give the estimate Time on Business requirement and give the feasible solution based on requirement to finalize whether to use Standard Template or Customize.
• Checked-in the ETL and SQL code using TFS (Team foundation server) , and deployed it to the ETL server for environments DEV and Stage using Team services link.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.

Environment: SQL Server 2014, SQL Server 2012, T- SQL, SSIS, SSRS, C#, XML, MS Project, TFS, Power Pivot 2016, SharePoint 2016.

Confidential

MSBI/Tableau Developer (SSIS/ T-SQL/Alteryx)

Responsibilities:

• Involved in conversion of MS Access Scripts into Transact-SQL Scripts
• Developed, deployed and monitored SSIS Packages using visual studio
• Worked on converting the package configurations from XML to SQL server table using the SSIS catalog functionality in SSIS 2014
• Worked on linking the child packages to the master package by using the parent variables within SSIS.
• Created the views and stored procedures to match the queries written in MS Access DB.
• Worked on the CCAR Schedule L project, which is an XLSM tool comprises of VB code and pointing to the MS Access database.
• Re-written the VBA code in the excel tool to point to SQL server instead of Access DB.
• Involved a thorough validation of comparing the XLSM tool data against Access and SQL server.
• Worked under the agile methodology, using the scrum tool Jira, to monitor our work/tasks on sprints basis.
• Implemented different types of constraints on tables.
• Worked on building the stored procedures to write the code for control checks and Fed edit checks submitted by business.
• Used the version control tool Git-hub to check-in our code to the Dev box which will be deployed to the higher environments on release basis.
• Worked on optimization of stored procedures by creating the indexes on few of the tables.
• Worked on converting the existing SSIS packages to use lookups instead of slowly changing dimension (SCD) transformation for incremental load.
• Worked on converting the existing Excel application into an Alteryx application/WF (workflow).
• Converted the business logic using Alteryx tools such as ( Dynamic input, Block until Done, runner tool etc).
• Created the macros and wrapper macros with in the Alteryx as part of business logic implementation.
• Generated the intermediary outputs into the Alteryx (.yxdb) and Tableau (.tde) files
• Published final outputs of the Alteryx macros to Tableau server.
• Worked on creating various Tableau dashboards (rich in visual) as per the business requirements.
• Linked the .tde (Tableau data extract) file onto the tableau server, so it refreshed every time when Alteryx workflow is ran.
• Worked on regression by building a comparison Alteryx WF which automates the regression process by comparing the results of Excel application against Alteryx WF results.
• Worked on variance analysis within the Tableau dashboard by including the different datasets there by allowing users to select the two time periods and perform the variance.

Environment: MS SQL Server 2008 R2/2012, Visual studio 2012, VB Scripting, SQL Server Integration services 2012, SQL Server Integration Services 2012, MS Excel, MS Access DB.

Confidential

SQL BI Developer (SSIS/SSRS) / Data Analyst

Responsibilities:

• Analyzing data, understanding data model, translating requirements and populating dimensions and facts in data warehouse
• Creating reports from different data sources using SSRS.
• Performance enhancement of already existing reports in development Report Manager.
• Migrating data from different data sources to SQL server database using SSIS.
• Load the configuration file into the database using the existing SSIS packages.
• Helping SA's in the validation process after the load using the SQL scripts.
• Creating stored procedures and some complex queries to embed this in SSRS reports.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.

Environment: SQL Server 2008, SSIS 2008, SSRS 2008, .NET Framework, T-SQL, XML, MS Excel, MS Access, Visual Studio 2008.