SUMMARY

• 7+years of experience in MSBI (SSIS,SSRS& SSAS).
• Excellent command on MS SQL SERVER 2012\2008\2005.
• Worked on SQL Server Integration Services (SSIS) packages creation, environment set up for DB projects creation, packages deployment, configurations & etc.
• Excellent in High Level Design of ETL, SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Derived Columns, Audit, Lookup, Data Conversion, Character Map, Merge and union all.
• Expert in Unix shell scripting
• Extensive working experience in using/generating Visual Studio 2008 Business Intelligence Report, SQL Server 2008 SSRS or MSRS (SQL Server Reporting Service).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Expert in XML data extraction.
• Experience in developing, monitoring, extracting and transforming data using SSIS Import Export Wizard, and Bulk Insert.
• Good experience in writing MDX queries while creating and customizing cubes using SQL server Analysis Services (SSAS)
• Solid knowledge and working experience in Installing, Configuring and Managing SQL server 2005/2008/2012.
• Involved in some server hardware and networking in the media domain just like assembling, installing and configuring the servers.
• Expert in Data Modeling.
• Expertise in Linux - Tomcat-MySQL, Linux-PHP-MySQL;
• Hands on experience in ALM (Application Life Cycle Management)
• Extensive experience with SQL Server and T-SQL in constructing tables, joins, views, triggers, indexes, functions, stored procedures, sub queries and group by, having, user profiles, relational database models, data dictionary, data.
• Expert in MVC reporting and Java Scripts.
• Expert in using of Dev express ASP.net
• Utilized the MVC frame work for implementing the document retrieval system.
• Experienced in design and development of reports using SQL Server.
• Worked on SSRS (SQL Server Reporting Services) reports creation on ad-hoc requirements
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Have knowledge in DBA activities like Backup, Restore, and Logins creation
• Have knowledge in establishing fail over cluster environment in windows server 2008 R2 and troubleshooting the cluster issues
• Worked on Cloud environment
• Good experience in programming with active involvement in all the phases of the Software Development Life Cycle (SDLC) like Requirement Analysis, Design, Development, Unit Testing and Maintenance using RDBMS
• End-to-end experience in designing and deploying data visualizations using Tableau
• Expertise in all areas of software development including client interaction, requirements gathering, analysis and tale-conferencing with the client during the progress of the project
• Possess good analytical, problem-solving and communication skills
• Development in SQL server 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Expertise in developing web applications using C#, ASP.NET, HTML5, JQuery and SQL server
• Proficient in data migration from sources like MS Access, SQL server, Text files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services(SSIS); and Data collation, data cleansing, Entity Relationship Design.
• Expert in developing code and testing based on defects in the logs.
• Perform system and integration testing of large data Ware house application developed using SQL and oracle.
• In addition to the ongoing involvement in aData Ware House Development life cycle was the designer, developer and architect of several Data ware House, Data marts and related back-end applications.
• Hands on experience in creating SSIS packages with error handling, logging, package configurations and by implementing Break points and Check points as well.
• Expertise in managing project versions and source code changes using source control tools like visual source safe, team foundation server and TortoiseSVN.
• Expert in Water Fall, Agile, RAD
• Expert in QA testing the data bases
• Expertise in analysis of SQL code, tuning and developing procedures to improve efficiency
• Expert in TOAD 9.0.
• Expert in UAT Test management, Execution, Scripts
• Expertise in Dot Net and Master Data Services programming
• Expert in SQL loading
• Worked on Kalido Dynamic warehouse
• Expert in MY SQL
• Import and export data using oracle, SQL server, MY SQL from UTL files
• Extensive knowledge in various objects like hierarchies, filters, calculated fields, sets, groups and parameters etc., in Tableau.

TECHNICAL SKILLS

Database Tools: Management Studio, SQL Profiler, Query Analyzer SQL Server setup, Security Manager, Service Manager, SQL, Server Analysis Services (SSAS), Database Engine Tuning Advisor, Data Ware Housing, MY SQL

ETL Tools: Data Transformation Services (DTS), SQL Server Integration, Services (SSIS), Import Export Data, Bulk Insert

Data Modeling Tools: ERWIN, MS Visio.

Programming Language: T-SQL, JAVA, C, C++, HTML, XML, and Visual Basic 6.0, Java Script

