SUMMARY:

• 15 years of IT experience with expertise in design, architecture and implementation of solutions using MS Azure, SQL Server, SSIS, Data Warehousing, MS Azure and C# in key delivery areas.

• Experienced in data integration standards, data architecture processes, data governance policies, and vision and explore new and emerging technologies.
• Lead strategy, development, and implementation of a Data Model and strategy development for usage of Operational Data Stores
• Promoted best practices for data modeling within information areas and provide oversight for all activities related to data cleansing, data quality, and data consolidation.
• Strong Hands on experience in SSIS packages. Worked on large database design techniques; experience in data mart, data transformation and migration using SSIS.
• Experienced in OLTP, dimensional and factual data modeling and Azure SQL Databases.
• Performance tuning in SQL Server using execution plan, SQL profiler and database tuning advisor.
• Experienced in data migration from on - premise to cloud (Microsoft Azure).
• Strong understanding of Azure environment (PaaS, IaaS) and experience in working with Hybrid model.
• Experienced in deployment of SSIS packages (lift and shift) in cloud (Microsoft Azure) using Azure Data Factory.
• Strong Hands on experience in Azure storage (Blob Storage, Data Lake Storage) and Azure SQL DWH.
• Experience in transformation of data using Azure Data lake analytics and U-SQL.
• Experience creating templates to provision cloud resources using ARM templates on PowerShell.
• Experienced in agile methodology, sprint scoping, capacity planning & daily scrums.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

Azure Data Architect

Responsibilities:

• Develop cloud architectures, governance policies, security models, and best practices.
• Analyze prospect requirements and establish parameters to ensure client receives teh right solution, in conjunction with teh Sales Representative.
• Cost projects with teh Sales Director to guarantee profitability.
• Resolve any client or sales concerns and revise proposals if necessary.
• Working with Vulnerability assessment team to work on discovered vulnerability.
• Designed solution and developed a generic pipeline to compare multiple files using Azure Data Factory.
• Created an automated process to determine teh slowest running queries and provide recommendation using azure data factory and query store.
• Designed and developed teh solution to migrate on-premises oracle data to azure data warehouse using azure data factory.
• Archived on premise data in Azure Data lake using ADF pipelines.
• Created a tool to compare teh data of two different systems using ADF, Azure BLOB and Azure SQL Server.
• Created CI/CD pipelines using azure Devops.
• Created reports using Tableau to facilitate analysis for business key people.

Environment: MS Azure, Azure Data Factory V2, MS Azure SQL DB, Logic apps, Azure Data lake storage gen2, U-SQL, Azure DevOps (VSTS) and Agile methodology.

Confidential

Lead Consultant (Architect)

Responsibilities:

• Organizing and managing teh technical data team of data modelers, engineers and providing leadership, guidance, and mentoring.
• Developing conceptual and logical information models within teh context of teh Enterprise and Line of Business Information Architecture.
• Overseeing teh mapping of data sources, data movement, interfaces, and analytics, with teh goal of ensuring data quality. Collaborate with project managers, address data related problems regarding systems integration and compatibility, as well as act as a leader for coaching, and providing career development to junior team members.
• Ensuring dat DW/BI standards and guidelines are used to develop teh information models and database designs.
• Working with teh DBA to transform teh logical information model into a first-cut logical database design (physical information model for teh target DBMS). Provided solutions to internal clients with respect to providing data, and suggestions to improve business processes and decision making
• Working with management to prioritize business and information needs perform other related tasks and assignments as required. Breaking down teh work into epics and epics into user stories.
• Designed and architect a synchronization process dat loads smart meter data from 7 separate source systems (like SQL Server, Oracle and csv files) and finds mismatched data across multi-million rows.
• Created an architecture of data migration from on-premise (SQL Server) to cloud (Microsoft Azure).
• Migrated SSIS packages (lift and shift) to cloud (Microsoft Azure) using Azure Data Factory.
• Created ELT pipelines and automated Azure Data Factory pipelines.
• Used Azure Data Factory, Azure Data Lake Storage, Azure SQL DWH for data transfer/storage.
• Created an architecture to retrieve data from various sources and then ingest, prepare and transform to Azure SQL Datawarehouse using pipelines of ADF.
• Designed high availability solution using azure traffic manager.
• Created Tableau reports to compare teh data.

Environment: SQL Server 2016, MS Azure, Azure Data Factory V2, Azure Data lake storage gen2, Erwin 7.3, T-SQL, U-SQL, SSIS, C#, Azure DevOps (VSTS), Tableau and Agile methodology.

Confidential, Philadelphia, PA

Lead Consultant (Architect)

Responsibilities:

