Tania Mondal
Kolkata
Summary
Results-driven Power BI & SQL Developer with expertise in data analysis and query optimization. Proven track record in team leadership and delivering impactful reports and dashboards.
Overview
12
12
years of professional experience
Work History
Power-BI & SQL Developer, Team Leader
Cognizant Technology Solutions
09.2020 - Current
- Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
- Created Dax Queries to generate computed columns & measures in Power BI.
- Designing current database by adding tables, relationships, creating stored procedure, views and performance tuning of SQL queries and stored procedures.
- Involved in creating new stored procedures and optimizing existing queries and stored procedures.
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
- Explore data in a variety of ways and across multiple visualizations using Power BI.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- I have done various POC and provided solutions based on the requirement.
- I have done the performance analysis based on direct query mode or dual mode and suggested my team to take the appropriate approach accordingly.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
Sr.Associate Projects
Cognizant Technology Solutions
Kolkata
06.2013 - Current
SQL & SSIS Developer, Team Leader
Cognizant Technology Solutions
08.2015 - 08.2020
- Coordinating with Client directly and with onsite coordinator.
- As a part of new requirement, prepared stored procedure, views, functions and SSIS packages.
- Performed Unit testing of the developed items which served as the deliverables.
- Prepared unit testcase document.
- Deploy SSIS packages, stored procedure, function, views in DEV and SYSTEST environment through TeamCity.
SQL Server Developer
Cognizant Technology Solutions
01.2015 - 07.2015
- Coordinating with onsite team and understand change requests or issues.
- Understanding business and job functionalities of the systems.
- As a part of migration activities, prepared Views, Stored Procedures & Functions.
- Migrate the data from old table structure into new table structure.
- Performed Unit testing of the developed stored procedures which served as the deliverables.
- Coordinate with different vendors and teams and complete task or fix bug within given time frame.
- Prepared migration documents.
Oracle script writer
Cognizant Technology Solutions
10.2014 - 12.2014
- Involved in Requirement Analysis and found ambiguities.
- Provided suggestions for improved requirements.
- Involved in effort estimation of enhancements and bugs.
- Created different business objects like Stored Procedures & Functions.
- Worked on Query Optimization.
- Involved in analyzing issues, determining root-causes and developing fixes to prevent reoccurrence.
- Directly interacted with client for regular updates and requirement discussions.
CW SFDC Data Analyst
Cognizant Technology Solutions
08.2014 - 09.2014
- Data management, analysis and manipulation.
- Ability to move large quantities of data into of Salesforce by using Apex Data Loader.
- Manage the quality of the data within the database by recommending appropriate workflow and performing data cleansing, merging, de-duplication activities.
- Audit, uncover and resolve data integrity issues.
- Develop reports, dashboards, and processes to support business operations.
SSIS Developer
Cognizant Technology Solutions
02.2014 - 07.2014
- Coordinating with Client directly.
- Understanding requirements of different Business Reports.
- Defining Views, Stored Procedures & Functions.
- Creating SSIS packages & load data into tables through SSIS packages & validates the data.
SQL Server Developer
Cognizant Technology Solutions
10.2013 - 01.2014
- Developed TSQL queries (which involves transformations) to migrate the data.
- Prepared referential test environment.
- Developed change tracking query to track the DML for a particular table for a particular database and also to track the data model changes.
- Prepared unit test cases.
- Handling business related issues.
- Ensuring quality delivery.
- Performed Unit testing of the upgraded/developed jobs and packages which served as the deliverables.
Education
BACHELOR DEGREE - Electronics & Communication Engineering
Future Institute of Engineering & Management
01.2012
HIGHER SECONDARY -
Labanhrad Vidyapith School
01.2008
SECONDARY -
Christ Church Secondary School
01.2006
Skills
- Windows XP
- Windows 7
- Windows 8
- T-SQL
- Stored Procedures
- Functions
- Views
- Triggers
- MSBI
- Power BI
- SSIS
- SSRS
- Query Optimization
- Database Designing
- Indexing
- Database Maintenance
- Database Migration
- SQL Server
- SQL Server 2005
- SQL Server 2008
- SQL Server 2008 R2
- SQL Server 2012
Personal Information
- Date of Birth: 10/30/90
- Nationality: Indian
- Marital Status: Married
- Religion: Hindu
Languages
- English
- Hindi
- Bengali
Hobbies and Interests
- Teaching
- Listening Music
- Cooking
Passport Holder
True
Mobile Numbers
- 09007521971
- 06290907556
Timeline
Power-BI & SQL Developer, Team Leader
Cognizant Technology Solutions
09.2020 - Current
SQL & SSIS Developer, Team Leader
Cognizant Technology Solutions
08.2015 - 08.2020
SQL Server Developer
Cognizant Technology Solutions
01.2015 - 07.2015
Oracle script writer
Cognizant Technology Solutions
10.2014 - 12.2014
CW SFDC Data Analyst
Cognizant Technology Solutions
08.2014 - 09.2014
SSIS Developer
Cognizant Technology Solutions
02.2014 - 07.2014
SQL Server Developer
Cognizant Technology Solutions
10.2013 - 01.2014
Sr.Associate Projects
Cognizant Technology Solutions
06.2013 - Current
BACHELOR DEGREE - Electronics & Communication Engineering
Future Institute of Engineering & Management
HIGHER SECONDARY -
Labanhrad Vidyapith School
SECONDARY -
Christ Church Secondary School
Similar Profiles
Janardhanan PerumalsamyJanardhanan Perumalsamy
Sr. Executive Support at Cognizant technology Solutions, Cognizant Technology SolutionsSr. Executive Support at Cognizant technology Solutions, Cognizant Technology Solutions
DIKSHA GUPTADIKSHA GUPTA
Software Engineer at Cognizant Technology Solutions, CTSSoftware Engineer at Cognizant Technology Solutions, CTS
RAJAKUMAR PERIYASAMYRAJAKUMAR PERIYASAMY
Technical Lead at Cognizant Technology Solutions US CorpTechnical Lead at Cognizant Technology Solutions US Corp
Kavirajan GanesanKavirajan Ganesan
Sr. SYSTEM ENGINEER at Cognizant technology solutionsSr. SYSTEM ENGINEER at Cognizant technology solutions
PRITAM VERMAPRITAM VERMA
Management Intern at Shiv Shakti EnterprisesManagement Intern at Shiv Shakti Enterprises