Summary of Skills

• Around 9 years of IT experience in Database Development/Administration, Business Intelligence, System Analysis ,Design and Development using MS SQL Server 2012/2008/2005, MS-BI Tools SSAS,SSRS,SSIS in Production, Beta, Test, and Development environments.
• Experienced in entire SDLC life cycle from requirement gathering and conceptual design to testing and deployment
• Business Intelligence and Data warehouse Skills
• Expertise in SQL Server DDL and DML and developer skills including ad-hoc queries, stores procedures , user define functions and views
• Efficient in Data extraction, transformation and loading ETL using various tools like SSIS, DTS etc. from multiple source systems likeDB2, SQL-Server, Oracle, Flat files, Xml
• Broad experience in Query Optimization and performance tuning of stored procedures, views ,SSIS packages etc. with execution plans, profiler and indexing
• Created SSIS packages to load data from OLTP to OLAP Data warehouse for reporting
• Hands on experience with performing various SSIS data transformation tasks like look-ups, checksum, conditional splits, event handler, error handling, For Loop etc.
• Created and Configured Data Source Data Source Views, Dimensions, Measures, Partitions, KPI's MDX Queries using SQL Server 2008/12 Analysis Services SSAS
• Strong experience in report writing using SSRS to create dashboards, charts, scorecards, drill-down and drill through cascading reports
• Experienced with various third party tools like Red-gate to deploy of changes from development to Production environment, Idera-SQL check for performance monitoring
• Experience in SharePoint , Team foundation server TFS for SSIS,SSAS and SSRS

Business Analysis Skills

• Strong knowledge of SDLC methodologies waterfall, RUP, Agile Scrum and Project Life cycle
• Strong experience in requirements gathering including scope document, functional and non-functional system requirements, Business requirement documents, Data, Functional, and Usability requirements
• Extensive experience in conducting GAP analysis, preparing SWOT analysis
• Proven expertise in developing Unified Modeling Language diagrams such as Use cases, Activity, Class diagram, Data Flow Diagram, E-R diagram, Sequence diagram using MS-Visio and Rational Rose, Star UML
• Excelling knowledge of Business Processes, Process engineering, Data analysis, Software Development, Databases OLTP, OLAP, Cloud, Systems Engineering
• Practical experience in testing and validation of product along all the test phases along with User Acceptance Test in co-ordination with QA team
• Strong knowledge of Software development, RDBMS, Business Intelligence, Data warehousing, SAP BI/BW, SAS-BI DW, Informatica, Cognos reporting

Information Technology Skills

Work History

Confidential

Responsibilities:

• Responsible for communication and follow up with teams of project for ensuring delivery of project
• In charge of delivering the required business functionality by making sure end product meet the quality standard
• Documentation of project deliverables ,training materials, Tasks in TFS, OneNote
• Created the project scope and objective by conducting meetings with project team and business stake holders to document the scope along with project manager
• Prepared GAP analysis of As-Is and To-Be process flow by understanding existing business processes and comparing it with new process design
• Interacted with different department heads like finance , statistics along project manager for impact analysis and requirement gathering using Rational Requisite Pro
• Coordinated with business users and technical team to conduct joint application development JAD sessions in order to confirm develop the requirements
• Prepared Business Requirement Document BRD and converted it to System Requirement for development team using Requisite Pro by conducting one-to-one interview session with various teams in organization
• Acted as a liaison between management ,development team for requirements and
• QA, and Conducted walkthroughs with stakeholders to make sure that all requirements have been accordingly met
• Created database, table, stored procedure to fetch data from various data sources like SQL-Server, Flat files, Xml ,used SQL agent jobs to automate and store in stage
• Created SSIS packages to populate data in Data warehouse OLTP to ODS and ODS to DW having DFT, sequence containers, data connections, package configuration, transformations etc.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers etc. as part of task in existing project
• Designed self-service , interactive ,exploratory reports using SSRS reports for business users to analyze complex SSAS cube data in MS-BI Suite
• Build Cubes for reporting along with Calculated Measures, KPI, role-playing dimensions, Measures, Partitions ,MDX using SSAS Cubes by views and BIDS
• Involved in performance tuning and query optimization of the database as required for extraction and tune some of existing stored procedure which were used for various reports in T-SQL
• Created ,Designed Data Source and Data Source Views using having SCD-dimensions ,Role-playing dimension ,calculated measure ,KPI and deployed to production
• Created and Configured SSAS cubes , SSIS packages , and SSRS package jobs from scratch with BI architect and DBA's to tune and migrate it to different server
• Used HP Quality Center for Test Case Management, and Defect Management with browser compatibility test in coordination with QA team for ensuring quality of product
• Worked extensively in designing UAT for a select group of key end-users in testing the user interface and functionality of the application as per BRD for signoff's purpose

