PROFILE SUMMARY:

• 4.5+ years of MS SQL Server Developer experience in various domains with expertise in MS SQL Server 2008/2005/2000 suite of products like SSRS and SSIS.
• Highly proficient in SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experience in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2005/2008.
• Having knowledge and experience in creating, managing and deploying reports using SSRS 2005/2008.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Project implementation experience using programming skills in Java and Visual Basic.net.
• Hands on experience in web designing using HTML, XML and JavaScript.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Excellent PC skills. (MS –Office tools and Windows)
• Strong Analytical, Problem Solving, multi-tasking abilities, Interpersonal and Communication Skills.

EDUCATION:  

Master of Science in Computer Engineering                                           
Bachelor of Science in Computer Engineering         

TECHNICAL SKILLS:

Programming Languages:CoreJava, VB6.0, C++, .Net.
Web Technologies:JSP, XML, HTML, Java Script.
Database Technologies:Oracle 10 gl, SQL Server 2000/2005/2008, MS Access.
Database Language:FoxPro, T-SQL and PLSQL.
Operating Systems:Windows Server 98/NT/ XP/ Vista.

WORK EXPERIENCE

Confidential, NYC, NY, March 2011 – Present
(NYC Bureau of Environmental Surveillance and Policy)
MS SQL Server Developer, SSRS Developer

Confidential, is the government health department which conducts unannounced inspections of NYC 24,000 restaurants at least once a year. Inspectors check for compliance in food handling, food temperature, personal hygiene and vermin control. Each violation of a regulation earns a certain number of points. The objective of the project is to get the data from various sources into the data warehouse and then creating the reports for users. Reports execute the stored procedures written in T-sql.

Responsibilities:

• Interact with analysts and users to gather the requirement.
• Create the documentation for the business requirements and query definitions.
• Create complex T-sql stored procedures, views, indexes and functions in Sql Server 2008.
• Analyze the data for requirement specifications.
• Remodeling of existing queries for the modifications in business rules.
• Optimize the performance of stored procedures by removing unnecessary columns, and eliminated redundant and inconsistent data, creating indexes.
• Involve in unit testing to test the data resulted from stored procedures.
• Defined the report layout and identified Datasets for the report generation in report builder 2.0.
• Created different type of reports including Cross-tab, Conditional, Drill-down, charts.
• Created date and entity based parameterized report for detail summary with advanced reporting features.
• Create SAS datasets by migrating the data from SQL Server and analyze the data.
• Created SSIS packages to migrate the data into data warehouse.

Project Environment: SQL Server 2008 R2, Microsoft Visual Studio, Sql Server Management Studio, Report Builder 2.0, SAS.

Confidential, BOSTON, MA, May. 2010-Nov.2010
MS SQL Server/SSIS/SSRS Developer

Confidential, is one of the nation's leading oral health companies. The main objective of the project was to collect data from various database sources to perform analysis and then integrate them with the existing systems using SSIS (ETL) and creating reports in SSRS. Then to test the data for quality assurance.

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Translated requirements, designs and functional specs into effective test plans and test cases.
• Used SSIS and T-SQL stored procedures to migrate data from various Claims processing (Mainframe), providers (Oracle), and Members (Access) databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed SSIS data transfers packages to the appropriate destinations.
• Tune various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created SQL server dynamic configurationsforSSISpackages.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Used BCP to transfer the data files to other server.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for creating parameterized and drill down reports based on the requirements using SSRS 2008.
• Modified the existing ERD's to insert more tables, columns and constraints using MS Visio 2008 for more refined data models.
• Used TFS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Project Environment:
MS SQL Server 2008, SQL server Integration Services 2008, SQL Reporting Services 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio,  MS Excel, T-SQL, Visio.

Confidential, DELHI, INDIA, Aug. 2006- Dec. 2007
SQL Server Developer/ SSIS Developer                                                                        

Confidential, is India's largestconsultancycompany with large consolidated revenues. It provides the solutions for IT services, business solutions and outsourcing company. The project was to create packages for loading data into data warehouse and to create T-SQL objects.

• Worked with Business Analyst to gather requirements and created functional specification and mapping documents.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Normalized the database up to third normal form.
• Developed source to target specifications for packages and created complex package that further calls different packages.
• Developed Procedures, functions, views and also triggers for automation.
• Developed stored procedures to transform the transactional data warehouse to build dimensions and load data to fact tables.   
• Performance tuning to optimize SQL queries using query analyzer.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Created indexes, Constraints and rules on database objects for optimization.

Project Environment:
MS SQL Server 2005, Microsoft Visual Studio, SQL Server Management Studio, T-SQL.

Confidential, INDIA Jul. 2005-Jul.2006
Software Developer (Internship)                         

Confidential, is a Research & Development institution for design, development and deployment of world class IT and electronics solutions for economic and human advancements.

• Worked on live project titled HMS (Hospital Management System).
• Conducted requirements gathering with all other modules, developed Use cases.
• Performed Database design, Data modeling (ERD), and Database Normalization
• Assisted with project scope formulation, time line and schedule development
• Designed GUI using JSP and HTMLfor web pages and connected to Oracle 8i database using JDBC bridge

Confidential, INDIA, Jun. 2004 – Nov. 2004
 Intern                                                                                                                                           

• Designed and developed Project "Courier Service Management System" utilizing Visual Basic.
• Designed Procedures using PL/SQL for retrieving and storing customer's information.
• Supported team members to complete all project related tasks, such as coding, testing, and bug tracking

MASTERS COURSE PROJECT: Jan. 2008- Dec. 2009

• Designed GUI using C#.net and HTML for Administrator and Customer web pages in Project "Toyota Car Wholesale" using Distributed System architecture and collaborating different databases.
• Designed Procedures using SQL server 2008 for retrieving and storing car dealers' information.
• Provided authenticated and secured access to Oracle database storing Dealers and customer Information.
• Architected the project using UML tools for case diagrams in waterfall model.
• Designed "Crap Game" using VB.net application.
• Performed Database design and Normalization for project "Requisition system".
• Built a Chat Server using the Client- server socket programming in Java.
• Built the Project "Numbers with Numerology" using Front end as VB.net and Back end as SQL Server 2008.

PAPERS:

• Presented paper on database driven web applications (XSQL) in summer 2009.
• Wrote Term Paper on Optimization of Database and Loading Process.

HONORS:

• Worked as Graduate Assistant in NYIT in Computer Lab for three semesters (Sept.2008 – Dec. 2009).
• Teaching assistant in Department of computer science ( Sept 2009 – Dec 2009)

Relevant Coursework: Database Design, Distributed Systems, Programming Languages, Automata Theory, Compiler Design, Software Engineering, Secure Software Engineering, Computer Architecture, Algorithm Concepts, Data structures, System Programming.