Alok Tiwari Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, United States

▸Addressing immediate business challenges by collaborating with a dedicated team of seven highly motivated professionals.▸Leveraged data-driven research expertise to devise a grassroots initiative aimed at expanding the business landscape in Mobile, Alabama.

Teach yoga part-time on the world's number one meditation application, 'Insight Timer'.Profile Link: https://insighttimer.com/alokmitus

Delhi, India

Taught yoga part-time at my institution, Patanjali Yog Foundation. You can book my premium yoga programs here: https://linktr.ee/alokmitus (currently paused).

Delhi, India

At Intellivision Education Pvt Ltd, we specialize in guiding students through the study visa process, with a focus on the US, UK, Europe, and Australia. Our expert team is dedicated to making your international education dreams a reality. With team members who have graduated from top 100 ranked colleges, we offer firsthand insights and exceptional support.

Gurgaon, India

His task was to implement technology in the business. In this role, he had to interact with the client (Massachusetts Mutual Life Insurance Company – U.S.) and understand their business requirements, obtain project deadlines and documentation, and explain the project requirements to the development, testing, and support teams. He coordinated with them and conducted regular follow-ups until the completion of the project. Additionally, his tasks included assigning daily tasks to the development and reporting teams and conducting follow-ups by the end of each day to ensure targets for that particular day were achieved. He set the delivery date of the project and ensured timely delivery.He also had to train juniors/freshers on the technology being used in the project and how to use these technologies to meet project demands. He set daily work deadlines, assigned work to juniors daily, and conducted follow-ups according to the final deadlines of the project.He is an Oracle-certified SQL Developer, Sun Certified Java Developer, Moreover, he is certified in Informatica and Unix, demonstrating excellence in his coding skills. In his daily tasks, he utilized Unix, PL/SQL, Informatica, Teradata, Oracle SQL database, Micro, and sometimes Maestro Scheduler. He wrote lengthy and complex codes in Unix, as well as in PL/SQL and Informatica.He also possessed a good understanding of databases, allowing him to write complex queries in SQL and Teradata, and to run and schedule batches using Maestro Scheduler. He wrote these codes in the development environment and tested them before moving them into the production environment.Additionally, he assisted other members of the technical team when they encountered technical difficulties. He often helped team members resolve their doubts, such as assisting with complex coding and writing intricate SQL queries.

Gurgaon, India

Cognizant Internal Project: DevelopmentTeam Size: 5Role: DeveloperTechnology: SQLTools: Informatica Powercenter 9.6.1Project Description:Created a centralized data repository and a data warehouse to enhance decision-making processes, sustain, promote, and increase sales, and to keep records updated on a monthly basis. The purpose of this project is to provide an overview of how the company will maintain its records. It includes the design document and briefing on information sources, cleansing scenarios to be followed, and the final target phase.Roles & Responsibilities:- Gathering and analyzing requirements.- Involvement in development and bug fixing.- Preparation of test cases and conducting unit tests on the application.

Gurgaon, India

Team Size: 7Role: DWH DeveloperDatabase: Oracle SQL DeveloperTechnology: SQLThe purpose of the project was to generate feed files for various downstream systems, which use these files to load and process the data in their systems. The source of data was a centralized data warehouse that stored data generated from various transactional systems.Roles & Responsibilities:- Involved in development and bug fixing.- Developed the ETL mapping according to the given requirements.- Utilized various tables to load the data into the source of the centralized data warehouse.- Created views for end users to abstract the complexity of the data.- Developed procedures in the database to handle queries within the database itself.- Demonstrated knowledge of procedures and functions in SQL.- Prepared test cases and performed unit tests on the application.

Gurgaon, India

Team Size: 12Role: PL/SQL DeveloperDatabase: SQL Server 2014Roles & Responsibilities:- Handling Service Now incidents for end users.- Creating ETL procedures to transform and upload data into sets of tables.- Working on triggers to invoke the transformation procedures.- Reviewing and understanding functional requirement specifications through interaction with onsite team members.- Understanding and designing requirements.- Preparing technical documents and unit test case documents for activities.- Involvement in query optimization and troubleshooting issues in the development environment.- Strict adherence to code development best practices.- Analyzing and resolving errors.- Responsible for creating and modifying database objects to meet changing business needs.

