Sayan Misra Email & Phone Number

Salt Lake City, Ut, Us

Atlanta, Georgia, Us

- Leading and managing multiple teams with team leads and engineers to deliver cutting-edge products for a SAAS based high throughput platform - Drive multiple bigger portfolio cross team projects in parallel to meet business needs within committed time frame- Hands on coding experience to unblock and assist team as and when needed- Collaborating with the team to develop and code cloud features aligned with business requirements- Regularly collaborated with executive leadership to establish priorities for engineering teams- Implemented a proven delivery execution model within the team, ensuring project requirements are met with high quality and within specified timeframes- Taking charge of design decisions and providing solution designs for project requirements- Actively involved in cross-team collaboration with product teams, machine learning teams, customer engagement managers, security, and other stakeholders.- Defining priorities based on resource availability, project criticality, solution design, scope, and business needs- Conducting code reviews with team members to maintain code quality- Participating in customer discussions to understand their needs and enhance service delivery

Salt Lake City, Utah, Us

Salt Lake City, Utah, Us

Tools/Languages - Hadoop Cluster (MapR/Cloudera), Python, Logstash, R, Ruby, Cassandra, NodeJS, JavaScript, Jade, Tomcat, Spring boot, Zookeeper, Kafka, Spark, Drill, Oozie, Hive, HBase/MapR-DB, MapR Streams, MongoD, Postgres, Streamsets, Simility• Leading a team to solve complex challenges related to real time fraud detection and information security• Performed migration work to move MapR Hadoop distribution related data integration jobs to Cloudera.• Involved in a project to collect logs (windows log, syslog) real time using logstash/kafka to load into Hadoop • Worked closely with enterprise architects in designing the next generation architecture for different applications across the organization• Using agile methodology, involved in task/story creations for the team to track progress using metrics and KPIs

Salt Lake City, Utah, Us

• Developed real time and batch ETL processes to ingest data from different external applications into Hadoop (/Hive) using Python, Ruby, Kafka, ETL tools• Maintained good health of production Hadoop cluster and all the necessary components installed within the cluster• Architect and built real time data ingestion process with different source applications to detect potential fraud in real time using data science• Analyzed large data sets to bring meaningful value and actionable insights• Involved in PoC to analyze the offerings of multiple cutting-edge technologies in big data world and understand its usability using cloud services like AWS and Azure• Maintained existing ETL workflows into Hadoop data lake and responsible for developing any new ETL workflow into lake• Managed Hadoop cluster (MapR) and all the services installed (Prod, DR, Dev)• Installed new cutting edge applications related to Hadoop eco-system into cluster and performed PoC

Mclean, Va, Us

Tools - TOAD Data Modeler, PLSQL, SAS, Tableau, AWS, SAP BO, SAP WebI, SAP Explorer• Created data mapping document as part of business requirement gathering process• Created data models in Toad Data Modeler to incorporate business logics• Developed ETL logics using PL/SQL stored procedure to feed data into a mart model from transactional source databases• Created BO universe on top of the developed data mart• Built tabular reports in WebI and interactive visualizations using SAP Explorer• Analyzed data present in multiple sources, staging areas and destinations to have meaningful insights and resolve data quality issues• Analyzed customer’s purchase data and created segmentations based on usage, price sensitivity using SAS. Use this segmentation to derive customer loyalty.• Designed dashboards and interactive visualizations in Tableau• Worked on Redshift columnar database to build cloud based data warehousing schema with improved performance and efficiency• Loaded data from operational databases to Amazon S3 to feed Redshift database

Mclean, Va, Us

Tools - Sqoop, Flume, Hive, Spark, Python, Scala• Imported large datasets from relational databases into HDFS and hive using Sqoop• Used Apache Flume to move large amount of streaming data into HDFS• Developed Python scripts to interact with spark shell using RDDs on local as well as on yarn mode to analyze large volume of data• Developed Python scripts to interact with spark shell using RDDs on local as well as on yarn mode to analyze large volume of data• Used HiveContext and SQLContext to query data stored in Hive/temporary tables and analyze datasets

Mclean, Va, Us

• Created data model in Microstrategy by connecting live oracle database using Microstrategy architect• Designed reports/dashboards by building attributes, facts, metrices, and filters from Microstrategy developer and web• Worked with 4 tier (web intelligence server), 3 tier (Intelligence server) and 2 tier architecture

Mclean, Va, Us

• Worked on administration and development of Salesforce CRM (SaaS)• Developed Apex triggers, test classes, visualforce pages• Configured SFDC environment as per needs• Created workflow rules, process builder and visual flows

Pune, Maharashtra, In

• Designed and developed a warehouse solution by extracting data from OLTP databases, transforming the extracted data as per business needs and loading the data in DWH (SSIS)• Analyzed requirements and planned the deliverables as per Agile methodology• Designed and developed ETL processes through PLSQL• Generated reports based on SQL queries• Designed data marts in 3NF by Entity-Relationship(ER) modeling• Designed dimensional modeling (Star & Snowflake schema)• Developed reports from data marts using Business Intelligence knowledge as per client requirements• Created highly tuned queries to optimize the performance• Designed Telecom Business Support System(BSS) solutions to support convergent billing

Pune, Maharashtra, In

• Led a team of 4 application developers to implement end-to-end development and upgrade narrowband applications in BT Infonet and BT Radianz that explored cost saving opportunities worth $3M• Troubleshoot production issues, provided solutions to business requirements• Designed relational transactional normalized database (BCNF) to support a newly launched LoB• Collected Raw usages (CDRs) from upstream network systems to Infonet mediation system in delimited file format, transformed the usages to understandable format for downstream (rating and billing), stored the usage details in Mediation database• Generated reports from the Mediation database using PLSQL procedures reflecting critical business processes• Analyzed the usage data to create a business intelligence dashboard to present to the business owners so that effective business decisions can be taken• Developed UNIX shell scripts and connected to Oracle database from Linux system to perform scheduled(/cronjobs) operations• Provided support to BAU billing operations for BT Radianz, mitigated complex billing problems, and engaged in month end billing operations• Designed and developed customized billing reports from Operational Data Store (ODS) to analyze business decisions• Developed customized solutions using Oracle BRM opcodes, C, Unix, Perl, PLSQL• Worked in Linux environment, configured XFB and FTP operations to enable automated file transfer mechanism, created user profiles, designed schedule tasks

Pune, Maharashtra, In

• Led a development project to construct a central data repository across various applications for reporting purpose using data warehousing concepts• Connected with business owners, understood requirements, prepared requirement analysis and low level design document• Prepared action strategies, researched requirements, and developed applications to improve BT retail services• Designed and developed the warehouse system, mapped source and destination columns to ensure correct data flow from OLTP systems to OLAP through ETL mechanism

Pune, Maharashtra, In

• Implemented multiple billing solutions in OBRM using op-codes in C, Unix, Perl, PLSQL procedures• Developed PLSQL procedures, functions, triggers to incorporate desired requirements• Designed and developed a cross-platform(iOS and Android) mobile application in Sencha using Model-View-Controller (MVC) framework• Enhanced telecom mediation system to capture new usages from upstream network, cleaned invalid or duplicate usages, transformed valid usages into understandable formats as per business requirements , load those usages into Mediation database, generated understandable usages for billing & rating, and transferred those usages to downstream systems

Master Of Science(Ms), Information Systems

Bachelor Of Engineering (B.E.)