Data Sql Server
Resume:
Bipin Maliakal
Mississauga, Ontario
L5M-7R3
*****.********@*****.***
Profile:
Around 10 years of experience in IT industry having design, development & deployment experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI), CRM database applications and various segments of Software Development Life Cycle (SDLC), using Oracle EBS, MS SQL Server 2017/ 2016/ 2012/ 2008/ 2005/ 2000, SQL Server Integration and Reporting Services.
Extensive SQL Development experience in Government Agency, HealthCare (EHR), Banking, Real Estate and other industries with a strong understanding of data & analytics.
Skilled in Business Intelligence tools like SQL Server 2016 Integration Services (SSIS) and Reporting Services (SSRS).
Solid understanding of RDBMS (Relational Database Management System).
Proficient in using SQL Server Integration Services (SSIS) (equivalent to the other ETL tools like IBM DataStage, Informatica), to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
Experience in creating SSIS packages and to automate the Import and Export data to and from SQL Server 2008, 2012, 2016 using SSIS.
Experienced in creating Tables, Stored Procedures, Views, Triggers, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
Extensive knowledge in Microsoft Technologies (ASP.NET, C#.NET, VB.NET, T-SQL MS SQL, SSIS, SSRS, SSAS) and IBM Cognos.
Excellent skills in gathering requirements, designing, developing and implementing projects and its work-flow.
Experience in managing and supporting multiple projects simultaneously.
Robust understanding of modern software development methodologies like Agile
and DevOps.
Strong knowledge of Computer Science theory & strong in modern programming languages (ASP.NET, C#.NET, VB.NET, R Programming).
A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem-solving skill.
Excellent Verbal & Written Communication skills and strong in Documentation with knowledge and experience in Agile and DevOps .
Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
Technical Skills:
Programming Languages : R programming, C, C++, C#.net, VB.net, VB 6
Data Base Technologies : SQL Server 2000-2016, MS Access,
SSRS (SQL Reporting), SSIS (Integration Services), MS Excel, Oracle EBS
Operating Systems : Windows 10, Windows 7, Windows XP
System Programming : PIC (Peripheral Interface Controller)
Other DB tools : Hadoop Big Data, MongoDB, NoSQL
Web Developing Software : ASP, ASP.Net 3.0 /3.5, HTML, JavaScript
IDE & BI Tools : MS SQL Data Tool for Visual Studio 2017,
SQL Server BI Development Studio (BIDS),
SharePoint, MS Visual Studio 2017/2016/2012/2008/2005, Crystal Reports
Version Control : Team Foundation Server (TFS), Visual SourceSafe
(VSS), GitHub
Application Packages : Photoshop, MS Office
Work Experience:
Sr. Database/ETL Consultant
Technical Standards and Safety Authority (TSSA) Toronto, Canada (Nov 2016 – Present)
•Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics by working with Business Analysts.
•Modelled and maintained the logical and physical data model of the future state using Toad Data Modeller and delivered BRD and the low-level design document.
•Discussed the logical and physical data model, data flow and data mapping with the data development team.
•Developed PL/SQL Scripts and packages, conducted Unit testing, coordinated the production deployment and resolved post implementation issues.
•Designed, developed and tested ETL processes using SQL Server 2017, SQL Server Data tools 2017 and/or SQL Server 2017.
•Knowledge and experience in database security management.
•Migrated data from Oracle EBS 12.1.3 to MS Dynamics 365 using SQL Server 2017, SSIS (2017) and Scribe.
•Reviewed, analysed the data quality loaded into the CRM database using Data Quality Tool (Data Quality Server - DQS).
•Experience on Agile and DevOps project environment, participated in daily stand-up meetings, weekly scrums and monthly update meetings.
Sr. SSIS/SSRS Developer
IBM – Royal Bank of Canada (RBC) Toronto, Canada (May 16 – Nov 2016)
•Data migrated from CRM 4.0 to CRM 2016 using SQL Server 2012 SSIS (2012) and CRM SDK.
•Analyse business requirements and created functional and technical design document (FRD, TDD, FDD) for the source to target data mapping for the ETL development (SSIS 2012) along with the logical and physical data models.
•Managed off shore team of 3 people for building the SSIS packages corresponding to the TDD.
•Created Data Lineage, Table and Column Data Definitions, Valid Values and others necessary information in the data models as per business rules for Data Transformation.
•Design, develop and test ETL processes using SQL Server 2012, SSIS 2012 and/or SQL Server 2000.
•Analysed the requirements and created Models, connecting various data sources, reports, sub queries, creating users, scheduler and joins using SSRS and Cognos Framework manager.
•Developed and debugged complex database schemas, stored procedures, triggers and functions based on various business rules using PL/SQL.
•Experience on waterfall project environment, participated in daily stand-up meetings, weekly and monthly update meetings.
Database Analyst/Developer
PointClickCare (Wescom Solutions) Mississauga, Canada (Mar 13 – May 16)
•Gathered business requirements from various business units, designed and coded a .NET application single-handedly that increased productivity of the team by 60-80% and producing more revenue per day.
•Designed, created and debugged complex database schemas, stored procedures, triggers and functions based on various business requirements.
•Data migration into SQL Server 2008/2012 from different data sources (Excel, Access, XML and flat files) using SQL Server 2005/2008/2012 SSIS (2012) /SSRS/SSAS packages.
•Developed and executed unit test scripts, regression test scripts and performance scripts in T-SQL
•Design, develop and test ETL processes using SQL Server 2012, SSIS 2012 and/or SQL Server 2000 –DTS.
•Involved in capturing Data Lineage, Table and Column Data Definitions, Valid Values and others necessary information in the data models.
•Analyse business requirements and created technical document for the source to target data mapping for the ETL development (SSIS 2012).
•Coded and done performance tuning for complex stored procedures, SQL queries, views and jobs and configured database mail in order to send scheduled reports to the clients.
•Scheduled and maintained number of SQL jobs to load data from various servers to csv files or excel file using SQL Agent.
•Designed and documented ETL SSIS (2012) packages, developed multi-dimensional and ER data modelling, data mining structure and algorithms.
•Helped with the reporting team to finish of the pending tasks on SSRS reports from Data warehouse.
•Worked with the project managers and team to architect and design applications.
•Experience on Jira Agile environment, participated in daily scrum meetings, weekly and monthly update meetings.
Enterprise Developer
The Bank of Nova Scotia (Scotiabank), Toronto, Canada (Mar 12 – Mar 13)
Involved in analysing, designing and developing project (ASP.Net 3.5, T-SQL, C#, SQL Server 2008/2000/2005, SSIS) on time with team members successfully.
Collaborated in Requirement Analysis, ETL Design and Development for extracting and loading data.
Created SSIS packages to clean and load data to SQL Server 2008 from different data sources such as Excel, Access, XML, flat files etc to the Data warehouse.
Involved in analysing, designing and developing project (ASP.Net 3.5, C#, SQL Server 2008/2000/2005) on time with team members successfully.
Created the Cognos reports using the transact SQLs in the report studio and also converted some of them into framework manager package.
Worked on SQL RDBMS system on the development of the application by using Entity Relationship Data Model.
Worked as bank’s technical point of contact for application development and performance tuning.
Fixed issues related to MS Excel Macros (VBA) which has been used across the bank.
Actively involved in bank’s image development and image deployment with the development and deployment team.
Managed bank’s Windows 7 Support forum (internal) and assigned tasks to deployment techs.
Remediated of all kinds of compatibility issues related to Windows 7 Application compatibility.
Deployed OS using different image engineering tools such as Microsoft Deployment Tool, Acronis etc.
Network and Application Developer
Starlight Investments, Mississauga, Canada (Sept 10 – Feb 12)
Created edited and updated reports using SQL Server Reporting Services (SSRS).
Performed data migration, data analysis, identify problems and develop solutions.
Involved in system development, integration, testing and deployment to ensure the quality delivery of the software applications in .NET platform with RDBMS system.
Fixed issues related to MS Excel Macros.
Worked as helpdesk team lead and provided technical support to users.
Installed and upgraded PC components such as network cards, memory chips, disk drives, modems and CD-ROM drivers.
Systems Analyst (Jan 10– Apr 10)
Mircom Technologies Ltd., Vaughan, Canada
Collaborated in analyse, design and development of the project on time with senior team members.
Created, altered and debugged number of tables, views, functions, triggers and stored procedures.
Altered application UI as per the requirement document.
Managed the analysis and design of database using MS SQL Server and MS Access.
Created and edited reports using Crystal Reports.
Successfully converted application from VB.Net to ASP.Net 3.5 with SQL Server 2005
Senior Software Developer (Sept 07 – Jun 09)
Istrox Research Inc., Kerala, India
Collaborated in analysing, designing developing and delivered the project (ASP.Net, C#, SQL Server 2000/2005) on time with team members successfully.
Actively involved in complete SDLC life cycle.
Managed the Analysis and design of database and wrote stored procedures.
Created, analysed and updated Reports and ETL Packages (SSRS, SSIS, Crystal Reports).
Involved in system development, integration, testing and deployment to ensure the quality delivery of the software applications in .NET platform.
Worked on the Oracle EBS system to analyse and migrate the data to .Net application.
Developed and successfully implemented the application (ASP.Net 3.5, C#, SQL Server).
Created database design using UML diagrams.
Performed Unit testing, performance testing and regression testing.
Educational Details Summary:
Advanced Diploma in Computer Systems Technology – Networking (Co-op),
Centennial College, Toronto, Ontario. (Sept 2009- Dec 2011)
Overall GPA is 3.8/4.5
Bachelor of Engineering in Electronics and Communication,
Anna University, Chennai, India. (2003 – 2007)
References:
Available upon request.
Contact this candidate