SUMMARY

• Over 10 years of experience in Microsoft .NET technologies and MS SQL Server
• Good experience in SQL Server 2016/2012/2008 R2 database Development and data migration
• Experience in Developing BI applications utilizing Sql Server, BI Stack, Power BI and Domo
• Experience in Building SSAS cubes and Dimensions with different Architectures and Data Sources for Business Intelligence
• Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions
• Proficient in buildings various dashboard reports using SSRS
• Experience in creating and scheduling Jobs, Alerts, Sql Mail Agent
• Developing C# scripts in SSIS and automating tasks using C#
• Expert in Ad - hoc reports, drill down reports and cross tab reports
• Involved in Migrating data to different environments
• Expert in Data Extraction, Transforming and Loading(ETL) using For Each Loop in SSIS with .Net
• Hands on experience with working on different Databases including Oracle, Postgres and AS400
• Good knowledge of Normalization/De-Normalization, Data Design methodology and building Referential Integrity for the relational Database Model.
• Experience indeveloping,monitoring, extractingandtransformingdata usingDTS/SSIS, Import Export Wizard, and Bulk Insert
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/20 /2016
• Good Experience in PL/SQL, LINQ to SQL
• Strong knowledge of Data Warehousing methodologies including star schema, snowflake schema
• Experience inPerformance TuningandQuery Optimization.
• Experienced in using Crystal Reports, SSRS, SSIS and SSAS
• Good understanding of how the various security systems work and Incident Management

TECHNICAL SKILLS

Databases: SQL Server 200/2003/2008/2012/2016

SQL Server Tools: DTS, SSIS, SSRS,Business Objects, Query Analyser

Technology Focus: Multi-Tier Web Based Architecture, VB.Net, C#, ADO.Net, ASP.Net. Web Services, Win Forms, Web Forms, Security, Stored Procedures

Programming Languages: C, C++, C#, VB.Net,HTML/DHTML.

Multimedia: Macromedia Fireworks, Dream Weaver, Photoshop, Flash.

Operating System: Windows 98/2000/NT/XP/Vista/ 7/2000/2003/2012/2018 Server

Microsoft Office Tools: Microsoft Word, Excel, Access, Visio

Reporting Tools: SSRS, Business Intelligence Tools, Crystal Reports, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Hallandale Beach, FL

Senior Product Developer/BI Developer

Responsibilities:

• Interfaced with business analyst to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner
• Designed, reviewed, and created primary objects like Views, Indexes, Triggers based on business requirements and physical constraints
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Designed cards in Domo and shared with all the franchisees across all the EWC Centers
• Created SSIS packages to Extract, Transform and Load ETL user data and other data from OLTP to OLAP
• Used SSIS for each loop to implement data updates from various sources to data warehouse
• Configured and deployed the new Project based deployment in SSIS 2016. Deployed the Projects to Integration Services Catalog and managed the security, and created SQL Server Agent Jobs to schedule daily data transformation
• Created Tabular Models judging by the data volume and corresponded with Microsoft BI tools.
• Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods
• Created snapshot on the report server management to ensure that the reports on the server won't be affected by constantly changing database environment
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Environment: Microsoft SQL Server 2016, Domo, SQL Server Integration Services SSIS 2016, SQL Server Reporting services SSRS 2016, SQL Server Analysis Services SSAS 2016, ASP.net, Excel 2013, Power BI, Windows 8, Team Foundation Server

Confidential, West Palm Beach, FL

Software Developer/BI Developer

Responsibilities:

• Create T-SQL Functions, Cursors,views, indexes,stored proceduresand triggers. Designing and developing new reports using SQL Server Reporting Services using Business Intelligence Development Studio.
• Analyzed & designed the business rules for data cleansing that are required by the staging, OLAP and OLTP databases.
• Worked very closely with the DBA team to ensure data integrity and security, provided architecture guidance.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing data sources.
• Perform data analysis that will support and enhance Information Management systems
• Work independently or as part of a team to design and develop solutions
• Expert knowledge of Data Management, Business Intelligence and Analytics concepts
• Developing Web application usingC#, ASP.NET
• Writing services using Web Api to get data from various Clients and update Risk
• Writing complicated queries using Linq to SQL
• Implementing Role Based Security
• Used various formatting techniques likeinteractivesorting,groupingto create user friendly reports using SSRS.
• Fixing issues identified during Quality Assurance
• Participate in design meetings
• Assist in providing IT security advice to clients and resolve production issues

