PROFESSIONAL SKILLS

• Over8+years ofSQL Server Development and Database Administrationexperience inSQL Server 2000/2005/2008/2012/2014.Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MSSQL Server Analysis Services (SSAS) in various Industry verticals like Healthcare, Financial, Pharmaceuticals, Banking, Manufacturing and Public sector companies.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Expertise in designing complex reports using Cascading parameters, Drill - Through Reports, Parameterized Reports, Sub reports and A usingSQL Server Reporting Services (SSRS).
• Expert in SQL Server Business Intelligence components including Reporting Services, Integration Services, and Analysis Services.(SSAS,SSAS,SSRS)
• Hand on experience in developing & deploying cubes usingSQLServer Analysis Services involving multidimensional data.
• Experience using Agile Scrum software development life cycle, Expertise inMS SQL Server Installation,Configuration, Migration and Maintenance, applying patches.
• Experienced in working withSQL Query Analyzer,SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs withSQL Server Agent,SQL Server Storage Structures, Index and Security ArchitectureandSQL Profiler
• Experience indata warehousingincludingbusiness intelligence tools- DTS, SSIS, SSAS, SSRS and Power BI.
• Very Good Experience in BI Development (SSRS,SSIS,SSAS)
• Experience inmigrating SQL 2000 servers to SQL 2005.
• Expertise in definingDatabase Backup, Recovery and Disaster Recovery Procedures.
• Design and develop ETL/Data Integration solution.
• Design mapping documents, functional and technical specification.
• Administer and maintain ETL environment, including performing configuration management activities related to the ETL environment (SSIS).
• Monitor and optimize the performance of the ETL, database scripts, routines and environments.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in designing and implementing NoSQL solutions (MongoDB and/or Cassandra), creating new clusters, adding and removing nodes, and capacity planning.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Experience with a business intelligence/reporting tool such as, Oracle, Cognos, MicroStrategy,, QlikView, TIBCO Spotfire, etc
• Work with data architects, as needed, to provide and facilitate technical design for data integration.
• Good experience in writingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.

TECHNICAL EXPERIENCE

Databases: MDX,DAX,T-SQL, SQL 2014,2012,2008,2005

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS). Excel Data Sorting Customer Service Data Scrubbing.

Excel Macros Logical Thinking QC Process

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x,8, MS-DOS.

Architecture: Relational DBMS, Client-Server Architecture, OLTP

Other: Reporting Services, Crystal Reports, .Net, HTML, Java script, jQuery, C++ Microsoft Visual Studio 2003/2005

PROFESSIONAL EXPERIENCE

Confidential, Fresno, CA

Sr. SQL/SSAS Developer

Responsibilities:

• Responsible for the development, testing and documentation of complex data transformations and services to enable the analysis of information to support strategic initiatives and ongoing business requirements for Confidential .
• Developed data transformation solutions using Power Center, Data Services, Shell scripts and advance SQL. Create Entity Relationship (ER) Diagrams to the proposed database.
• Expertise in Transact-SQL (TSQL), with strong proficiency in creating tables, indexes, joins, triggers, views, complex stored procedures, user-defined data types, and functions.
• Responsible for recommending database solutions to recognized problems and for design and implementation of new Cassandra and Open Source databases. Evaluate database and software requirements and influence design decisions.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database
• Worked with developers to tune the SQL queries using SQL Profiler, Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
• Performance Tuning, Replication, Backup/Restore and troubleshooting of Cassandra and other Open source / Big Data databases in a highly dynamic environment.
• Assisted in database performance tuning including analyzing and tuning of complex SQL statements.
• Served as a mentor to fellow entry Data Developers in assisting in the creation of a sustainable data warehouse ecosystem.
• Developed reporting/dashboards with Power Pivot, SSRS, Power View, Performance Point, Microsoft BI integration with SharePoint
• Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Developing SQL scripts for maintaining administration tasks, Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Based on the business need created all three replication models on different applications.
• An excellent understanding of the SQL Server stack including 2008 R2, and 2012.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• WritingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.

Confidential, Irvine, CA

