SKILL:

• SQL - Server(2016)
• SSRS
• SSIS
• Database Administration
• SSAS
• Dimension Modelling & MDX Query
• Oracle
• Sybase
• Excel Macro
• Netezza
• C#
• Query Optimization
• PLSQL
• Linux/Unix Shell Scripting
• TSQL
• Informix
• Hive
• Power Shell
• Pig
• VB
• HDFS

SUMMARY:

• Certified in Querying Microsoft SQL Server 2012.
• A seasoned Database Developer with more than 10 years in System Analysis, Design, Development, Testing, and Administration: complete application development life cycle
• Expertise in several RDMS’s includes SQL Server, Access and Oracle, and 10+ years with Informix
• Created Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asSlowly Changing Dimension,Lookups,Bulk Insert,MergeandData Quality Services. These include writing of VBA / C# scripts using Script task and Script component task respectively.
• Hands on experience in CreatingStar SchemaandSnow FlakeSchemas and adept in writing MDX Queries.
• Worked in MS Excel and Access in various projects with a proven expertise in VBA/Excel Macros, Power Query, Power View and Power Pivot.
• Expert in writing complex SQL and MDX queries, created various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SQL Reporting System and Crystal Reports.
• Experience inPerformance TuningandQuery Optimization.
• Experience in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent, and scheduleDTS/SSIS Packages.
• Experienced with several operating systems includes Sco-Unix, Linux, Windows and writing Shell Scripts
• Strong Database Administration skills including installation/implementation, backup/recovery, user administration, storage space optimisation
• Implemented solution for Hadoop Big Data solution for Payment Hub for CIBC by using Hive and Linux Scripting. Scheduled the jobs by writing scripts for SFTP and Auttosys.
• ETL (Extract, Transform and Load) into Big Data Cloud Era using Linux Schell Scripting from Feed Hub.
• Banking experience in implementing solutions using Hive, Pig, Ooozie, Sqoop, Flume, Pig and Eclipse.
• Effective communication skills include Strong training and presentation skills; with multi-tasking abilities

PROFESSIONAL EXPERIENCE:

Confidential . IL,

SSIS Developer

Responsibilities:

• Created and Modified 40 SSIS Packages include parent and child packages at the group and copy book level
• Created several TSQL queries which handled all the tasks of SSIS like validations, data matching, joins, error handling and packages for performance and accuracy of the result set.
• Created Database and Database Objects like Tables, Stored Procedures, views.
• Created C# Scripts to look for trigger and validation file, folders and read count and validation date from the respective files
• Optimized SSIS packages to run several child packages in parallel and also implemented dynamically rerun of the selective child packages in event of failure.
• Modified stored procedure for reconciliation counts enabling multiple view counts for single SSIS package. This was done in such a way that there was no need to modify any SSIS package.

Sr. Technical Lead

Responsibilities:

• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector.
• Organized dashboards in Tableau to analyze the Child Loan System over various attributes of Student Loan, time and location dimension.
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations
• Created and Modified 5 SSIS Packages to in corporate necessary changes in the CSV views for the loan system.
• Created several TSQL queries which handled all the tasks of SSIS like validations, data matching, joins, error handling and packages for performance and accuracy of the result set.
• Created Database and Database Objects like Tables, Stored Procedures, views.
• Created Power Shell Scripts to generated a document of all the transformations taking place in different packages by reading all the .dtsxfiles available in various folders
• Created Power Shell Scripts to generate dynamic queries for a list of exemption views with respective columns and alias stored in a table with the result set to be stored as CSV file in a shared folder.
• Modified stored procedure for reconciliation counts enabling multiple view counts for single SSIS package. This was done in such a way that there was no need to modify any SSIS package.

Technical Environment

• SQL Server 2008, 2012, TSQL, SSIS.
• Created SSIS Packages,, stored procedures, deployment scripts, Tableau Reports, PowerShell Scripts and Batch files

Confidential

SSIS Developer

Responsibilities:

• Created and Modified 10 SSIS Packages to in corporate new dimensional table consolidating incremental loads of all daily application and applicant processes.
• Created several Netezza query which handled all the tasks of SSIS as well like validations, data matching, joins, error handling and packages for performance and accuracy of the result set.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Carried out several production fixes by modifying and creating several queries, stored procedures in record time.
• Carried on data transfers to and from the clients and solved data transfer issues.
• Generated and deployed SSIS Packages in multiserver environment and generated and run deployment scripts for rapid deployment across various servers and included Package administration and assigning permissions.