Environment: SQL Server 2016, SSRS, SSIS, SSAS, BIDS, Visual Studio 2015, JavaScript, Angular JS, Web Api, WCF Services, ASP.Net, C#, Entity Framework, Team Foundation Server, Github

Confidential, West Palm Beach, FL

BI Developer

Responsibilities:

• Converting Stored Procedures from Legacy systems to SQL Server by using Dynamic Sql.
• CreatingSSIS packagesto load data fromPostgresto Sql Server using various transformations in SSIS.
• Creating T-SQL Functions, Cursors,views, indexes,stored proceduresand triggers.
• Developed and automated report subscription process usingSSRS
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Designed and developed various reports by comparing the growth of company based on each quarter by using bar charts.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Involved withQuery Optimizationto increase the performance of the Report.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Writing complicated queries using Linq to SQL
• Used various formatting techniques likeinteractivesorting,groupingto create user friendly reports.
• Fixing issues identified during Quality Assurance

Environment: SQL Server 2012, SSRS, SSIS, BIDS, TSQL, Visual Studio 2015, JavaScript, JQuery, AJAX, Telerik Controls, ASP.Net, C#, Entity Framework, WCF Services, Team Foundation Server

Confidential, Miami, FL

Programmer Analyst/BI Developer

Responsibilities:

• Developing Windows and Web Forms using C#.NET
• Performed Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics, SSRS reports using MS Visual Studio.
• Converted Business Objects reports into SSRS.
• Built connections to pulling data from AS400, mainframe/db2 and Oracle.
• Created database objects like table, Views, Stored Procedures, Triggers, Functions etc. using T-SQL to provide structure to store data and maintain database efficiently.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report.
• Configure SSIS Package for run time Parameters and config file.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed many stored procedures which were used in the reporting.
• Scheduled alerts for successful or unsuccessful completion of Scheduled Jobs.
• Documented the data flow, source and target mappings from the existing data loads which are being carried out through manual steps and developed a strategy to automate the process using SSIS.
• Designed and developed SSIS (ETL) packages to validate, extract, transform, which was load data from spread sheets to the Clients server, automated many manual steps which were being used to load the data.
• Implemented data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column and Joins in SSIS
• Developed and deployed data transfer packages using SSIS and maintained the jobs running on Servers.
• Converting the Console App to SSIS package
• Designing and developing new reports using SQL Server Reporting Services(SSRS)
• Design and develop ETL processes using Microsoft SQL Server 2012 SSIS, or other related tools and technologies
• Schedule and maintain SSRS reports using the subscription list on Report Manager Server
• Developing Stored Procedures, Dynamic SQL Queries, Triggers and Views on SQL Server
• Fix issues identified during Quality Assurance(QA) and User Acceptance Testing(UAT)
• Configured and trained users to use Reporting Services

Environment: Visual Studio 2008/2010/2012, C#, SSRS/SSIS Reports, BIDS, SQL Server 2008/2012, ASP.Net, 2008/2012, Web Services, Team Foundation Server, Windows Server 2003.

Confidential, Miami, FL

BI Developer

Responsibilities:

• Worked closely with Managers, Project Managers, Technical Managers and subject-matter experts to obtain requirements, objectives, and business rules for projects and translate them into functional and non-functional specifications document, for BI and applications for the various business users like Actuaries, underwriters etc.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers).
• Created complex Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified/optimized already existing stored procedures, triggers, views, indexes according to the new design requirements.
• Strong hold in Database and Data warehousing concepts.
• Experienced in creating complex SSIS packages, using various transformation package parameters and variables. Import export wizard and bulk insert.
• Proficient in MS SQL Server 2000/ 2005/ 2008/2012 advanced database programming concepts such as cursors, stored procedures, functions, view, and CTE.
• Good knowledge of using various MS SQL Server tools/wizards such as SQL Profiler, Performance Monitor Index Tuning Wizard tuning MS SQL Server performance
• Experience in working with OLTP and OLAP Data models.
• Good experience in complete ETL cycle, including data analysis, database design, data mapping, and conversion and data load.

Environment: Visual Studio 2008/2010/2012, ASP.Net, C#, SSRS/SSIS Reports, ADO.Net, SQL Server 2008/2012, Web Services, WCF Services, Visual Source Safe, Team Foundation Server, Windows Server 2003.