SUMMARY

• 7 years of strong experience in the IT industry as a SQL,ETL, Data Warehouse and BI developer with sound business analysis skills.
• Expertise in array of domains from Retail, Insurance, Telecom, Financial and Banking .
• Strong experience in the Analysis, design, development and testing and Implementation of Business Intelligence solutions using ETL and BI SQL Server, Oracle, MS Dynamics AX -
• Experience in installing, updating and configuring SQL server 2008/2008R2/2012,2014 and 2016.
• Extensive experience in SQL Server stored procedures, triggers, tables, user defined functions, relational database models, data integrity.
• Experience in creating and managing Clustered Index and Non-Clustered Indexes to improve performance.
• Worked in different environments like having Microsoft Dynamics AX, Intrader and polyPath as source systems.
• Experience in various data sources and targets like Oracle, DB2, SQL server, Excel and non-relational sources like flat files, XML SSIS/ Informatica -
• Experienced in using SSIS for data extraction, transformation and loading.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Standardizing data loaded into OLTP and OLAP databases using ETL .
• Experienced in extracting data from flat files and transforming the data to the destination format and loading into the data warehouse using ETL.
• Experienced in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Expert in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in Microsoft Visual C# in script component of SSIS.
• Experience in tuning SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Good experience in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experienced in using slowly changing dimension types.
• Extensively used informatica Client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Implemented slowly changing dimension in informatica.
• Worked in debugging informatica mappings, SQL Stored Procedures and Functions, Performance and Unit testing of Sessions and Target Data. SSRS/Power BI-
• Experience in generating reports for OLTP, Data Warehouse, DataMart and OLAP databases.
• Hands on experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Linked Sub Report, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports and formatting.
• Hands-on experience in the scheduling of reports to refresh and run on daily, weekly and monthly basis and deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Developed Dashboard Reports using SSRS, Report Model and Ad Hoc Reporting using Report Builder.
• Involved in integration of SSRS Reports using various web parts into SharePoint and Performance Point 2010 and Dashboards.
• Hands on experience in development of SSRS report from OLAP cubes using MDX script.
• Hands on experience in configuring and maintaining Report Manager, Report Server and Repot Builder for SQL Server Reporting Services (SSRS).
• Hands on Experience about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Hands on experience in creating/converting from Crystal/SSRS reports to SSRS/Crystal reports.
• Hands on experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Created Reports/Visualizations/Dashboards in Power BI using filters at Visualization level/page level/report level.
• Created measures, calculated columns, conditional column, custom columns in Power BI.
• Design, develop and deployment of Power BI solutions.
• Experience in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Designed and Built tabular model Cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP self-service reporting needs.
• Created KPIs for scorecards and performance management.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2008R2/2012,2014 and 2016, Oracle 11G, Excel, Access 2000/2003

Programming: T-SQL, MDX, DAX, C#, VB.net, Java

Developer Tools: SQL Server Management Studio, SQL server Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio 2010, SSDT, BIDS, Team Foundation Server (TFS), IBM clear case

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

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, Tableau

Analytical tools: SSAS

Data Modeling: MS Visio 2000/2007/2010 , ERWIN 7.1, ERWIN 4.1

Operating Systems: Windows NT/ 98/2000/2003 , 2008 R2,2012 Server XP/Vista, UNIX, Linux

Web Technologies: HTML, XML, JAVA SCRIPT, CSS

PROFESSIONAL EXPERIENCE

Confidential

BI (SSRS, SSAS, Power BI)/Informatica Developer

Responsibilities:

• Actively participated in interaction with Business Analyst, financial Analysts, Director of Departments, Architects (BI and Data), QA and DBA to convert the requirements into solutions and deployments.
• Created SSRS reports for Accounting, Economic Development/Community Investment, Credit Risk, Market Risk, Collateral, Strategic Planning, Member Sales, Banking Operations, Financing and QA departments for different time versions (Daily, Monthly, Final).
• Created IT-Metric reports from execution logs of SSRS Reporting Services databases, to get the performance of SSRS reports in dashboards and list of SSRS reports with database connections, for internal IT usage.
• Assisted the Accounting, Financial analysts while they were validating data between source systems vs Data Warehouses and SSRS reports.
• Created number of views in new Data warehouse environment to combine the fact tables of Hedge, Position and advances from old database environments (which was about to be decommissioned), with good performance, by using data conversion techniques.
• Worked on existing SSRS reports for change requests and improved the performance of the reports by creating index and altering the stored procedure logics.
• Designed and implemented SSAS Tabular Cubes as the self-service reporting layer.
• Created many dimension, measures and cube partitions using SSAS Tabular model.
• Also, implemented composite key in SSAS tabular model for unique row identification.
• Created SSRS reports from SSAS tabular model using MDX and used multiple data sources to access the data. Also, used look up, multi lookup, sub reports while accessing the data from two different sources.
• Implemented composite-key in tabular model by combining two columns.
• Interpreted many business logics from very old Progress database code and requested the data team (informatica) to bring fields required for future reporting purposes.
• Created interactive Visualizations and Dashboards in Power BI desktop
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Created Power BI reports/visualizations using filters on Visualization level, page level and report level filters.
• Created Roles and implemented Row level security for user Authentication in Power BI.
• Created effective Dashboards in Power BI Service and made the reports user friendly and interactive.
• Installed On premise data gateway and scheduled refresh on daily basis in Power BI.
• Used various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator, update strategy to load data into Server database using informatica 9.5
• Worked on informatica 9.5 components -Designer, workflow manager, workflow monitor, repository manager.
• Worked on Power Center tools - Source Analyzer, transformation developer, Mapping & Mapplet Designer.
• Involved in Unit testing, User Acceptance testing to check whether target data is matching with source system data according to requirements.
• Also, helped business analyst and project manager to create a newer standard version of business requirement documentation for their future requests.
• Participated in regular meetings with business analyst, architects, developers, Financial analysts, Director of departments while delivering projects/database objects and acted dynamically to update the SSRS reports in case of any sudden requirement changes from the business/logic changes from ETL.