Web Tools: MS-Front Page, Macromedia 6(Flash, Fireworks, Dream Weaver, MS-Outlook Express.

Reporting Tools: Crystal Reports 9/10/11, SQL Server Reporting Services (SSRS), MS Access, MS Excel, MVC

Databases: SQL Server 2005/ 2008 R2/2012, Oracle 10g / 9i, MS Access.

Operating System: Windows 9x/Me/NT/XP/Vista/2003/2000, Mac.

BI Tools: Tableau

PROFESSIONAL EXPERIENCE

Confidential, Topeka, KS

MS SQL Server BI Developer/Administrator

Responsibilities:

• Actively participated in interaction with users, stake holders and business users to fully understand the requirements of the system.
• Performed Migration of data from SQL Server .
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database, which provides efficient and granular level of control.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Expert in Bash scripting
• Working in My SQL
• Efficiently working on Tableau.
• Utilized the MVC frame work for implementing the document retrieval system.
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Working on Data modelling tools like SSMS and Navicat data modeler.
• Expert in upgradingData ware housing.
• Was the lead in Data Ware Housing Foot-Print reduction
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Developed Multi-Dimensional Objects Cubes, Dimensions using SSAS.
• Hands on experience in UAT Test management, Execution, Scripts
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, Visual Studio 2008, T- SQL, Visual Source Safe 2008 (VSS), XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, MS-Excel, Cloudera Hadoop

Confidential, Seattle, WA

Senior MS SQL Server BI Developer/Database admin

Responsibilities:

• Design and build ETL, Data Marts and Reporting systems.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Troubleshoot system issues, performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for performance purpose.
• Maintain the upgrade of the ETL system for marketing and sales lead scoring system that allows for easy and consistent data transfers and integration.
• Expert in Bash scripting.
• Expert in designing and deploying data visualizations using Tableau
• Contribute to the upgrade of Oracle 9 and older SQL Server systems to SQL Server 2012
• Created Packages and jobs to import the data on daily basis from Flat file to SQL server.
• Actively involved in Normalization of database and assisted clients with physical database modeling, data archiving strategies and disaster recovery planning.
• Worked on MVC reporting and javascripts
• Reacting and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively participated in gathering Business Requirements and System Specification from users.
• Created complex stored procedures and functions to support efficient data storage, purging and manipulation.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Importing and Exporting of the data using DTS routines that extract, transform, and load data from heterogeneous sources.
• Worked in My SQL
• Worked on Cloud environment.

Environment: SQL Server 2012/2008R2 Visual Studio 2010, MS Office 2007, Team Foundation server, Oracle 11g, Oracle Data Integrator, Microsoft Share point server, Cloud.

Confidential - Peoria IL

SQL Developer/data base administrator

Responsibilities:

• Gathered all the requirements from the end users for design and development of the application.
• Developed the star schema and the snowflake schemas depending on the requirements while designing the database.
• Involved in the enhancement of existing database schema by adding new tables, views,indexes and defining the relations.
• Developed and implemented database design documentation, including database diagrams, data mapping documents, data dictionaries etc.
• Involved in installation and administration of nearly 50+ servers ensuring zero downtime.
• Successfully implemented Log Shipping in SQL Server 2008.
• Designed Security Model by creating Users, Schemas, Roles and Permissions for SQLServer 2008/2005.
• Worked on application software’s like Linux-Tomcat-MySQL, Linux-PHP-MySQL.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, and views.
• Worked on the Reports module of the project as a developer (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Worked on different kinds of transformations in SSIS as per the Requirement.
• Monitored Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Managed and maintained all production and non-production databases.
• Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
• Configured database parameters, creates prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development ActivitiesAdvisor for index recommendations.
• Experience in Trouble shooting connection issues with IIS in SQL Server
• Implemented and administratingSQLServerSnapshotreplicationand executing complex queries and writing.
• Evaluated, examined and implemented user roles and assigned relativedatabaseaccess privileges.
• Disaster Recovery Planning, Security Management, Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), TFS, SharePoint, XML, MySQL

Confidential, Denver, Colorado

SQL Server BI Consultant / Senior DBA

Responsibilities:

• Analyzed business requirements and created complex data models using data from multiple data sources.
• Involved in some server hardware and networking in the media domain just like assembling, installing and configuring the servers.
• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split and Term extraction, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Tasketc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Optimized cubes for better query performance.
• Extracted data from XML files.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• By using Kalido Dynamic Information Warehouse (DIW), export business models from the data warehouse to Business Intelligence applications
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven Report Subscriptions
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Created ad-hoc reports, drill down, and drill through reports.
• Deployed reports on Microsoft office SharePoint (Moss).
• Created users define functions in SSRS using VB script.
• Involved in reviews for database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications

Environment: SQL Server 2008/2005, BIDS 2005, Reporting services 2005, Integration Services 2005,Analysis Services 2005, Windows Server 2003, HealthCare database, Oracle 9i,DB2, Share point server, TFS.

Confidential

Backend SQL Engineer

Responsibilities:

• Performance tuned queries optimization for long run query and using more CPU
• Took part in design review sessions.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL for new tables and for updating the existing ones.
• Reviewed SQL server performance report during all testing cycles.
• Worked on Replication, Log Shipping and Database Mirroring.
• Set up and used SQL Profiler to monitor query performance to the migrated database.
• Provided 24 X 7 dedicated supports to all Production, QA & Development MS SQL Servers.
• Fine tuning of database objects and server configuration.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Identified the necessary steps to enhance user response time by checking fragmentation and Re-index tables for efficient application access methods.
• Data migration (import & export - BCP) from Text to SQL Server.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Manage Analysis management objects (AMO) using BIDS.
• Wrote distributed queries to extract data from different servers.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications

Environment: MS SQL server 2000/ 2005, SQL, Enterprise Manager, Query Analyzer, Windows 2000 Server, MS Office 2000, DTS package and import export wizard.