Experience

People Strong Hr Services Private Limited

• India
• Consumer Services
• 1 - 100 Employee

• Data & Analytics - Engineering Manager

  • Oct 2015 - Present

  Big Data Ecosystems: AWS EMR, Apache Kylin, Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop,,Oozie, Flume and TalendBI Data System: Apache Kylin, SSAS, SSIS, SSRS, Cubes and DWHReporting Tool: SSRS, Cube Dashboard, Power BI, TableauData ingestion: Sqoop, kafka, Spark Streaming and SSIS ETL Design, TalendProgramming Languages: PySpark, PythonScripting Languages: PythonDatabases: NoSQL and SQLTools: Eclipse, MS Visual Studio, TFS, PyCharm, IDLEPlatforms: Windows, Linux, Solaris, AIX, HPUXMethodologies: Agile, UML, Design Patterns



iYogi

• United States
• IT Services and IT Consulting
• 400 - 500 Employee

• Senior Software Engineer

  • Mar 2010 - Oct 2015

  • This Project contains more than 500 reports and Dashboard, KPI’s. For the requirement we used SQL server 2008 R2 with SSRS, SSIS.• My scope of working consists of; understanding the requirement of Client’s. Writing stored procedure for fetching data, designing reports with SSRS, deploying reports. Maintaining security strategy as per hierarchical responsibility levels. The module has a base of 250 reports to track the information for Accounting, Finance, Human Resources, Marketing, and MIS. • Creating Graphs like Column, Pie, Line, Shape, Bar, Area etc. using SQL.• SSAS Data Mining to explore the data and Analytics to know the types of customers and business relevant metrics • Worked on various SSIS packages for processing cubes and simple DTS packages.• Knowledge of maintaining the BI Report Server like Report’s access, subscription.Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.• Handled Performance Tuning and Optimization in T-SQL, SSIS, SSRS, SSAS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.• Created reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down, Drill Through reports as well as interactive reports according to business requirements in time restricted environment.



ADMA SOLUTIONS PRIVATE LIMITED

• India
• 1 - 100 Employee

• Data Management Team Lead

  • Oct 2008 - Mar 2010

  • Primarily responsible for managing the team in order to achieve targets on a day-to-day basis and for demonstrating subject-matter expertise and serves as Analyst backup. Handling a team of 30 associates.• Responsible for the production, performance, attendance and motivation of the associates. Review daily key operational variables.• Update Manager on process performance and critical people issues• Hold regular team meetings with Team Members to ensure that there is constant flow of information and knowledge dissemination.• Making & analyst the Daily & Monthly MIS for the better performance. (Like,Team Productivity reports (TPR) bases on Resolution of Collections, Production Deliverable reports (PDR), Process performance report (PPR), Maintend the Audit & Complience report (Quality) etc.)• Spool the raw data of “Agent Performance Report (APR)” on daily basis & manual calculation of Productive Hours “Average Handling Time (AHT)”, “Wrap time”, “Idle Time/Avail Time”, “Hold Time”, “Preview Time”, “Login Hours”, “Average Login Hours”, “Head Count”, “Shrinkage”.• Make Deliverables MIS Report (DMR) which is based on Agent wise & Conversion of deliverables