Achievements:

• The project execution was on schedule and resource utilization within project budget
• Successful implementation of data warehouse and BI solution to the company

Confidential

Responsibilities:

• Responsible for the documentation of full project activities and technical communication document required for the project deliverables
• Conducted software walkthrough with user ,management and other stake holders for familiarizing the project owners with the new loan system
• Acted as point of contact between technical team and business users to troubleshoot the issue related to business rules for product development during project
• Conducted requirement gathering sessions like brainstorming , requirements workshop to determine the needs of the new web-based system using Requisite-Pro
• Worked with the business users to develop Business Requirements BRD and create business process design for the new system to have efficient theoretical design for implementation
• Performed Gap analysis on As-Is and To-Be business process
• Conducted workshop for business users to identify project objectives and limitations using RUP methodology
• Prepared Functional Specification and Technical Specification with various teams in project as per the business requirement document
• Designed and developed use cases, activity diagrams and sequence diagrams using UML tools like MS-Visio and Rational Rose to have visual model of enterprise-level system
• Extensively worked on stored procedures, triggers, Views, cursors, CTE's, T-SQL scripts, schemas, permissions and performance issues with client/server database
• Designed ETL packages dealing with different data sources SQL Server, Flat Files, and XMLs etc. and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS
• Generated multiple Enterprise reports in SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS-BI cubes in SQL Server Analysis Services SSAS
• Worked on transformations such as checksum in SSIS where all of the rows in table need to compared for an update.
• Used SSAS cubes and SSRS in Asp.Net, C reporting platform
• Collaborated with the QA team to ensure testing of software along with appropriate documentation and logging of defects using Bugzilla
• Generated project invoices and get the required approval from client in timely manner
• Conducted UAT User Acceptance Testing and documented test cases to ensure deliverable as per requirements
• Coordinated with developers to implement features or any bug fixes along with
• Recommendation for new features based on users' feedback
• Met business stakeholders to gain consensus on new product functionality
• Achievements:
• The new system based on optimized business processes and efficient data processing, improved the system and processing time by 30 as compared to old system

Confidential

Responsibilities:

• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements using RUP methodology
• Extensively worked with database modelers team for conceptual , logical and physical data model reformation of database using ERWin
• Developed Use-Cases ,class diagrams and ER diagrams for the development team to understand the process flow and data flow the new system using MS-Visio , ERWin
• Prepared system requirement in order to make the website compatible to the new product
• Performed Gap Analysis to understand and analyze the business requirements necessary for new system
• Interacted with different stakeholders and customers to gather business requirements and prepare functional requirements then convert them to technical requirements
• Responsible for normalized logical data model to define data requirements for building data models related to project
• Act as a liaison when between with various business units and being cross-functional to facilitate collaboration among team along with project manager
• Developed Complex T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Optimized SQL queries to upgrade SQL Server performance using SQL Server 2005/08/12
• Responsible for gathering/refining requirements from the customer for development
• Create DDL scripts to create database schema and database objects.
• Building reports using SSRS and published them using various reporting tools like Pro-clarity, Crystal Reports SSRS.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer. Proficient in Creating SSIS Packages to automate the Import / Export of data in SQL Server 2005/08
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed using SSIS.
• Involved in Coding ETL Stored procedures which performs delta load as per the Functional Specification
• Hands on experience in creating OLAP cubes using SQL Server 2005 analysis services SSAS .
• Involved in writing MDX queries.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Provided day-to-day administration tasks like space and log management.
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Achievements:

Successfully implemented BI solution for stein mart on schedule

Confidential

Responsibilities:

• Created Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data
• Worked with installing, designing and managing MS SQL Server 2005.
• Upgraded DTS packages to SQL Server Integration Services SSIS
• Created Tabular Reports, Matrix Reports, Chart and Graphs reports based on business requirements using SSRS
• Created daily and monthly reports in MS-Office Access, MS Excel and Crystal Reports
• Created indexes to improve the performance of the queries
• Performed backups and restore operations
• Used SQL Server Integration Services SSIS to perform bulk insert operations from SQL Server 2005 databases to flat files/CSV files and vice versa.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS