Simran Chavan Senior Data Engineer

Email: adivhj@r.postjobfree.com

Ph#: 647-***-****

Professional Summary:

IT Professional with around 15+ years of experience in the Design, Development, Implementation and Maintenance with exposure to Banking, Accounts and Financial Services Domains.

Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence BI in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expertise in writing SQL, Oracle, Access, Hive DDL/DML,T-SQL Queries, PL-SQL, Dynamic-queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-defined Functions and Views.

In-depth knowledge of data warehousing methodologies.

Experienced in Hadoop Big Data technologies, Hive, Pig and integration tools such as Talend ETL tool.

Experience with Talend to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.

Knowledge of Cloud Databases and Data warehouses (SQL Azure / RDS / Redshift / SnowFlake/ DataBricks).

Experienced with Power BI, Tableau data visualization reporting.

Proficient in analyzing and validating data using Python, R, Spark, PySpark, Shell Scripting & PowerShell.

Experience with libraries such as pandas, numPy, matplotlib, sciPy, scikit-learn.

Designed data model from scratch to aid team in data collection to be used for Tableau visuals

Troubleshot production problems mainly associated with performance using SQL Profiler and Performance tuning.

Optimized performance of production system by modifying indexes, redesigning stored procedures and implementing partitioned views.

Worked extensively on transferring data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

Experience in Microsoft Visual C# in script component of SSIS.

Expert in generating writing parameterised queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 and Crystal Report using data from ETL Loads and various heterogeneous data sources.

Worked extensively with report manager for deploying the reports across all the environments.

Experience in ASP.NET, C#, XHTML, XML, CSS, Java, JavaScript.,API, Web services, Visual Basics.

Proficient in overall Defect Management/Problem solving including tracking bugs and reporting using HP ALM, Quality Center and Jira.

Expertise in Job Scheduling environments CA Workload Automation AE (AutoSys Edition)

Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.

Ability to adapt to new methodologies, tools and technologies and domains depending on the job responsibilities.

Technical Skills:

Databases

SQL Server 2012/2008/2005,Oracle 9i/10g/Toad, MongoDB, Hive, Pig, MS Access, noSQL

ETL/BI Tool

SSIS, SSAS, Talend, Python, R Programming,Big Data,Hadoop, Spark, Scala, PowerShell, Shell Script

Others

Microsoft Azure, SQL Profiler, SQL Query Analyser, SQL, PL-SQL,KAFKA, Redshift, Glue, Autosys,C#,ASP.NET, XML, Java, JavaScript, HTML, CSS, Excel, Doc, Restful API, Salesforce

Reporting Tools

Tableau, Power BI, SQL Server Reporting Services(SSRS),Crystal Report XI/X

Bug Tracking Tools

HP ALM, JIRA, Quality Center (QC)

Methodologies

Agile-Scrum, Waterfall

Cloud Services

On-Premises, Infrastructure as a service(IAAS), Platform as a service(PAAS), Software as a service(SAAS)

Operating Systems

Windows XP/10/8/7, Linux

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (B.E.) in Information Technology.

TECHNICAL CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 Certified.

ITIL 2011 Foundation in IT Service Management Certified.

Oracle 9i : Program with PL/SQL Certified.

MCTS: .NET Framework 2.0 Web Applications Certified.

Hadoop Big Data.

MongoDB.

Data Science.

Python Spark ( Pyspark)

LIST OF CAREER AWARDS

TD Legendary Quarterly Award (Year-2020)

TD Beyond Excellence Award (Year-2019, 2018 )

CIBC Achievers Award (Year-2017)

TCS Beyond Performance Awards (Year-2016, 2015, 2014 )

TCS Excellence Award (Year-2015, 2014, 2013, 2012 )

Professional Experience:

Company: TD Canada Inc May 18 – Till Date

Role: Sr. Data Engineer

Responsibilities:

Worked closely with business analyst, multiple business units to identify key information of business requirements.

Prepared high-level technical design specifications and low-level specifications based on business requirements.

Involved as primary ETL developer during the analysis, planning, design, development and implementation stages of various projects.

Experience with implementing data pipeline to ingest, clean, aggregate, and integrate data from various data sources.

