SUMMARY

• Over 8+ years of IT experience in Database Design, Development and Administration with MS SQL Server 2014,2012, 2008, 2005 and Oracle11g/10g database technologies.
• Expert in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008 R 2/2008/2005/2000 databases.
• Expert in Database designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T - SQL Scripts in MS SQL 2005/2008.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions (UDF’s) and other T-SQL (DDL, DML) statements for various applications.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005 for integrating data between heterogeneous sources (SQL Server, Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, fuzzy Lookup and Union all.
• Expert in Database performance tuning and Query optimization using SQL Profiler, Database engine tuning advisor and managing the indexes.
• Proficient in writing distributed queries between SQL Servers by creating linked servers.
• Expert in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary Key and Foreign Key concepts.
• Experienced in working with BCP utilities, DTS and SSIS in the process of designing and maintaining Data Warehouse and Transactional systems.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Expert in implementing different types of Replication models such as Snapshot, Merge and Transactional replication.
• Extensive experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS.
• Experience in writing business objects and data access using C# and T-SQL
• Expert in managing version control using source control tools like Visual Source Safe, Team Foundation Server to maintain code changes.
• Excellent in Software development methodologies such as Agile, RUP (Rational Unified Process), SCRUM, Test Driven Methodologies.
• Closely collaborated with team members to ensure the productivity of the system.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2005/2008/2008 R/2012/2014, Oracle 8i/9i.

Data warehouse tools: OLAP, SSAS,SSRS, SSIS,DTS, and SAP BI.

Data Modeling and ETL tools: ERWIN, Microsoft Entity Framework, MS Visio.

Languages: C#, T-SQL, VB, ORACLE 8i, HTML, XML.

MS Technologies: .NET framework 2.0/3.0/3.5, MS Access, MS Share Point.

Methodologies: Business analysis, Object- oriented Analysis, Database designand Normalization, Data modeling, Code Specifications, andVSS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

MS SQL Server Developer

Responsibilities:

• Worked on REO (Real estate owned) department deals in Property foreclosure.
• Create new tables regarding property condition, location and status including other related details for which data was imported from a flat file to SQL.
• Updated the existing SQL tables with new data regarding addition in new zip codes, current status in market and property value.
• Created various internal and external SSRS reports as per requests including reports about from city violations, open cases/close cases, to current property status(sold/vacant/occupied/eviction/redemption etc.).
• Created jobs using SQL Server Agent Job to automated processes for the activities such as database backup processes and SSIS and SSRS packages run sequentially.
• Developed stored procedures and queries for generating reports such as drill down reports, drill through reports, parameterized reports etc. and used Report Manager to deploy the reports to production server.
• Prepared Ad-hoc report through report builder.
• Created custom report templates using SSRS, providing consistency of the report throughout the organization.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Developed T-SQL queries, functions, cursors, triggers and stored procedures to generate XML files, based on requirement specifications.
• Developed SSIS packages to convert XML files into flat files, to upload the generated flat files to FTP server and to download the flat files from FTP server to local server.
• Used XML marker, a XML reader tool, to view the flat file in proper format.
• Designed and developed data structure to provide mapping between two databases and defined primary key, foreign key.
• Designed entity relationship diagrams showing foreign key relationship between tables using SSMS database diagrams.
• Created SSIS packages to load data from ASCII text compressed flat files to staging tables. Also package used stored procedure to load data from staging table to respected tables in ODS database.
• Used Team Foundation Server to load database, Report and SSIS Packages.

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SQL Compare 10 Database Tool, XML Marker, SQL Server Management studio (SSMS),TFS, MS Excel, MS Visio.

Confidential, Philadelphia, PA

MS SQL Server Developer

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Database planning in relation to physical and logical data architecture.
• Worked on Extraction and Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, and BCP &Bulk Insert utilities.
• Worked on deploying and managing various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats like (PDF, Excel) and resolved formatting issues.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats like (PDF, Excel) and resolved formatting issues.
• Involved in preparing document for application development and QA/UAT teams.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Designed SSIS Packages to extract transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team. Expert in database activities like database creation and maintenance, performance monitoring, tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Developed high Level Design of Package (SSIS) in MS SQL Server 2012 for integrating data from heterogeneous sources (Excel, CSV, Oracle, and flat file, Text Format Data).
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle, and XML in order to create and maintain a centralized data warehouse.
• Developed SSIS packages to load the data from the various databases environments like Lotus, Oracle.
• Built numerous C# UI components and business modules.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), C#, NET Framework 4.0, Crystal Reports, BIDS, Visual Studio 2010, MS Visio 11.0.

Confidential, Los Angeles, CA

MS SQL Server/SSIS Developer

Responsibilities:

• Deploying new Database objects in production environment.
• Development tasks included coding numerous C# business components and ASP.Net web pages, scheming data models, and enhancing the software in a highly dynamic environment.
• Created drilldown. Drill through, parameterized reports using Ms SQL Serve Reporting Services 2008 (SSRS) to represent the data to the business users.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Designed, Developed, tested and Deployed SSIS packages on Development, Test and Production Environment.
• Implemented SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Designed complex SQL Server Analysis services (SSAS) solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Writing Stored Procedures, Triggers, and Cursors and creating indexes.
• Migrated enterprise reports from SQL Server 2005 to SQL Server 2008 with redesigning while improving the visibility, performance and automation of the reports.
• Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.
• Performed unit integration and functional testing of the SSIS packages, T-SQL and Stored procedures.
• Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs. Troubleshot ODBC driver issues used for migration of data from the Top Speed database to SQL Server 2008.
• Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/SSIS packages.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Provided on - call 24/7 support.

Environment: SQL Server 2008 Enterprise Edition, SQL, Enterprise Manager, T-SQL, ERWIN 4.0, XML, C#, NET Framework 3.5,MS PowerPoint, MS Project & Windows 2003 server.

Confidential, Pennington, NJ

MS SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using MS Visio.
• Coded numerous interface based business and data access objects using C#, T-SQL
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Developed and maintained many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output and deploying it on SharePoint 2007 and in .net intranet applications for internal Investment clients.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc. to extract, transfer and load (ETL) data from OLTP to OLAP databases.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Developed all the required Stored Procedures, user defined functions, triggers, views using T-SQL as per business logic which were used to support .net Investment application for customers.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats like (PDF, Excel) and resolved formatting issues.
• Optimized the performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Performed daily tasks including backup and restore by using SQL Server 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, VSS 2005, MS Visio 11.0, Windows NT/2003, C#,Microsoft .NET framework 3.5.

Confidential, Dallas, TX

MS SQL Server BI Developer

Responsibilities:

• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Optimized the performance of queries with modifications in T-SQL queries.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Created SQL Server Reports using SSRS for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Created SSIS packages to migrate data from Oracle 8i, MS SQL 2005 to MS SQL Server 2008.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
• Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
• Worked on Authoring Reports and managing reporting services.
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS
• Generated Chart-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Generated reports using Expressions and Functions using SSRS.

Environment: MS SQL Server 2005, SQL Server 2005, SSRS, SSIS, SSAS, T-SQL, C#, NET Framework 3.5,MS-Excel, XML, Windows 2003/NT/XP.7

Confidential, Los Angeles, CA

SQL Server Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2005 on Database Servers.
• Applied patches and service packs to keep the database at current patch level.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Going through the clients' requirements and coming up with database design and application architecture.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.

Environment: SQL server 2005, DTS, T-SQL, Crystal reports 7, Windows 2000 server, .Net programming, VSS 4.0