Sameer Kulkarni Email & Phone Number

Maineville, OH, US

Jacksonville, FL, US

• Provided guidance and leadership to direct reports, sr. data engineers and architects. Ensured clarity around priorities and goals for the functional area.
• Proposed, Architect and designed, coded complete Realtime and batch data piplines to address complex business needs in big data(On-Prem) and AWS-Snowflake cloud technologies.
• Provided leadership and vision around leveraging Big Data technology and AWS Cloud technology to develop next-gen data driven solutions. Worked across functions with peers in other groups to ensure collaboration for.
• Created solution architecture, design documentation and diagrams collaborate within, and across teams to create the efficient, effective, and scalable data solution to leverage cloud and big data architecture and.
• Defined solution roadmap, plan capacity and resources needed to execute and lead the development and delivery of wide range of enterprise data domains and data products.
• Led complex problem solving in the subject area of financial analytics and reconciliation data applications.

Jacksonville, FL, US

• Attended requirement-gathering session with business units to understand their new business requirements and pain points of existing online analytical system.
• Analyzed the various data sources and requirement documents and provided detailed solution architecture document, which included the UI design document, Spark ETL design document.
• Developed Metadata driven automation shell scripts and Distcp to load data from Hadoop On prem system to AWS S3 bucket.
• Developed metadata driven batch processing ingestion pipeline to ingest data from AWS S3 buckets to Snowflake tables using External tables->Stream->Task.
• Managed the Snowflake environment and warehouses to make sure the compute cost in Minimum.
• Helped other team to optimized the queries and warehouses to reduce the snowflake compute cost.

Mclean, VA, US

• Clients: FIS aka Vantiv Inc aka Worldpay Inc | Allegis Group | Lexmark International | Tempur-Pedic | Dana Inc | Thrivent FinancialResponsibilities:
• Attended requirement-gathering session with Vantiv business units to understand their new business requirements and pain points of existing online analytical system.
• Analyzed the various data sources and requirement documents and provided detailed solution architecture document, which included the UI design document, Spark ETL design document.
• Designed and developed new web user interface using the Web focus Maintain application. The application provided a web interface for the Vantiv users for Card Campaign management process.
• Developed Metadata driven automation scala scripts to call sqoop jobs/spark code to load data from DB2, Oracle Exadata, SQL Server to HDFS/Hive partitioned tables.
• Developed pyspark and Scala scripts to read data from raw zone transform it and load into hive/HDFS.

Round Rock, Texas, US

• Create and deliver Proof of Concepts (POC) based on the Quick Start Data Warehouse a Dell Data Warehousing appliance.
• Analyze client’s Data warehouse or Data marts and BI environment and then provide inputs with respect to how the data can be stored or loaded on QSDW in order to decrease the fragmentation and in turn increase the.
• QSDW is based on the Microsoft’s Fast Track DW Reference architecture. Self-trained on SSIS.

• Worked on 8 different projects developing 6 OLTP Database, 8 data marts, Designing, developing and testing of ETL jobs specific 8 data marts, 8 universes, 40+ reports used in different parts of the operations team at.
• Co-ordinate development, testing effort with offshore team and production deployment.
• Developed OLTP databases. Used Data Modeling to build reporting data marts.
• Used Datastage to move data from OLTP system to Reporting Datamarts.
• Designing and implementing a complex parallel and server jobs also implemented SCD logic.
• Developed a Business objects universe using custom hierarchies, Solved Join Path problems like loops, Fan Traps and Chasm Traps using alias and Contexts, Used Aggregate awareness and Index awareness for performance.

Pune, Maharashtra, IN

• Involved in Installation and Configuration of Business Objects XIR2, XIR3, Oracle 9i/10g/11i, SQL Server 2005, My SQL. Used Import wizard to migrate date from XIR2 to XIR3 and from 6.5 to XIR2
• Developed, maintained and tested the Universes for running the queries against the Database like Oracle, SQL Server 2005, My SQL, Sybase, MS Access, MS Excel.
• Created Linked universes using multiple data providers like, Oracle, SQL server 2005, My SQL, Sybase, Freehand SQL and Stored Procedure.
• Have made use of Aliases and Context to resolve looping issues, checked integrity of universes and made use of aggregate awareness for tuning the performance of the universes.
• Have worked on Objects level, Row level security.
• Have worked with CMC. Created Users and Groups and applied User level, Group Level security also worked with scheduling the reports. Worked on taking Repository backup, restoring from backup.

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Engineering