PROFESSIONAL SUMMARY:

• Expert Microsoft Business Intelligence Solutions Developer with SIX (6+) years of overall IT experience in Microsoft Technologies.
• Have thorough understanding of Software Development Life Cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation and Testing, Deployment & Production Support experience.
• Have worked with traditional waterfall and Lean Agile Methodologies using JIRA Kanban Framework
• Experience in High Level Design of ETL SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split Insert, merge and union all
• Worked on various Transformations in SSIS in Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Extract data from excel, flat file, and different data base and load in SQL data base using SSIS packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Good experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes
• Skilled in writing advanced T-SQL queries (DDL, DML), Stored Procedures to improve the database performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling, error handling, stored procedures and performing other maintenance tasks.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Good understanding of Azure architecture and experienced in Azure architecture decision making. Worked actively in implementing ETL and data movement solutions using the Azure Data Factory (ADF).
• Skilled in understanding and implementing medium to large scale BI solutions on Azure using various other Azure Data Platform services like Azure Data Lake, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks and NoSQL DB.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created multiple kind of Power BI Reports and Dashboards
• Expertise in writing different DAX functions in Power BI to create columns, measures and tables
• Strong Analytical problem solving skills and Extensive work experience creating various types of visualizations and features for visualizations.
• An excellent team member and individual contributor

TECHNICAL SKILLS:

Database Platforms: MS SQL Server, Azure SQL DB, Oracle 11g

Programming Languages: T-SQL, PL-SQL

ETL Tools/ BI Tools: SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Reporting Services Report Builder, Data Transformation Services, SQL Server Profiler, Import & Export Wizard

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory(ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service(AAS), Azure Search, Azure App Service, Data Migration Service(DMS), Azure SQL Data, Azure SQL Analytics.

Methodologies: Agile, Waterfall

Testing Tools: Test Director 8.0, Quality Center 9.2, HP ALM

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visual Studio

Operating Systems: Windows 10/8/7/XP, UNIX, LINUX, Azure Virtual Machine (VM)

Reporting Tools: SSRS, Power BI, Crystal Reporting.

Ticketing Tools: Service-now, Remedy

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential, St. Louis, MO

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Created new reports based on requirements.
• Worked with Internal modeling team for data analysis and profiling.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
• Created SSIS Packages to import and export from Excel Spreadsheets, Text files and CSV files.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.
• Worked on building several new SSIS packages and updating existing packages and created related scheduled jobs.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Help to Design reporting solutions to meet business requirements.
• Involved in developing complex reports for various new projects and converted excel reports into Business objects for ease of use and maintenance.
• Experience in using SSRS in creating and managing reports for an organization.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Efficient in understanding of Azure architecture and experienced in Azure architecture decision making. Participated in implementing ETL and data movement solutions using the Azure Data Factory (ADF).
• Planned, designed, and implemented processes to receive, transform and load valuable data from external sources into local databases.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Designed SSIS Packages to load data from different sources like excel, flat file, csv etc.
• Facilitated UAT (User Acceptance Testing) for all the converted internal systems with business users, management group and team members.
• Experience in using SSIS in solving complex business problems.
• Used SSIS, SSRS for solving business problems and creating reports in organization.
• Involved in interacting with the end-user (client) to gather business requirements.
• Developed complex mappings to load data from Source System (SQL) and flat files.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Managed and executed the test process, using Agile Methodology.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Generated tableau dashboards with combination charts for clear understanding
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user-friendly in analysis purposes.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs

Environment: Oracle 11g, SQL, Azure Cloud Services, Power BI, Linux, UNIX, Windows, MS Project, MS Access, ALM/Quality Center, MS Word, SSRS, SSIS.

Associate Software Developer

Confidential, St. Louis, MO

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Participate in daily agile meeting, weekly and monthly staff meetings and collaborate with various teams to develop and support ongoing analyses.
• Conduct data accuracy analysis and support stakeholders for decision-making.
• Performed data cleansing, data validation and mapping as described in the business requirements.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Created naming and system standards for lookup, transformation and target tables.
• Worked on Manual test cases for UAT testing and use SQL for querying and analysis purposes on various source tables and conditions applied.
• Conducted User Acceptance testing (UAT) and A/B testing worked with users and vendor who build the system.
• Managed the testing and verification of HIPAA standard transactions, and EDI messages like (837, 835, 834), Validate the date from EDI transaction.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 834 EDI transactions
• Responsible for defining the functional requirement documents for each source to target interface.
• Analyzed various source systems to understand the relationship between different source Tables.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Developed dashboard, Charts and reports using Power BI.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008
• Worked on formatting SSRS reports using the Global variables and expressions
• Created Parameterized reports, drill down and Drill through reports using SSRS
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse
• Developed complex mappings to load data from Source System (SQL) and flat files
• Extensively worked with Quality Analyst to make sure that the functionality meets requirements
• Worked with GUI team for designing the screens and assisted in developing mockup screens and prototyping of the user interface for usability testing
• Prepared system Test Plan and scenarios for Test Scripts
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing

Environment: PL/SQL, SQL Server 2008, Oracle 11g, Windows, Power BI, SDLC, Waterfall and Agile methodology, UML Diagrams and Flow Charts, MS Office, MS Access, ALM/Quality Center.

Intern Software Developer

Confidential

Responsibilities:

• Attended various App building workshops and participated in seminars on Artificial Intelligence and Virtual Reality
• Worked and developed a website for the university to build and manage College Bus Transport System using HTML for the front-end, Java script for implementing it and managing the database
• Achieved a hands-on experience on a starter project using Android OS Tool Kit to implement and build a Text to speech mini project for a mobile platform
• As a software developer intern, learned about software engineering as well as how to navigate the politics and dynamics of a corporate or startup setting
• Carried the job duties as a software engineer intern including tasks like coding and debugging software applications and experimenting with design elements
• Participated in reviews with other developers’ code, tested software applications and patches, and implemented changes and updates when necessary