Ruchir Ansingkar

• Company Overview: Client-Total Energies France (EU)
• Lead and manage a cross-functional team of 20 members across 3 concurrent projects in the Oil & Gas domain, ensuring high-quality delivery within scope, budget, and timelines.
• Provide technical leadership leveraging skills in Microsoft Azure, GitHub, Azure Data Factory (ADF), Azure Functions, PySpark, Python, SQL, PostgreSQL, VS Code, and CI/CD pipelines.
• Drive the adoption of AI/ML models to optimize processes, which resulted in a 40% increase in project ROI by enhancing efficiency, accuracy, and data-driven decision-making.
• Utilize GitHub Co-pilot and automation to streamline development and reduce repetitive tasks, contributing to faster delivery and better code quality.
• Successfully optimized team structure, reducing headcount by 12 members while maintaining the same productivity and output, through automation, process improvements, and effective resource management.
• Coordinate with stakeholders, business users, and clients to align technical solutions with business objectives and industry standards.
• Establish project roadmaps, track milestones, mitigate risks, and ensure adherence to compliance and quality benchmarks.
• Mentor and guide team members to improve technical capabilities and encourage continuous learning in cloud, data, and AI technologies.
• Implement best practices in DevOps, CI/CD, and cloud-based architecture, ensuring scalability, reliability, and performance of solutions.
• Deliver innovative solutions that support digital transformation initiatives within the Oil & Gas sector.

• Define project scope, objectives, and deliverables in alignment with organizational goals.
• Develop detailed project plans, schedules, and resource allocation for multiple concurrent projects.
• Monitor project progress, track milestones, and ensure timely delivery within budget and quality standard.
• Lead and manage a team of 10 members across the projects, ensuring effective collaboration and productivity.
• Assign tasks, set priorities, and provide technical guidance to the team.
• Conduct regular team meetings, reviews, and performance feedback sessions.
• Mentor and support team members to enhance their technical and professional skills.

• Company Overview: Client-Capri Holding USA
• Worked with business analysts to gather and define project requirements.
• Deployed business logic frameworks for model implementation.
• Coordinated system installations, testing and code corrections.
• Supervised team of developers in analysis and creation of mappings.
• Defined technical integration strategy and developed integration plans.
• Migrated the data from on-prem to Azure services.
• Assessed code during testing stage to determine potential glitches and bugs.
• Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.

• Company Overview: Client-CRIF INDIA
• Working with clients to understand their needs and to agree the scope of each consulting project
• Conducting research, surveys and interviews and analyzing data to gain insights into the business & Analyzing statistics
• Assessing the pros and cons of possible strategies
• Exploring business problems and modelling different solutions
• Attending meetings and compiling and presenting information orally, visually and in writing to keep clients up to date on progress
• Making recommendations for improvement and presenting these to clients
• Implementing agreed solutions
• Developing and implementing new procedures or training to support the changes proposed.
• Small team Handing up to 4 members
• In my leadership, our team win the RFP proposal for Credit bureau client over 1 million.

• Company Overview: Clients -Michaels Stores & Tuesday Morning US
• Handing an analyst team of 10+ resources for design and development of BI reports and dashboards
• Created logical data models, recognize source tables and columns, to build BI Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Micro Strategy project
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes
• Experienced knowledge in different types of data modelling, like- star schema modelling, and snowflake modelling
• Conducted meetings to gather user/business requirements and carried out quality reviews with the Users and created documentation for the same
• Identify and modified source tables and columns in the warehouse required creating the Micro Strategy project
• Used Micro Strategy Desktop for creating various application objects

• Company Overview: Client -Cisco HRMS USA
• Participated in intra-organizational staff meetings to coalesce company-wide efforts around meeting prescribed business goals and addressing client concerns.
• Worked as part of project teams to coordinate database development and determine project scopes and limitations.
• Trained non-technical users and answered technical support questions.
• Developed and managed enterprise-wide data analytics environments.
• Exceeded customer satisfaction by finding creative solutions to problems.
• Created and implemented complex business intelligence solutions.

• Company Overview: Client -Morgan Stanley USA
• Involved in designing the Conceptual model of DB.
• Involved in creating the Aggregate tables considering both the Technical Feasibility and Business Feasibility to improve reports performance
• Used the concept of Partition Reference tables and built the reports with data from two databases
• Created lookup tables for the Customer Demographics data
• Designed the schema in Micro strategy Desktop based on the business requirements
• Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters
• Created Hierarchical prompts, nested prompts, object prompts
• Created customized Custom Groups with complex filters and Relationship filters

Cybage Software Pune, Maharashtra

Software Engineer

Client -Walmart USA

• Worked as a micro strategy analyst in a team of 32 for design and development of Micro Strategy report and dashboards
• Created logical data models, recognize source tables and columns, to build Micro strategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Micro Strategy project
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes
• Experienced knowledge in different types of data modeling, like- star schema modeling, and snowflake modeling
• Conducted meetings to gather user/business requirements and carried out quality reviews with the Users and created documentation for the same
• Identify and modified source tables and columns in the warehouse required creating the Micro Strategy project
• Used Micro Strategy Desktop for creating various application objects