PROFESSIONAL SUMMARY:

• Highly experienced Business Intelligence Professional using SQL server 2005 and 2008 offering over 7 years of commercial experience working for various organizations within several industries such as health, manufacturing, supply chain management, banking, retail and private
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS)
• Diagnosed query optimization, client/server connectivity, and running database consistency checks using DBCC Utilities
• Developed database objects such as tables, views, stored procedures, triggers, row - level audit tables, cursors, indexes, user-defined data-types, functions, constraints
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP
• Experience in Database Backup and Recovery
• Debugging Stored Procedures, Views, User Defined Functions and Triggers
• Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects
• Experience in writing Multidimensional Expressions (MDX) and used the MDX queries in the report generation
• 4+ years’ experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services, (SSRS)
• Experienced in Development and Deployment of Reports (Tabular forms, Matrix (Cross Tab report) form, Conditional, List Items, Charts and Sub Reports) using SSRS
• Experienced in SharePoint providing central management, governance, and security controls for implementation of project requirements
• Experience with software development life cycle (SDLC) and project management methodologies.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
• Possess excellent management skills of outstanding decision making with excellent verbal and written communication skills
• Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients

TECHNICAL SKILLS:

RDBMS/Data Access: MS SQL Server, SSIS, SSRS, SSAS 2005/2008 R2

Development Tool: BIDS, SSMS, VSTS 2008/2010, Report Builder 2.0/3.0

Language: C#, VB, C++

Reporting Tools: SQL Server 2005/2008 /R2 Reporting Services, Report Builder 2.0/3.0, Excel

Web Technologies: ASP.NET, JavaScript, HTML, XML, XSLT, SOAP, WSDL, CSS, Web Services, Ajax

Source Control: Source Depot, CVS

Operating Systems: XP, Vista, Server 2003/2008, window 7

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• ETL development of moving SSIS packages from 2005 environment on to 2008 with new transformations
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at client’s station
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS)
• Created OLAP cubes in SQL Server Analysis Services 2005 & 2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously.
• Created SSIS packages using different transformations in SSIS toolbox like aggregate, merge, merge join, pivot etc
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience in code optimization and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Extensively used views for complex joins queries involving multiple tables from different databases
• Designed numerous triggers to keep track of the changes made in the database for log purpose
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring

Environment: MS SQL Server 2005/2008/2008 , DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS.

Confidential, Des Plaines, IL

SQL BI Developer

Responsibilities:

• Migrated and Extracted Data from SQL Server 2000 to SQL Server 2008 using SSIS.
• Managed and created altered Databases, Tables, Views, Indexes and Constraints with business rules usingT-SQL.
• Created complex Stored Procedures, Nested Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Enhanced the Query performance using Cluster and Non Clustered indexes.
• Created, monitored and tuned SQL scripts for performance.
• Cleaning and extracting data for the Data warehouse using SSIS as an ETL tool from various heterogeneous data sources including Excel, MS Access, MS SQL Server.
• Designed and implemented Data flow models based on the requirements for the SSIS packages.
• Created process tasks that execute reports based on the data extracted using SSIS services.
• Developed a Tabular Reports using SSRS Report Designer.
• Created an ad-hoc reports using SSRS Report Builder.
• Designed different types of SSRS reports including drill-down and chart lists.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Used MDX to create calculated members in the cube.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, C#.NET, WIN server 2003, MS Access 2007, SVN.

Confidential, Dallas, TX

SQL Server/ BI Developer

Responsibilities:

