SUMMARY:

• Around 8 yrs of IT experience in design, development and implementation using Microsoft technologies.
• Experience in dealing with high volume transactional data in SQL. Strong experience in SQL Development, ETL development using SSIS, Business Intelligence delivery using SSAS, and reporting solutions using SSRS.
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages.
• Extensive experience in developing tools using Access, VBA.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Data modeling under different schemas like Star Schema and Snow Flake schema.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Create shared dimension tables, measures, hierarchies, levels, cubes, aggregations on MSOLAP/Analysis Server SSAS.
• Creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions
• Developing Custom Report & different types of Tabular Reports, Matrix Reports, Ad hoc reports & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

TECHNICAL SKILLS:

Languages: Transact SQL, Java, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET.

Databases: Microsoft PDW(APS),SQL Server 2016/2012/2008 R 2/2008/2005/2000, MS Access, TFS, Oracle

Analysis/Reporting Tools: SSRS, SSAS, Tableau.

ETL Tools: DTS, SSIS, Power BI

Data Modeling Tools: Erwin, Visio

Other Software: MS Office - 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, MS Azure SQL Enterprise Manager, Management Studio, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Bluebell, PA

SQL Server Developer

Responsibilities:

• Created various databases like SQL queries, views, Custom functions and stored procedures for application development & reports distribution using SQL Server 2016.
• Interacted with SMEs to understand system and implement the solution for restricting users from accessing data.
• Created various stored procedures using Dynamic SQL for implementing client specific validations.
• As part of ETL package development, created packages to process claims transactions from various clients in various file formats.
• Tested and validated HIPPA compliance and HI-7 messages requirements in the application.
• Experience in using T-SQLfor developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity,SQLjoins.
• Used SQL Server Profiler to tune the performance of existing SQL objects like stored procedures, complex sql scripts etc. Created indexes to improve the performance of sql scripts.
• Created various database objects like SQL queries, views, custom functions and stored procedures for application development & ETL using SQL Server 2008R2 and later.
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).

Environment: ’s:-SQL 2016, 2012 and 2008, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau, TFS, C#, CRM.

Confidential

SQL BI Developer

Responsibilities:

• Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Created packages usingSSISDesigner for exporting heterogeneous data from OLE DB Source.
• Configured Server for sending automatic mails to the respective people when aSSISpackage fails.
• Enhancing and deploying theSSISPackages from development server to production server.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL,SSISand VBScript.
• Wrote complexTSQLqueries to get data from different sources and test results with expected results.
• Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Based on the required reports, identified various data sources and established the connections usingSSISand constructed data source view.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Involved in implementation of reporting tool Power BI for advanced and interactive business intelligence reporting.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Involved in creating report models and applying row level security filters for report model.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code fromdevelopersand QA.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Used SQL Server Agent for scheduling jobs and alerts.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2012.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.

Environment: ’s:-SQL 2016, 2012 and 2008, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau, TFS, python, C#, CRM.

Confidential, Charlotte, NC

SQL Server/MSBI Developer

Responsibilities:

• Created reports using various data visualization like SSRS and Tableau.
• Support in deploying and scheduling the BI solutions.
• Worked in loading data from Microsoft APS server.
• Worked on performance tuning and reduced the time for the daily running jobs.
• Heavily worked and involved in weekly migrations.
• Extensively created and used variousTeradataSet Tables, Multi-Set table, global tables, volatile tables, temp tables.
• Expertise in SQL Server and T-SQL (DDL and DML) in constructing Tables, Indexes, Stored procedures, Views, Normalization techniques on database Tables.
• Worked in buildingDataIntegration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions usingSQLServer Integration Service (SSIS).
• Demonstrated expertise in utilizing ETL toolsInformaticapower center 9.x, 8.x for developing the Data warehouse loads as per client requirement Experience in Data Warehouse development working with Data conversion, Data migration and (ETL) Extraction/Transformation/Loading usingInformaticaPower center with Oracle.
• Developed Workflows to create an efficient way of communication among different Agencies by Auto-Email notifications for key updates on any DynamicsCRMrecords.
• Worked with Logical and physical models inErwin.
• Wrote SSAS cube withMDXand DAX.
• Experience in upgrading and migrating various versions ofPostgreSQLdatabase on different platforms.
• Wrote complex queriesutilizingjoins, sub queries, CTE, and set operators involving multiple tables.
• Extract the Data fromCosmosto SQL layer, and Build SSAS Cubes.
• Created perspectives inSSASand configured security levels for the Cubes.
• CreatingPowerBIdashboards usingPowerBIDesktop andPower Query.
• Developed SQL queries to fetch complex data using Inner/Outer joins, subqueries, CTE, Tally tables accommodating complex filters and database links.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Worked as production support for ongoing jobs and responsible for creating new jobs and maintaining them.
• Coordinate with Onsite and Offshore team and get it approved by client.
• Daily interaction with team in assisting and clarifying their queries.
• Developed complex T-SQL stored procedures using joins and unions to createcrystal reportsand also optimized SQL queries for efficiency and the front enddeveloperwith their queries and procedures.
• Designed and coded Win Forms usingC#.NET.
• Wrote complexT-SQLqueries to get data from different sources and test results with expected results.
• Deployed packages and ETL stuff like procedures, DDL’s etc with Octopus Model Deployment.
• Major and minor enhancements, bug fixes and production support.
• Implemented best practices, query optimization and performance tuning.
• Analysis of the specifications provided by legacy systems.

