SUMMARY

• Over 5 years of experience with MS SQL technologies, including T - SQL, stored procedures, functions, views, prepared statements, and various OLTP schema and design patterns, and architecture paradigms.
• MS SQL and Server - installation, maintenance, architecture, optimization, debugging, migration, patching, upgrading, analysis, tuning, disaster recovery.
• Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Microsoft SQL Server 2005/2008/2012 and BI Suite for various Business domains.
• Application development experience: ASP.NET, C#.NET, AJAX, WCF, Web Services, LINQ, ADO.NET Entity Framework, Visual Studio, etc.
• Experience with SSAS, SSRS, SSIS, SSMS, Master Data Services, Data Integrity, etc.
• Expertise in Data Extraction, Transformation and Loading (ETL) using DTS package SQL Server Integration Services (SSIS) and experience in creating Jobs, Alerts, SQL Mail Agent, Scheduling SSIS packages.
• Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports and formatting them.
• Experience with various Business Intelligence technologies, including Power-BI, Tableau & Crystal Report
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
• Experience with fundamental web technologies including HTML, JavaScript, CSS, etc.
• Team player with excellent communication skills.
• Ability to explain technical concepts to non-technical people.

PROFESSIONAL EXPERIENCE

Database Developer/Informatics Advisor

Confidential, Baltimore, MD

Responsibilities:

• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Create, maintain, and optimize database stored procedures, functions, views, and prepared statements, for hundreds of sites over tens of thousands of pages, covering terabytes worth of data.
• Gathered business requirements and converted it into SQL stored procedures for database specific projects
• Created files, views, tables and data sets to support Grant Operations and Analytics teams
• Implemented SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Interacted with end users to understand the business requirements and implemented those in the interfaces.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Extensively worked with multiple databases i.e. SQL Server and Oracle for the migration of databases from old system to new system.
• Performed cleaning of data by analyzing to successfully migrate the existing data to new database.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Developed and maintained system documentation, diagrams and flowcharts.
• Automating and Daily monitoring of jobs, figuring out errors and solving any Blocking issues that arise

MS SQL SERVER Developer

Confidential - Washington, DC

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Produced operational reports in SSRS, drill-down, drill-through, dashboard and matrix reports.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed different Parameterized Reports, which consist of, report Criteria in various reports to minimize the report execution time and to limit the number of records required.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.

Confidential, Portland, OR

MS SQL SERVER/SSIS Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Built SSIS Packages for smooth running of Interfaces necessary for the new application.
• Created Configuration Files and implemented Error Handling to support the SSIS Packages.
• Deployed database objects and SSIS packages into production.
• Created Complex Stored Procedures, Triggers, Tables and other database objects for supporting the SSIS Packages and application.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked with multiple databases i.e. SQL Server and Oracle for the migration of databases from old system to new system.
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Assisted in setting up the new application on the application server and worked to implement LDAP and SSO for effective functioning of the application.
• Worked with project manager and technical leads for resolution of technical issues.

Confidential, Portland, OR

MS Business Intelligence Developer 

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database and OLAP as SSAS 2008 source
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Configured the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.