SUMMARY

• Technical Lead, Architect who has successfully designed and developed commercial quality, enterprise software.
• More than 17 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems.
• Proficient in SQL Server\Oracle and T-SQL (DDL and DML) in constructing Tables, normalization techniques on database Tables.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Strong experience in database concepts using SQLServer, Hive, Redshift and Oracle.
• Proficient in OOD, .NET, Java, Framework Design, Web and Windows Development.
• Good knowledge of Hadoop ecosystems, HDFS, Big Data, AWS, Microsoft Parallel Dataware house Appliance, ETL and RDBMS.
• Experience in Cloud technologies using AWS, Lamda and Redshift
• Expertise in performance tuning of SQL Server(TSQL) and Oracle(PL\SQL), SQL queries, tables, indexes, functions etc.

TECHNICAL SKILLS

Technology: ASP.Net, VB.NET, C#, Spring, Java, ADO.NET, LINQ, ORACLE DBA

RDBMS/DBMS: Redshift, Hive, Oracle 8i/10g, SQL Server 7/2000/2005/2008/2012

Web Technologies: Angular, ASP.Net, HTML and DHTML, JAVA Script and VB Script.

Cloud Technologies: AWS, Lambda, Redshift, Data Pipeline

Conceptual: OOPS and XML

Tools: Cruise Control, Jenkins, JBPM, WebStorm

Reporting Tool: Crystal Reports 8/8.5, SQL Reporting Services, Actuate Reports

Source Controls: GIT, Source Tree, TFS, VSTS and Visual Source Safe

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

Senior Systems Analyst\ Team Lead

Responsibilities:

• Designing and programming web pages in the project using HTML and Angular 4.
• Design and create objects in Java using Spring Tool Suite (STS).
• Integrate with DB objects using Spring Hibernate.
• Create queries, functions, Stored procedures and Packages required by the application using PL/SQL in Oracle 12c.
• Working in Confidential integrated environment by integrating with other systems like ELMS.
• Create and modify workflow using Java Business Process Model (JBPM 6.5).
• Involved in Unit and Integration testing using complete flow of data from other systems.
• Involved in re-design, re-code, and analyzing existing code and logic.
• Review of the Code, Application and Database objects using Git and Source Tree.
• Manage Tasks using Jira.
• APWS code review and analyzing framework for Angular using Webstorm Editor.
• Analyzing workflows using JBPM.

Environment: Java 8, Spring, Hibernate, Angular, Tomcat, JBPM 6.5, Eclipse Oxygen, Oracle 12c, Toad, GIT, Jira, Source Tree, ORACLE DBA

Confidential, San Antonio. TX

Senior Database Engineer\ Team Lead

Responsibilities:

• Design and development of Enterprise Data warehouse (EDW) applications and Business Intelligence solutions.
• Building Highly performance and scalable applications on Microsoft Parallel Dataware house appliance.
• Designed and developed SSIS Packages to import and export data from Sharepoint, FTP SQL Server and Flat files.
• Working on Framework for EDW, improving, testing and releasing multiple versions of the same.
• Leveraging and evaluating new technologies, suggesting the same to the organization if fits any current needs.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Data teams Standards. Make sure all the deliverables following Data teams coding standards and Quality deliverables within the time.
• Execution of SQL jobs, Fine turning the systems, indexing data are some of activities to be mentioned.
• Meetings with Business Analysts, project managers and End Users for getting requirements and delivering the projects.
• Responsible for EDW Data Team’s deliverables and resolving any issues related to the same.
• Migration from relational RDBMS to AWS Redshift to provide continuous data to consumers.
• Create ETL process in Cloud to load data in Redshift datawarehouse.
• Upload files to S3 bucket and trigger Lambda functions to load the data.
• Manage instances using EC2 and users and roles using IAM.
• Integrate with Microsoft Dynamics AX using SSIS.

Environment: •Microsoft Parallel Dataware house, Salesforce.com, SSIS 2012, SSRS, Business Intelligence Studio, Visual Studio 2010, Visual Studio tools like VSTS and TFS, MS SharePoint, BIDS, Pragmatic works Taskfactory and BIExpress, C#, T-SQL, SQL, SOQL, JAMS, Spark, Sqoop, HDFS, AWS, S3, Lambda, Boomi, MS Dynamics AX