• Extracted data from different OLEDB sources, flat file, and excel destinations with major transformations loaded on the SQL Server destination tables
• Created SSIS packages to migrate data from Oracle to SQL Server 2008
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS) on incremental loading
• Published migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Used SSIS control flow tasks like loop containers, FTP, bulk insert, transfer job task and different data flow tasks like derived column, fuzzy lookup, data conversion
• Involved in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Wrote MDX queries to retrieve the data from data warehouse dimensions and to perform analysis
• Developed sub reports, matrix/tabular reports using MS SQL Server Reporting Services (SSRS)
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks
• Generated reports with complex expressions to calculate, group, filter, parameterize and format the contents of a report using MS SQL Server Reporting Services (SSRS)
• Created and modified data driven subscriptions using SSRS Report Manager
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS)
• Responsible for setting up comprehensive backup and recovery Strategies for SQL Servers.
• Created complex stored procedures and functions to support efficient data storage, archiving, purging and manipulation
• Utilized performance point server to create scorecards and dashboards to monitor business performance
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system
• Responsible for the creation and maintenance of entity relationship diagrams, meta data repository and comprehensive system documentation including everything from environment configuration information through standards policies and procedures

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL, UNIX, LINUX, SQL Server Profiler, Windows 2003, UNIX, Visual Studio, Performance Point Server, Proclarity, MDX

Confidential, Camarillo, CA

SQL Server BI Developer

Responsibilities:

• Creating SSIS packages to gather data from various sources (mainframe, Informix, Oracle)
• Improving SSIS packages for better performance by reassigning the transformations
• Created DTS packages for loading data from desperate system to porters
• Installed, upgraded and migrated databases from Oracle to MS SQL Server 2005
• Designed ER diagrams and mapped the data into database objects
• Involved in Normalization to 3F for OLTP system and some De-Normalization for OLAP system.
• OLAP with the various applications to analyze the data for clients i.e. excel, reporting services.
• Experience in developing and extending OLAP Cubes, dimensions and data source views.
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL
• Experienced in using Informatica 7.x for Extraction of data from multiple sources and load on to SQL Server, monitored dataflow using work flow manager
• Built reports for the analysis services using SQL Analysis services 2005 using different reporting tools
• Designed dimensions and using the MDX expressions for the various Optimizations like optimizing cube schema in SSAS
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Developed both the drill down and drill through reports
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services
• Migration of data from MS Access to SQL 2005/2000 using upsizing wizards
• Involved in the analyzing and solving problems during the client application system’s installing, upgrading and running stages
• Wrote SQL scripts to insert/update and delete data in SQL database
• Converted existing PL/SQL stored procedures, triggers, functions and script to T-SQL
• Created schemas, views, stored procedures, triggers and functions for data migration
• Involved in the complete life cycle of the project, from planning stage to pushing the codes to production
• Responsible for query optimization using SQL tools such as SQL Profiler, Index tuning wizard
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server, Excel and Reporting Services tools.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, SSAS, Windows XP, Oracle, T-SQL and ER-WIN, Windows 2000 Server, Informatica PowerCenter7.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor)

Confidential, Kissimme, FL

SQL Server BI Developer

Responsibilities:

• Working with business/functional analysts to determine ETL, report and analytical requirements
• Involved in the complete ETL life cycle and solely responsible for the design, development and maintenance of SSIS packages.
• Develop SSIS packages with logging, event handling and error tracking to support the BI processes
• Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
• Creating Stored Procedures, T-SQL, and Trigger and modifying the existing one.
• Design, Develop and Deploy SQL Server Reports using SSRS.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Participate in full life cycle of SSRS (Authoring, Managing and Delivery reports)
• Provide End Users support and technical guides when required for all Business Intelligence (SSIS) or reporting applications.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.

Environment: C#, SQL Server 2005, SSRS, SQL Server Integration Services Windows Server 2003.

Confidential

SQL Server Developer

Responsibilities:

• Included Design, Development and Implementation Phase of the project.
• Gathering Information and Analysis the requirement using SQL Server analysis systems.
• Use of SharePoint controls.
• Writing Stored procedure, tables, Indexes, Constraints, Jobs, Backup & Recovery.
• Created Custom Timer job.
• Implemented the database for production and marketing purpose.
• Administered of all SQL server database objects, logins, users and permissions in each registered server, Creating Stored Procedures, Triggers, Cursors, Indexes, functions, views on Database objects.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Unit testing and deployment.

Environment: MS SQL Server 2005, Windows Server 2003, T-SQL and MS Access, ASP.NET 4.0, C#.\

Confidential

SQL server Developer/DBA

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2000, ER-Win, T-SQL, Excel, Access and Windows NT.