Environment: Microsoft Azure, Server 2014, SQL Server Integration Services (SSIS) 2012, Informatica 9.5, SQL Server Reporting Services (SSRS) 2012, SQL Server Analysis Services, SQL server Profiler, Microsoft Visual Studio 2010, .NET, C#, Team Foundation Server (TFS), BMC jobs, MKS integrity.

Confidential, Irving, TX

SQL BI (SSIS, SSRS) Developer

Responsibilities:

• Implemented ETL (Extraction, Transform and Load) for data migration and data staging using SQL Server Integration Services.
• Responsible for writing T-SQL queries, designing SSIS packages, SSRS reports and analyzing existing stored procedures along with recommending modifications for query efficiency.
• Bulk data migration using SSIS from flat files.
• Worked extensively on SSRS report with loads on integrated calculations with best on fly performance.
• Transformed the complex business logic and calculations into coding.
• Created Monthly/Historic automated load Using SSIS.
• Used the C#/VB.NET in SSIS script tasks to read the content of the flat files and assigning it to variable while loading the data from windows shared location to sql server tables.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Implemented various extra functionality and applications in SSRS reports.
• Created SSRS,Crystal,excel reports for sales,accounting and other departments.
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Importing data from various data sources to SQL Server using SSIS/DTS using various features like data conversion, derived columns.
• Worked with SSIS packages involved File System Tasks, FTP tasks, Fuzzy Grouping, Merge, and Merge joining Control Flow Transformations.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, Restorability and roll back techniques.

Environment: SQL Server 2012, SQL Server Management Studio, UC4 Job Scheduler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL server Profiler, Microsoft Visual Studio 2010, .NET, C#, IBM Clear Case

Confidential, Houston, TX

SQL BI (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created many tables with the cluster and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs using SSRS.
• Created Company level inventory, sales, budget reports from OLAP Cubes using MDX Script.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping.
• Converted existing Excel / Crystal reports to SSRS Reports.
• Worked on various types Chart Reports such Lines, Columns, Bars with both 2D and 2D views in order to display cumulative totals based on day to day requirement.
• Involved in Performance Improvement of thus created reports and deployed reports onto Report Server and Report Manager and to SharePoint Server making those reports available for the end users.
• Created table valued functions and used in the report stored procedures on the fly.
• Proposed and Developed Power Pivot and Power Query based reporting for forecasting major initiatives and building ad hoc reports to assess per business needs.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Developed Charts and other visualization using Power View.
• Filter and Sorting Data using Power View in Excel 2013, Also developed Power Maps using Excel 2013 for Reporting.
• Worked on the performance of reports, created appropriate indexes on tables and modified the code in existing stored procedures for the best fly-on performance.
• Attended functional testing meetings, user acceptance sessions and worked on the feedback s.
• Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server .
• Created SSIS packages to get the data from different sources to BI environment using different transformations on hourly basis, daily basis and monthly basis.
• Involved with ETL team and created packages using SQL Server Integration Services (SSIS) to extract data from various feeder systems, apply required transformation and finally load the data to the destination data warehouse.
• Used multiple transformations including Fuzzy lookups, Merge, Merge Joins, Conditional Splits, Fuzzy Grouping, Derived Columns, Data Conversion, Union All etc. in order to get the desired output before loading it to destination.
• Scheduled jobs that would run on the less traffic hour using SQL Server Agent.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data in data warehouse .
• Aggregated the data in tables of DataMart for reporting purposes
• Created SSIS packages which sends the customers and sales data from BI servers to marketing department on hourly basis.
• Created the report which gives the status of the production server jobs, which gives the status of each production server jobs.
• Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Used SQL Profiler to estimate the Slow Running queries.
• Used Team foundation server for sprint plan and database objects (ETL, Reports) check-in.

Environment: SQL Server 2012, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Profiler, Microsoft Visual Studio 2010, .NET, C#, VB.NET, Team Foundation Server(TFS)