SUMMARY

• Extensive experience in gathering User requirements and translating them into technical and system specifications. Managing clients, vendors and partner relationships for various business groups.
• Extensive experience as a solution architect for business intelligence systems focusing ondatabase architecture, data modeling, data analysis, and software design, programming and application integration.
• Assessed project feasibility, gathered business requirements, and executed project plans for various business groups.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools.
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow - flake modeling.
• Extensive experience in developing tools using Access, VBA, Excel environment.
• Microsoft Access experience including application architecture design, User forms, queries, and VBA code.
• Expertise is in data-centric web applications, predominantly working on the database and middle-tier, as well as the application architecture.
• Experience in handling the client calls for getting the requirements, Change requests and also the problems in the production environment as a single point of contact between the offshore and on-site team.
• Involved in taking the technical decision providing solutions to the team and reviewing the technical activities of the offshore team.
• Traditional and cloud storage experience with S3 and Azure Blob Storage.
• Good knowledge with Amazon Web services components S3, EC2, EBS, Data Pipeline, EMR, Redshift and Dynamo DB.
• Involved in the SOX migration, identified the financial related database objects, analyzed the impact on several applications, executed migration and recovery plan.
• Involved in the plan, design, and execution of export process of the 930 portals of the Confidential from webridge extranet environment and successfully exported all portals in 20 hours.
• Good knowledge of Hadoop architecture and core components including Kafka, Spark, MongoDB and Cassandra (developed POC on streaming analytics using spark RDD).
• Deep understanding of Linear Regression Method, Logistic Regression Method, Dimensionality Reduction methods such as PCA (Principal component Analysis),SVM (Support vector Machines) and Decision Tree.

TECHNICAL SKILLS

Cloud Technologies: Azure (Database, data warehouse, Data Lake, ML, Blob Storage), AWS (S3,EC2, EBS, Data Pipeline EMR, Dynamo DB, Redshift)

Transactional Databases: MS SQL Server 2000/2005/2008 R2/2012, Oracle 11g, MS SQL Server 2016 (Polybase and R integration)

BI Tools: Crystal Reports, SSIS, SSRS and SSAS (Tabular and Dimensional)SAP Data services 4.0. Power BI.

Programming Languages: Core Java, Advanced Java, C# 5.0, VB.net, JavaScript, VBA, T-SQL, PLSQL, R Programming, Python, DAX, M Query.

Web Tools: ASP.Net, JSP Servlets, ASP, Remote Scripting, and Web services, DHTML, Ajax, JSON, and JQuery.

Source Controls: VSS 6.0, TFS and SSDT

Portal Development: Webridge Extranet, Share Point 2007

App Tools: VS 2012/13/15, Visual Basic 6.0/ 5.0, Eclipse

Continuous Integration Tools: Jira, MPP(Microsoft Project Plan), Confluence, Jenkins

No SQL Databases: MongoDB and Cassandra

Big Data Ecosystems: Map Reduce, HDFS, HIVE, HBase, Kafka and Spark

PROFESSIONAL EXPERIENCE

ETL Architect & Power BI Developer

Confidential

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Designed database models including creation of tables, referential integrity, keys and constraints
• Documented ETL Designs, ETL Standards and Source to Target mapping
• Scheduled jobs weekly/daily basis to import data from various data sources like SQL server, Oracle, excel & delimited files.
• DevelopedPowerBImodel and reports for Risk Report, Project Tickets SLA.
• Designed and published DPP dashboard in Power BI.

Technologies: SQL Server 2012, SSIS, Excel VBA, Power BI, M query and DAX

ETL Developer

Confidential

Responsibilities:

• Designed and Developed log extraction through REST API.
• Designed and developed components to load integrated Jason files to target system.
• Configured EC2 and developed python components for API data extraction, Integration upload into S3
• Implemented incremental loading with date and time as incremental key.

Technologies: Linux Cent OS, Python, S3.

ETL Architect & Data Analyst

Confidential

Responsibilities:

