PROFESSIONAL SUMMARY:

• Over 15+ years’ experience in software development, applications architect, business intelligence, data architect & visualization with a history of leading IT organizations to leverage technologies toward accomplishing strategic and tactical business objectives.
• Outstanding knowledge of business practices and procedures. Amazing ability to communicate with clients and management. My areas of strengths arebuilding teams from the ground up, understanding the business needs (versus the wants) andtransforming them into complete and concise requirements.
• Assists in the delivery of strategy assessments, POCs, and POVs as well as scoping services to our customers in the areas of AWS and Snowflake Data Warehouse solutions.
• Create and implement a solution roadmap and select the right infrastructure and technology platform or product based on in - depth knowledge of Azure & AWS and broad knowledge of other technologies.
• Ability to lead development of the technical solution or offering, in translating the business needs into technical requirements. Identifies gaps, strategic impacts, financial impacts and the risk profile in the technical solution or offering and provides technical support.
• Strong background in design, develop and deploy state-of-the-art, data-driven predictive/descriptive models to solve business problems using the latest and most appropriate technologies in statistical modeling and machine learning.
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses.
• Experience with AWS, Microsoft Azure big data services and Blockchain.
• Experience working with structured, semi-structured and unstructured data sets, determining the key takeaways or action items and communicating them pictorially.
• Working with external development team’s day to day, conveying vision, priorities and being available for questions and support.

TECHNICAL SKILLS:

Programming Languages: C#, Python, R, Spark

Databases: SQL Server, MongoDB, HBASE, Greenplum, Neo4j, Snowflake Data Warehouse.

AWS Stacks: EC2, EMR, Amazon Data Pipeline, S3, Redshift, Redshift Spectrum, Athena, Relational Database Service (RDS)

Azure Stacks: Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, Azure Stream Analytics, HDInsight, Power BI, Azure Machine Learning,Azure Cognitive Services, BOT.

BI & ETL Tools: - Informatica Cloud Services, Snaplogic, Matalian, SSRS, Business Object, Crystal Reports, SharePoint, SSIS, SSASBig Data: HDInsight, Cloudera Hadoop ecosystems, HDFS, Hive, Pig, Sqoop, Map Reduce and Impala, Pivotal HD.

Data Modeling: ER*Studio, Erwin

PROFESSIONAL EXPERIENCE:

Manager - Architect

Confidential

Responsibilities:

• Extensive experience designing and implementing large and complex Data Lakes, Data Warehouses and Analytics projects needs for a variety of Fortune 500 corporations and other major organizations.
• Work with sales/engagement practice team to develop & build value argumentation. Develop technical presentations & proposals & perform customer presentations.
• Manage and coordinate proof of concepts (POC’s). Develop POC plans with agreed use cases. Work with presales support teams to execute on the POC.
• Delivery or architecting solution experience around data on any of the major cloud platforms such as AWS, Azure Cloud and Snowflake Data Warehouse.
• Work in cross-disciplinary teams with pharma industry experts to understand their needs and ingest rich data sources such as social media, news, internal/external documents, emails financial data, and operational data
• Provides thought leadership on all aspects of the program in order to ensure successful delivery and process improvement within the organization.
• Experience developing and deploying large-scale data analytics solutions with AWS, Azure & Snowflake Data Warehouse.
• Multi Chanel Marketing (Data Lake & MMX model) - GSK, Takeda, Ipsen (Pharmaceutical company)
• Marketing data lake available to collect all personal and non-personal promotion data
• Marketing-Mix for all brands to inform investment decisions
• Triggers based on rules and engagement metrics
• Integration with Veeva to coordinate with personal promotion
• Migrate Teradata solution to Redshift - Merck (Pharmaceutical company) Medical Affairs Global Medical Affairs wants to build a global and scalable data repository for existing and upcoming reporting, BI and analytics requirements using AWS stacks and Informatica Cloud Services (ETL).
• Data Strategy and Data Governance consulting and implementation - Bayer Pharmaceutics company.
• Created Analytical Workbench for Data Processing