SR. BI/T-SQL Developer

Responsibilities:

• Designed, developed, deployed and supported / maintained SSAS/SSRS, MS BI dashboards on enterprise-wide servers. Development primarily in SSAS (both Multi-dimensional and Tabular mode), SSRS and T-SQL.
• Development of T-SQL views as well as designing cube solutions with SQL Server Data Tools. sCreated Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• T-SQL coding and testing: functions, views, triggers, cursors, and stored procedures, Created Triggers to enforce data and referential integrity.
• Implemented database standards and naming convention for the database objects
• Conversion the legacy systems data into MS SQL server using DTS packages.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc.
• Strong T-SQL, MDX and DAX skills and experience deriving scalable reports from data management frameworks.
• Retrieving data from various data sources by writing efficient stored procedures, functions, views, dynamic TSQL, and created ETL packages using SSIS 2012.
• Understanding the business requirements received from business team by taking part in triage meetings, and involve in database design, making enhancements to the existing database and SSAS Cube.
• Maintained SQL Server DB stored procedures.
• Use SQL to pull complex data from SQL Server backend systems with good understanding of Agile methodology.
• Develop rich, interactive visualizations integrating various reporting components from multiple data sources.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Developed rich, interactive visualizations integrating various reporting components from multiple data sources.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations usingMDX Programming
• Worked indata warehousingincludingbusiness intelligence tools- DTS, SSIS, SSAS and SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services (SSAS) 2012
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Managed Login and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.Environment.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries.

Confidential - San Diego, CA

MS BI/SQL Developer

Responsibilities:

• Developed advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures.
• Designed Contract Retention database using SQL Server 2008 technology.
• Created complex SQL views and stored procedures to join multiple tables for contract data interface files.
• Developed SSAS Tabular Model databases, including DAX calculations, query tuning, and security.
• Involved in planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Experience as a Developer, Programmer, Coder roles, with an established focus on Business Intelligence development using the Microsoft BI Stack (SQL Server, T-SQL, SSAS, OLAP, SSRS, SSIS, MDX, DAX).
• Analyzes and improves existing dashboards, reports and reporting systems
• Analyzes and perform integrity checks data coming in from 3rd parties in flat file and other formats.
• Provided agile process improvements and coach our engineering team to be as efficient as possible
• Designing and maintaining SSAS cubes in SQL Server and Database development using T-SQL.
• Responsible for importing data from various sources and providing summary reports regarding data integrity, completeness, etc.
• Worked closely with the Enterprise and Solutions Architects team and provides technical design recommendations on the data mart structures which support analytical applications
• Provides and owns the technical details for implementation and maturing of BI solutions.
• Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Identified problem trends and corrective actions and documenting these through modification of existing best practices guidelines
• Provided expertise and guidance to other developers in the use of the toolset.

Confidential, Dallas, TX

MS BI /SQL Developer

Responsibilities:

• Developed SSIS integrations from Operation Data Stores into our Dimensional Data Warehouse.
• Involved in setting up and Troubleshooting clusters Application Center Clusters Performance tuning, and optimization of procedures and queries.
• Maintain DTS packages and SQL scripts for generating reports, Troubleshoot and monitor SQL performance issues
• Created Power BI visualizations, aggregating into Dashboards, As required, provide end-user training and end-user support
• Deployed Tabular data into the Power BI infrastructure.
• Provided an end to end BI solution by configuring metadata, building analytics repository, dimensional modeling design, and building business models.
• Designed, developed and maintained business and physical data mappings. Identify and understand source data systems. Map source data to data warehouse, operational data store databases, or target databases.
• Created processes that will validate data accuracy.
• Developed reports, analysis and business intelligence using the latest techniques andtechnology, to increase user and executive understanding of operations.
• Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.
• Provided Daily Support and administration tasks.
• Actively headed the team on production support activity and had a smooth handover to the client.

Confidential - Charlotte, NC

MS BI/SQL Developer

Responsibilities:

