Amit Kumar
IT Professional
New Delhi
Summary
Dedicated and seasoned data professional with 5 years of hands-on experience in SQL, SSIS, SSRS and Power BI. Seeking a challenging role where can leverage expertise in designing and implementing robust ETL processes, optimizing data workflows, and creating insightful Power BI visualizations. Aiming to contribute technical proficiency, strategic thinking, and collaborative skills to drive data-driven decision-making and enhance overall business performance.
Overview
6
6
years of professional experience
Work History
Programmer Analyst
SCI-BI Pvt Ltd
5 2022 - Current
- Lead the design and implementation of robust ETL processes, optimizing data extraction, transformation, and loading for improved efficiency
- Developed and maintained complex SQL queries and stored procedures to extract, manipulate, and analyze large datasets
- Created and managed Power BI dashboards, providing actionable insights to key stakeholders and facilitating data-driven decision-making.
- Developed and maintained a wide range of SSRS reports to meet diverse business requirements, including operational, analytical, and executive dashboards.
- Utilized advanced SSRS features such as interactive sorting, drill-down functionality, and parameterized reports to enhance report interactivity.
- Strong analytical skills with the ability to transform raw data into actionable insights
- Expertise in creating interactive and visually appealing reports and dashboards using Power BI
- Expertise in writing T-SQL queries, Dynamic Queries, sub-queries and Joins for generating SPs, Views, Triggers
- Experience in Importing/Exporting data between different Sources like Oracle/Access/Excel etc
- Using SSIS Utility
- Familiarity with data modeling, DAX (Data Analysis Expressions)
- Windows Server monitoring and troubleshooting to keep the Application up and running.
Programmer Analyst
Majorel India Pvt Ltd
05.2018 - 05.2022
- Conducted performance tuning on SQL queries and optimized database structures for improved responsiveness
- Collaborated with data architects and business analysts to gather and define requirements, translating them into scalable and efficient ETL processes
- Designed and maintained data models in Power BI, creating visually engaging reports and dashboards to enable data-driven decision-making
- Developed SSIS packages for data integration to report server database
- Developed and scheduled automated data refresh processes in Power BI Service, ensuring up-to-date reporting for end-users
- Developed SSIS packages for data integration to report server database
- Backup and restoring databases from production to lower test and dev environments
- Troubleshooting errors in SSIS package jobs for smooth data loads
- Suggest changes in process that can help to improve performance efficiency Integrated data from various sources excel, flat file, other SQL servers Created full and incremental loads for reporting database from Application database
- Collaborating with various teams for in time resolution of issues.
- Championed culture of continuous learning within team, driving adoption of new development methodologies that yielded improvements in workflow processes
- Developed scalable solutions to accommodate evolving business needs while maintaining high levels of performance and stability
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications
Education
Master’s in Business Applications -
Swami Vivekanand Subharti University
Bachelor’s in Arts. -
VMS University
CBSE Board-12th -
CBSE Board-12th New Delhi
New DelhiCBSE Board-10th -
CBSE Board-10th, New Delhi
New DelhiSkills
SQL
undefinedSummary Of Qualification
- 5 years of experience in SQL, SSIS development and Power BI/SSRS.
- Good Hands-on SQL, SSIS and SSRS.
- Excellent communication and presentation skills to emphasize the important aspects.
- Ability to plan contingency steps to resolve issues with good people management skills.
- Good knowledge of Microsoft SQL server and SQL Integration services and automation of the reports.
Timeline
Programmer Analyst
Majorel India Pvt Ltd
05.2018 - 05.2022
Programmer Analyst
SCI-BI Pvt Ltd
5 2022 - Current
Master’s in Business Applications -
Swami Vivekanand Subharti University
Bachelor’s in Arts. -
VMS University
CBSE Board-12th -
CBSE Board-12th New Delhi
CBSE Board-10th -
CBSE Board-10th, New Delhi
Similar Profiles
Pramodh Kumar. PPramodh Kumar. P
Assistant Manager- Client Servicing at BI Worldwide India Pvt LtdAssistant Manager- Client Servicing at BI Worldwide India Pvt Ltd
Arpan BiswasArpan Biswas
Data Engineer at Visual BI Solutions Pvt. Ltd., An ATOS CompanyData Engineer at Visual BI Solutions Pvt. Ltd., An ATOS Company
Lakshmanan VLakshmanan V
Director - Participant Experience at BI Worldwide India Pvt LtdDirector - Participant Experience at BI Worldwide India Pvt Ltd
Manav SaxenaManav Saxena
Technical Lead at Digicommerce Solution LLPTechnical Lead at Digicommerce Solution LLP
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited