SUMMARY

• Over ten years of experience in the field of information technology with expertise in web as well as client/server based applications design and development using MS SQL Server, Oracle, Visual Studio, C#, .NET framework, OOPS Concepts.
• Knowledge on full software development life cycle (SDLC) starting from collecting business specifications, user requirements, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting effectively the entire life cycle.
• Expertise in Developing and Tuning T - SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks
• Ability to deliver comprehensive Business Intelligence solution through integration of BI suite of products (SSIS, SSAS, SSRS, Power BI, Qlikview, Tableau) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries. Experience in supporting Very Large databases (VLDB) and Very large tables with millions of rows and troubleshooting the problems and also good experience with complex databases.
• Extensive experience in Data warehousing concepts, DW Architecture, DW/BI tools, MS Azure - Azure SQL, AAS, Azure Synapse, Azure Data Factory (ADF), Azure Data Lakes, Azure Devops, Azure Logic apps, Azure Data Bricks, MS SQL, MSBI - SSIS, SSRS, SSAS, Power BI, QlikView, Informatica, Oracle, Excel VBA, VB, .NET and Excel Pivot,
• Having hands on experience in Azure SQL stack architecture - Azure SQL, Synapse, Azure AS, Azure Function, Cosmos DB, Azure Data factory, Data Lakes, Logic apps and Azure IaaS Technologies - VMs, SaaS, PaaS and IaaS architectures
• Implementing Normalization, Transactional and Snapshot replication and Performed log shipping as Disaster recovery solutions.
• Expertise in creating different types of Complex Reports using SSRS.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008.
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008 and Crystal Reports X1.
• Mastered creating the OLAP cubes using various dimensions and creating SQL Server Analysis Projects using SSAS 2005/2008.P
• Extensive experience with data modeling, logical and physical database design using Erwin.
• Experienced in sorting the data, defining data source and subtotals for the reports Expert in Cube designer in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Proficient in implementing security and managing partitions in Analysis Services.
• Extensive experience in creating complex SSIS packages.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2005/2008/ 2012/2014/2016 .
• Solid experience in designing and coding high-volume DTS or ETL SSIS type SQL applications for efficiency and maintainability.
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Agent.
• Designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes.
• Worked in performance tuning, query optimization, client/server connectivity, and Database Consistency Checks using DBCC utilities.
• Extensively used check constraint and primary/foreign key constraints to enforce data and referential integrity.
• Having good experience in configuring and troubleshooting IIS and XML.
• Expertise in Using DMVs, DMFs, DTA, Performance dashboard and database snapshot.
• Expertise in Dashboard design with a working knowledge of Performance Point Server including the ability to design and develop scorecards and dashboards using ProClarity.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Knowledge of Server Components using .NET Framework and Visual Studio 2005.
• Excellent communication and interpersonal skills. Versatile team player with proven problem solving skills. Worked independently as well as in team environments.

TECHNICAL SKILLS

RDBMS: MS SQL, MS Access 2000/97, MySQL, Oracle 10g/9i/8i.

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Databases Maintenance Plan, Data Transformation Services (DTS), Bulk Insert and BCP, BIDS, SSMS.

OLAP/Reporting: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Tableau, Qlikview, Power BI.

ETL Tools: SQL Server Integration Service (SSIS), SQL Server DTS

Programming Languages: C, C++, Core Java, Java Script, C#, .NET, VB.NET, MATLAB.

Operating Systems: Windows 95/98/2000/XP/ Vista/ NT, MAC, UNIX (Linux)

Web Technologies: ASP, ASP.NET, XML, HTML and DHTML

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr. Power BI/ Azure Developer

Responsibilities:

• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Worked on Azure VM migration within and between subscriptions.
• Developed Azure APIs to pull cost related data and VM metrics data and aggregate the data to get monthly costs using python 3.7
• Working in Azure SQL stack architecture - Azure SQL, Synapse, Azure AS, Azure Function, Cosmos DB, Azure Data factory, Data Lakes, Logic apps and Azure IaaS Technologies - VMs, SaaS, PaaS and IaaS architectures. Create Azure Logicapps function and invoke that function in ADF to transfer the files from BLOB to SharePoint and FTP. Maintain the release management of Azure ADF pipelines by using Azure Devops. Create PowerShell scripts to copy the files from different servers by using AZCopy. Involved in Networking and Security for the Blob Storage, Azure SQL and VM in Azure Iaas. Having hands on experience in programming and scripting languages such as Python, JavaScript, PowerShell Migrate the on-premise database - SQL server 2016 into Azure SQL DW.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Developed python API to work with any API url making it reusable with any API.
• Created power bi dashboards using various visuals to create cost analysis data.
• Worked on creating ssis packages to pull data from Microsoft provided raw data and transform according to the business rules
• Code Reviews, customization and maintenance of code across applications using Git Hub

Environment: SQL Server 2012/2014/2016 , SSIS, SSRS Power Pivot, Power BI Desktop, Power BI Web, Git Hub, python 3.7, COSMOS, AZURE Database, SharePoint, XML, HTML

