Skills
- Microsoft Certified MSBI Professional offering around 16 years of career in MSBI, Database/Data Warehousing & Development of Enterprise N-Tier Web and Windows Application.
- Presently associated with Wipro Technologies, Kolkata as Technical Lead/Consultant. Leading a team of 10-12 developers.
- Microsoft Certified in Designing Business Intelligence Solutions with Microsoft SQL Server (70-467).
- Extensive experience in designing ETL Data flows using SSIS interfaces (2005 / 2008/2012/2014) with various data sources like SharePoint list, SharePoint files apart from other standard data sources. Also successfully integrated third party tool like COZYROC within standard SSIS packages.
- Strong SSRS development skills, experience including tablix, Matrix, chart, graphic score card reports, sub-reports.
- Hands-on experience in design and development of ETL solutions for data warehouses and data marts, using different architecture, design techniques.
- Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
- Hands-on experience in implementing master data management by Enterprise Information Management tool in MS SQL Server 2012.
- Hands-on experience in Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.
- Ability to code and implement complex business rules in T- SQL using Functions, Triggers and Stored Procedures.
- Strong hands-on experience in developing Business Intelligence solutions with the Microsoft Business Intelligence stack.
- A keen planner, strategist & implementer with demonstrated success in end-to-end program management and ensuring effective management of various resources to meet project specifications across domain like healthcare and payment.
- Insightful experience in project management activities including project scoping, estimation, planning, finalization of technical / functional specifications, resource administration and quality management.
- Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
- Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
- Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server 2005 to MS SQL Server 2008 to 2012.
- Experience in Log Shipping for Automated Process for backing up, restoring, copying the transaction logs and synchronizing the database for distributed database server application which can improve the application performance and availability of database.
- Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert and BCP.
- Experience in creating Indexes for faster performance and Views for controlling user access to data.
- Experience in optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard. Also expertise in Database Partitioning.
- Experienced in managing projects with Team Foundation Server Tool.
- Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and Language Integrated Query (LINQ) Providers for data manipulation.
- Lead and performed manual testing. Experience in formulating test strategy and test cases.
- Numerous times visited Onsite (U.S.A/U.K) for various project assignments and also worked as Onsite Coordinator.
- An effective leader with proven abilities in leading teams during the project phase, training & guiding team members and enabling knowledge sharing among the team.
- Excellent communication, interpersonal and analytical skills.
- Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.
Project history
Certifications
Azure Data Fundamentals (DP-900)
Microsoft
2022
Designing Business Intelligence Solutions with Microsoft SQL Server (70-467).
Microsoft
2016
Local Availability
Only available in these countries:
India