Experience with Python, Spark for data analysis & ETL development libraries like pandas, numpy, scipy etc.

Experience with APIs used for Salesforce data import /export using Python.

Worked on designing the table layout in hive, scripts to write the data into Hadoop

Worked on data reporting/dashboard using Power BI & Tableau.

Experienced using the Talend with Big data using Hive, Sqoop, Hdfs components.

Experienced in Data Ingestion projects to inject data into Data lake using multiple sources systems using Talend Big data

Experience with Talend to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.

Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.

Good experience on Talend architecture and Talend installation. Have the knowledge on scheduling jobs on TAC .

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.

Experience in creating complex ETL logic using proper control and data flow elements with error handling.

Involved in building the logical and physical models for dimensional modeling projects.

Loaded the interacting with clients to gather requirements on cleansing rules and data remediation.

Developed stored procedures, functions, packages, triggers, indexes and views.

Troubleshooting database, workflows, mappings, source and target to find out the bottlenecks and improved the performance by collecting statistics and observing explain plan.

Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Experience in converting the Store Procedures logic into ETL requirements.

Ability to work independently or as a part of team to accomplish critical business objectives and to make decisions under pressure.

Used Python scripts to manipulate files and managed large datasets using Panda data frames and SQL

Worked with data visualization Tableau team to represent data in the form of dashboards to enhance business decision-making.

Supported technical team members in development of automated processes for data extraction, analysis and testing.

Written Job Information Language (JIL) commands and Created, scheduled and monitored Autosys jobs.

Environment: Hadoop Big Data, Hive, Python, R, Spark, Pyspark, Kafka, Redshift, MS Azure, Tableau, Power BI, Salesforce, MS-SQL, MS SQL Server Integration Services (SSIS), Talend, Oracle, PL-SQL, JavaScript, Power Shell, Autosys Job JIL.

Company: CIBC-TCS, Toronto, ON. Mar 16 – Apr 18

Role: Sr. ETL Developer

Responsibilities:

Designed, developed and supported Client proprietary application system by maintaining data integrity using integration services to transfer data across applications as per business requirement document (BRD).

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008 R2.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Implementation of MS SQL Server 2012/2008 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Databases.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spread sheet to SQL Server 2012/2008.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

ETL processes involving migrations and in synchronization processes between different databases.

Developing reports on SSRS on SQL Server. Sound Experience and understanding of SSAS, OLAP cube and Architecture

Experience in Performance Tuning and Query Optimization.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Ensuring deliverables as per quality assurance plan and final inspection.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Data transferred from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2012/2008).

Used Microsoft Visual C# in script component of SSIS.

Proposing best fit solutions in terms of vision of the project and technical feasibility. Assess the risks and recommend/ install service packs or hot fixes when needed. solution to effort estimate, cost as well as schedule.

Environment: Query Analyzer, SQL Enterprise Manager, SQL Management Studio, Reporting Server, Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), Tableau, Power BI, Oracle, Big Data, MS SQL Server Reporting Services (SSRS), MS SQL Business Intelligence (BI)

Company: TCS Sep 10 – Mar 16

Role: IT Developer / ETL Developer / Tech Lead / Project Manager

Responsibilities:

Web based application created and upgraded with the help of .Net/ SQL / SSIS/ SSRS for capturing Applicant details, Online Passport Tracking, Online Scheduling/ Rescheduling/ Cancellation Appointment at Visa Application Center(VAC) and Embassy for completing Visa Process.

Created requirement documents with high level design specification based on the customer requirements and provided logical quality solutions.

Project planning and tracking each phase of software life cycle by regular coordination with client, team and other stake holders.

Created High Level and Low Level Design Documents, interfacing with client and internal teams.

Created best suited techno-functional strategies for the implementation of the project reducing system requirements and cost management.

Created ETL framework to handle multiple data to be processed into staging area. It is further loaded into target area by adding business logic to it. Also archival logic was added to suppress old data. Further data was utilized for reporting purpose. This initiative has helped to drive business growth and analysis and MIS reporting purpose.

Created Dynamic scripts for rolling out Country level configuration.