Confidential, Atlanta, GA

Technical Lead (ETL)

Responsibilities:

• Led a team of three developers on offshore and reported to the Technical director.
• Implemented ETL using SSIS with very efficient logging and error handling and loading data from multiple sources both using some of the inbuilt transformations in SSIS and also writing custom SQL and SP’s to support
• Create an Azure function by using C# and Python scripts to handle the functionalities which are not supported in Azure ADF. Had hands on experience in Hadoop, machine learning and advanced data processing Extract data from Azure Blob storage using Hadoop technologies by creating external table.
• Involved with the end-to-end business users for the requirement elicitation and analysis performed
• Created Azure Data Factory for copying data from Azure BLOB storage to SQL Server. Created ADF pipelines / SSIS Package and Performance tuning in the existing package/pipeline
• Documented and developed risk management, technical, and system specifications.
• Worked in a Data Warehouse environment and worked with SQL Server, Oracle, Teradata and Excel based data sources. Identified the data sources for ad-hoc analysis.
• Worked with SAP BO reports to deliver to the customers based on requirements.
• Provided production support and operational support including systems monitoring, problem diagnostics, troubleshooting, resolution, escalation and analysis. Verified and approved daily scorecards to deliver to executive business users.

Environment: SQL Server 2012, SQL Server 2016, DTS,SQL Server Business Intelligence Development Studio 2008R2, Microsoft Visual Studio 2008, MS Excel,MS Access,Windows Server 2003, Oracle 10g, SAP BO report.

Confidential, Boston, MA

Sr. Database/ Power BI Developer

Responsibilities:

• Develop & Design analytical solutions maximizing analytical output.
• Design & Develop databases, models, and processes to support these global assets using SSIS, SSAS.
• Developed complex SSIS packages to import data from SAP HANA into SQL Server including various transformations.
• Analyze and validate data comparing SQL Server imported data with SAP Front end.
• Created complex stored procedures to meet the business requirements. Worked with large datasets.
• Create and monitor jobs using SQL Server agent to automate the process.
• Developed SSAS Tabular models including measures using DAX that accommodate the business requirements and use as a source in Power BI reports.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Extensively used data visualizations calculations using DAX using power BI. Also configured Power BI related Gateways.
• Developed power bi reports using various types of charts, KPIs and slicers and configuring these visualizations according to the user’s requirements.
• Work directly with the business users to gather requirements and understand their usage of the data in depth.

Confidential, Tewksbury, MA

Sr. BI Developer

Responsibilities:

• Design and develop ETL process to integrate data among business systems and Data warehouses in Oracle and MS SQL Server.
• Develop physical data models using ERWIN and created DDL scripts for database schema and objects.
• Maintain and develop system integrations among enterprise front and back end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)
• Modify SSAS cubes in order to resolve production issues or as per requirements by the business.
• Extracted data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data.
• Work directly with the business users in order to gather requirements and understand their usage of the data in depth.
• Work with VB script in SSIS packages in order to ensure the data flow according to the business requirements.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and T-SQL code.
• Check daily jobs and verify databases in order to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is a Oracle Financial ERP system for Confidential, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.
• Involved indaily batch loads (Full & Incremental)intoStagingandODS areas, troubleshooting process, issuesanderrors using SQL Server Integration Services (SSIS) 2008.
• Design, code and test and trouble shoot business reporting for end users in Business objects Crystal Reports, SSRS and Tableau.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Developed Flowcharts with Visio/VBA/Excel/SQL, which was used in storing Flowchart elements.

Environment: SQL Server 2008 R2, SQL Server 2014, DTS,SQL Server Business Intelligence Development Studio 2008R2, Microsoft Visual Studio 2008, MS Excel,MS Access,Windows Server 2003, Crystal Reports 10.0, Tableau, Oracle 10g, Power BI.

Confidential, Boston, MA

Database developer

Responsibilities:

