Data Manager
Resume:
Sanchay Bhambri
*******@************.***
Professional Summary:
Around 4 years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2014/2012/2008R2/2008/2005 for both OLTP & Data Warehousing applications.
Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005/2000, DTS, SSIS and SSRS 2005/2008.
In-depth experience of Transact-SQL (DDL and DML) operations. Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
Experience in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
Good Knowledge of Data Warehouse/Data mart concept and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert.
Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing using triggers and SQL Scripts.
Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases..
Excellent communication skills, bridging Client Interaction and Team player.
Technical Skills:
RDBMS / Databases
MS SQL Server 2014/2012/2008R2/2008/2005, Oracle 10g,11g, MS-Access 2013/2007/2003, IBM DB2
Languages
T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML, XML
Operating Systems
Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2
Modeling Tools
Microsoft Visio 2007, Erwin Data Modeler 8/7/5
Reporting Tools
Crystal Reports 8/10, SQL Server Reporting Services (SSRS)
Integration Services
SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
Analysis Service
SQL Server Analysis Services (SSAS)
Database Tools
MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, Database Engine Tuning Advisor (DTA), Hadoop, Hive, pig
Internet Tools
Internet Information Server (IS 5.0 / 6.0), FTP, TCP/IP
Professional Experience:
Regions Bank, Birmingham, Alabama Feb 2020 – Present SQL Server (SSIS/SSRS) Developer
Responsibilities:
Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
Created views to restrict access to data in a table for security.
Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER 2008 R2.
Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments.
Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow.
Defines and captures metadata and rules associated with ETL processes.
Design and develop SSIS ETL packages per the requirement to enhance existing system from heterogenous data sources like SQL, DB2 via direct query.
Worked on implementing server right from the scratch by installing, creating instances, database, table space, tables, indexes along with installing IBM DB2 client on windows platform.
Played a major role in improving the performance of the cube by implementing multiple instances using SSAS.
Delivered the design and developed Business Intelligence and Reporting Software using BIRT and automated Reporting capabilities to Extract data from SQL stores.
Review and analyze database performance, cubes and reports generated using SQL SERVER 2008 R2 Reporting Services.
Environment: SSIS, SSRS, MS SQL Server 2014/2012, DB2, C#, Visual studio 2008, MS Access 2013, MS Excel.
Care Source, Dayton, OH Jan 2019-Dec 2019 SQL Server Developer/ BI Developer
Responsibilities:
Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
Gathered business requirements, provided architecture and design for financial module for Medicare Advantage program.
Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
Used Team Foundation Server to retain Project code during deployment process.
Part of Code review during Production deployment and QA deployment.
Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data into the Data Warehouse.
Designed Console application to generate Single .CSV and text file from Different Relational Database table using SSIS and C#.
Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
Tested reports, bug fixing and modification of actuate reports.
Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012.
Generated Sub-Reports, Cross-tab, Conditional, Drilldown reports, Drill through reports and Parameterized reports using SSRS 2012.
Environment: MS SQL Server 2012, SSIS Package, SQL BI Suite (SSMS, SSIS, SSRS), SQL Server Report Builder 3.0, XML, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Erwin r 7.3, Net 4.0/4.5, TFS 2010.
ICICI Bank, India Mar 2015- Aug 2017 SQL Developer
Responsibilities:
Understanding of existing business processes, project functional and technical specifications.
Involved in meeting with business and exploring requirements and planning for creating Data mart for different systems.
Involved in identifying facts and dimensions for the Data Mart based on reporting requirements and existing reports.
Created ETL logging Control tables for maintaining a log of all the loads.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Imported data from text files/excel spread sheets, Informix Database into SQL Server 2005/2008 database using SSIS package.
Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
Created different types of Tabular reports like Cascaded Parameters, drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
Deployed SSRS reports to Report Manager and created linked reports, snapshots, and subscriptions for the reports and worked on scheduling of the reports.
Involved in migration of SSRS from SQL 2005 to SQL 2008R2.
Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
Environment: SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Windows Server 2003, Performance Point Server 2007, C/C++, Oracle 10g, PL/SQL, SQL Server Report Builder 3.0, Visual SourceSafe, visual Studio 2010
Education:
Masters from Northeastern University in Engineering Management Nov 2019
Contact this candidate