SUMMARY

• Over 11 years of IT Industry experience, expertise in different domains like healthcare, Settlement funding, Finance and retail domains with key focus in Analyzing, Developing, Integrating, Migrating, Deploying and Testing of solutions using Microsoft Technologies like SQL Server 2008/2008 R 2/2012/2, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services including cloud technologies like Azure data factory, Azure Data bricks, Snowflake
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors
• Experience in cloud technologies like Azure data factory, Azure Data bricks, Snowflake
• Good knowledge of web related technologies such as, HTML, JavaScript, CSS and Flash.
• Able to work in front end and back - end development.
• Able to work in a team and can communicate to provide training to staff and faculty.
• Experience in preparing Test plan, developing, and maintaining test scripts, execution and analyzing the results of scripts, defect management in multi-tiered environment
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2005/2008/2008 R 2/2012/2, MS Access.

ETL Tools: SSIS 2005/2008/2008 R 2/2012/2014/2016 , BCP (Bulk Copy Program, Azure ADF)

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C# ASP.NET, HTML, Python, Spark SQL.

Operating Systems: Windows95/98/7/8, Windows2000/NT/XP, MS DOS.

Reporting Tools: Crystal Reports 11,10, SSRS 2005/2008 R 2/2012/2014/2016 , Tableau 10.x

Testing Tools: Quality Center, Cross Database Comparison Studio, Red Gate SQL Compare, Oraylis, SQL Delta

Other tools: Microsoft Visual Studio 2005/2010, 2012, Salesforce CRM, ProClarity ODBC, and MS Office, Erwin4.0 and SAP ERP

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

Senior SQL Server Developer/SQL Server Architect/Senior Data Engineer

Responsibilities:

• Interacted with business analysts and users to discuss the requirements for development
• Developed functional and technical specification document to assist in the design, development and/or maintenance of deliverables
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Played Architect role for a small project which brings the data from one SQL server to another
• Worked with 3rd party vendor and played internal Architect role for big data migration project and make sure all the requirements have been covered
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task etc. to import the data into data ware house
• Developed SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Deployed packages to pre-production environment and created SQL Agent jobs to run those packages
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices
• Experienced in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012
• Developed, scheduled and generated various reports like List, Matrix, Drill-Down, Chart and Sub report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Responsible to test complex business applications based on business requirements.
• Responsible for developing test scenarios, test scripts and entering them into HP Quality center
• Participate in test planning and giving estimates for testing efforts like creating test cases, writing test scripts and execution time
• Involved in testing multiple applications like Salesforce CRM, SAP ERP & FNO which is used for managing entire licenselifecycle of software, entitlements
• Responsible to work closely with development team to resolve issues and assist business during UAT phase
• Developed Quality Dashboard for QA team using Tableau 10.x
• Used Informatica Power center to create ETL workflows to load the data into destination tables
• Worked with multiple file formats like JSON, XML when testing data in Azure Lake to SQL database
• Administrated HPQC in terms of maintaining licenses, upgrading application, and configuring all projects etc.
• Created Azure data factory pipelines to load the data from Sales force to Azure Blob and then Azure Blob to Azure DB and deployed to higher environments using Azure resource manager
• Created multiple resources in the Azure subscription and administrating all the resources under multiple subscriptions
• Working on Business Intelligence Continuous Delivery Automation Framework Development with all the BI developers and leading the effort
• Used SQLite to run SQL queries with Python
• Working on enabling the Tableau usage data from Non-SQL DB Postgres into SQL DB for reporting purpose
• Enhanced multiple tableau dashboards by adding more functionality sourcing from SQL database
• Created a snowflake procedure to load the parquet files from Amazon S3 bucket to snowflake schema using STAGE and used Snowflake task to run the procedure on schedule
• Created Azure data factory pipeline to load the data from a shared folder to Azure data lake storage and wrote python code in Azure data bricks to transform and send to Azure SQL database
• Created all necessary resources like subscription, resource group, key vault secrets, linked services and datasets and able to send code from feature branch to collaboration branches using Azure dev ops repositories
• Worked on migrating on-prem E2E solution to snowflake using Azure data factory, Databricks and created final views in snowflake for business reporting to use in Tableau
• Replicated on prem objects to snowflake using an existing ADF pipeline and config table used for incremental load purpose.

Environment: SQL Server 2018/2016/2014/2012/2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework and TFS 2010, HPQC ALM 12, Cross Database comparison Studio, SQL Compare, Tableau 10.x, Microsoft Azure, Postgres, Power BI, Informatica Power Center, Python, Azure data factory, Snowflake, Azure data bricks

Confidential, Boca Raton, FL

Sr. SSRS Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications
• Migrated existing Telerik reports and crystal reports to SQL Server Reporting Services (SSRS)
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely with IT project managers, programmers, and testers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimized Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production
• Trained end users with step-by-step instructions to access the pre-build or published reports.
• Performed enhancements to the existing reports based on the requirements and impact analysis of the change
• Responsible for Configuration and Deployment of all reports across various SDLC environments

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), MS Office, MS Visio, HP Quality Center, Cross Database Comparison Studio and Oraylis

Confidential, Sunrise, FL

SQL BI Developer (SSIS & SSRS)

Responsibilities:

• Participated in sprint meetings to discuss on the present tasks assigned and any hurdles related to tasks.
• Interacted with business analysts and users to discuss the requirements for development
• Developed functional and technical specification document to assist in the design, development and/or maintenance of deliverables
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task etc. to import the data into data warehouse
• Developed SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Deployed packages to pre-production environment and created SQL Agent jobs to run those packages
• Implemented Logging and Error handling in SSIS packages
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices
• Created Parameterized, Cascaded parameter Reports using SSRS
• Created dashboard SSRS reports under report server projects and published SSRS reports to the reports server.
• Experienced in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008
• Developed, scheduled and generated various reports like List, Matrix, Drill-Down, Chart and Sub report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 R2 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Environment: SQL Server 2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework and TFS 2010

Confidential, Fort Lauderdale, FL

SQL BI Developer (SSIS, SSAS, SSRS).

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complexSQL 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 cubes and dimensions and measures and calculated measures according to the business requirements.
• 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 SSAS 2008.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• 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.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generation of 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.
• Performed maintenance of Stored Procedures to improve Performance of different front-end Applications.
• 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.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Used ProClarity for analysis services in some cases.
• Extensively 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.
• 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 SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• 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.
• 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, ProClarity, MS Excel.