Environment: Azure - HDInsight, Azure Data Lake Gen1 & Gen2, Azure Databricks, Cosmos DB, Azure Data Warehouse Gen1 & Gen2, U-SQL, Azure Data Lake Analytics, Azure Data Factory (ELT), Cognitive Services, Azure ML, Power BI AWS - EC2, S3, Redshift, Redshift Spectrum, Athena, Relational Database Service (RDS), EMR (, Python, Hive, Spark, Snowflake Data Warehouse, Informatica Cloud Services (ETL).

Confidential, Des Moines IOWA

Solutions Architect

Responsibilities:

• Partners with various business stakeholders and technology leaders to translate program requirements into scalable technical solutions and system designs.
• Drive team to implement a modern data and analytics platform.
• Lead designing of all aspects of our data solution including artifact creation such as diagrams and other technical documents.
• Building a brand-new data warehouse in Azure SQL Data warehouse for Confidential Group.
• Involved in requirement gathering and Source System Analysis, Kimball Matrix to map dimensions and facts.
• Created Logical and Physical Dimensional Data Model.
• Defined Data Governance (DG) Policies, Standards and Best Practices
• Developed Source to Target attributes mappings specification, and Azure Data Factory (ADF) Strategy.
• Define a suitable architecture for data integration from multiple, disparate data sources.
• Created and managed tabular model using SSAS. Defined appropriate measure groups and KPIs & deployed cubes.

Environment: Azure SQL Data warehouse, Azure Data Factory, Power BI and Azure Analysis Services, Azure Data Catalog, Azure Data Lake.

Confidential

Solution Architect

Responsibilities:

• As a BI Architect, architect and develop solutions that facilitate advanced Business Intelligence, data analysis and visualizations techniques to team members ranging from Executives to Power-Users.Provide thought leadership in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, database design and implementation.
• Strong background in data mining, SQL, building reporting, and statistical modeling.
• Created ETL jobs to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Experience in development, coding, testing, evaluation and deployment in Data science models (classification, regression, recommendation systems, sentiment analysis, etc.) using Azure ML, R, and new tools and technologies in data science.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Designed and evaluated new data-mining techniques and algorithms for improving the relevance of search results. This ranged from basic statistical analysis and feature visualization in Power BI to larger experiments using sophisticated machine-learning tools and software, as well as processing on terabyte-sized data sets.
• Diagnose and solution technical issues including performance problems, data quality issues and reporting solution issues
• Develop rich, interactive graphics and data visualizations of "large" amounts of data that facilitate the presentation of data
• Generating a deep knowledge of existing data & tool capabilities across the BI suite and the organization and driving efficient solution design
• Translate business, and functional requirements into technical specifications including defining data collection and database schema requirements.
• Understanding the data nature from different OLTP and OLAP systems and designing the injection processes for HDFS. Working on Hadoop File formats Text InputFormat and KeyValueTextInputFormat.
• Work on technologies like Cloudera Hadoop Ecosystem, Sqoop, Spark, Hive, Java MapReduce, Flume, Storm, HAWQ, Unix scripting.
• Serve as the interface between IT projects and business units to ensure collaboration and coordination between all stakeholders.

Environment: Azure SQL Data warehouse, Azure Data Factory, Azure Data Lake,Power BI, SQL Server 2016, SSIS, SSRS, SSAS, .Net, HDInsight, Hive.

Confidential

Solution Architect

Responsibilities:

• As a Solution Architect captures business requirements and defines scope, creates designs and specifications, and determines the business effort in terms of duration and cost, and works with the client to define boundaries around other solution design in terms of scope and defining assumptions. And act as a central contact for the solution design, providing a single point of contact for clients, internal teams and third-party teams.
• Through broad collaboration, created data strategies; defined and guided the roadmap for the implementation of the data strategy; including data modeling, implementation and data management of data warehouse and data analytics systems.
• Defined the road map for migration to a services-oriented architecture and led services center of excellence. Key activities included defining: technology standards, services maturity model, life cycle model, architecture, and governance strategy.
• Designed Star Schema Data Warehouse with data from OLTP databases for Confidential Commercial Finance. Created MDX queries for use with cubes created using Analysis services.
• Expertise in Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, DataMart Design, Metadata, Data Quality, Master Data Management and Data Governance
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed and develop complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Proficient experience in understanding of Private and Hybrid Cloud and their impact on the enterprise architecture. Perform research and Proof-Of-Concept on new technologies in the cloud. Hands on experience in AZURE AD, ADFS, ACS, Single Sign On, Claim Based Identity and Service Bus queue and Topics.
• Architected/Designed & Implemented Asset/Property Management, Payment Processing, Disbursement, Collection Management, Escrow Calculator, Hazard and Flood insurance systems.
• Facilitate bank compliance system audits.

Environment: SQL Server 2008/2012, MongoDB, TFS, SSIS, SSRS, MDX, Citrix, SSIS packages & SSRS reports, Appworx (Batch Jobs Scheduler), TFS, Azure (Microsoft Cloud Computing Platform), HDInsight.

Confidential

Solution Architect/Project Lead

Responsibilities:

• Responsible for development, implementation, maintenance and managed of Confidential Real Estate applications.
• Provide in depth analysis of infrastructure and capacity planning for future projects and growth to render scalable and operable products and platform.
• Played a Key role in the entire SDLC of ATLAS project, design application architecture and data modeling. Gathered Requirements from Stakeholders. Worked with Business Analyst to convert business requirements into technical specifications. Wrote Use cases.
• Responsible for writing technical design document and in designing and documentation of application flows and developed functional diagrams using Visio.
• Responsible for drafting conceptual, logical and physical diagrams including data flows, develop capacity plan and threshold limits and work with other analysis, including configuration security and development personnel to ensure system development follows the planned architecture.
• Involved in writing the Sub-Queries, managed stored procedures, Joins, Views and Indexing to improve the performance of SQL Server 2000 and 2008.
• Extensively worked on Consuming, Calling, Transmitting and processing business component services.
• Performed project management and coordination of off-shore development team. Mentored off-shore staff in C# and the .NET Framework.
• Facilitate User Acceptance Testing (UAT) and production roll-outs, and the defects detected were tracked and managed using HP Quality Center and reported to development and management teams.
• Complete ownership to deploy the application in QA, UAT & Production environments on all servers (Application servers, Batch servers, Citrix Servers & IIS).
• Completed ownership to handle problem and incident tickets and to ensure their SLA compliance.
• Debugging and fixing the bugs and also very good with support and maintenance. Designated as first point of contact for business team. Providing 24*7 support to business on P1 case.

Environment: Citrix, ASP.NET, VB.NET, C#, COM+, SQL Server 2000 & 2008,DTS, SSIS packages & BO (Business Objects). Appworx, Starteam, Appworx, MRI

Confidential

Software Engineer

Responsibilities:

• Communicated with client on requirements gathering and worked on prototype design and Customizations.
• Design and Development of solution using VB 6.0, SQL SERVER 2000, COM,DTS, Crystal Report 8.0.
• Handled a small team and mentored team members with technical knowledge.
• Worked on debugging to identify issues and fix issues within stipulated delivery timeliness.
• Conducted peer code reviews, given the necessary review comments to produce clean code using best practices
• Designed and created database tables, views, stored procedures.
• Worked on test cases preparation, and necessary project documentations.
• Worked on packaging, planning and code deployment

Environment: VB6.0, SQL SERVER 2000, COM, DTS, Crystal Report 8.0 and Windows 2000.

Confidential

Sr. Programmer

Responsibilities:

• Designing, Coding and Testing

Environment: VB .NET, SQL SERVER 2000. Crystal Report

Confidential

Sr. Programmer

Responsibilities:

• Designing, Coding and Testing

Environment: VB 6.0, SQL SERVER 2000. DTS, Crystal Report