Gurgaon, India

CLIENT: Massachusetts Mutual Life Insurance CompanyProject: Massachusetts Mutual SID ImplementationThe Strategic Information Delivery (SID) project is part of Mass Mutual Retirement Services. The project’s goal is to develop a centralized repository, referred to as the Batch Information Factory (BIF). BIF will act as a single point of access for information maintained and analyzed by RS. This project includes Data Modeling & Data transformation required for building the Information factory along with Metadata Implementation and Automated Testing.Role: ETL / Informatica DeveloperTeam Size: 7Technologies: Informatica, Unix Scripting, PL-SQL, Teradata, MySQL, Oracle 10g, Basics of Core JavaTools: Informatica Power Centre, Teradata, Putty, Android Studio V 2.0, Eclipse, MySQL Workbench, Oracle SQL DeveloperResponsibilities:- Informatica Mapping Development- Unix Scripting (Bteq Query) for Automation in the Project- Performing Data Validation using Teradata- Data load, Unit testing, and Data validation- Maestro Job creation, deployment, and migration to different environments like IUT, ST, and Pre-prod- Fixing errors/exceptions occurring in the old Mapping Development- Addressing errors observed in production and related issues, including root cause analysis.

Gurgaon, India

He and his team worked painstakingly and came up with an innovative solution to one of the major problems faced by both customers and vendors. His team developed the "Shopster" app. In this app, customers can search for products using the category section (such as Clothes, Electronics, Games, Furniture), and the app displays a list of the nearest malls, shops, vendors, and stores in order of the discounts provided by these establishments (also providing ordering/filtering by distance).The app also showcases feedback and the quality of service provided by malls, shops, stores, and vendors based on ratings and feedback provided by previous customers. Additionally, the app features a special section displaying the best/special deals and discounts offered by the nearest establishments on a product for that particular day (Special/Super Deal of the Day) on its homepage every day.What made the app stand out from others in its category was its extreme benefit for both customers and vendors, covering both sides of the market. The app offered two login options:1) Customer Login: Allows customers to purchase items with the highest discounts, better service, and in the nearest location.2) Vendor Login (Shops, Stores, Malls): Enables vendors to sell their products quickly, significantly improve their service, and increase their revenue.The app was advantageous for both customers and vendors because:1) Customer Side: Customers could purchase items with the best discounts, better service, and in the nearest location.2) Vendor Side: Vendors (Stores, malls, shops) could sell their products online quickly, significantly improve their service based on feedback and ratings provided by customers on the app, and increase their sales and profit by enhancing the quality of service.

Allahabad Area, India

1. He was an active member of the robotics community at the college. Later on, he founded a company named “RoBotin” with his friends and started training fresher and junior students on robotics. Under this banner, he also reached out to schools (grades 10-12) and conducted training events at the school level.2. He conducted many robotics competitions such as Wild Soccer, Robo-War, and Robo-Race at our college, as well as in other schools. Additionally, he organized technical events such as robotics training, quizzes, and black screen coding competitions.3. He also participated in various robotics events at IIT-Delhi, IIT-Bombay, IIT-Kanpur, and MNIT Allahabad, winning numerous prizes.

Master'S Degree, Electrical Engineering

Activities and Societies: Engineers Without Borders- Illinois Tech Chapter Society for Environmental Engineers and Scientists- Public.

Master Of Science - Ms, Computer Science

Dropped the program due to Visa issue.

Bachelor Of Technology (B.Tech.), Electrical And Electronics Engineering, A

Activities and Societies: 1. He was a Microsoft Student Partner from college in his fourth year. 2. He founded a company named “RoBotin”.

High School, Math, Phsics, Chemistry., A+

Activities and Societies: Speeches, Debate team, Science Quizzes.-Scored 100 out of 100 marks in mathematics examinations 9 times between.