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 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) 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 the BI solutions.
• Worked in loading data from Microsoft APS server.
• Deploy the code using Git across the 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 the time for the daily running jobs.
• Heavily worked and involved in weekly migrations.
• Actively responded and closed the 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 the Azure portal.
• Experience in working with API’s to push/pull the 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 the power BI reports using the 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 the Database and perform all the database transactions.
• Analysis of the 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 the 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 the web using the CR Viewer control in Visual Studio
• Automated the old manual reports and getting the updated data from app tracker from the 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 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.
• 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 the data from the di erent 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.
• Scheduled the 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 the jobs manually.
• Experience working on Azure SQL Databases and Azure Dataware house.
• Wrote database triggers in T-SQL to check the referential integrity of the 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 this.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• 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 di erent servers.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the 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 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.
• Knowledge of importing COBOL data structure.
• Configured SQL mail agent for sending the 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 the 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 the functional and technical documents, report templates and reporting standards for the developers to work on the 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 the business requirements.
• 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.
• 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 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.
• 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 the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• 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 SSAS2008.
• Involved in the 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 the testing team to test the reports.
• Prepared the reports for the 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 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.