Technical Environment

• SQL Server 2008, 2012, TSQL, SSIS, Netezza
• Created SSIS Packages, triggers, table valued functions, stored procedures, deployment scripts and Batch files.

Confidential

Hadoop Developer

Responsibilities:

• Created and Modified scripts for creation of temp directory, temp tables, copying the source files to hdfs, validating count, header and trailer of source files, creating and inserting into hive tables, recording the audit entries, archiving the source file and clean up.
• The Hive tables created as per requirement were Internal or External tables defined with appropriate Static and Dynamic partitions as per interface agreements and data models.
• Create sftp scripts to pull files from feed hub into landing zones on edge node.
• Handled importing of data from various data sources, performed transformations using Hive, worked with HCatalog to open up access to Hive's meta-storeusing PIG & MapReduce, loaded data into HDFS and extracted the data from Oracle and SQL Server into HDFS using Sqoop.
• Implemented partitioning, dynamic partitions and buckets in HIVE designed and implemented Hive and Pig UDF's for evaluation, filtering, loading and storing oflarge sets of structured, semi structured and unstructured dataand extensively used Pig for data cleansing.
• Worked on Performance Tuning of Hadoop jobs by applying techniques such as map side Joins, Partitioning, Bucketing and using different file formats such as Sequence File, RC File, ORC File, XML file.
• Wrote Scripts using Eclipse to generate Map Reduce jobs and performed ETL procedures on the data in HDFS using PIG, Hive, Python and OOZIE.
• Developed workflow in Oozie to automate the tasks of loading the data into HDFS and pre-processing with Pig
• Exported the analyzed data to the relational databases using Sqoop for visualization and to generate reports for the BI team.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Carried out DIT testing exhaustively including negative test cases and transferred scripts for SIT testing.

Technical Environment

• Cloudera Hadoop, Hive, Pig, Python, Sqoop, Oozie, Oracle 11g, Linux and Unix, Eclipse.

Confidential

SSIS Developer

Responsibilities:

• Created and Modified 25 SSIS Packages to in corporate new Product Hierarchy and implemented the same in Production well before the tight deadline.
• Created several stored procedures and functions and compex queries and packages for performance and accuracy of the result set.
• Upload data into dimension and measures by pulling incremental data from Oracle and SAP data sources.
• Carried on data transfers to and from the clients and solved data transfer issues.
• Tuned the SQL queries using SQL profiler.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Worked with designing Star Schema, Cubes, Dimensions and Measures.
• Populated Dimensions and measure using data from SAP, Oracle and SQL Server.
• Generated and deployed SSIS Packages in multi server environment and generated and run scripts for rapid deployment of reports which included Package administration and assigning permissions.

Technical Environment

• SQL Server 2008, 2012, TSQL, SSIS, Oracle 11g, SAP, SSAS
• Created SSIS Packages, triggers, table valued functions, stored procedures, deployment scripts and Batch files.

Confidential

SSIS Developer/Architect

Responsibilities:

• Design and build complex relational databases and data warehouses. Designed the database by creating tables, semi-summary tables and other database objects to cater to the needs of the user requirements.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Responsible for database tuning using normalization and application tuning
• Responsible for report performance and interacted with the DBAs to advise on table partitioning, data imports from DB2 databases and resolving complex queries using TSQL.
• Production support on all the user issues including bug fixing, report enhancements, and user training.
• Developed more than 60 Reports and includes Business Review Reports, Monthly Reports and Daily Reports reflecting various facets and decision points of the system and depicting using charts
• Created several stored procedures and functions and optimized the query for performance and accuracy of the result set.
• Created and modified 20 Reports for several clients at Hinext.com and deployed the reports to the remote client servers.
• Carried on data transfers to and from the clients and solved data transfer issues.
• Generated and deployed reports in multi server environment and generated and run scripts for rapid deployment of reports which included report administration and assigning table permissions.

Technical Environment

• SQL Server 2005, 2012, TSQL, SSRS, SSIS, Visual Foxpro, C++
• Created triggers, table valued functions, stored procedures, and deployment scripts.

Confidential

Team Lead / Architect

Responsibilities:

