SUMMARY:

• MS BI Professional with 13 years’ experience in designing and development Database applications.
• Expert in Client/Server and WEB application development using Microsoft SQL Server, SSIS, SSRS, ASP.NET and C#.
• Have strong knowledge and extensive experience in finance and ecommerce domain.
• Hands on experience in analytical software R and MongoDB.
• Extensive experience in executing full life - cycle development projects; ramping-up projects within time, budget & quality parameters, as per project management & best practice guidelines.
• Strong skills in systems design, database-centric application design, development and deployment.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Highly proficient in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, relational database models, Data Integrity, SQL joins and SQL Query Writing.
• Excellent Experience in SQL Server Performance tuning in MS SQL Server 2000/2005/2012/2014/2016 using SQL Profiler, SQL Query Analyzer, Execution plans and Windows Performance Monitor.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems.
• Strong Experience in development/tuning of SSIS Packages to Extract, Transform and Load (ETL) data from heterogeneous sources such as flat files, Oracle 11g, Sybase IQ, MS Access, MS Excel.
• Strong experience in designing and developing enterprise reports (SSRS/ Business Objects) using the data from ETL Loads, and various heterogeneous data sources.
• Extensive experience in SSRS Report Authoring, Report Management and Report Delivery.
• Experience in developing cubes (SSAS) using Partitions, KPI’s, and Perspectives, slow changing dimensions
• Working Knowledge on Web API, WCF& Web Service, ASP.NET MVC
• Expertise in Project Developing using 2 tier and 3tier Architecture.
• Expertise in working Client/Server technologies using C#, JavaScript, ADO.NET and Web Services.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/2005/2012/2014/2016 , Mongo DB 3.0

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Client Configuration Utility, DTS import/Export, SQL Server BIDS/SSDT (SQL Server 2005, SQL Server 2012)

Languages: C# 3.0, JavaScript, HTML, HTML5, R 3.2, Python 2.7.

ETL Tools: SQL Server Integration Services 2012 (SSIS), SQL Server Integration Services 2005 (SSIS), DTS

Reporting Tools: SQL Server Reporting Services 2012 (SSRS), SQL Server Reporting Services 2005 (SSRS), SQL Server Reporting Services 2000 (SSRS) and Crystal Reports 8.6

Tools: MS Visio 2010, IIS 7, Control-M 7.0, Microsoft Project 2010, TFS 2010, Visual Source Safe 6.0., SVN, PowerShell, Github

PROFESSIONAL EXPERIENCE:

Confidential

Email Marketing and Transactional Emails/ Programmer Analyst

Responsibilities:

• Work with project managers and businesses owners in collecting business requirements and implementing customer deduplication using MS SQL Server 2016 Database and Match IT tool.
• Developed incremental and full load jobs to pull the data from OMS/CMS and process it to Responsys.
• Developed packages to generate various feeds like prospectus list, product list and send it to Responsys.
• Developed packages to consume feeds like opt-outs, complaints from Responsys.
• Design and Developed Transactional Email processing.
• Automated the data archival process.
• Design and developed C# process to consume data from different vendors.
• Design and developed the process in C# to post data to Responsys.

Environment: SQL Server 2016, SSIS 2016 and C# 3.0.

Confidential

Global Analytics (GA)/ SQL Developer/BI Developer

Responsibilities:

• Work with project managers and analyst teams in collecting business requirements, implementing performance attribution and FI analytics reports using MS SQL Server 2012 Database.
• One of the lead developers that created a scalable SQL Server based Fixed Income Attribution System.
• Developed Fixed Income attribution engine to calculate Monthly, Month To Date (MTD) Attribution data; The systems included Classification, aggregation, calculation, approval, quality control, and reporting components.
• Involved in developing automated batch for overnight calculation and processing of equity accounts.
• Involved in the development of automated batch processing system with standardized QC subsystem in MS SQL. The optimized system improved performance and it is extendable, and allows us to auto approve accounts, saving analysts a significant amount of time.
• Developed Queue based system in SQL to process the portfolios/benchmarks in parallel to make the Fixed Income and Equity Performance Attribution reports available much earlier to end users.
• Applied table partitioning in the bigger tables and tuned various queries and improved the overnight batches performance significantly.
• Developed ETL framework (SSIS) to receive the various data like Holdings, Transactions, returns data from Heterogeneous sources; The system is built flexibly to handle multiple loaders, allowing each benchmark/portfolio its own individual data driven data source.
• Design SQL Database to collect and store analytics data from Data vendors MSCI, Factset, FTSE, MorningStar etc.
• Creates ETL (SSIS) solutions to distribute data to other business units.
• Developed Reporting Solutions (SSRS) for Dynamic Asset Allocation module and Migrating Equity and FI attribution reports from Crystal to SSRS.
• Involved in Migration of SQL Server 2000 to SQL Server 2005 and DTS packages to SSIS packages.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2012 and upgrade of SSIS.
• Involved in retiring legacy systems and involved in moving its data to SQL Server.
• Involved in creating and implementing the strategy for data archival.
• Designed and developed Account Maintenance module in ASP.NET and C#.
• Involved in designing and developing settings and report launching web pages.
• Involved in designing and developing in web services.
• Responsible for meeting the SLA of the FI batches and loaders that we receive from upstream.
• Developed test plans and scripts; performed testing for routine to complex processes to ensure proper system functioning.
• Worked closely with UAT Testers and End Users during system validation.

