SUMMARY:

• Over all 10 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2016/2014/2012/2008 R2/2005.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures , Views , UDFs , Triggers
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Good experienced 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.
• Excellent experience in maintaining Batch Logging , Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel,, flat files, CSV, Teradata, Netezza using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Dashboards , Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global Variables, Parameters, Expressions and Functions for the business users using SSRS 2005/2008R2/2012
• Created Report Subscriptions, Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages .
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard .
• Extensive experience in providing BI reporting and development (T-SQL, SSIS, SSRS, SSAS, PL/SQL)
• In-depth knowledge of Business Intelligence Development processes and tools (SSMS, BIDS, Teradata, Netezza, MicroStrategy, Aginity Workbench)
• Proficient with MS Access, MS Excel, PowerPoint, T-SQL, PL/SQL and VB.Net scripts.
• Impeccable knowledge of emerging industry practices when solving business intelligence challenges
• Ability to express complex business concepts in technical terms
• Strong problem resolution skills, testing and debugging skills
• Excellent verbal and written communication skills
• Ability to successfully manage multiple task assignments
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skills and good team player with excellent team work skills.

TECHNICAL SKILLS:

Databases: MS SQL SERVER 2005/2008/2008 R 2/2012/2014/2016 , Teradata, Netezza, MS Access, Oracle

Database Tools: SSRS, MicroStrategy, SSIS, SQL Client, Management Studio, Aginity, TFS

Languages: T-SQL, PL/SQL, VB.NET, R, Python

Deployment/Scheduler: Continua, FinalBuilder, JAMS

PROFESSIONAL EXPERIENCE:

Lead Business Intelligence Developer

Confidential, Thousand Oaks, CA

• Automated various data deliveries and report production
• Designed and model tables, views and wrote stored procs to create ETLs and SSIS packages for automated loads for new projects.
• Collaborated with Model Execution teams and Analytics teams to process data end to end
• Automated complex reporting process to create SSRS reports as soon as data available
• Fixed production issues related to TSQL,SSRS, SSIS and SSAS
• Learned new models and approaches for mortgage loss analysis
• Learned Tableau and Python through office hours programs and applied the knowledge
• Engaged in business knowledge trainings such as compliance, AML and fed requirements for mortgage business.

Confidential, Boston, MA

Lead Business Intelligence Developer

• Created mapping documents of data fields for legacy system to new system as part of the migration process
• Mapped existing views to new system using mapping documents
• Lead effort to convert legacy ETL (SPs) to an incremental using SSIS that uses incremental loads, logging and deployment facilities while moving to new systems.
• Maintained TFS repositories in check and built code base deployment facilitates using Continua
• Automated schedules of ETL using JAMS scheduler
• Lead data gap analysis of complex source and included in the new architecture to report on
• Provided production support for data integrations and reporting team.
• Educated in MicroStrategy advance reporting, architecture and development methodologies and utilized in creating interactive dashboards.

Confidential

Sr. SQL Developer/ Reports developer

• Work directly with business users and analysts to understand reporting needs. Played an active role during the requirements gathering , analyzing and designing of the system.
• Responsible for developing and enhancing reports using SSRS and business functions.
• Working on reporting services, integration services and implementation of database design and functionality.
• Maintaining database availability and objects. Mantained existing reports and availability to users.
• Performed data analysis, reconciliation and technical support to end users.
• Involved with Query Optimization to increase the performance of the Report.
• Modified reports by applying standard formating to SSRS reports.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Applications
• Responsible to run existing ssis packages to load files from users.
• Loading data from multiple source locations like SQL Server, SFTP and Excel and Text files.
• Loading the Dimension and Fact tables using different SSIS tasks like Lookup, Merge Join, and Sort.
• Cleansing the data in Stage tables by writing stored procedures to remove duplicates, handling the NULLS, unknown values
• Moving the SSIS code to different environments like QA, Production.
• Expertise in SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart, Pie Chart reports to analyze critical data in SSRS.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Created SSRS reports to utilize Web Services directly into datasets.

Confidential, East Hartford, CT

AVP Risk Analysis Specialist

• Risk analysis specialist for global banking and markets. Provided detail reports at different levels and presented them in form of web portals, pdfs and subscriptions to business users.
• Gathered business requirement from users, documented and converted into technical logic to generate reports/dashboards using charts, graphs, subreports, matrix, KPIs, drilldown, drill through.
• Converted MS Access processes to SQL server and fully automated, deployed reports into pdfs, excel and PowerPoint from SSRS with organization standardized formats.
• Updated existing applications from SQL server 2005 to SQL server 2008 R2 and SQL server 2008R2 to SQL server 2012.
• Using provided requirements, extracted filtered data from legacy repository Teradata and loaded into SQL server 2008 R2 and SQL server 2012 using SSIS packages.
• Wrote and successfully used functions, stored procs, triggers and cursors to build robust and dynamic applications.
• Actively participated in unit testing and validation process during migration of legacy repository to new Netezza environment.
• Converted SQL applications to Netezza and automated them using SQL BI suit.
• Mentored colleagues on SSRS and SSIS techniques and helped to build automated applications which reduced significant amount of manual interventions and hours.
• Maintained, modified and updated projects under ownership throughout the lifecycle.

Contractor-Risk Analysis specialist

Confidential

• Extracted slice of data from Teradata and loaded into SQL server 2005 using SSIS packages.
• Created stored procedures, functions and views to populate the reports.
• Created reports using SSRS 2005 using tables, matrixes, charts.
• Scheduled reports subscriptions to run on monthly basis that writes reports to shared drives.
• Generated and scheduled Agent Jobs to run the whole applications automatically.
• Assisted team members with queries, SSRS and SSIS techniques.
• Generated scripts from SQL server 2005 and ported databases to SQL server 2008 R2.
• Upgraded reports and packages as well as applications to SQL server 2008 R2 from 2005.

Contractor-SQL Developer/Report Developer

Confidential

• Actively participated and interacted with users, DBAs and technical manager to fully understand the requirements of the system.
• Designed SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Lookup, Multicasting, Conditional Split, Derived column.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 R2 using Report Builder/Designer, T-SQL, scripts, stored procedures and views.
• Experience in creating reports using Report Model and applying row level security filters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008 R2.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Accessed reports in Report Manager and created subscriptions and deployed in production environment.
• Installation SQL Server 2005 with the latest service packs.
• Designed databases for different projects and resolved database issues.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Installed SQL server 2005 on windows 2000, applied service packs and security fixes.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Coordinating post-implementation events such as testing.

Confidential

IT intern/ Developer

• Gathered functional requirements and written the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Developed stored procedures, functions, views and triggers.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Combined unrelated Database Accesses to improve performance.
• Created and supported reporting team to generate reports using report builder.