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 modelling under di erent schemas like Star Schema and Snow Flake schema.
• Experience in Performance Tuning and Query Optimization.
• Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access databases like SQL Server 2008/2005/2000.
• Extensive experience in using SQL Server Profiler to monitor teh SQL server for deadlocks, long running queries and tunes teh 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) 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 & di erent 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, C#.

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

Analysis/Reporting Tools: SSRS, Tableau, Power BI, SSIS, Data Factory, Data Lake, databricks

ETL Tools: SSIS

Data Modelling Tools: Visio

Database Tools: SQL Query Analyzer, Parallel Data Warehouse, MS Azure SQL Enterprise Manager, Management Studio, Analysis Manager, Reporting Server, PowerShell, Command Shell, Python

PROFESSIONAL EXPERIENCE

Confidential, Rolling Meadows, IL

Azure Developer

Responsibilities:

• Building of ETL packages as per new Microsoft PDW standard.
• Created reports using various data visualization like SSRS and Tableau.
• Support in deploying and scheduling teh BI solutions.
• Worked in loading data from Microsoft APS server.
• Deploy teh code using Git across teh environments.
• Implemented CI/CD for sql objects and data pipelines in Azure.
• Experience in developing and building Azure functions.
• Pulled data from CosmosDB for an UI application.
• Push changes from local to GitHub repository.
• Knowledge on Git hooks.
• Worked on performance tuning and reduced teh time for teh daily running jobs.
• Heavily worked and involved in weekly migrations.
• Actively responded and closed teh NOC issues.
• Experience in integrating and automation of Python scripts in Data factory using data bricks.
• Worked as production support for ongoing jobs and responsible for creating new jobs and maintaining them.
• Coordinate with Onsite and O shore team and get it approved by client.
• Daily interaction with team in assisting and clarifying their queries.
• Code reviews of team.
• Built storage containers for large file data loads in teh Azure portal.
• Experience in working with API’s to push/pull teh data.
• Developed dynamic email notification using LogicApps.
• Used RestAPI client POSTman for testing web service request and response.
• Experienced on creating multiple kind of report in Power BI
• Developing teh power BI reports using teh connection string like SQL server, SSAS and T - SQL statements.
• Created power BI reports from data mart tables.
• Migration of project from PDW to Azure.
• Loaded packages through Azure Data Factory.
• Deployed packages and ETL stu 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.
• Wrote LINQ-TO- SQL queries to perform DML operations from Entity Data Model.
• Used Entity Framework and LINQ to Entities to Connect to teh Database and perform all teh database transactions.
• Analysis of teh specifications provided by legacy systems.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL data sources
• Responsible for connectivity of database using ADO.NET Components.
• Developed stored procedures as per new Microsoft PDW standard.

Environment: Microsoft SQL 2012 and 2008, Parallel Data Warehouse(APS), SSIS, SSRS, Tableau, TFS, MS Azure, Octopus, GitHub, VSTS, Command Shell, PowerShell

Confidential, Butler, PA

Developer BI

Responsibilities:

• Reviewed many T-SQL issues using management studio for better performance.
• Working on various SSRS reports which are already existed.
• Modifying teh old reports and adding subscriptions.
• Responsible to create new web services using ASP.Net with C#.
• Generating reports using Crystal Reports to be displayed on teh web using teh CR Viewer control in Visual Studio
• Automated teh old manual reports and getting teh updated data from app tracker from teh site location.
• Written Unit test cases for chef recipe testing using test kitchen, food critic etc.
• 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.
• Created reports using Cognos.
• Converted various crystal reports into Cognos reports using Cognos BI.
• Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy teh various report items like charts, maps, images, graphs, tables etc. to teh R2 report server along with teh reports.
• Expert in designing reports using SQL server reporting services (SSRS) & Excel power pivot table based on OLAP Cubes.
• 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 report.
• Worked on SSRS in SharePoint Integrated Mode.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting teh data from teh di erent sources (CSV files, oracle, and MS SQL 2000) and stored teh data into teh intermediate Staging Database using teh SSISETL tool.
• Transform teh data from teh staging database and perform teh transformation using teh Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled teh Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Built and managed a large deployment of Ubuntu Linux instances systems with Chef Automation and Wrote recipes, tools, shell scripts, and monitoring checks.
• 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.

Confidential, Marietta,PA

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.
• Familiar with SAP BODS and worked with team in creating Batch jobs and running teh jobs manually.
• Experience working on Azure SQL Databases and Azure Dataware house.
• Wrote database triggers in T-SQL to check teh referential integrity of teh database.
• Using SAP data designer to create work ows, data ows etc.
• Test Chef Cookbook modifications on cloud instances in AWS and using Test Kitchen and Chef Spec.
• Migrated SQL Server 2008 database to windows Azure SQL Database and updated Connection Strings based on dis.
• Alter teh schema for teh required objects. Designed and optimized all teh SSIS packages.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performing teh ETL operations to support teh incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing teh data between two di erent servers.
• Involved in building and maintaining SSIS Packages to import and export teh data from various data sources using BIDS based on teh design data models.
• Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
• Integrated teh application with spring framework.
• Involved actively as a part of team for collecting and analyzing teh needs of end user requirement.
• Generated various reports with drilldowns, calculated members, and dropdowns from teh 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.
• Knowledge of importing COBOL data structure.
• Configured SQL mail agent for sending teh error records to a di erent team.
• Successfully deployed SSIS (ETL) packages and scheduled jobs.
• Optimizing Stored Procedures & long running SQL queries using indexing strategies & query optimization techniques.
• Responsible for rebuilding teh indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.

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/MSBI Developer

Responsibilities:

• Worked with Technical Architects/Database analysts for Design of Summary tables for efficient Report Design.
• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh report development.
• 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 ow task, file system task, Execute package task
• Created cubes and dimensions and measures and calculated measures according to teh business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS2008.
• Performed teh task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from teh cubes by connecting to Analysis server from SSRS.
• Developed teh 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 teh database.
• Experience in creating complex SSIS-ETL packages using proper control and data ow elements
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing teh cube for analysis and validation of teh data. Processing teh cubes and dimensions on a daily basis using teh SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease teh processing time and increase teh performance of teh queries running on front end application using SSAS2008.
• Involved in teh SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Build database queries and test cases for teh testing team to test teh reports.
• Prepared teh reports for teh day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

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 teh 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 teh code for best results and better performance.
• Used SQL Profiler to monitor teh performance of SQL Server.
• Scheduled replication on teh 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 teh 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 teh Read operations of teh database.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating teh 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.