• Assesses application, environment, network, or storage issues and makes recommendations to improve overall performance.
• Work to establish best practice and methodology in teh area of architecture, design and development.
• SQL Tuning including analyzing existing code and providing recommendations for improvement.
• Provide technical and business subject matter expertise to teh data modelers and other developers.
• Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
• Discover and implement performance and uptime improvement strategies.
• Coordinates and works with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Involved in data architecture and data modelling. Implemented Kimball methodology in dimension modelling.
• Writing, installing, configuring, scheduling and monitoring SSIS packages.
• Developed, modified, and optimized complex queries for data retrieval and modification in SQL Server.
• Programming views, stored procedures, and functions, and reviewing query performance and optimizing code.
• Created Data Migration scripts and ETL (SSIS) to migrate data from different Sources to SQL Server.
• Opportunity to work on challenging environment and new technologies such as Cloud, high performance scale-out architecture.
• Designing Strategies and Tooling for teh Entire Data Pipeline dat includes Data Ingestion, Data Transformations, Storage and Analytics.
• Migrated SSIS packages and on-premise database into cloud (Microsoft Azure) using Azure Data Factory.
• Ingest data in Azure Data lake storage gen2 and transform in Azure Data lake analytics.

Environment: MS SQL Server 2014, T-SQL, XML, SSIS, Erwin 7.3, Azure Data Factory, Self-Hosted integration runtime serviceC#, TFS, VSTS, Microsoft Azure and Agile methodology.

Confidential

Senior Consultant

Responsibilities:

• Interfaced with Line of Business to Collect Requirements.
• Designed database and developed data mart schemas using SQL Server 2014.
• Created Stored Procedures, Functions and Views using SQL Server. Created complex SQL queries and worked on query optimization in SQL Server. Performance tuning using Execution plan, SQL profiler and Database tuning advisor.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML to MSSQL Server by using SSIS services and BCP utility. Created SSIS packages to transfer teh data from files and automated teh process by scheduling in SQL Server Job agent. Created and Maintained SQL Server Job agent and worked with Cisco Tidal Jobs.
• Created and provided XML format data files to vendor using XML Datatype.
• Developing Parameterized and Crosstab reports from Data Mart using SSRS on SQL Server 2014.
• Consumed REST API from SSIS script task and component using C# and .Net.
• Configured HRMS UltiPro tool and integrated with SQL Server 2014.

Environment: SQL Server 2008/2014, SQL Server Management Studio, Business Intelligence Development Studio, T-SQL, XML, SSIS, SSRS, Data Warehousing, C#, .Net and CISCO Tidal.

Confidential

Engineer II

Responsibilities:

• Analyzed Business Requirements and segregated them into technical design documents.
• Developed Complex Queries, Stored Procedures, Functions and View using SQL Server. Worked on Performance issues of teh SQL Queries using execution plan and worked on data quality issues.
• Created SSIS ETL packages to data transfer from files to tables.
• Data Access Layer development using C#, Entity Framework, and LINQ to SQL.
• Created Business Entities using Class Library in C#. Created Web forms using ASP.Net.
• Prepared unit test cases and held peer review sessions. Performed unit testing of developed solutions.

Environment: SQL Server 2008 R2, SSIS, C#, Visual Studio 2010 with .NET Framework 4.0 .,Entity Framework 4.1, ASP.NET

Confidential

Consultant

Responsibilities:

• Facilitated meetings with IT managers from teh client side to manage site-specific development expectations and deliverables. Analyzed Business Requirements and segregated them into technical design documents. Used teh Agile methodology to manage a rapid development schedule.
• Created Stored Procedures, User defined functions and triggers in SQL Server 2008. Created and scheduled SQL Jobs using SQL Server Agent. Used BCP and SSIS ETL tool to transfer data from various sources to Staging, ODS and Data Warehouse. Worked on performance tuning of teh SQL queries and created indexes in SQL Server tables.
• Web form development using ASP.Net 4.0, and C#. Created Business Entities using Class Library in C#.

Environment: SQL Server 2008, T-SQL, SSIS, BIDS, ASP.NET, C#, Microsoft Visual Studio 2010 with .NET Framework 4.0, IIS 7, VSSData Warehousing, Agile Methodology.

Confidential

Responsibilities:

• Participated in teh complete SDLC of teh project. Used Agile methodology to manage a rapid development schedule.
• Designed, developed, tested, tuned, and implemented relational databases and procedural database code. Developed and maintained Complex SQL queries in Microsoft SQL Server. Created stored procedures, UDF and views using SQL Server. Used SSIS to transfer teh data from flat files, csv and xml files to SQL tables.
• Prepared test cases and tracked teh status of execution of test cases & held peer review sessions. Performed unit testing of developed solutions. Support to users during UAT phase.

Environment: SQL Server 2008, T-SQL, SSIS, BIDS, C#, IIS 7, VSS, N-Unit and Agile Methodology.

Confidential

Software Engineer

Responsibilities:

• Worked on multiple projects of NCR HRMS, Compliance and active directory as a developer. Also worked onsite, NCR headquarter in Dayton, OH, USA. Managed projects from end to end independently using SQL Server 2005/2008, T-SQL, Net 3.5, ASP.Net 3.5/2.0, C#, JavaScript, ASP.Net SVN, VB.Net, ASP 3.0, VB Script, Oracle 10g, PL/SQL, VSS 6.0 and TOAD

Confidential

Software Engineer

Responsibilities:

• Developed web applications for Pharmaceutical Companies of teh USA, US - Johnson & Johnson, Novartis and AstraZeneca using Classic ASP 3.0, VBscript, Javascript as front end and created Oracle packages, stored procedures, views and queries using Oracle 9i, PL/SQL, TOAD as backend.