Confidential, Stamford, CT

Team Lead\Senior Software Engineer

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Worked on technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad - hoc analytic.
• Experience in creating OLAP cubes using SSAS.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Using Hadoop, Hive and Hive s analytical functions.
• Capturing data from existing databases that provide SQL interfaces using Sqoop.
• Load dataset into Hive for ETL (Extract, Transfer and Load) operation.
• Designing and programming various web pages\reports using C#.
• Optimizing database objects to improve the performance.

Environment: •ASP. Net, C#, SQL Server 2012, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), HTML, T-SQL, XML, Hadoop, Hive

Confidential, Dallas, TX

Team Lead\ Architect

Responsibilities:

• Design and Created architecture and framework of the project using multiple technologies.
• Handled team of 11 resources who are working in different modules.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Design web pages using HTML and Angular.
• Perform estimation, design, analysis and programming tasks.
• Review of the Code, Application and Database objects.
• Manage Users\Tasks configuration in TFS.

Environment: •ASP. Net 4.5, C#, SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), WCF, Unity 3D, MVC 3, HTML 5, CSS 3, Angular, T-SQL, Ajax Toolkit, XML, Win Forms, TFS

Confidential, Southborough, MA

Senior Software Programmer\ Team Lead

Responsibilities:

• Worked as a Release controller for both web and database that includes releasing Weekly\Monthly\Quarterly production patches, optimize the release process.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Designing and programming various web pages in the project using .NET 4.0, VS 2010, ASP. Net, C# and XML.
• Created in house tools using MVC 3.0 and Entity Framework.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Implementing Ajax Toolkit for VS 2008 for data driven web pages.
• Create queries, functions and Stored procedures required by the application using SQL.
• Implemented SOLID OOPS principals.

Environment: •ASP. Net, C#, SQL Server 2008, SSIS, SSRS, T-SQL, Ajax Toolkit, XML, Framework 4.0, HTML, TFS, Cruise Control, MVC 3.0, Resharper, Share point, WinForms

Confidential, Chicago, IL

Senior Application Programmer

Responsibilities:

• Involve in requirement analysis with business users. Provide optimal solution after feasibility study.
• Created Databases, Tables, Cluster/Non - Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Designing and programming various web pages in the project using .NET 3.5, VS 2008, ASP. Net, Vb.Net and XML.
• Generated custom and parameterized reports using SSRS. Created reports that call sub reports in SSRS
• Implementing Ajax Toolkit for VS 2008 for data driven web pages.
• Process large XML files using LINQ to XML.
• Designing of various reusable classes in the project using Vb.Net using Framework 3.5.
• Create reports in Crystal Reports and SQL Reporting Services.
• Create queries, functions and Stored procedures required by the application using SQL

Environment: •ASP. Net, Vb.Net, SQL Server 2008, T-SQL, Ajax Toolkit, XML, Framework 3.5, HTML, Microsoft Application Blocks, Enterprise Library, Visual Source Safe, LINQ and LINQ to XML, Crystal Reports, SQL Reporting Services (SSRS), SSIS

Confidential, Chicago, IL

Senior Application Programmer

Responsibilities:

• Created WCF Services to interact with client s database.
• Send email asynchronously to client after completion of process using MSMQ queue.
• Designing and programming various web parts, features, sites, list library, content types in the project using .NET 3.5, VS 2008, C#, XML.
• Implemented OOPS concept using Framework 3.5.
• Implementing Multithreading, Synchronous and Asynchronous processes.
• Using Microsoft Enterprise Library and Application Blocks e.g., Data Access, Caching, Authorization, Exception Management and Logging application blocks.
• Process large XML files using LINQ to XML.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Designing of various reusable classes in the project using C# using Framework 3.5.
• Development and Design of Front End Screens in C# and ASP.Net.
• Create reports in HTML and send them to queue in MSMQ.
• Create queries, functions and Stored procedures required by the application using PL/SQL in Oracle 8i.

Environment: • ASP.Net, C#, Oracle 10g, PL/SQL, Ajax, XML, Framework 3.5, MSMQ, TOAD, Intersoft Controls, WCF, Microsoft Application Blocks, QVCS, LINQ to XML, Telerik Controls