PROFESSIONAL SUMMARY:

• Having 7+ years of experience in Business Intelligence & Data Warehousing.
• Analysis, Design, Development and Implementation of operational database systems (OLTP) and data warehouse systems (OLAP) using MSBI such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Worked on different projects wif best industry standard experience implementation (SDLC), troubleshooting, presentation abilities and issue resolution capabilities.
• SSRS reports and SSAS models are presented to Decision Support Systems (DSS) for top management.
• Quick understanding of business and domain wif source and target systems.
• Expertise in understanding Fact Tables, Dimension Tables and Summary Tables.
• Expertise knowledge and experience in deploying SSIS packages, SSRS reports and SSAS Cubes to DEV, TEST and PROD Server.
• Worked on performance improvement, ETL migration, Environment setup and admin activities.
• Experienced in enhancing data warehouse wif extensive knowledge of Data mapping, Data Modeling, Snowflake, Star Schemas, ETL jobs and OLAP operations.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Created many Drill through and Drill Down reports using SSRS and Power BI.
• Created interactive dashboards in Power BI reports that were presented to Business users, Program managers and End users.
• DAX query language used in Power BI, Tabular Model of SSAS and MDX query language used in multidimensional model of SSAS.
• Master in performing administrative tasks: database files management, backup/restore, data integration and synchronization.
• Having excellent knowledge and good experience in handling Very Large Databases (VLDBs) and Big Data Hadoop concepts.
• Data extracted from various legacy database systems like SQL Server, Oracle, Teradata, DB2, CSV, Flat files and XML files using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduled DTS/SSIS Packages.
• Good experience in managing the offshore team and driving the project on schedule.
• Worked on creating ETL review guidelines, RFP documents and estimation sheets.
• Experience in UNIX shell programming.
• Experience in SQL tuning using Hints, Materialized Views.
• Expertise inFunctional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing and Integration testing.
• Experience in Agile and waterfall models to deliver the projects and used JIRA tool for Sprint planning and tracking the project status.
• Excellent communication, interpersonal skills, self - starter, enthusiastic, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

Database Tools: MSBI Data Tools 2005/ 2008/ 2012 (SSIS, SSRS, SSAS), Power BI, Power Excel, Power Pivot, Data Transformation Services (DTS)- Import/ Export Data, Bulk Copy Program (BCP)

Databases: MS SQL Server 2014/2012/2008/2005/2000, Oracle 8i/9i/10g/11g, MS Access, DB2 and Teradata

Language: SQL, T-SQL, PL/SQL, VB.NET, Java Script, HTML, Unix Shell Script and Query Languages for Cubes (DMX, DAX)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Tools and Utilities: Toad, ALM, Jenkins, Autosys, JIRA, Git and TFS

Operating System: Windows server 2008/2008 R2,2012,2014 Windows 7,8,10/XP and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, OH

SQLBI/Power BI Developer

Responsibilities:

• Worked wif business analysts for requirement gathering, business analysis and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Created various database objects as for business logic demands like Stored Procedures, Tables, Views, Indexes etc. based on user requirements.
• CreatedSSISpackages to extract, transform and load data into data warehouse.
• Createdtransformations to manipulate data using Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, SCD, Script component, Pivot, Unpivot, Merge etc.
• Used many Tasks like Execute SQL Task, Data Flow Task, Execute Package Task and Script Task etc.
• Create Generic Reports and Dash boards in Power BI.
• Error Handling and Logging done to control and prevent data leakage.
• Responsible for Deploying the SSIS packages.
• Auto scheduled the package through Jobs in SQL Server Agent.
• Experience in optimizing Microsoft Power BI dashboards wif a focus on usability, performance, flexibility, testability and standardization.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Created reports in Power BI preview portal utilizing the SSAS tabular via Analysis connector.
• Report refresh and publish are auto scheduled in Power BI report server on daily, weekly and monthly basis.
• Used the Bulk Copy Program (BCP) to load the large volumes of data from files into tables.
• Mail Task used to send mails to client and admins about the scheduled package auto run status.
• The reports are generated on various Business Needs, Categories and demographics using SQL Server Reporting services (SSRS).
• Created Table, Matrix, Tablix, Chart, Drilldown reports, Parameterized and Cascaded reports according to business requirement.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Utilizing the Azure platform for various cloud computing functions such as provisioning virtual machines and data management.
• Created ETL metadata reports.
• Designed complex reports like dynamically driven parameterized reports, reports wif sub reports, drill through reports using SQL Server reporting services.
• Reports distributed based on defined roles like top executives, Business analysts and customer representatives.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality Services.

