SUMMARY

• Performed overall project management, analysis, architecture, design, development and implementation of Business Intelligence, data warehousing and business intelligence initiatives for last six years
• Responsible for defining the information architecture and technology infrastructure along with the design of multidimensional data models and the Business Intelligence delivery solutions
• Responsible for managing the data analysis, data sources, data mapping along with defining the meta data repository
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs
• Skilled in implementing Data Warehousing and Business Intelligence solutions. Expertise in Ralph Kimball and Bill Inmon’s Data Warehouse methodology
• Successful background working with stakeholders to develop a Business Intelligence architecture framework that aligns strategy, processes, and project development with business goals.
• Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within projects.
• In - depth experience establishing best practices and guidelines for selecting, developing, Integration, and implementing information systems within BI Stack.
• Designed technical processes as a Team Lead by using internal modeling and working with analytical teams to gather requirements and create specifications.
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner, meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department
• Expert to follow agile process in application development and Coordinate and deliver application development related activities.
• Lead a team of 6-8 data integration team members to achieve success in design, development and deployment activities.
• Proficient in analysis, design, and development of Database Management Systems uses SQL Server 2008 R2, 2012, 2014.
• Expertise in implementing business logic in Oracle uses Stored Procedures, Functions, Packages, Views, materialized views, function based indexes and Triggers, Dynamic SQL, ad-hoc reporting using SQL.
• Mentored, coached, cross-trained junior developers by providing domain knowledge, design advice.
• Proven ability in defining goals, coordinating teams and achieving results.
• Performed business analytics and optimization solutions and applications which may run on multiple platforms and may be composed of multiple software packages
• Excellent communication, presentation, and organizational skills.

TECHNICAL SKILLS

Current Technical Expertise: SQL Server 2008 R2, 2012,2014, SSIS, SSRS, SSAS, ASP.NET, T-SQL, MDX, SPs

Project Management Tools: Microsoft Project Management Platform, Kanban, Scrum with Excel, Wiki

Business Intelligence Technology: SSIS, SSRS, SSAS, MDS, DQS & SharePoint BI

Power (BI) Business Intelligence: Power Pivot, Power Query, Power Map, Power View, Power Q&A

Development Tools: BIDS, VSDE, Red Gate, SSMS 2008 R2, TFS, SSMS 2012, SSDT, SSMS 2014

Analytics Tools: Power View, Tabular Model, MS Excel 2013, Office 365

Database Language: T-SQL, DAX, MDX, SSRS Expression, SSIS Expression

Programming Language: C#, C, C++, JAVA, VB, Turbo Prolog, Core JAVA, SGMP

Latest Technology: BIG Data, Data Scientist, SQL Azure, Hadoop with SSIS

Web Designing: HTML, CSS, Flash, Dream-viewer

Database Server: SQL Server 2008 and 2008 R2, SQL server 2012, SQL Server 2014

Testing Tools: SQL test trikes, Jira

Operating System: Windows XP, Windows 7, Windows Server 2008

Miscellaneous: SharePoint 2010, SharePoint 2013, MOSS, Active Directory Concepts

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Helping to formulate estimates and timelines for project activities and setting related goals
• Acting as a technical mentor for developers, Assisting developers with design work, analysis and requirements gathering
• Participate in peer code review to make sure that coding standard follow, Provide direction to the developers when needed
• Participating in the weekly Technical Integration Working Group meetings
• Completing a weekly status report for the project manager
• Responsible for key architecture decisions
• Developing Data Module and Database Object
• Developing SSIS Package for job scheduling, Deploy SSIS package
• Understand, Design, Develop Graphical Reports
• Write Stored Procedures and Function
• Implementation of Parallel Processing and performance Optimization in SSIS Package and SQL Server stored procedure
• Ensuring the changes are delivered on time and on budget, Code changes and unit testing
• Co-ordinate between the business stakeholders, project manager, offshore development team and support teams
• Work with a team of architects and engineers to develop proof-of-concept components
• Write and maintain architecture and detailed design specifications
• Manage a team of senior engineers and contractors to implement the key components of the product according to specifications
• Perform design and code review
• Work with product manager to ensure the architecture design meets the product requirements
• Work with QA manager to develop test specifications
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG
• collaborating with application developers and architects to define application middleware requirements and create middleware configurations to meet these needs
• Develop and monitor solutions focused on presentation, logic and data tiers that allow for more junior team members to understand and debugging existing applications that interfaces with a database back end
• Preventing system resources and application consumption from negatively affect service availability
• Reporting on incidents and following through a resolution
• Implementing and maintaining a highly available and scalable system infrastructure
• Identifying offending processes in various systems and prevents future occurrences
• Collaborating with problem management engineers to identify and resolve issues to meet customer service level agreements
• Responsible for ensuring the coordination of various development efforts that take place in parallel on the project and ensuring that we are proceeding with tasks in the proper order and with the proper priority.
• Transform business requirements into comprehensive solutions using the appropriate methods, tools and technologies.
• Coordinate and deliver application development related activities with team of 6 data integration team members to achieve success in design, development and deployment activities.
• Perform hands on development and coding of application components using SSIS, SSRS and SSAS.
• Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing.
• Mentor and challenge junior software engineers and other team members, while growing the technical, functional and leadership skills.
• Strong team leader with excellent interpersonal and communication skills.

