SUMMARY

• Over 8 years of IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.a
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2000/20 R2 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.
• Experience in Error handling and debugging, Normalizing and De - normalizing.
• Extensive noledge of normalization and relational database management systems.
• Proficient in Logical and Physical database design & development (using normalization, dimension modeling, Data Modeling and SQL Server Enterprise manager).
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expertise in Analyzing Query Plans, Using Extended Stored Procedures, Managing Indexes and Locks, Troubleshooting Deadlocks.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Working noledge in .net technologies ASP.NET, C#.
• Expertise in creating Reports with complex formulas and to query the database for business Intelligence using SSRS.
• Proficiency in creating different types of reports such as Table Reports, Cross-Tab, List Reports, Conditional, Pie Chart Reports, Drill-down, Drill through reports, Group reports, sub-group reports, Adjacent group reports, Total Reports, Sub-total Reports, Grand Total Reports.
• Expertise in Integrated SQL Server Reports with SQL database using views and stored procedures.
• Expertise in developing Reports like Standard parameter Reports, cascading Reports for each and every Departments.
• Experience in developing ad-hoc reports using Report Builder.
• Extensive noledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experienced using in FTP and SFTP servers to upload files.
• Extensively worked in creating and integrating Micro strategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, etc) with the data warehouse.
• Created and maintained Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2005/2008 Dashboards / Reports.
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 R2.
• Good Knowledge in Physical and Logical Data Modeling.
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.
• Excellent professional written and verbal communication and interpersonal skills. Proficient in technical writing and presentations.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

Languages: T-SQL, PL/SQL, C# .Net, ASP.Net, XML, HTML, Java Script

Tools: /Utilities SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * PlusDatabases MS SQL Server 2005/2008 R2, Oracle10g/9i, MS Access, MySQL

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

SQL Server BI Developer/SSIS

Responsibilities:

• Involved in the completeSoftware Development Life Cycleincluding Analysis, Design, Implementation, Testing and Maintenance.
• Developed SQL Server 2008 R2 Databases objects i.e. Tables, Views, Indexes, Stored procedures and Triggers
• Designing and building data load stored procedures, using MS SQL Server.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Written Queries usingT-SQLStatements,Views, User Defined Functions, Stored Procedures,TriggersinSQL Server 2008 R2 for inserting/Updating/Deleting the data into the relational tables.
• Has hands on experience integrating Web Applications with SQL Stored Procedures by using SQL Server 2008 R2.
• Worked on ADO.NET objects like Data Sets, Data Readers to access database.
• Used stored procedures and views for all of the ASP.NET web applications.
• Design and Build Extract Transform Load processes using SQL Server Integration Services and created the packages to import/export data feeds to/from data warehouse and legacy systems.
• Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources
• Experience in Report Builder in SSRS 2012 and 2008.
• Created the SQL server users and file server users with required permissions by including them in the scripts.
• Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts
• Involved in re-design, re-code, and deploy new data extractions using SQL Server Integration Services, and designed and produced documentation of data transformations for all extractions.
• Fine-tuned the Stored Procedures, Functions and Views for optimum performance.
• Used SQL Profiler and Estimated Execution Plan to optimize queries and Stored Procedures.
• Created SSIS packages for data load and transfer to and from various data sources like SQL Server, Netezza and IBM DB2.
• Scheduling SSIS package Jobs from SQL Agent.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Performed maintenance tasks which includes backup / restore by using SQL Server 2008 R2 using SQL Server Management Studio and SQL Server Profiler.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Preparing Dashboards using calculations, parameters in Tableau.
• Worked on various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, and Parameters etc., in Tableau.

Environment: Microsoft SQL Server 2012/2008 R2, SSIS, T-SQL, MS-Excel, Windows 7, VS Business Intelligence Tool, SSIS, SSRS,SSAS,TFS, SharePoint, Tableau, SQL Data Examiner, IBM DB2 10.1,ASP.NET,C#.

Confidential, Dover, DE

SQL server BI Developer

Responsibilities:

• Created SSIS packages for transferring data from various data sources like Oracle, MySql, Excel, *.Txt file, *.CSV files.
• Involved in database designing using Normalization.
• Exported reports to various formats like PDF, Word and Excel.
• Involved in security and user role assignment to different reports.
• Developed C# scripting for packages.
• Used ADO.NET for SQL Server database interactions using Data Adaptors, Data Reader and Dataset.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases.
• Migrated databases from SQL Server 2005 to SQL Server 2008. Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL using Business Intelligence development studio.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Developed MDX Queries against SSAS cubes to generate reports.
• Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for creating batch files and scheduling the jobs.
• Experienced in analyzing the Dashboards, including Action Items, KPI’s.
• Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Involved in preparing detailed technical documents.

Environment: MS SQL Server 2008,C#,ASP.NET, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Erwin Data Modeller 7.2, Windows Sever 2000/2003/2008 R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential, Lisle, IL

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Involved in the tuning of the existing Database Objects.
• The task involved writing a lot of TSQL Code, including use of complicated joins and cursor loops.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various Web applications, maintained referential integrity and implemented complex business logic.
• Involved in translating business requirements into technical design specifications.
• Involved in managing data sources from other sources to SQL Server.
• Designed and deployed various complex reports using MS Reporting Services.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created and generated reports to display data.
• Used Query Profiler to optimize SQL queries.
• Managing the Clustered environment databases and was fixing the errors when they arose.
• Involved in execution and creation of SSIS packages using Business Intelligence Development Studio
• Involved in Deployment and Administration on SSIS packages
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Loaded data from flat files into SQL Server 2008.
• Developed and executed several optimized queries in SQL.
• Setup and installation of databases including test, development environments
• Involved in DBA activities such as Backup, Recovery, Performance tuning and User administration
• Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Query Analyzer.
• Fine tuning of database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008, Windows 2000/2003/NT/XP, SQL Server Integration Services (SSIS), T-SQL, Enterprise Manager, Query Analyzer, MS Access 2003, MS Excel 2003, Visual Source Safe 2005 and MS Reporting Services.

Confidential

SQL Server Developer.

Responsibilities:

• Requirement gathering - Solution design.
• Involved in installing and configuring SQL Server 2005 on development server for designing and testing.
• Created rules, defaults, tables, views, clustered & non-clustered indexes, user defined data types, and user defined functions, triggers, stored procedures for the data consistency and to avoid duplication.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Develop, review, and optimize queries for data retrieval and update.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup and restoration and monitor the performance of Database Server.

Environment: MS SQL Server 2005, T-SQL, SQL Server Enterprise Manager, Excel, DataImport, DBMS.

Confidential

Junior SQL Developer

Responsibilities:

• Responsible for creating Databases, Tables, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Conversion / Migration of SQL Server 2005 to SQL Server 2008.
• Responsible for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created new database objects like Procedures, Functions, Packages, Triggers, Queries, Indexes and Views using T-SQL in Development and Production environment.
• Used script task, Script Component, lookup, control flow tasks like FTP, Bulk Insert Task, Transfer Job Task etc.

Environment: SQL Server 2000/2005/2008 , Enterprise Edition, SQL, Enterprise manager, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, Oracle.