Environment: Microsoft SQL 2012 and 2008, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau

Confidential, Los Angeles, CA

MSBI Developer

Responsibilities:

• Reviewed many T-SQL issues using management studio for better performance.
• Working on various SSRS reports which are already existed.
• Modifying the old reports and adding subscriptions
• Automated the old manual reports and getting the updated data from app tracker from the site location.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Designed Dimensional Modeling usingSSASpackages for End-User. Created Hierarchies in Dimensional Modeling
• Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along with the reports.
• Expert in designing reports using SQL server reporting services (SSRS) & Excel power pivot table based on OLAP Cubes.
• Wrote T-SQLqueries usinginnerjoin, outerjoin, and selfjoins, mergejoin. Also implemented functionality for removing duplicate records like using CTE and ranking function
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
• Utilized T-SQL daily in creating customs view for data and business analysis.
• Created subscriptions to provide a daily basis reports.
• Developed the necessary project plan based onAgilePrinciples, timelines and schedules related to client'sinfrastructure and workflow needs for the scope of the project
• Tested and validated HIPPA compliance and HI-7 messages requirements in the application.
• Worked on SSRS in SharePoint Integrated Mode.
• Good experience in configuring and supporting clustering, Mirroring and Replication high availability techniques
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.

Environment: - Microsoft SQL 2012 and 2008, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau, TFS.

Confidential

ETL DW-BI (SSRS /SSIS/SSAS) Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Exposed various capabilities such as Web Services using Restful Framework (Spring MVC Framework)
• Responsible for logical and physical design of SQL Server databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Experienced on creating multiple kind of report in Power BI.
• Expertise in forward and reverse engineering usingErwin.
• Created many complex Query's and used them in Power BI Reports directly to generate reports.
• Involved in creatingMDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Developed dashboards and ad-hoc reports using MSPower apps and SSRS for senior management team for analysis.
• Generated ad-hocreportsusing MS Reporting services andCrystalreports.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Designed the application by implementing spring framework based on MVC.
• Developed business logic usingC#.NET, used the developed data layer class extensively for database related transactions.
• Experience in writing complexSQLqueries involving multiple tableinnerand outerjoins.
• Involved in writing, modifying new/existingTSQLand MDX Queries as part of bug fixing in the existing ETL/Reports or to build any ad-hoc reports.
• Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Integrated the application with spring framework.
• Involved actively as a part of team for collecting and analyzing the needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS and Crystal reports.
• Managed and troubleshoot report server related issues.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to user communities.
• Configured SQL mail agent for sending the error records to a different team.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures & long running SQL queries using indexing strategies & query optimization techniques.

Environment: MS SQL, T-SQL,SQL Server 2012/2008R2/2008/2005, SSRS 2012, SSIS 2012,MS Azure, TFS, Java, Visual Studio 2012, XML, XSLT, MS Office, Visual source safe.

Confidential

SQL Server Developer

Responsibilities:

• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Developed SSIS ETL packages usingdatawarehousearchitecture model by creating fact tables role playing and conformed dimensions.
• Developed SQL queries to fetch complex data using Inner/Outer joins, subqueries, CTE, Tally tables accommodating complex filters and database links.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Experience in testing Electronic Data Interchange (EDI) perHIPPA (837,834) Compliance.
• Tested and validatedHIPPA (271)compliance and Hl-7messages requirements in the application.
• Deployed SSIS packages and Reports to Production Servers.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports usingSQLServer Reporting Services (SSRS).
• Design and develop customreportsto meet the business needs using SSRS andCrystalReporttools.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Experience in creating snapshots of static reports and configure subscription.
• Experience in creating complex SSIS-ETL packages using proper control and data flow elements
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Environment: - SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, ProClarity, MS Excel.

Confidential

SQL server Developer

Responsibilities:

• Worked in the team of developers and designers and handled designing, developing, modifying computer applications
• Worked with Sr. Developers to convert verbal requirements into technical format.
• Modified code and provide extremely complex logic to the code for best results and better performance.
• Used SQL Profiler to monitor the performance of SQL Server.
• Scheduled replication on the databases.
• Actively participated in meetings to decide backup policies for database & perform back up operations on databases.
• Performed Join operations using on large scale database tables.
• Maintained the table performance by following tuning tips like normalization, creating indexes and collect statistics.
• Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
• Created Indexes on database tables to perform the Read operations of the database.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.