Sridhar Rana Email & Phone Number

New York, Ny, Us

New Jersey, United States

Bridgewater, New Jersey, United States

• Contributed to the development of the Orchestrated Customer Engagement Optimizer (OCE) Optimizer • Developed and maintained various UI, report, and dashboard modules of OCE Optimizer leveraging Salesforce Sales cloud, Apex, LWC, AWS Services, Snowflake, and Google Looker report, Javascript, SOQL, SQL. • Handled large datasets, data lakes and provided features such as continuous alignment, optimization, engagement planning, field reviews, segmentation, targeting.• Led the end-to-end design efforts for data models and UI modules, automated processes, wrote test plans derived from functional requirements, such as smoke tests, automated tests, unit tests, and regression tests to ensure proper operation. • Designed and developed microservices, API architecture, authentication, security best practices, and governance framework.• Designed and developed analytical dashboard & operational reports using Google Looker and Snowflake DB providing drill-down analysis, capacity planning insights, team comparison, and KPIs to share with stakeholders.• Collaborated with cross-functional teams such as enterprise architecture, information security, infrastructure, product management, pre-sales, and quality assurance. • Partnered with delivery teams in the ETL process, data validation, performance monitoring, and tier 3 production support for the clients• Reviewed business requirements and advised on technical solutions. Translated business needs to technical specifications and provided input for solution development.• Documented work in Confluence and tracked and defined work within JIRA using Agile methodology.

Warren, Nj

• Developed processing-intensive recommendation engine using Spark SQL, Hadoop, Parquet, Scala, kafka, and splunk on Cloudera cluster. Developed analytical reports using PySpark. This provided a significant performance improvement, customer satisfaction and sales revenue. • Led the re-architecture of the product to Software-as-a-Service (SaaS) mode, significantly reducing implementation costs, increasing resource utilization, and significantly expanding client base to lower size companies resulting into increased sales revenue.

Bedminster, New Jersey, United States

• Led the development, implementation, maintenance, and release cadence of a Field Force Effectiveness application to its commercial success, generating $15+ millions per year - a widely adopted solution by many top 20 pharmaceutical companies across many nations.• Designed and developed flexible rule-based Realignment Engine using C#, SQL, PL/SQL and Oracle, responsible for dynamic alignment of customers to territory/Rep and to maintain call-on product list. Developed packages, procedures, functions and queries in Oracle. Responsible for oracle query optimization.• Designed Enterprise-wide Integration Solution connecting CRM, Warehouse, and 3rd-party apps using ETL Tools and SOA architecture. Used various tools such as TIBCO, Informatica, and in-house framework, in different point of time.• Led the end-to-end design efforts for data architecture, integration architecture, platform security and UI modules, automated processes, wrote test plans derived from functional requirements, such as smoke tests, automated tests, unit tests, and regression tests to ensure proper operation. Highly experienced in managing tier 3 production support for the clients. • Collaborated with cross-functional teams such as enterprise architect, information security, infrastructure, product management for maintaining feature backlog, feature prioritization, estimation, pre-sales, and quality assurance to meet business needs and exceed customer expectations.• Managed and mentored a team of software engineers in multiple countries fostering a culture of innovation within the team, encouraging continuous improvement and the adoption of emerging technologies.

Bedminster, New Jersey, United States

• Developed and maintained web applications using ASP.Net MVC, html, Javascript, jQuery, css, C# and .Net Framework.• Designed and developed an on-demand backend Engine for generic/configurable rule-based entity processing using C#, SQL, ASP.Net, PL/SQL and Oracle. This engine provided the basis for Service-Oriented Architecture (SOA) model and maintained all longitudinal.

Multiple Client Locations

Worked as a consultant for various clients such as South Texas Project Nuclear Operating Company (STPNOC) Texas, British Gas, P & O Containers Limited, and Lufthansa Airlines, in India, UK and USA.