Environment: SQL Server 2012, SSIS 2012, SSRS 2012, T-SQL 2012, ASP.NET 3.0, C# 3.0, Asp, Control-M 7.0 and Crystal Reports 8.6.

Confidential

SQL Developer/Software Engineer

Responsibilities:

• Responsible for creating and maintaining database objects including tables, views, SQL Stored Procedures, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for developing SSIS packages to Extract, Transform and Load (ETL) data into the SQL database from various data sources inside the organization.
• Handling Performance Tuning and Optimization on SSIS and SQL Stored procedures,
• Develop and tune Microsoft SQL Server Integration Services (SSIS) packages and reporting services (SSRS) reports and models.
• Define, develop, and maintain reports written in SSRS utilizing SQL Server 2005
• Designing, developing and testing reports using SQL Server Reporting Services (SSRS).
• Providing technical assistance by responding to inquiries regarding errors, problems, or technical questions.
• Provided On-Call support to critical processes.
• Perform analysis, QA, implementation, and deployment tasks as part of the software development lifecycle.
• Provided Daily Status report, check list documents and weekly status reports to the Project Manager.
• Responsible for Level-2 Escalations pertaining to application.

Environment: SQL Server 2005, SSIS 2005 and SSRS.

Confidential

SQL Developer/BI Developer

Responsibilities:

• Design and develop the portals/reports needed as per the business requirement.
• Create ETL packages (SSIS) to Validate, Extract, Transform and Load data from various sources inside the organization and load it to Data Warehouse and Data Mart databases.
• Monitoring the OLAP Cubes and testing it.
• Write SQL stored procedures to move the data from Reporting Server to Archival server.
• Handling Performance Tuning and Optimization on SSIS and SQL Stored procedures.
• Writing stored procedures and views to retrieve the data from database to display in reports.
• Worked on SSRS reports which display Employees training progress and other attributes.
• Perform Data Validation, Data Integration and Backend/DB testing using SQL queries manually.
• Provide relevant test scenarios for the testing team. Work with test team to develop system integration test scripts and ensure the testing results correspond to the business expectations.
• Created Test input requirements and prepared the test data for data driven testing.

Environment: SQL Server 2005, SSIS 2005, SSRS, ASP.NET 2.0 and C# 2.0.

Confidential

SQL developer/BI Developer/.Net Developer

Responsibilities:

• Translated business user’s requirements into various documentation deliverables such as functional specifications, use cases, workflow / process diagrams, data flow / data model diagrams
• Responsible for developing DTS packages to Extract, Transform and Load (ETL) data into the SQL database from Teradata.
• Writing Teradata queries to pull required data from source and use it in DTS.
• Responsible for writing stored procedures to get the required data for the reports based on the user selections.
• Authoring various SSRS reports based on the user requirements.
• Writing stored procedures to do customize quality check for the incoming data.
• Enhanced end user understanding of the system by providing individual user training.
• Developed 16 SSRS reports which display various aspects of revenue.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.
• Created ASP.NET page with C# to bind SSRS reports.

Environment: SQL Server 2000, SSRS, DTS, ASP.NET and C#.

Confidential

SQL Developer/.Net Developer

Responsibilities:

• Understand each of the intranet sites using different databases and develop a strategy for up-gradation.
• Interacting with Onsite people, taking clarifications regarding applications.
• Analyzing the requirements and discussed with managers and leads on the functionality.
• Participate in Walk-through sessions with onsite people
• Write C# code for the application.
• Prepared the Test cases and test plan to test the application.
• Execute the test plan for each of the sites and fix the bugs.
• Work closely with Business users and operations teams to do UAT and get signoff.
• Write SQL queries to validate the data manually.
• Gathered and documented Use Cases, Business Rules, created and maintained Requirements.
• Created SQL views to display required information on user interface, and triggers to validate consistent data entry into the database

Environment: SQL Server 2000, C# and ASP.NET

Confidential

Junior SQL Developer/.Net Developer

• This project was worked for giving the client zero percent effort in managing the employees in various phases like recruitment, discipline, leave management, house allocation, performance assessment, awards and rewards.
• Effectively produce letters and reports at all the stages.
• Enforces authority level in all the stages and allow restricted access to the selected menus.