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.

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.
• 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

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

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
• 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)

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.
• 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

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.

Master Of Science(Ms), Information Systems

Bachelor Of Engineering (B.E.)