SUMMARY

• 5 years of experience in software domain as a MS SQL Server Developer including Business Intelligence (SSIS, SSRS,) with great analysis skills in Business.
• Extensive experience in Database design and development of applications using SQL Server 2005/2008/2012 , Management Studio, Business Intelligence Development Studio with Integration Services (SSIS), Reporting Services (SSRS).
• Expert in generating formatted SQL server Reports and skilled in handling sub reports, linked reports, drill - down and drill through reports in SSRS 2005/2008.
• Expertise in installation and configuration of database cluster/ High availability for SSIS (in SQL 2005 and SQL 2008 environments).
• Strongly experienced in defining Referenced relationships in SSAS.
• Experienced in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Extensively experienced in writing advanced SQL queries by using Joins, Indexes, Views, Stored Procedures and Triggers.
• Excellent Experience working with T-SQL and building OLTP/OLAP databases through conceptual ER Diagrams and Erwin.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in generating reports using SQL Server Reporting Services Crystal Reports, and MS Excel spreadsheets
• Experienced in Enterprise Data Modeling (Dimensional & Relational) with a solid understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, and fact and dimension tables modeling of data.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities(Data Warehouse, Data mart).
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Good Hands-on experience in writing scripts such as custom scripts, Java Scripts.
• Monitored, Optimized and Tune complex T-SQL scripts and Stored Procedures based on the execution plans and also using SQL Profiler and Database Tuning Advisor (DTA).
• Good Knowledge in Agile scrum software development framework and in V model of SDLC.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Developed Dashboard Reports using SSRS, Report Model and Ad Hoc Reporting using Report Builder.
• Knowledge in Job Scheduling, Replication, Performance Tuning, Normalization/De-normalization concepts, database design methodology.
• Good knowledge in java concepts.
• Strong team player with organizational and analytical skills.
• Excellent analysis, consulting and interpersonal skills.
• Excellence customer service skills and attention to detail.

PROFESSIONAL EXPERIENCE

Confidential, California, CA

Software Developer II

Responsibilities:

• Design, develop and deploy data movements using SQL Server Integration Services, TSQL and Stored Procedures.
• Collaborate with business analysts, subject matterexperts, and other team members to determine data extraction andtransformation requirements.
• Follow data standards, resolve data issues, completeunit testing and system documentation for data migration processes.
• Provide development, QA and production support to troubleshoot day-to-day data related issues
• Setup and manage tools for database monitoring, diagnostics, and performance optimization for the data migration efforts.
• Provide database infrastructure and architecture recommendations to admins supporting tactical and strategic business needs.
• Establish best practices for database design, data modeling, development lifecycle, and coding/scripting, and train/mentor development teams to follow best practices.
• Work with IT operations teams to troubleshoot ETL issues and optimize the database server environments.
• Partner with application and operations teams to establish and maintain standard operating procedures for data cleansing, data modelling and data migration.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager

Environment: MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services 2008 R2/2012, MS SQL Server Integration Services 2008 R2/2012, MS Visual Studio 2008, MS Visual Studio 2010, Oracle 10G, Team Foundation Server 2012, MS Visio, MS Office, HIPAA

Confidential, Grapevine, TX

MS SQL Server Developer

Responsibilities:

• Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP
• Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, and Log Providers etc.
• Extensively involved in using SSIS tools like Import and Export Wizard for developing the packages.
• Involved in writing T-SQL stored procedures, views, triggers, cursors.
• Wrote SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Created tables, views, users, logins, indexes (indices), check constraints, and business rules using T-SQL and maintained databases.
• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Extensively Involved in Preparing Detailed Technical Documents from the Functional Specifications.
• Governed and maintained performance and analysis of the customers billing information in the form of reports using SSRS.
• Implemented conditional formatting using reporting services.
• Developed, Prepared Unit Test documents for all SSRS reports.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Used SQL Profiler for debugging issue, performance tuning whenever necessary.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008 R2/2008, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Microsoft Visual Studio 2010

Confidential

SQL Developer

Responsibilities:

• Studied and analyzed the Functional Requirement Specifications, System Design specifications and interacted with analysts for changes in requirements if any.
• Developed an independent component for data access, which can be used as generic component for every project. This component generates parameters from stored procedures dynamically and used some overload functions for executing Queries, which ensures the complete N-Tier architecture.
• Develop various stored procedures using MS SQL server 2005.
• Fix issues related to front end and database design.
• Client side and server side validations for all the data entered.
• Document all the technical requirements and user manuals for the applications developed.
• Design the front end according to client specifications.
• Used ADO.NET to connect to backend database SQL Server.
• Testing, bug tracking & regression testing after Fix is promoted to test environments & involved in build/release and also using Visual Source Safe for code security.
• Fix hot issues with the application

Environment: ASP.NET, C#, ADO.NET, T-SQL, SQL Server 2000, and Microsoft Visual Studio 2005.