• Gather requirements from business users and worked on deriving technical specifications based on functional specifications.
• Create or modify complex TSQL stored procedures, functions, views etc. to fetch data from different databases.
• Developed triggers to invoke the health management team the various issues of patients after the diagnosis.
• Created stored procedures for effectively retrieving the medical errors from records.
• Developed efficient user defined functions to access Personal Medical Information of the patients.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Responsible to create dimensions with the cube wizard, refreshing cube to get the latest date updates, deployment of cubes to the production server.
• Create complex ad hoc reports using SSRS reports and Crystal reports.
• Deploy the crystal reports to the Business objects server and SSRS reports to reports server and create jobs using SQL Server agent to automate the process.
• Develop complex SSIS packages with different data sources incorporating script task (VB scripting or C# scripting), etc. to deliver data reports to business users.
• Worked as interim Production developer to deploy development work to production, run weekly, monthly, quarterly, semi annual and annual jobs so that the reports are delivered to the client on a timely basis.

Environment: SQL Server 2008 R2, SQL Server 2012, DTS, SQL Server Business Intelligence Development Studio 2008R2, Microsoft Visual Studio 2008, XML, MS Excel, MS Access, Windows Server 2003, Crystal Reports 10.0.

Confidential, Windsor, CT

Sr. SQL/BI Developer

Responsibilities:

• Involved in installing and configuring SSRS 2008 R2.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created ad-hoc reports with incorporated filters, sorting, etc. and presented them Confidential the client side to note the changes they may need.
• Worked on T-SQL Queries, Stored procedures to fetch complex data from different tables
• Deployed reports on to the report manager and organized them in folders.
• Changed the report parameters and report data sources and added the web part after deploying to share point.
• Created Multi-Dimensional Expression (MDX) for accessing OLAP cubes
• Developing a Business Intelligence solution framework according to Architectural specifications to integrate the following components: Data Warehouse and metadata, ODS, Data Staging, Data Quality, OLAP cubes, ETL’s, scorecard, dashboard, Reporting tools, analysis of error logs.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Used c#.net asp web pages to show the deployed reports as required by the user.
• Built effective queries for high-performance reporting and rendered them to XML, csv and Excel formats using Reporting Services.
• Used JIRA portal and SharePoint server for project and bug tracking and document updates.
• Created standard Reports and Cross Tab Reports, Drill Down and Drill Through reports from data source: SQL Server 2008 R2.

Environment: SQL Server Business Intelligence Development Studio 2008R2, Jira, SQL Server Management Studio 2008R2.

Confidential, Jacksonville, FL

Sr. Database Analyst/Developer

Responsibilities:

• Developed stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Expertise with DDL and DML statements, RDBMS’, data dictionaries and normal forms.
• Created logical and physical database design, data structures and maintained it by writing user defined functions, views, T-SQL scripts.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Created indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and complex business logic using Batch Files.
• Worked on Query Optimization and performance tuning of stored procedures, functions etc.
• Developing MS SSIS packages for extracting the data from Staging Database and front end Field Collector application, Perform the QC Rules Check and loading into the National Property Database.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008/2008R2.
• Developed SSIS Packages to extract data from various data sources such as flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count, Merge Join.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Author concise functional/technical documentation and provide status and project updates using Visual Studio Team Foundation Server.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSIS, T-SQL, Windows Server 2003, Team Foundation Server, Visual Studio 2010 Ultimate (TFS).

Confidential, St. Louis, MO

Sr MS SQL Developer/ SSIS/SSRS Developer

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology
• Involved in installing and configuring SSRS 2008.
• Created User defined functions and stored procedures to meet the requirement.
• Worked with Exception Handling with @@error and Try/catch.
• Created various Indexes on tables for better Query Performance.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages
• Identified and defined the Datasets for the report generation.
• Migrated Crystal reports to SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created ad-hoc reports with incorporated filters, sorting etc and presented them Confidential the client side to note the changes they may need.
• Deployed reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Created standard Reports and Cross Tab Reports, Drill Down and Drill Through reports from data sources like SQL Server 2008 and IBM DB2 AS400 (I Series).
• Created complex Stored Procedures, triggers, functions, Indexes, Tables, Views and SQL joins for applications.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.

Environment: SQL Server 2008 R2, SQL Server 2012, DTS, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio 2008R2, Microsoft Visual Studio 2008 C#, ADO.net, XML,MS Excel, Windows Server 2003.

Confidential, Rochester, NY

MS SQL Developer SSIS/SSRS Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created and modified stored procedures.
• Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Successfully used SQL Server Integration Services for integrating data from databases like oracle, MS Access and heterogeneous data to and from SQL Server.
• Responsible for Performance tuning like optimizing stored procedures which involves re-writing Some portion of code according to business and adding some indexes to base tables etc.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
• This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
• Responsible for Monitoring Daily running jobs like Data loading jobs, Replication jobs.
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Traced long running queries and Stored Procedures using SQL Profiler to tune them as a part of Application enhancement.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS 2005.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Experience in SSAS (SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Developed and implemented Backup and Recovery strategies. Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per the business needs.
• Extensive experience in Developing SSIS (Integration Services), Testing and Deployment / Implementation, Performance, Error Handling, logging and data auditing and Troubleshooting.
• Used Team Foundation Server for integrated source control, builds, testing, and deployment

Environment: SQL Server Business Intelligence Development Studio 2008, Microsoft Visual Studio 2005, SQL Server Management Studio 2008, IBM DB2 AS400 (I Series), Aqua data 9.0, XML, MS Excel.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Used T-SQL to create various queries of employee data, new hire applicants, promotion, demotion, leave or absence, payroll data.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Created new tables, wrote stored procedures and user defined functions for the database.
• Performed data conversions from flat files into a normalized database structure.
• Created triggers, check constraint and Primary/Foreign Key to enforce data and referential integrity.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Managed historical data from various heterogeneous data sources like excel, fixed width flat files.
• Performed tuning of SQL queries and stored procedures using SQL profiler.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked in the team for gathering and analyzing the needs of end user requirements.

Environment: Microsoft SQL Server 2000, Windows XP, Microsoft Visual Studio, XML, DTS.