• Analyze the requirements, understand the systems, source data models and design a new solution to centralize the data and channelize to external systems.
• Design the ETL structure and data profiling
• Design and develop strategies for use in high volume, high performance heterogeneous environment.
• Design the XML formats based on the STEP system requirements
• Validate the system and the generated XML with XSD schema at all integration points
• Designed and developed data services job for XML generation of the Package information and ingredient information
• Validated the optimized data collection and qualifying procedures to ensure that all the upstream and downstream data flow is accurate

Technologies: PL SQL, SAP Data services, SQL Developer, Oracle 11g, SSIS, SQL Server 2012, Kafka

Data Scientist & Application Architect

Confidential

Responsibilities:

• Evaluate various regression algorithms in R using historical and laboratory data.
• Trained and published experiments on Azure ML for Level 1 and Level 2 datasets.
• Build few Models in R and published in Azure ML.
• Developed the solution with ASP.Net and Azure ML API creating a service layer that links the optimizer page.

Technologies: Azure ML, SQL Server 2012, R Language, ASP.net, JavaScript and C# 5.0

Sr. Technical ETL & DW/BI Architect

Confidential

Responsibilities:

• Designed and developed asynchronous data migration tool on azure environment
• Involved in the designing of the complete solution design, architecture, tool and database design
• Customized the tool as per the business requirements, designed a new hybrid tool to accommodate the integration of the tools developed in .Net and SQL Azure technology
• Designed the Metadata driven ETL tool on SQL Azure where required business rules and mapping formulas can be stored as data instead of hard coded TSQL scripts.
• Designed and developed a temporary tool which allows developer to prepare metadata for ETL tool to makes developers job easy.
• Designed batch migration mechanism to process the large files because of limitation on data processing ability on Azure databases

Technologies: Microsoft Azure Database, Excel VBA, C# and JSON

Sr. Technical ETL & DW/BI Architect

Confidential

Responsibilities:

• Complete ownership on monthly releases for OL and MBD stream and successfully released more than 20 monthly releases.
• Understand, analyses and document the user requirements and technical design documentation with the solution provided
• Interpret data from multiple sources using statistical techniques and provide ongoing reports.
• Worked with inter-team members to complete special projects and achieve project deadlines.
• Redesigned and developed CISI data extraction process.
• Developed concurrent data extraction process from multiple servers.
• Redesigned MS Sales data processing module for CRMOL Sales cube.
• Analyzed and provided solution for the fixes as well as fixed few historical and rigid bugs in CRMOL sales cube.
• Implemented complex migration metrics for billing platform migrated customers.
• Owned the responsibility on UAT handover calls for complex issues.
• Delivered the high end solutions in short period of time.
• Used advanced Excel functions to generate spreadsheets and pivot tables.

Technologies: MSSQL 2008R2/12, MSBI (SSIS, SSRS, SSAS), TSQL, MDX and C#

Sr. Technical ETL & DW/BI Architect

Confidential

Responsibilities:

• Initially version of this system was developed with minimal resources and later it has been promoted and developed as large scale application with highly designed and scalable offer distributions. In proposal data migration and gap analysis was done by SA.
• Taken complete responsibility on data migration project of DOX System.
• Analyze the DOX1 and DOX2 database schemas.
• Designed the Data dictionaries and prepare the mappings between database schemas.
• Planned and executed data migration project in three iterations.
• Gap analysis between two product versions of DOX system.
• Understanding and translating business Requirements into functioning application components.
• Designed and developed the identified gap features in DOX2 system.
• Gathering the Requirements and developing the Enhancements in DOX2 system.
• Visited client location for requirement gathering.

Technologies: SQL Server 2005, Oracle 11g, SSIS, PLSQL, TSQL

Architect & Developer

Confidential

Responsibilities:

• Designed Entity structure for new components.
• Design high level view of components and Focus on scalability, maintainability and performance.
• Component development with Jscript.
• Design the XML schemas and designed the architecture of portal export process. Testing & Review
• Designed and developed portal export process in asynchronous bgtask threading.
• Visited client location for requirement gathering.

Technologies: Webridge Extranet, Jscript