SUMMARY

• Over 7+ years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in integration of various data sources like SQL Server, Salesforce, Oracle, Access DB, DB2 and Flat File, Excel File.
• Import Data into Power BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in Power BI.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Used transformations likeSCD,CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting teh business requirements
• Extensively worked on Control Flow Tasks such as For each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of teh integration services (SSIS).
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS 2008/2012/2014/2016.
• Experience in debugging teh SSIS packages using breakpoints and checkpoints.
• Hands-on star schemas, snowflake schemas, dimensional modelling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
• Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Highly proficient in teh use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool.
• Experience in using Star Team and Team foundation server for source control.

TECHNICAL SKILLS

Server Operating System: Windows 2003, 2008, 2012.

Languages: C, C#, Pl/SQL, T-SQL

Microsoft Technologies: C#.NET, ASP.NET, VB.NET, ADO.NET

Web Technologies: HTML, XML, SharePoint 2010.

Data bases: MS SQL Server 2005/2008/2012/2014/2016 , Oracle 10g

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI Desktop.

Development Tools: Visual Studio.NET 2008/2012/2013/2015/2017 Community Edition

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2015, SQL Profiler, DQS, Toad for SQL server

PROFESSIONAL EXPERIENCE

Confidential, Tampa

Sr.SQL BI Developer

Responsibilities:

• CreatedSSISpackages to perform filtering operations and to import teh data on daily basis from teh legacy data sources to SQL Server 2016.
• Creating complex SQL scripts to transform legacy data in staging area using SSISpackages.
• ConfiguringSSISpackages for run time parameters and config files.
• UsedSSISfor Extracting and Merging of data from different source to single source.
• Scheduling Jobs to runSSISPackages in teh night feed to DSS for fresh day data.
• CreatedSSISpackages to automate different FTP's files and emailing to different clients.
• CreatedSSISpackages included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Generated reports from SQL Server Database and OLAP data warehousing.
• Deployed Reports to Report Manager and Troubleshooting for any errors during in execution.
• Scheduled teh Reports to run on teh daily and weekly basis in Report Manager and email them to teh directors and analyst to review in Excel sheet.
• Created Sub-Report, Matrix Report Tablix Report Drill down Report and Charts usingSSRS.
• Deployed and subscribe Reports usingSSRSto generate all daily, weekly and monthly reports.
• Build automated ETL processes in SQL Server Integration Services (SSIS) for teh system.
• Designed a Power BI Data model with multiple Facts and Dimension Tables based on teh requirement.
• Designed and Implemented analytics solutions using Power BI Dashboard and Reports.
• Utilized Power Query in Power BI to Pivot and Un-Pivot teh data model for data cleansing.
• Created Page Level filters, Report level Filters, Visual level filters in Power BI according to teh requirements.
• Participated in testing during teh UAT (QA Testing). Mentored and monitored team development and status.
• Drop and recreate Index on teh DSS System while migration data.
• Based on teh business requirement written complex T-SQL queries to perform data and graph validation to make sure that teh test results are matched.
• Designed Data flows, Workflows and jobs to load data from source to target.
• Created trace in SQL Profiler and used Data base engine tuning advisor for performance tuning on scripts and stores procedures.
• In-Depth knowledge of SDLC, understanding of various phases like Requirements, Analysis, Design, Development. And Testing. Reviewed many T-SQL issues using management studio for better performance.

Environment: SQL Server 2014/2016, SQL Server Integration Services, Power BI, MS Excel 2016, Management Studio, SQL Profiler andSSRS.

Confidential, Atlanta, GA

Sr. SQL Developer

Responsibilities:

• Responsible for gathering requirements for teh new projects and creating teh data flow model of teh Business requirement with MS Visio 2013.
• Involved in integrating different Database Applications using SSIS packages.
• Creating SSIS packages that involves migration from legacy systems to centralized Database.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping teh right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Expert in using teh work flow canvas for multiple transformations of data and teh use of different features like variables, package configurations, event handlers,errorloggingand check points to facilitate various complex ETL logics and specifications
• Deployed and uploaded teh SSRS reports to SharePoint Server for teh end users and involved in enhancements and modifications.
• Provide optimized views and queries for Business Objects reports
• Validate data before performing ETL transformations and load into SQL server database.
• Intensively worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS 2012.
• Usedtaskfactorycomponents and transformation like Upsert destination, Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMSTaskinSSISpackages
• Worked with Web Service task where some of teh binary files will be converted into XML element to place in Message Broker queue.
• Involved in creating SSRS and power view reports.
• Implemented transformation mapping through BizTalk server with teh help of Visual Studio to achieve data transformation from one type to another.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
• Created stored procedures, Cursors, Joins in T-SQL.
• Manually documented each process and teh flow of teh package.
• Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on teh business requirements.
• DesignedVBAmacros in Excel to automate data extraction and reporting.
• Created visualization reports and dashboards using Power BI desktop and published them to teh Power BIService.
• Implemented Distributed Transaction Control for teh SSIS packages and event handlers to keep track of error logs. Also to trigger emails about teh failure using Email task.
• Designed and created Report templates, bar graphs and pie charts based on teh inspection data.

Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS 2016/2012/2008 , Microsoft Office, MS VISO 2015, Profiler, Visual Source Safe, BIDS, C#.NET,VB, Visual Studio, MS BizTalk Server.

Confidential

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing teh purpose of teh project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in teh project.
• Imported teh data from flat files and were transformed and placed in DB2, Teradata Databases as they were teh target databases.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008R2 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed SQL scripts for data dump in teh Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements TEMPeffectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
• TEMPEffectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted teh organization in performing data compilation, mining and analysis required to evaluate teh given data.
• Performed business data analysis and report creation in support of both ad hoc requests from teh customer and to support new development and system maintenance.
• Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.

Confidential

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Communicated with teh Business Users to understand teh requirements.
• Created Drill reports for teh Clean-up Activity followed in teh company
• Created reports for calculating teh number of hours scheduled and teh calculations made for teh payment.
• Generated periodic reports from teh cube based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
• Wrote queries using MDX
• Deployed and configured teh reports in teh Report Server.
• Experienced in designing teh OLAP systems for data mart applications using SQL Server Analysis Services 2008
• Used stored procedures and user-defined functions for different Reports.
• Wrote complex correlated sub queries to generate reports.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.

Environment: SQL Server 2008, SSRS 2008, SSAS, Visual Studio 2008, XML, XSLT, MS Office and Visual Source Safe