Experienced in performance tuning and optimization of TSQL queries, stored procedures and functions, dynamic script generation.

Excellent in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server with T-SQL.

Data transferred using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Preformed ETL processes involving migrations and in synchronization processes between different databases.

Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow.

Generated parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2012 R2 using data from ETL Loads and various heterogeneous data source.

Expertise in generating reports using SQL Server Reporting Services Implemented and delivered SSIS packages to develop and deploy ETL.

TCS MasterCraft data tool used for tracking, validating and measuring the quality of data.

Task tracked for their timely completion and work towards achieving better performance by optimizing query.

TCS TQAS(TCS Quality Audit System)- This tool is used for managing project related audit process. Highlighted project risk, mitigation plan, project process tracking, audit tracking.

Environment: MS-SQL Server 2005/2008/2012,Query Analyzer, SQL Enterprise Manager, SQL Management Studio, Reporting Server, Data Transformation Services(DTS),Oracle, MS SQL Server Integration Services(SSIS),MS SQL Server Reporting Services(SSRS),MS SQL Business Intelligence(BI),Big Data,.Net Framework 1.1/2.0/3.5/4.0, T-SQL, ASP.NET, C#, XHTML, XML, JavaScript

Company: Osource India Pvt. Ltd. Apr 06 – Aug 10

Role: IT Developer / Tech Lead / Project Manager

Responsibilities:

Created plan to incorporate Project life Cycle and Researched project resources. Managed customer relationships

Responsible for ensuring developer met all milestones and goals as laid out in project plan.

Reviewed, analyzed and evaluated change management requests for a thorough understanding of project direction. Generated and analyzed statistical data reports.

Compiled detailed descriptions of user needs, program functions and steps required to develop or modify computer programs

Proactively initiated quality assurance policies and procedures to significantly reduce errors.

Apply strong leadership talents toward interviewing job applicants, training new hires, and establishing and maintaining a cohesive work climate among programmers.

Delegate and prioritize workflow for programmers, troubleshoot and resolve technical issues, and diligently maintain company's response tracking database.

Reviewed and ensured all quality assurance processes and policies were administered.

Constantly reviewed and provided data analysis as requested per our clients request.

Business analysts discussion with clients to identify requirements, conducted business and technical studies,requirement document, design, develop, integrate and implement information systems business solutions and suggest on information systems strategy, management and service delivery

Involved in database design, development, Reports generation and Application Maintenance and Support.

Software development and implementation of policies and procedures throughout the software development life cycle to maximize the efficiency, effectiveness and overall quality of software products and information systems

Environment: Oracle 9i/10g,Load,SQL Server 2005/2008,Query Analyzer, MS-SQL,(SSRS),.Net Framework 2.0/3.5,Java, JavaScript, Crystal Report, T-SQL, ASP.NET, C#, XHTML,XML

Company: Perfect Elogics InfoTech Pvt. Ltd Jun 05 – Mar 06

Role: Software Developer

Responsibilities:

Designed and built effective and attractive user interfaces for a variety of platforms

Participated in user requirements meetings in order to transform client needs into proposed application designs

Created test suites in order to assess product functionality and performance

Extensive experience with continuous integration, problem-solving, and creative thinking

Developed, maintained and supported Projects from scratch.

Involved in database design, development, Reports generation and Application Maintenance and Support.

Environment: T-SQL, ASP.NET, C#, Javascript, XHTML,XML

Company: Vishleshan Software Solution Pvt Ltd Nov 04 – Apr 05

Role: Jr. Software Tester / Developer

Responsibilities:

Knowledge on Programming and Database Fundamentals.

Knowledge on Software Development Life Cycle and Software Test Life Cycle.

Involved in database design, development, Reports generation, Application Maintenance and Support.

Knowledge on Generating Test Scenarios, Write Test Cases, and Collect Test Data.

Knowledge on Executing Test Batches and Analyzing Test Result.

Knowledge on Defect Reporting, Defect Tracking and complete Defect Life cycle.

Experience with continuous integration, problem-solving, and creative thinking

Environment: Excel, Word Document, MS-Access,.NET, C#, Javascript

References

Will be provided upon request.

Contact this candidate