Nishan Sharma
Montgomery Village,MD
Summary
At GEICO, my leadership in data engineering has been pivotal, steering a team that revolutionized IOT/Telematics through Spark/Scala/Data Bricks/Azure functions, halving cost of ownership. My approach to team development is centered on fostering expertise in robust data warehouse construction and advancing ETL/ELT pipeline efficiency.
Experienced Technology Leader specializing in Data Engineering, Analytics, and Business Intelligence. Proven expertise in shaping strategic directions for Enterprise Data Management and driving successful execution. Proficient in bridging technology and business realms, translating requirements into actionable plans. Embracing a SAFe® 5 Agilist certification, I champion agile methodologies to bolster dynamic, high-quality delivery. Our collective efforts in data processing have strengthened GEICO's IOT/Telematics domain, reinforcing our market position and showcasing our commitment to innovation and resilience in technology infrastructure.
Overview
21
21
years of professional experience
Work History
Senior Software Engineering Manager
GEICO
02.2015 - Current
- Leading different subject areas and domains including Sales, Service, Claims ,Telematics verticals and provide technical insights mentorship to the teams
- Decreased Cost of ownership by 50% contributing to a net savings of over 1 million dollars per year
- Collaborate with Product, user experience, business groups, project management, and executive management teams throughout the project lifecycle
- Provided strategic direction and vision to the team to ingest various applications to the platform and improved team processes and improved productivity in the team
- Allied with other engineering leaders to plan, manage and coordinate teams around reaching prescribed development milestones.
- Successfully delivered business critical initiatives such as Telematics, PURE, PACE, CARMA, SCAI Giveback as well as support initiatives such as SVOC- unsold internet quotes, claims fraud initiatives on time and with quality
- Successfully completed the implementation of parallel data ingestion for all the prod pipeline data sources; with data flowing simultaneously to both Soft layer sites
- This protects us from datacenter failures
- During my leadership, successfully supported and moved applications to the cloud
- Led Data governance efforts and was able to successfully solidify a tool and process
- Automation and balance control for all SQL, oracle and flat file sources were completed
- Pipeline team has successfully started the journey for GEICO Data Encryption initiative by successfully implementing voltage
- Conducted interviews and were successfully able to hire engineering candidates both at IC and Manager levels on Data Engineering teams
- Created tasks, projects for data ingestion developers, scrum masters and analysts in MS Project
- Mentored trained analysts/developers on requirement gathering processes, coding practices, architecture etc and resolved impediments for teams
- Improved on call processes and improved productivity for the on-call ticket
- Provided mentoring and coaching for all associates and conducted regular 1:1
- Created checklist for requirements, added additional data points, reviewed requirements, mentored and helped associates on day to day aspects of the job pertaining to requirements, validation, data governance, ranger etc
- Enhanced workbook, playbook, firewall documentations and continuously worked with internal and external teams to provide status, trainings, design reviews, reconciliation activities
- Environments: Big Data, JIRA, Kafka, Camus, Spring-XD, HIVE, Oracle, Azure, Data bricks, Cosmos DB, Snowflake, Data Vault
Senior Data/Business Analyst
Horizon Technologies
08.2011 - 02.2015
- Company Overview: Horizon Technologies is a premier Silicon Valley-based staffing services firm that helps companies to implement their next generation technology strategy
- Leveraging deep industry & functional expertise, leading technology practices, and an advanced global delivery model, enable companies to unlock their business potential
- Below are some of my clients facing roles in various projects:
- American Family Insurance: Consultant-Lead Data/Business Analyst
- Consolidate and deliver data centric project artifacts including data profile findings, data quality requirements, business metadata (table/column)
- Identify Business rules to be used by the IDQ processes
- Work with business analysts to understand source data systems
- Documenting business and system requirements, processes, workflows and test plans
- Work closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution
- Assist with the creation of test cases, identify issues and report in JIRA
- Create issues, track bugs, and identify defects, link issues to the related source code monitor activity through JIRA
- Identify in scope and out scope attributes for the scope of the project
- Worked as a liaison between layman business users and developers to solve complex business problems
- Perform data profiling, data mapping, and data gap analysis activities
- Create and Maintain Data dictionary, Business requirement documents
- Produce systemic data profiling requirements and lead the data profiling analysis
- Compile data profile results and document for downstream use by the business data analysis and scenario calculation streams
- Horizon Technologies is a premier Silicon Valley-based staffing services firm that helps companies to implement their next generation technology strategy
- Leveraging deep industry & functional expertise, leading technology practices, and an advanced global delivery model, enable companies to unlock their business potential
- Environments: Oracle, IDQ, JIRA, BI, Data Warehouse, Excel, Data Analysis, Business Analysis, Policy Center, DB2, metacenter
Consultant -Data Analyst /ETL Designer
US Cellular
07.2013 - 06.2014
- Create DDL/DMl scripts as per necessary for various objects
- Primarily responsible for ETL design, coding and testing strategy
- Involved in data analysis using all tab columns, all tables etc
- Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router
- Analyzing the ETL code, data for defects and fixing the defects
- Track defects through clear quest promote code to different environments
- Build ETL solutions to extract and transform data
- Documenting business and system requirements, processes, workflows and test plans
- Develop ETL programs using Informatica
- Environments: Oracle, Informatica 9.1, IBM Rational Clear Quest, BI, Data Warehouse, Toad, build forge, TWS
Consultant -Data/ETL Developer Analyst
GOGO
02.2013 - 07.2013
- Collaborate with user experience, business groups, project management, and executive management teams throughout the project lifecycle (building a new Enterprise Data Warehouse)
- Perform Source System Data Profiling including structures, data and relationship discovery
- Create source to target mappings documents
- Perform data profiling, data mapping, and data gap analysis activities
- Create databases, tables, views, indexes, constraints, stored procedures and SSIS packages from technical and business requirements
- Ensure technical development meets timelines and communicates timely any delays
- Create SSIS packages ETL jobs for landing staging and EDW tables for both Type 1 and Type 2 tables
- Create Functional requirements documents, Specification requirements documents
- Perform Source System Data Profiling including structures, data and relationship discovery
- Assist Data Modeler with designing conceptual, logical and physical data models
- Consolidate and deliver data centric project artifacts including data profile findings, data quality requirements, business metadata (table/column)
- Identify Business rules to be used by the ETL processes
- Create Data structures
- Documenting business and system requirements, processes, workflows and test plans
- Develop and test extraction, transformation, and load (ETL) processes in a SQL Server environment
- Support or enhance the ETL processes to accommodate changes in source systems and new business user requirements
- Map source system data to data warehouse models
- Work with business analysts to understand source data systems
- Work closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution
- Assist with the creation of test cases, and participate in functional, load and performance testing
- Define and capture metadata and rules associated with ETL (SSIS) processes
- Create and adapt ETL processes for imports and exports to accommodate changes in source systems and new business requirements
- Create issues, track bugs, and identify defects, link issues to the related source code monitor activity through JIRA
- Environments: SQL Server, SQL Developer, JIRA, SSIS, BI, Data Warehouse, Razor SQL, My SQL, Oracle
Consultant -Data/Business Analyst
Secure Net
11.2012 - 02.2013
- Collaborate with user experience, business groups, project management, and executive management teams throughout the project lifecycle (building a new Enterprise Data Warehouse)
- Create Functional requirements documents, Specification requirements documents
- Perform Source System Data Profiling including structures, data and relationship discovery
- Assist Data Modeler with designing conceptual, logical and physical data models
- Consolidate and deliver data centric project artifacts including data profile findings, data quality requirements, business metadata (table/column)
- Create source to target mappings documents
- Identify Business rules to be used by the ETL processes
- Data analysis of source data
- Create Data structures
- Conduct JAD sessions with business SME's for identification of business requirements
- Identify project phases in scope out of scope depending upon criticality of the systems
- Document and complete detailed mapping specifications and rule definitions to support key data sourcing activities
- Create Test Plans and Test Cases
- Perform data profiling, data mapping, and data gap analysis activities
- Create and Maintain Data dictionary, Business requirement documents
- Produce systemic data profiling requirements and lead the data profiling analysis
- Compile data profile results and document for downstream use by the business data analysis and scenario calculation streams
- Create issues, track bugs, and identify defects, link issues to the related source code monitor activity through JIRA
- Administer the JIRA instances on a day to day basis
- Create JIRA workflows including project workflows, screen schemes, permission scheme and notification schemes in JIRA
- Writing Queries in Oracle to extract data and provide logical interpretation of the data
- Read data models, Interact with business users, developers and write adhoc SQL Queries
- Identify, analyze, define, and document detailed requirements to support projects and associated business objectives
- Collaborate with user experience, business groups, outsourced development team, project management, and executive management teams throughout the project lifecycle
- Environments: Oracle, SQL Developer, JIRA, Teradata, BI, Data Warehouse, DM Express, Financial Industry, JIRA, Planet Data Feeds
Consultant -Data/Business Analyst
GSI COMMERCE an EBAY company
08.2011 - 10.2012
- Lead Business/ Data and QA Analyst (ETL Tester) during various lifecycle of the project
- Create source to target mapping design documents, Source System Analysis through information requirements
- Create Functional requirements documents, Specification requirements document
- Create Test plans and Test cases in Zephyr etc
- Creating bugs, improvement related bugs in JIRA for tracking it
- Communicating with offshore and teaching them on how to perform End to End Testing for a complete data warehouse system
- Writing Queries in Netezza, SQL developer etc to extract data and provide logical interpretation of the data
- Create issues, track bugs, and identify defects, link issues to the related source code monitor activity through JIRA
- Create deliverables such as FRS, Functional Test protocols, UAT etc as per necessary in SDLC
- Read data models, Interact with business users, developers and write adhoc SQL and stored procedures
- Create XML’S, BI feeds, order xml, order event xml etc as a source to be stored in a target which is data warehouse
- Supervised a team of 4 team members and provide solutions in a timely manner both offshore and onshore
- Prepare documented reports for the usage of existing system and proposed new reports for efficient workflow
- Worked as a liaison between layman business users and developers to solve complex business problems
- Perform ETL End to end testing and component testing for reports within the organization
- Identify Gaps in the current ETL process and provide recommendations to developers
- Identify, analyze, define, and document detailed requirements to support projects and associated business objectives
- Collaborate with user experience, business groups, outsourced development team, project management, and executive management teams throughout the project lifecycle
- Solid experience conducting JAD sessions, Questionnaire, identifying requirements
- Use of Inner joins outer joins, unions, sub queries etc
- While creating queries in SQL
- Environments: Netezza, SQL Developer, Pentaho BI, Talend ETL, Sagent ETL, Ephiphany, Feeds, Enfinity, IBM/Sterling OMS system, Retail Industry
Data/Business Analyst
University of Baltimore
08.2009 - 08.2011
- Responsible for analyzing huge data sets with basic statistical methods, interprets results, and provides written summaries of data analysis
- Responsible for identifying, analyzing patterns of data, presenting to upper management for Strategic decisions
- Developed Various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie-charts etc
- Using Microsoft Excel
- Worked on People soft as an Agile System and CRM as a waterfall system
- Performed Sales analysis and projections (WHAT-IF Analysis, Goal Seek Analysis, and Forecasting) using, Access, Excel
- Performed Excel to Access Integration for various types of data transformation using Macros
- Testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica
- Create Meta Data Mappings between source and target systems
- Extraction, Transformation, Loading of data and analyzing data in the Talisma CRM System
- Analyzing clicks of potential customers, finding ROI and helped Senior Management take decisions on the next market segmentation
- Reducing Process and Data inefficiencies such as controlling redundancy with existing system through data profiling
- Use of SharePoint in Access and for campaign creation
- Debugging macro code and other visual basic errors in visual basic developer application
- Ability to develop variables and analytic approach in collaboration with project staff
- Ability to perform requested tasks with minimal direction
- Responsible for handling interactions of the Talisma CRM system
- Responsible for Creating Logic and Filters for Segmentation of the huge datasets and process them accordingly depending upon organization needs
- Prepared documented reports for the usage of existing systems and purposed new reports for efficient workflow
- Insures the integrity of Research Project Data, possibly including data extraction, Processing storage, Manipulation and Analysis
- Responsible for optimizing load and query performance
- Involved in troubleshoot data issues using SQL Server Query Analyzer, and Enterprise Manager Tools
- Create Custom Reports and Queries using Inner and Outer Joins
- Generated data models using basic concepts of ERWIN
- Use of Campaign Dashboards to analyze Clicks, Conversion, Cost per clicks and to provide ROI
- Monitor and track Campaigns Performance
- Performed Source system Analysis in a data Warehouse through information requirements
- Understand and articulate business requirements and then convert requirements into technical specifications Documents
- Responsible for WHAT-IF Analysis, Goal Seek Analysis, and Forecasting using SQL Server 2008 Analysis Service
- Perform QA from business point of view, test cases, and scenarios in different stages such as test, QA and production environment in PeopleSoft Oracle
- Gathering data from different sources for ETL purposes and Reporting
- Analyzing requirements and then grouping the requirements whether they are clear, incomplete or contradictory and then resolving these issues
- Involved in development of data requirements, data definitions and specifications for data collection procedures
- Responsible for Data Cleansing, Data Collection, Trimming, Concatenation, transforming, data validation of data for Comparison and Loading purposes
- Responsible for creating Data Mappings for the load of External Data
- Responsible for analyzing clicks by segmented groups and then preparing Reports for calculation of ROI
- Performed Impact Analysis on purchasing new software, Purchase decisions regarding to maximize organizational goals
- Designing and Writing Queries in People Soft, SQL, ProClarity to support day to day Business Operations
- Stream lining existing processes and improve data performance
- Environment: SQL Server, People soft Oracle 9.1, Informatica 7.1.1, ERWIN, MS Access and MS Excel
IT Officer
Com 2 Engineering and Associates
09.2006 - 07.2007
- Supervising the Management Information systems personnel
- Gathered business requirements, implemented business processes, identified risks, impact analysis, and Sequence and activity diagrams
- Responsible for developing, implementing, Company's Plan and development of IT Strategic Plan
- Responsible for network security and analysis
- Managed the Computer Operations department
- Responsible for presenting the IT strategic plan to the senior management
- Performed Sales analysis and projections (WHAT-IF Analysis, Goal Seek Analysis, and Forecasting) using, Access, Excel
- Conduct analysis of alternatives and provide recommendations for support issue resolution
- Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs
- Reducing Process and Data inefficiencies such as controlling redundancy with existing system through data profiling
- Performed Source system Analysis in a data Warehouse through information requirements
- Stream Lining existing processes and improve data performance
- Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project
- Performed Sales analysis and projections using Access and Excel
- Involved in analysis and cleansing of data
- Designed and developed Crystal Reports
- Wrote SQL and PL/SQL and stored them in Crystal Query and attached them to the Crystal Reports using the Proper ODBC connections
- Involved in development of data requirements, data definitions and specifications for data collection procedures
- Worked as a Liaison between users and Information technology professionals to solve complex problems
- Environment: Crystal Reports, Visual Basic 6.1, SQL, CRM, SQL Server Developer, SQL Server 2005, SSMS, Visual Studio, Business Intelligence tools, ER-WIN, MS Office 2007(Access, Excel, Visio), SQL
Software Developer
Applied Software Systems
07.2004 - 08.2006
- Eliciting requirements of the client systems
- Analyzing requirements and then grouping the requirements whether they are clear, incomplete or contradictory and then resolving these issues
- Creating manuals for the software to be used from a Layman Perspective
- Suggest design Layouts for the Implementation of the projects
- Providing reporting analytical thinking, process improvements, problem solving, time management, decision making and issue resolution
- Developed ER diagram, Flow Charts using tools like Smart Draw and MS Visio
- Gathered business requirements, implemented business processes, identified risks, impact analysis, and sequence and activity diagrams
- Generates queries by using SQL Operators and data manipulations
- Executed SQL queries to validate data in Oracle and SQL Server 2005
- Involved in gathering end user requirements, User/System documentation, user training and testing developed reports for final deployment
- Responsible to collate appropriate data for use in databases and conduct related research
- Generated reports using IT/database systems and assist in their analysis
- Excellent use of graphs and charts with named groups and formula fields
- Designed and developed Crystal Reports
- Responsibilities included imparting training to the end-users and doing the knowledge transfer for reporting needs
- Environment: SQL Server 2000, MS Excel
Education
Master’s in Business Administration - MBA (IT)
Bachelor’s in Information Technology - undefined
MBA - Information And Communication Technology
Towson University
Baltimore, MDBachelor of Science - Engineering
College of Information Technology And Engineering
Kathmandu NepalSkills
- Data Leader
- Data Pipelines
- ETL/ELT processes
- Azure Stack
- Spark/Scala/Kafka
- Event hubs/ASB
- Data Bricks
- People Skills
- Decrease Cost of ownership
- Product management
- Software architecture
- Big data technologies
- Technical leadership
Timeline
Senior Software Engineering Manager
GEICO
02.2015 - Current
Consultant -Data Analyst /ETL Designer
US Cellular
07.2013 - 06.2014
Consultant -Data/ETL Developer Analyst
GOGO
02.2013 - 07.2013
Consultant -Data/Business Analyst
Secure Net
11.2012 - 02.2013
Senior Data/Business Analyst
Horizon Technologies
08.2011 - 02.2015
Consultant -Data/Business Analyst
GSI COMMERCE an EBAY company
08.2011 - 10.2012
Data/Business Analyst
University of Baltimore
08.2009 - 08.2011
IT Officer
Com 2 Engineering and Associates
09.2006 - 07.2007
Software Developer
Applied Software Systems
07.2004 - 08.2006
Bachelor’s in Information Technology - undefined
Master’s in Business Administration - MBA (IT)
MBA - Information And Communication Technology
Towson University
Bachelor of Science - Engineering
College of Information Technology And Engineering
Similar Profiles
Derwin Dhas GDerwin Dhas G
Senior Engineer at GeicoSenior Engineer at Geico
Oona MooreOona Moore
Insurance Claims Representative at GEICOInsurance Claims Representative at GEICO
John DavilaJohn Davila
License Claims Specialist at GEICOLicense Claims Specialist at GEICO