PROFESSIONAL SUMMARY:

• Over 7+Years of IT Experience in requirement analysis, design, development, Implementation of web - based and windows based, client-server and n-tier Applications.
• Proficiency in software development life cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation
• Expert in MS SQL Server 2012/2008R2/2008/2005 and Oracle 11g/10g/9i. Knowledge in developing stored procedures functions and triggers using T-SQL and PL/SQL.
• Experience in implementing end to end ETL process using MS BI Stacks (SSIS, SSRS, and SSAS) 2012/2008R2/2008/2005 and Informatica 8.5/8.1/7.1.2.
• Excellent understanding and experience in implementing database concepts such as Joins, Sub queries, Stored Procedures, Triggers using MS SQL Server and Oracle client tools, MS Access.
• Experience in writing DML DDL and Transaction queries in T-SQL for MS SQL Server database.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities
• Extensive knowledge with Database Backups, Recovery Procedures, Backup strategies and scheduling
• Experience working with large and or complex data sets for business operations.
• Designed and developed Power BI graphical and visualization solutions based on business requirement.
• Designed and developed of SSAS cubes for analytical reports Implemented Custom drill to details solution using .Net code and adding it to SSAS solution; this allowed to generate custom reports being generated using SSAS default drill to details action Implemented SSAS expressions to provide comparative analysis.
• Experience in modifying MDX Cubes and Dimensions in SSAS. Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Published reports to Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent knowledge in Performance tuning methodologies at a database level, ETL, and Report Level.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Strong understanding of relational database theory including OLAP and OLTP database design.
• Experience in designing conceptual, logical and physical database models using Erwin and MS-Visio.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
• Good knowledge on CSS, IIS, JavaScript, UI design and development, consuming and manipulating data using ADO. NET.
• Proficient with WCF, Web Services using WSDL, SOAP and UDDI.
• Experience in web development using HTML, XHTML, DHTML, XML, XSD, X-Path and XSLT
• Better understanding of utilizing API for internal and external application using REST and SOAP based design.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS:

Databases: MS: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , Oracle 12c/11g/10g, Microsoft Access, SharePoint 2010/2007.

Programming Languages: T: SQL, PL/SQL, HTML, XML, Java, VB.NET, C#.Net.

IDE Tools: Visual Studio .Net 2010/2008/2005/2012/2018

Data Modeling: Erwin, MS Visio 2010.2007/2005.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services, Data Transformation Services (DTS), Informatica.

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008R2\2008\2005, Crystal Reports, Business Objects, Power BI

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, SSAS Enterprise Manager, Oracle SQL Developer 3.2, Toad, Oracle 12c/11g/10g.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2012/2010/2008/2005. Tidal

Operating System: Windows 10/8.1/8/7/ XP Professional /Standard, 2000.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server/SSIS/SSAS Developer

Responsibilities:

• Working in software development life cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation
• Responsible for designing complex SSIS packages for performing ETL operations as per the need and scheduling the jobs on the agent using configurations.
• Design and develop SSIS packages, maintain and improve the performance of existing SSIS packages.
• Extracting data from heterogeneous systems like csv, Oracle, Excel, XML, text files etc. for performing business operations and applying rules.
• Working on Implementation of technical solutions into design, development, deploy, Test into different environments by utilizing SQL Server, Visual studio and excel.
• Responsible for Adding new features to java application to normalize data and clean incorrect data in SQL server database.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Assisting in design and implementation of a .NET integrated testing suite for end-to-end testing of T-SQL stored procedure.
• Designed and developed of SSAS cubes for analytical reports
• Implemented Custom drill to details solution using .Net code and adding it to SSAS solution; this allowed to generate custom reports being generated using SSAS default drill to details action
• Implemented SSAS expressions to provide comparative analysis
• Implemented translations for reporting using SSAS
• Implemented role-based security
• Created SSAS perspectives to provide simplistic view of Cube to business users
• Implemented optimal SSAS processing plan using SSIS
• Refactor multiple T-SQL queries to enhance performance substantially and increase readability of the code.
• Expert in creating Star schema cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Responsible for writing DDL scripts for creating SQL objects and utilizing objects like tables, SP’s, Functions, Triggers, Views etc.
• Responsible for Implementing technical design, development, deploy test into different environments.
• Responsible for updating, maintaining and documenting the website such that it is currently used for creating, updating and reporting much of Confidential 's international work with foundations.
• Responsible for utilizing various control flow tasks, data flow elements, event handling, logging, configuring, deploying and scheduling SSIS packages at various stages in different environments.
• Involved in deployments activities, enhancements and maintenance of data loading, batch jobs, Instances, Linked Servers and Indexes.