Language: C#, ASP.NET and Telerik

Database: Major - SQL Server 2008 R2, 2012, 2014 | Minor - My SQL, Sybase, DB2, Oracle 9i

OS: Windows 7/Windows Vista/ Server 2003/ Server 2008

BI Tool: MSBI (Microsoft Business Intelligence- SSIS, SSRS, SSAS, MDS, DQS), SQL Server integration Services, SQL Server Analysis Services 2008, SQL Server Reporting Services 2008, Master Data Service, Data Quality Service

Power BI - Microsoft Power Busine Intelligence - Power Pivot, Power Query, Power Map, Power View

Other: Sharepoint, Active Directory, Telerik Tool, WCF, Red Gate

Confidential

Responsibilities:

• Developing SSIS packages
• Formatting Reports in SSRS
• Data-set of reports using MDX and SP
• Developing SSAS cubes with required fact and Dimensions
• Find and Form Measures in cube
• Deploy SSIS package and reports in MOSS
• Write Stored Procedures and Function in SQL server 2008
• Developing Search screen in ASP.NET for Forest Object
• Active Directory Analysis of data
• Preparation of Technical Design document
• Ensuring the changes are delivered on time and on budget
• Code changes and unit testing
• Co-ordinate between the business stakeholders, project manager, offshore development team and support teams
• Develop UI screen and model for search

Language: C#, ASP.NET and Telerik

Database: SQL Server 2008, BIDS (Business Intelligence Development Studio)

OS: Windows 7/Windows Vista/ Server 2003/ Server 2008

Tool: MSBI (Microsoft Business Intelligence), SQL Server integration Services 2008, SQL Server Analysis Services 2008, SQL Server Reporting Services 2008, MOSS 2007, Active Directory, Telerik Tool, WCF

Confidential

Responsibilities:

• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T-SQL writes stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Worked on logical and physical database modeling with UML
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB database.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created a DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• SQL Server Capacity Planning, Consolidation & Virtualization

Confidential

General Development

Responsibilities:

• Delivered complex enterprise applications using Microsoft Technologies
• Derived complex design from scratch for large enterprise scale applications
• Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects
• Convert complex design into solid implementations that scale and perform
• Architecting and Implementing Complete Automation by saving time in Design, Development, Coding, Testing, Analysis and Maintenance phase
• Database Data Modeling, table design and implementation for Database and related ETL processes.
• ETL architecture, design & patterns and framework
• Analysis, design, development, and implementation of Database ETL, client/server, and mainframe transactional applications
• Ensure solution delivered adheres to the technological standards established in the organization
• Experience with data visualization tools
• Participate in requirements gathering sessions with the business and BI Analysts to understand business analysis requirements
• Assistance in preparation of project proposals, including client and vendor meetings
• Designs and implement a proof of concept or prototype as needed for solutions as an individual contributor
• Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners

SQL Server

Confidential

Responsibilities:

• Experience with very large databases and/or data warehousing, Good knowledge of SQL
• Understanding and Requirement Gathering - ER Diagram, Object and Class Diagram
• Database Designing and Architecting
• Stored Procedure & Function writing
• Optimization and parallel Processing
• Auto Data generation for testing
• Design Authority for all company databases
• Adherence / Enforcement of company Quality procedures
• Experience as an MS SQL Server DBA
• Data management, versioning of data, backups
• Create, maintain and develop documentation
• Diagnose and correct programming errors
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to a newer version of SQL Server.
• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Ensure that the code is written keeping in mind any security issues such as SQL Injection.
• SQL tuning, query and index optimization
• Management and monitoring of database security and audit logs in accordance with PCI/DSS.
• Collaboration with application architects, developers, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures and other necessary aspects of the database.
• Understanding, Developing and managing CDC (Change Data Capture)
• Follow established SQL Server standards for design, development and migrations
• Stored Procedure Test Script writing

SSIS - SQL Server integration Service

Confidential

Responsibilities:

• Package designs and Development.
• Analyzing Source, Destination and Transformation
• Analyzing Data flow, Control Flow task and Event Handler
• Provide technical expertise to functional and detailed designs.
• Package configuration - Custom, File, XML and Environment Variable
• Package Logging - Custom, Standard, Text, XML and SQL Server logging
• Engage with business users, analysts, technical staff, and project team members to design, develop, implement, and enhance applications.
• Package Deployment and Maintenance - MSDB and File System
• Ensure proper data transformation and migration between disparate systems
• SSIS Package Security and transaction option
• Ensure the integrity and reliability of data feeding systems
• Package Execution – Runtime, Scheduling, BAT file and Stored Procedure
• Package, Parallel Processing with Continuous multithreading
• Reviewed existing processes to identify areas for improvement and opportunities for additional savings
• Check the accuracy of test results using current, valid and reliable data
• Participates in the development and maintenance of corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards.
• Package Error handling and Troubleshooting
• Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• SSISDB catalogue, Analysis with Data Taps and using build on the report