SUMMARY

• Over 8+ years of experience as Microsoft BI developer, database developer and data analystwith Microsoft SQL Server 2012/2008 R2/2008/2005, SSIS/SSRS/SSAS,OLTP, and OLAP (Different environment such as Production, UAT, and development) in various domain.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Expert in designing (development) and deployment of SSIS package from various sources like MS access, oracle,BD2,excel, Microsoft sequel server, flat file, and XML.
• Proficient in performing various SSIS data transformation task such as Look - ups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Spilt, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.
• Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
• Expert in creating various types ofcomplex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Expert in Designing and deploying reports on the portal as per the end user requests using web interface and report manager.
• Experienced in reporting services configuration manager to configure and maintain Report Manager, Report server, Send emails to the end user, and Scheduling reports.
• Expert in web development using HTML, CSS, Java Script, AJAX and ColdFuison to display the reports on the web interface.
• Very Good experience in Creating OLAP cubes,Drill Down reports and Sub Reports using SSAS SQL server analysis Services.
• Proficient in Data mining models, deploying and Processing SSAS objects.
• Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Start Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.
• Proficient with T-SQL (DDL, DML, DCL, and TCL) in implementing Complex Stored Procedure, Indexes, Views, Table Variables, Triggers, Nested Queries, Joins, Cursors, and user and system defined functions
• Good knowledge of Team Foundation Server, Crystal Reports, and Share Point.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans
• Excellent understanding of Normalization/De-normalization, Normal Form and database design methodology. Expertise in using data modeling tool like MS Visio, Bizagi, Visual Paradigm for logical and physical design of database.
• Skilled in designing logical and physical data modeling using Visual Paradigm and Bizagi data modeling tool.
• Experience in developing web applications using ASP.Net, ADO.Net and Web Services Involved in 24/7 production support and also experienced in testing environment.
• Worked with Business Analysts, Web development team, and users on database solutions
• Expert with different phase of project life cycle (analysis, design, implementation, testing, and debugging new/existing client-server based applications.
• Strong communication, management, and team player capabilities.
• Excellent problem solving, multitasking, business analytical, and critical thinking with the ability to work on fast based environment.
• Good Knowledge of implementing iterative Software Development Life Cycle (SDLC) using Rational Unified Process (RUP), agile, waterfall, Extreme Programming (XP), and Scrum.
• Working Knowledge of .Net Framework 2.0 (VB.NET and C#.NET), ISS 6.0 and 7.0.

TECHNICAL SKILLS

Modeling Tool: ERWin, MS Visio, Visual Paradigm, Bizagi

Methodologies: SDLC Waterfall, RUP (Rational Unified Process),XP (Extreme programming), Cost/Benefit, Scrum, Agile methodology.

BI Tool: SSIS, SSAS, SSRS, Report Builder 2.0/3.0, Tableau

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQLServer Business Intelligent studio (BIDS), TOAD for Oracle.

GUI /Tools: Lotus Notes, MS Word, MS Excel, MS PowerPoint, MS Project, SAS.

Database & Query Tools: SQL Server 2012/2008/R2/2005, Oracle 11g/10g, TOAD for Oracle,MS Access.

Markup Language: XML, HTML, java script, Web services, CSS, AJAX, ColdFusion.

Defect Tracking/ Testing: Load Runner, Win Runner, Quick Test Pro (QTP), Quality Centre (QC).

Operating Systems: DOS 6.22, Windows 98/95, Windows XP, UNIX, Windows 2007.

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

SQL Server BI Developer

Responsibilities:

• Gathered end users requirements, Developed Logical Model, and implemented requirements using SQL server 2012/2008 R2.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks.
• Performed Data Analysis and Data Profiling using complex SQL on various source system including Oracle and Teradata.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks
• Worked closely with project stakeholder and staff to understand requirement specifications new applications and redesigning existing applications.
• Created Technical Piece of SRS (Software Requirement Specification) Document.
• Prepared project Progress Report and Status Reports and submitted it to upper management on weekly basis.
• Created Data Flow Diagram (DFD) and Flow Charts to display the flow of information in the new system.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Developed web-applications using ASP.NET MVC, C#, AJAX&JQuery.
• Used PowerShell for DevOps in Windows-based systems.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
• Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
• Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2012/2008 R2.
• Developed SSAS Cubes from scratch.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions.
• Designed and implemented parameterized, drill-through, drill-down, and tabular reports using SSRS.
• Developed crossed reports, sub-reports and matrix in SSRS.
• Created complex queries to build the dataset required for developing the SSRS reports.
• Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more user friendly.
• Displayed reports in Webpages using Coldfusion, JavaScript and AJAX.
• Provided 2 weeks training as a part of knowledge transfer on SSRS and SSIS to the client in order to modify existing and develop their own ad-hoc reports and SSIS package.
• Designed, developed and implemented database systems and Store Procedures based on Client requirements.
• Involved in database Schema Design, development and executed store procedures Using Batch files.
• Worked closely on Coldfusion administrator to establish connections with databases.
• Created and established user friendly website in IIS 7.0 to access reports in all production, Testing and Development servers.
• Implemented the project using Agile methodology.

Environment: s: SQL Server 2012/2008 R2, T-SQL, Windows 7, SSRS, SSAS, SSIS, Coldfusion, Jeera Dashboard, MS Visio

Confidential, Charlotte, NC

SQL Server Developer/BI Developer

Responsibilities:

• Developed use cases from requirements and created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams.
• Created Data Flow diagrams and flow charts to display the flow of information in the system and make users understand the functionalities.
• Worked with design and admin team to design physical database and its modifications.
• Responsible for project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Performed Data Analysis and Data profiling using SQL on various sources.
• Developed the application using Visual Studio 2010 with C# to display timesheet and generate reports.
• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, Configuring optimizations and securing the web application.
• Worked within the Cloud for integration processes.
• Performed DevOps for Linux Mac and Windows platforms.
• Created ETL SSIS packages both design and code to process data to client databases.
• Created SSIS template for developing SSIS packages to dynamically deploy the packages into the development, Testing, and production environments.
• Designed and developed SSAS cubes, fact and dimensional table using dimensional data modeling standards using SSAS.
• Created different format of the reports using SSRS as per the end user and business requirements.
• Worked on Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed system testing for the SSIS packages and SSRS reports.
• Used Notification services to generate error messages and notify users through e-mails.
• Design, develop and implement database systems and store procedures based on client requirements.
• Optimize database systems for performance efficiency.
• Ensure data quality and integrity in databases by DBCC command.
• Designed physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for warehouse system.
• Worked on DBA task such as providing access, established ODBC connection.

Environment: s: SQL Server 2008 R2, T-SQL, Windows 7, SSRS, SSAS, SSIS, UML, Visio

Confidential, MOUNTAIN VIEW, CA

SQL/BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Documentation of developed BI solution as a part of knowledge transformation.
• Analysis of business requirement and various source systems for data and metadata information.
• Responsible for preparing technical specification based on functional requirement.
• Prepared unit test cases based on functional and technical specifications.
• Developed Web forms using C# and ASP.NET
• Implemented and executed SSIS 2008 packages to import/export data from the different source to perform the ETL process.
• Used different SSIS transformations such as RecordSet destination, ForEach Loop container, Multicast Transformation,DerivedColumn Transformation to create new column, ConditionalSplit Transformation to split data flow using Business Intelligence Development Studio (BIDS).
• Created SSIS package which implements DataProfiling using SSIS Expressions, Variables, Expressions and SQL Server based Package configurations
• Modified the existing SSIS packages to increase the performance of the packages.
• Created and modified the existing SSRS reports based on T-SQL using Business Intelligence Development studio (BIDS).
• Used and defined reportsParameters, created ParameterCascading to populate sub-reports,drill down reports, and drill through reports.
• Created PerformancePoint based Dashboards having WebParts of SSRS Report, Pie Chart, Funnel Chart, and bar charts.
• Reviewed, performed unit andsystem testing, and fixed bugs for SSIS package, and reports using SQL 2008 Business Intelligence Development studios.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Created/wrotestore procedure, functions, views, index to handle database automation task.
• Developed Database structures, store procedures, DDL triggers and user definedfunctions tooptimize the database performances.

Environment: s: SQL Server 2008 R2, MS ACCESS, Oracle 10g, T-SQL, Windows 7, SSRS, SSAS, SSIS.

Confidential, Houston, TX

SQL Developer/Business Analyst/SSRS

Responsibilities:

• Gathered requirements and preparedbusiness requirement documents (BRD).
• Developed and maintained all operational and technical flows using Visio and Power point.
• Working closely with the Senior Management to understand their requirements and maintain and enhance the database accordingly.
• Taking weekly export of the database and preparing reports, graphs and charts in SSRS.
• Troubleshoot database related issues in a timely manner.
• Ensure data quality and integrity in database using DBCC command.
• Design of the database and tables.
• Involved in ER diagrams and mapping the data into database objects.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Maintained database performance such as tuning, backup, restoration and disaster recovery.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Built table relationships and wrote stored procedures to clean the existing data.
• Provide support in handling faults and issues.
• Maintenance and enhancement of the production database.
• Responsible for translating business requirement document (BRD) intofunctional specifications and test plans.
• Performed Regression Testing and created test scenarios for User Acceptance Testing (UAT)

Environment: s: SQL Server 2008, MS access, DB2 T-SQL, Windows XP

Confidential

SQL/BI Developer/ DBA

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database. Performed basic DBA activities like Backup and Restore.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Developed report specifications, created and modified reports using SSRS 2005.
• Scheduled reports and exported in PDF, Word and Excel format.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with SSIS and also prepared ETLmappingprocesses and maintained the mapping documents.
• Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and OLAP databases.
• Identified slow running query and optimization of storedprocedures and performed testing on applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.

Environment: s: SQL Server 2005, Oracle10g, DB2, MS Access, Excel T-SQL, Windows XP

Confidential

SQL Developer/ DBA/ Business Analyst

Responsibilities:

• Documented the project works and process.
• Attended Weekly and daily Status Meeting.
• Prepared Daily and weekly dashboard, prepared business requirement documents along with system Requirement documents and Technical Document for Project development.
• Communicate team with the customer needs, specifications, design targets, task performance and supports.
• Identify the Impacted components by Impact Analysis.
• Analyzing the Low Level Design with existing & revised changes.
• Managed and coordinate with remote user for change request and optimization of application.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Optimized query performance by creating indexes.
• Monitored database system and execution time.
• Created users and roles and assigned permissions to them.
• Created web interface to display the table’s data to the end users.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• EstablishedODBCconnection for database.
• Worked with various business groups while developing applications, assisted with design, installed SQL server clients in different environment.
• Performed Production support and on call duties.
• Resolved deadlocks issues with the databases / servers on a real-time basis.
• Prepared unit test cases for system testing.

Environment: s: SQL Server 2005, T-SQL, Windows XP, Quality Center, QTP