• Work with technical and end users to understand business requirements and identify data solutions.
• Provide leadership and direction to database developers
• Provide performance tuning of database systems for query and data loading performance, including data partitioning, indexing, data model review/updates, etc.
• Design and build complex relational databases and data warehouses. Designed the database by creating tables, semi-summary tables and other database objects to cater to the needs of the user requirements.
• Responsible for report performance and interacted with the DBAs to advise on table partitioning, data imports from DB2 databases and other issues.
• Production support on all the user issues including bug fixing, report enhancements, and user training.
• Created SSIS Packages and developed stored procedure to port the historical data from legacy system and for importing daily sales data generated by various call centers using Slowly Changing Dimension.
• Implemented a Caging System used to cage the cheques, credit cards received for the donations/Membership sold. This system scanned the cheques and remainders received from donors and matched to the sales and help in finding the duplicate and invalid cheques with various checks and balances. This system not only reduced the manpower but also eradicated the problem of missing or duplicate cheques. The output of the system was tallied Bank Deposit Report created in SSRS.
• Responsible for timely preparation and uploading of client specific donor list in the dialer for regular calling by Call Centres. This involved porting of data received from clients in Excel/CSV format to SQL Server. Validating the data and doing phone lookups for missing phones. Writing custom stored procedures for tumbling the data and segmenting it as instructed. Executing the necessary kills on the data and forwarding the counts to the user and upload the household data together with gift History into dialer.

Technical Environment

• SQL Server 2008, TSQL, SSRS, SSIS, Visual Foxpro.
• Created triggers, table valued functions, stored procedures and SSIS packages.

Confidential

SSIS Developer

Responsibilities:

• Created SSIS package and scheduled it for importing data from Sybase Server (OLTP) into Staging and then into SQL Server Data Warehouse into Fact and Dimension tables.
• Created and modified cubes, dimensions and measure and populated those using SSIS.
• Created and modified hierarchies to suit the reporting needs
• Extensively used MDX Queries, Named Queries, Named Sets.
• Created and fixed complex queries and optimized the same for the performance.
• Created weekly, monthly, quarterly and yearly reports and scheduled it for delivery by email or stored to hard disk as per the user request.
• Analysed and monitored Log files of SSIS packages for data transfers and initiated timely actions in case of any disruption in data transfer.
• Captured data from various sources including text, excel, ftp and data base and combined them with incremental data loads and translated them into Fact and Dimension Tables and presented them in reports timely.
• Developed VB.Net Scripts for Script tasks and components, meant for transferring data from Sybase using stored procedures, Excel Macros & Power pivot using multiple Excel Files and Text Files having complex Validations with respective error handling in place.
• Created Asset exposure report using the matrix template in SSRS, one of the main features of the matrix report is the calculation of project-to-date totals of equity, Loan value and % Concentration Industry and Industrial category wise and depicts the same using charts. Other useful reports include velocity reports showing average time taken for Account application processing, Document processing report showing the average documents processed individually on daily basis.

Technical Environment

• SQL Server 2008, TSQL, SSRS, SSIS, SSAS, Sybase, Power Pivot, Excel Macros.
• Created triggers, table valued functions, stored procedures, deployment scripts and SSIS packages.

Confidential

Team Lead - Architect

Responsibilities:

• As a Team Leader I has been involved complete development life cycle of the development and implementation Production Planning and Control Project besides guiding 2 Programmer and 3 Junior Programmers. Some of the major projects implemented by me are
• Developed and implemented Attendance Recording System. This system was designed to capture data files generated while punching in/out from Attendance Recording System and update the databases for Informix and SQL Server simultaneously serving as input data for generation of Payroll, Leave Maintenance, Late Attendance and several MIS Reports. The entire system, including reporting, was designed in SQL Server with a separate database as well as ETL (Extract, Transform, & Load) processes using SSIS and SSRS.
• Developed and implemented Integrated Product Costing System. This system design involved exploding the Bill of Materials for each product and components, process data form Warrants, Inventory, Orders and Production Tables to arrive at the Production Cost of each and every products and respective components. All these data both input and output data is downloaded according to predefined structure specified by head office in flat files and FTP to Head Office at Kolkatta and uploaded at central server to enable Integrated Product Costing of all Factories. The entire system, including reporting, was designed in Informix Server with a separate database as well as ETL (Extract, Transform, & Load) processes using Shell Script and FTP.

Technical Environment

• Informix 7, Linux & Unix, SQL Server 2005, 2008, TSQL, SSRS, SSIS, COBOL, Informix 4gls, VB, JSP, Java Script, VB.NET, Eclipse
• Created triggers, table valued functions, stored procedures, deployment scripts, SSIS packages, Shell Scripts, Coding using Java script, VB, Informix 4gls, Foxpro and COBOL.