SUMMARY

• Overall 5+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2016/ 2014/2012/2008 R 2/2008/2005/2000
• Experience in MS-SQL Server Development and Administration including Design and implementation of Distributed or Replicated Databases, planning or implementing backup or recovery strategies, and Performance tuning.
• Strong experience of Data Mapping, Data Modeling and Data Profiling.
• Expert in Relational Database Management Systems.
• Experienced in creating T-SQL objects like Tables, Views, Indexes, Triggers, Temporary tables and functions.
• Expert in optimizing the performance by using tools like Tuning Wizard, SQL Profiler, Execution Plan and Windows Performance Monitor for Monitoring and Tuning Performance.
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• Extensive knowledge in T-SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Developed dynamic SSIS packages to support ETL frameworks that can dynamically work across different environments.
• Hands on knowledge in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Experience in installation and configuration of SQL Server 2008/2008 r2, 2012, 2014 and 2016.
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL
• Expert in creating Business Intelligence reports, defining queries for generating report layout using SQL Server Reporting Services (SSRS).
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Strong experience in creating complex reports that use cascaded parameters.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Created SSIS packages to import the data from one server to SQL server management studio/ required server and also performed few transformations on the data imported.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in extracting and transforming data using SSIS Import Export Data from various sources, Bulk Insert, BCP and SSIS Packages.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Hands on experience and knowledge on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), Analysis Services (SSAS) and MDX interactive Reporting.
• Experience with TFS (Team Foundation Server), a ticketing system and code integration system.
• Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Good understanding on other SQL languages such as MySQL, Oracle etc.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, XML, JavaScript, C#.

Databases: Microsoft SQL 2014/2012/2008 , MySQL, SYBASE, MS ACCESS

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Oracle SQL, Microsoft Visual Studio2010/2012

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012 , Reporting Services (SSRS), Power BI

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Operating Systems: Microsoft Windows, UNIX, LINUX

Tools: and Utilities: Business Intelligence Development Studio (BIDS), Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

SSIS/ETL Developer

Responsibilities:

• Created SSIS packages to migrate data from different data sources to the data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Involved in enhancing and deploying the SSIS Packages from a development server to production server.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Developed complex reports using multiple data providers, user-defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Improved database performance including CTE, views, and stored procedures, Index, etc. and optimized the T-SQLstatements using SQL profiler and Execution Plan.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Environment: SQL Server 2014, SSIS, SSRS, T-SQL, SSMS, C#, Excel 2013, TFS, Visual Studio 2013.

Confidential

SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Designed and developed SSISPackages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in complete SSISlife cycle in creating SSISpackages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSISDataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Implemented Event Handlers and Error Handling in SSISpackages.
• Created SSISpackages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High-level dashboard usingSSRS2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports usingSSRS2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in creating report models and applying row level security filters for report model.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Hands on experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS,SSIS,SSRS), Power BI .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

SQL (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data, Normalized tables.
• Created Tables, Views, and Triggers, Stored Procedures, Functions and other T-SQL scripts.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Worked on Filtered Views, views and Base table integration between different source systems.
• Worked with different methods of logging in SSIS and created packages in SSIS with error handling.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for on-going ETL Processes.
• Modified existing ETL packages to support additional/new features based on the customer requirements.
• Provide technical support, troubleshoot and monitor packages released for staging.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed and maintained daily\weekly status report and same to Higher Management.
• Working with QA team on the Defects assigned and Test Case review.
• Repaired/recreated PPS reports damaged in the conversion process.
• Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.
• Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
• Responsible for adhering to our Programming, documentation and process standards
• Created and Managed OLAP Cubes using SSAS.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Implemented Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.
• Worked on the enhancement of SSAS, Processing multi-dimensional cube (In MOLAP storage mode), querying multi-dimensional cube using knowledge of MDX.

Environment: MS SQL Server 2008R2/2012, SQL Server Reporting Services 2008R2, SSIS, SSAS, Unix, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Confidential

Loan Officer

Responsibilities:

• Working at Credit Department as a Branch Second Line’s responsibility.
• Manage and handle credit relationships of different clients- Retail & SME’s.
• Acquire, develop and strengthen customer relationship through effective relationship management
• Manage and develop credit relationships with new and existing customers through detail analysis to meet their personal and business needs.
• Assess loan requests of customers and appraise their credit requirements following critical evaluation and risk analysis of the proposal in line with Finance’s credit policies and NRB directives.
• Obtain and make follow up for the documents required for new loan processing/analysis and/or renewal/enhancement/restructure/reschedule of existing credit facilities.
• Monitor/make follow up for taking necessary precautions and actions for timely recovery of interest/ dues and any other payments from the customers.
• Keep proper records/ updates of credit files under the fold assigned.
• Handle customers in regards of credit solicitation/ renewal or any other issues related to management of credit relationship.
• Execute timely renewal of assigned credit files of the Branch credit file.
• Execute timely loan recovery of payments/ charges/ interest overdue/ suspense if any and as applicable.
• Keep track and maintain record of insurance expiry, stock report and other documents related to customers as and when required in coordination with Branch’s Credit Support Unit.
• Coordinate with cross functional departments (Branch Coordinator, CA Team, TFT, Legal, etc) for execution of credit facilities, or any issues pertaining to the customers/ credit files under the assigned fold.
• Perform all required tasks related to the credit relationship as assigned by reporting officers as and when required.
• Solicit deposits and help in managing the budget of the Branch.
• Review the credit proposals, memos, etc prepared by the subordinates in credit department.
• Assist in Teller, Remittance and Operation Department when required.