Environment: MS-SQL Server 2016/2014/2012/2008 R2 Enterprise Manager, Oracle SQL Developer, MS-Access 2010/2007, Bit Bucket, Confluence, TFS, Visual Studio, MS Business intelligence (BI) SSIS, SSRS, SSAS, XML, MS Office 2013, MS Visio 2010.

Confidential, Chicago IL

SQL Server/SSIS/SSAS Developer

Responsibilities:

• Involved in business requirement gathering from the end users and convert into Technical aspects by providing optimal solutions.
• Involved into multiple projects, Migration from MS access DB to SQL Server, upgrading from SQL server including SSIS packages and SSRS reports. Performed GAP analysis for building data mart, involving into housing goal scoring and reporting projects.
• Automate multidimensional analysis through use of OLAP and MDX queries in data warehouse. Pull data from various OLTP databases via ETL/SSIS. - Write complex queries that include aggregation.
• Worked with MDX to query cube’s data.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Interface with SaaS reporting tools such as PowerBI to provide connectivity to on-prem and cloud sources with direct queries and periodic data refreshes for data visualization, analytics, and OLAP functionality.
• Implemented translations for reporting using SSAS Implemented role-based security Created SSAS perspectives to provide simplistic view of Cube to business users Implemented optimal SSAS processing plan using SSIS.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Worked with MDX to query cube’s data.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available
• For the decision makers
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Designed reports and tuned them for optimal performance when using multiple
• Responsible for database, ETL development activities and handling production support for the operational data loads utilizing SQL Server, Oracle, SSIS and SQL Agent.
• Expertise in SSAS, data warehouse design, data marts, and SQL Server.
• Responsible for designing complex SSIS packages for performing ETL operations as per the need and scheduling the jobs on the agent using configurations.
• Experience in extracting data from heterogeneous systems like CSV, Oracle, Excel, XML, text files etc. for performing business operations and applying rules.
• Responsible for creating and maintaining various database objects like Stored Procedures, Views, functions, Triggers and Constraints etc. to meet the needs.
• Responsible for utilizing various control flow tasks, data flow elements, event handling, logging, configuring, deploying and scheduling SSIS packages at various stages in different environments.
• Experience in creating scoring and reports for reporting purpose.
• Responsible for implement Unit testing and performance improvement purposes.
• Modified web services to interact with the other applications and exposed them using SOAP and HTTP.
• Used Hibernate, object/relational-mapping (ORM) solution, technique of mapping data representation from MVC model to Oracle Relational data model with SQL-based schema
• Responsible for creating and maintaining the documentation for implementation and for future changes.

Environment: MS-SQL Server 2016/2014/2012/2008 R2 Enterprise Manager, Oracle SQL Developer, MS-Access 2010/2007, TOAD, MS Business intelligence (BI) SSIS, SSRS, SSAS, SAS, SharePoint Server 2010, Power BI, XML, MS Office 2013, MS Visio 2010, VB.Net, C#. Net, Visual Studio 2013/2010/2008 , Windows Server 2008, TIDAL, SQL CMD Utility TFS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Designed Logical and Physical data models using ERWIN data modeling tool
• Involved in deployments activities, enhancements and maintenance of data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Involved in data analysis performing GAP Analysis and Function Point Analysis to estimate the benefits of the new system v/s. the existing system
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Responsible for Cleansing up database for Maintenance of the database.
• Responsible for unit testing, writing design documents and uploading it to share point server.

Environment: SQL Server 2012/2008/2005 , Oracle 9i, MS .NET Framework, MS Visio, MS-Office 2007, HTML, XML, VB.NET, SQL Profiler, Windows 2003 Server, TFS /Visual source safe (VSS).