SUMMARY

• Over 8 years of Excellent Experience as SQL Server Developer in Production, Development, Testing environments with various domains like Health Care, Financial, Insurance Telecommunications.
• Experience in SQL Server 2000/2005/2008 , SQL, T - SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS packages, and Oracle 9i/10 g, PL/SQL, SQL Plus, Oracle Developer 2000 Forms and Reports.
• Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation
• Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Ad-hoc reports using Business Objects.
• Good knowledge in working and implementation of Crystal Reports 8.0/9.0/10/Xi.
• Expertise in installing, designing, developing, maintaining and tuning of RDBMS like SQL 2008, 2005, 2000.
• Good working knowledge of Oracle and INFORMATICA Power Center.
• Good working knowledge of data base design and data modeling.
• Experience in writing complex SQL queries,Java, Stored Procedure and MDX queries.
• Experience with Production (24 X 7) and Development Environment.
• Experience in developing applications using .Net,VB.NET,SSIS.
• Experience with 2008 new concepts like Date Time data type, Transparent Data Encryption, Grouping sets, MERGE operator, Change Data Capture, GEOGRAPHY and GEOMETRY Data Types, Filtered Indexes, Data Profiling, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS)and SQL Server Analysis Services (SSAS).
• Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.
• Data modeling using Erwin Data Modeler and MS Visio.
• Experience with 2005 new concepts like data partitioning, online indexing, Data Definition Language (DDL) triggers, Dynamic Management views (DMV), Dynamic Management Functions (DMF), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Excellent experience of SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.
• Experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2005/2000 .
• Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using ERwin.
• Excellent skills in Log Shipping, Transactional, Snapshot Replication, Database Backup, Linked Servers, DTS.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs.

TECHNICAL SKILLS

Operating Systems: Windows 2003 / NT / XP/ME/9.X

Languages: C, C++,C#, T-SQL

Web Technologies: HTML,JSP, WML, XML

Databases: MS SQL SERVER 20 / 7.0, MS Access 2003

Packages: MS Office 2005, MS Visio, ERWIN, MATLAB

Testing: Win Runner, Load Runner

ETL tools: DTS, SSIS, SSAS, SSRS

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts,, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Senior SQL Server Developer

Responsibilities:

• Gathering user requirements for application to meet end Client specifications.
• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents.
• Design Test Plan, Test Strategies, Test Scripting and Traceability Matrix.
• Writing & debugging the SQL scripts.
• Prepare Automation Scripts using QA Automation Tool.
• Mentor less Experienced Team Members on needy basis on Best practices.
• Maintaining test script relationship and assigning Requirement id for ease of traceability.
• Make recommendations related to maximizing investment in existing test automation tools, identify report, escalate, monitor, and mitigate project and product risk.
• Perform a functional testing of Quickcomm/ Confidential products and perform a test script audit of all documented test scripts to make an assessment related to test coverage.
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Write Complex SQL queries for Data manipulation, insertion, deletion and updates.
• Review of the Code to verify the accuracy, standards and optimizing the queries and minimizing the page upload times.
• Provide Weekly status report to Client & Provide Reports on Test execution of the team.
• Support issue resolution for emergency fixes.
• Consult with key business users and subject matter experts to gather information about Reporting needs, objectives, functions, features, input and output requirements.
• Reviewing HLD documents created by the Business Analysts and Test Plan, Test Strategies& Traceability matrix for Reporting Solutions.
• Developing automated Testing tools using XML, SQL server automated testing tools using XML, SQL Server
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Perform Quality Assurance/Unit Testing before the developed rules and Database Objects moved to Production system.
• Provide assistance to business users to solve operating problems by recreating steps taken by them to locate the source of problem.
• Develop and execute test cases and test plans for Functional, Performance, Stress, and Regression testing needs.
• Create scripts for test cases. Test front-end user interfaces and make usability recommendations
• Review and provide feedback on project deliverables.
• Perform knowledge transfer to end users.
• Ensuring delivery of bug free code to User system and Support the field issues.

Confidential, NYC, NY

Senior SQL Server Developer

Responsibilities:

• SQL Server 2008 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSRS on SQL Server (2008).
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Created/managed configuration files in order to deploy SSIS packages in different environments.
• Support current production jobs by troubleshooting long running queries and optimize them to improve performance using different optimization techniques, DTA/ITW and Execution Plan.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created SSAS packages, OLAP cube, and multi-dimensional modeling on Terabytes Database, and worked in Designing and Building Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.
• Support current production jobs by troubleshooting long running queries and optimize them to improve performance using different optimization techniques, DTA/ITW and Execution Plan.
• Debugged and enhanced existing stored procedures for better performance gains.
• Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.
• Automate and Productionized manual jobs by creating SSIS packages and scheduling it through IBM TIVOLI job scheduler.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Re-architectured new database designs.
• Developed database tables satisfying the 3rd Normal form, and complying with referential integrities.