Environment: MS SQL Server 2008/2012, MS Business Intelligence (MSBI), MS Excel, Oracle, JIRA,, Power BI, Git, and SQL Server Toad.

Confidential, Bentonville, AR

MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Software Development Life Cycle (SDLC) including analysis, design, development and testing of the project.
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services.
• Designed and develop Dashboards and Reports using Power BI and SSRS.
• Solid knowledge of Data Warehousing, strategies for ETL, identifying Metrics, Dimensions, Hierarchies and design dimensional schemas (Star, Snowflake).
• Involved in managing slowly changing dimensions (SCD), De-Normalization, Cleansing, Conversion and Aggregation.
• Importing data to Power BI from various sources.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server, Oracle and DB2 Databases.
• Responsible for cleansing up database for maintenance of the database.
• VB.Net and other .NET languages C# used in Script task to control the flow of SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Unit Testing, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Implemented Performance Tuning at various levels and created indexes (cluster and non-cluster index).
• Designed, Developed, Tested, Published and maintained Power BI Functional reports, Dashboards.
• Participated in design of Staging Databases and Data Warehouse/Data marts using Star Schema/Snowflakes schema in data modeling.
• Experienced working in the Agile methodology.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.

Environment: SQL Server, MS Business Intelligence (SSIS, SSRS), Oracle, DB2, T-SQL, PL/SQL, Toad, Unix, Autosys, Power BI, Hive, Hadoop, Confluence, Git, Sqoop and HDFS

Confidential - Ohio

MSBI Developer

Responsibilities:

• Worked wif business users/Analytics team, data architects to identify the business requirements and developed designed document for ETL flow, analysis of database architecture, created various complex Packages using SSIS.
• Designed and Created database objects based on business requirements.
• Improved the performance of queries by introducing clustered and non-clusteredindexes on tables in the database.
• Performed daily tasks including backup and restore from disaster recovery by usingSQL Server 2008/2012 tools like SSMS, SQL Server Profiler.
• Experience in UNIX shell programming.
• Migrated existing DTS packages to SSIS.
• Experience in Designing, building the Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Responsible for migration code between various environment and production release at the end of each Sprint.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Implementing and maintaining database security (Create and maintain users and roles and Login access, assign privileges) to each schema level permission.
• Involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Involved, Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.
• Created very complex SSIS Packages wif considering all the best practice like error handling, logging, configurations, deployments and maintenance.
• Configuration and Deployment of the Reports (RDL, RDS) which were created in SSRS.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Created the various kinds of reports using SSRS me.e. Cached reports, Ad hoc reports,Clickthrough reports, Drilldown reports, Drill through reports.
• Migrated existing Crystal reports to SSRS reports.
• Developed Audit Strategy to validate the data between Source and Target System.
• Stored Procedures created in T-SQL for reports and ETL process.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Code history maintained in Team Foundation Server (TFS).

Environment: MSBI (SSIS/SSRS/SSAS), SQL Server, Oracle, Teradata, Unix, JIRA and TFS.

Confidential

SQL Server Developer

Responsibilities:

• Responsible to meet wif business stakeholders and other technical team members to Gather and analyze application requirements.
• Performed source/target analysis of data structures & content.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSIS.
• Experience in designing, developing, and implementing entry level workflow solutions wif heterogeneous sources and multiple operating system environments.
• Extensively used various SSIS Objects such as Dataflow and Control Flow Elements, Connection Managers (Connections), Event Handlers and Progress Tab etc.
• Validated and modified data using SSIS wif different Data Flow Transformations like Send Email Task, File System Task, Conditional Split, Lookup, Merge Join, Aggregate, Multi-Cast, Derived Column and Data Conversion etc.
• Created SSIS packages and used Analysis Services processing task to update the cube wif current data.
• Worked wif team members to tune the SQL queries. Created necessary Index/Partition on huge fact tables for getting a better performance in ETL.
• Implemented Logic wif Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in Data Warehouse.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Used data compression techniques for Back Up.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2 and MS Access and designed data conversions from wide variety of source systems.
• Providing Production support to operational team for daily/weekly/Monthly job failure in Production environments.
• Created deployment documentation wif the halp of other users and operational team to deploy the new release in Production environment.
• Actively participated in the daily standup, planning, Review meetings.

Environment: MS SQL Server, MS Business Intelligence (SSIS, SSAS, SSRS), Oracle, DB2, T-SQL and TFS