• Responsible for the development and implementation of enterprise solutions that align with business needs. Primary duties will include, developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, and support of data warehouses, and underlying data models.
• Understood the client business Requirement and created the high level documents.
• Handling team from offshore and coordinating with Onsite resources and Clients on daily basis to gather requirement.
• Linked Servers Configuration
• Supported all data models for production, test and development databases and worked with application developers and database end-users to resolving database related problems.
• Work with the company DBA to establish needed data model changes as required.
• Produced reports using Reporting Services and Collaborated with senior business executives to clarify and document business requirements for Claims analytics and reports.
• Designed develop, test, and implement MS SQL solutions.
• Performed Detail -oriented, security-conscious SQL Server database administrator.
• Proficiently worked on SQL Server as Agent, with the ability to create, schedule and troubleshoot jobs.
• Worked hard in a team-oriented environment and helped to build a good team.
• Worked with non-technical users to understand and troubleshoot issues.
• Leading a team of 4 member, handling Knowledge Transition process and working on documentation along with Individual Contribution in team

Confidential, Addison,TX

MS BI SQL/SSIS Developer

Responsibilities:

• Design, Develop and Deploy SQL Server Integration Services (SSIS) Packages.
• Participated in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Created cubes in SQL Server Analysis Services (SSAS).
• Created functions to provide custom functionality as per the requirements.
• Helped in writing and optimize in-application SQL statements.
• Collaborated with other team members Higher management to Prepare documentations and specifications
• Maintained, and administer complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS)
• Provided maintenance and 2nd-tier production support for a self-service business intelligence environment
• Facilitated the development of data integration efforts with the development team.
• Established methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

Confidential, Los Angeles,CA

MS BI /SQL Developer

Responsibilities:

• Expertise in transformation architectures, data profiling and cleansing tools, as well as general database technology concepts, data analysis capabilities, and the ability to gather and refine data requirements to meet business rules.
• Worked with Business Objects reporting tools.
• Proficiently performed multi-tasking and prioritized projects.
• Helped in Database Migration.
• SSIS Packages / Replication Configuration - Development of SSIS packages, deploying and scheduling them
• Reporting the daily activities.
• Document the business requirements, validate them with business users and get their approval
• Deep understanding of advanced data warehousing concepts and track record of applying these concepts on the job
• Advanced knowledge in SSIS/SQL Server business Intelligence Studio 2005/2008

Confidential - New York, NY

MS BI Developer

Responsibilities:

• Developed functional design documentation to support business requirements.
• Worked closely with solution developers to assist, support and review system and technical design documents to ensure functional and business requirements are met.
• Completed all appropriate documentation to support the Software Development Lifecycle (i.e. project management, test, design, deploy, post go live support),
• Experience in mapping data using disparate data sources such as flat files, databases, xml files and/or unstructured data.
• Ability to collaborate effectively with business users to translate business requirements into technical requirements.
• Worked on Microsoft SQL Server 2008R2/2012 and Microsoft Visual Studio.
• Created technical documentation including design, flowcharts, and operations.
• Intermediate to Advanced knowledge within the Microsoft Office Suite (Access, Excel, Word, Outlook, PowerPoint, Visio).
• Closely worked on SSAS/tabular cube

Confidential - McLean, VA

MS BI Developer

Responsibilities:

• Worked with members of technology and operational teams to understand data requirements.
• Designed, develop and maintain new and existing database systems and applications (primarily SQL Server); including but not limited to creation of table architecture, views, functions and stored procedures.
• Designed and developed ETL, data delivery, and BI Solutions; including but not limited to Microsoft SQL Server BI stack (SSIS, SSRS, SSAS), service layer integration, reporting, analytics, etc
• Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
• Good Knowledge of MSBI - SQL Server Software Architecture, Design, Best Practices
• Demonstrated understanding of SSAS modeling including multidimensional and tabular techniques.
• Strong understanding of relational data structures, theories, principles and practices.
• Strong understanding of business functions addressed by BI solutions, including: Financial Management/Reporting; Supply Chain, Sales and Marketing.
• Ability to translate business questions and requirements into transformations, views, and other BI objects.