Environment: MS SQL Server 2008/2005/2000 , Database Tuning Advisory, IBM TIVOLI, PVCS, INFORMATICA Power Center 8.6.1, Oracle 10g, .NET, Visio 2003, MS Share Point, MS Excel, Windows Server 2003, UNIX, DB2.

Confidential, NYC, NY

Senior SQL Server Developer

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML to MS SQL Server by using BCP utility, SSIS services.
• SQL Server 2005 RDBMS database development including T-SQL programming.
• Expertise in designing B2B data Exchange platform using ETL process.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with slow changing dimensions.
• Developer developing web applications on n-tier architectures with ASP.NET MVC Framework.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSRS on SQL Server (2005).
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Experience in creating SSIS packages for XML based Business to Business Data exchange using different type’s task and with Error Handling and Reporting Capability.
• Used SQL profiler to identify the longest running MDX queries and modify them for best performance gain.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SSRS.
• Assisted and was involved in data modeling for different data marts for individual departments.
• Conduct conformed facts and data model review meetings and act as liaison between development teams and business stakeholders.
• Using SSRS, creating well-formed reports and web-based reports for Energy saving applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Expertise in designing ad-hoc reporting for different level of end user.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Configure the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated dynamic stored procedures, xml stored procedures, triggers for the database development.
• Fine tuned the complex database stored procedures and increase performance up to 7%.
• Experience in Database Tuning, Database Mirroring, Database Snapshots.
• Experience in creation of logins, users and configuring permissions and assigning roles to users
• Taking weekly database backup and schedules job using SQL Agent.
• Involved in Backing up and Restoring of databases.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Create joins and sub-queries for complex queries involving multiple tables.

Environment: Windows Server 2003/2008, SQL Server 2005/2008, ProClarity/PPS, Visual Studio 2005/2008, Multi Terabytes databases, MDX, ASP.NET MVC, SharePoint Server 2007, SharePoint Designer 2007, C#, ASP.NET, JavaScript,XML,XSD,X-query

Confidential, OH

MS SQL Server Developer

Responsibilities:

• SQL Server 2008 RDBMS database development using T-SQL programming, queries, Stored Procedures, Views.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.
• Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Design and develop the User controls by using VB.NET.
• Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
• Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cubes.
• Worked on deploying Cubes in SQL server management studio as well as created partition on that having process full for fact table and process update for dimension daily basis.

Environment: SQL Server 2008/2005, SSIS, SSAS, T-SQL, Crystal Reports,J2EE, Active X Script, VB.Net, MS-Excel, Visual Studio 2005, Windows NT scripting.

Confidential, Wilmington

MS SQL Server/ Oracle Developer

Responsibilities:

• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
• Developed database tables satisfying the 3rd Normal form, and complying with referential integrities.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Designed and coded reports using Oracle 10g. Designed and implemented reports using Oracle Reports Designer.
• Extensively worked on Query Studio and Report studio as report developer.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Designed and Developed parametric Reports, JavaScript, XML, XSD, X-query
• Cross-Tabbed and Sub-Reports in SSRS.
• Worked closely on database tuning, performance planning, backup planning and database administration.
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Generated reports using the Crystal Reports and Reporting Services.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints.
• Adhered to the Change Management procedures.

Environment: MS SQL Server 2008/2005,J2EE,ODBC, Oracle 9i/10g, Crystal Report, PL/SQL, Management Studio, SSIS, SSRS, Windows 2003, MS- Access 2003, JavaScript, XML, XSD, X-query.

Confidential

SQL Server Developer / BI Developer

Responsibilities:

• Involved in writing views, stored procedures and triggers.
• Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net revenue, forecasting.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing crystal reports.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Using DTS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Created DTS Package to transfer data from the Oracle source database.
• Scheduled the ETL Process using Jobs and Created Alerts to notify the status of the process.
• As a Production support person, monitored every day’s ETL Process, and fixed the data issues.
• Modified DTS to SSIS packages to accomplish critical business logic.
• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.
• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases

Environment: MS SQL Server 2005, T-SQL, DTS, SSIS, MS Visio 2000.