SUMMARY

• Over 9+ years of in - depth experience in database development, and maintenance of SQL Server
• Proficiency in creating different types of Reports such as Crosstab, Drill-down, Summary, Parameterized, Sub reports, and formatting them using SSRS.
• Crystal Reportsdevelopment focusing on website/email tracking, database queries, and accounting.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations, and demographic comparisons with SQL database of customer information.
• Designed, coded, and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data sources and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions, and Functions for the reports. click-through, and demographic comparisons with SQL database of customer information.
• Used Crystal Reports tracking successful/unsuccessful sent emails, emails that were read,
• Power BIdevelopment and administration.
• Launching the report builder for ad-hoc reports.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort, and Derived Column for cleaning bad data, validating data.
• Created SSIS packages using package logging, Breakpoints, Checkpoints, and Event handling to fix the errors.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation, etc. to migrate the old Bills information, Customer Information, Contracts Information, and other important data
• Accomplished in creating Packages, Scheduling Jobs, and sending Alerts using SQL Mail.
• Requirements gathering, Analysis, and Design of all the client requirements.
• Managed Alerts for successful or unsuccessful completion of scheduled jobs.
• Ability and willingness to learn new technology and deliver results on time.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

• Azure
• MS Internet Information Server
• MS Office
• Tableau
• MS SharePoint
• MS SQL Integration Services
• MS SQL Reporting Service
• MS SQL Server
• MS Windows
• SQL Server Management Studio
• TFS
• Teams
• Slack
• MS Visio
• Data Stage
• Power BI
• Data Factory

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr. MS BI Developer

Responsibilities:

• Developing visual reports, dashboards, and KPI scorecards using Power BI desktop.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Imported data from various sources such as SQL Server, SQL Server Analysis Services (Tabular Model), Multi-Dimensional Model, and MS Excel to generate reports.
• Created DAX Queries to generate computed columns in Power BI.
• Developed SQL queries using common table expressions (CTEs), views, temporary tables to support the Power BI report.
• Wrote Calculated Columns, Measures query is in Power BI desktop to show good data analysis techniques.
• Utilized Power Query for data cleansing and data transformation.
• Worked on all types of transformations that are available in Power bi query editor.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. used DAX function like SUM, MIN, AVG, COUNTROWS, DISTINCT COUNT, IF, OR SWITCH, ISFILETERD, ISCROSSFILTERED, CALCULATED, CALUCATEBLE, ALL, VALUES, SUMMARIZE, ADD COLUMNS in Power BI.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Used different types of slicers available in Power BI for creating reports.
• Creating Row Level Security with Power BI and integration with Power BI Service portal.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, alteryx and get quick insights about datasets.
• Involved in the full Software Development Lifecycle (agile methodologies, SCRUM) phases including requirements, design, development, troubleshooting, document design, testing, and training
• Created SSIS packages using package logging, Breakpoints, Checkpoints, and Event handling to fix the errors.
• Closely worked with a business in the design, loading, and tuning of our Data Warehouse, Data Mart, and Data Vault environments
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning using DMVs and third-party tools.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.

Confidential, Denver Colorado

MS SQL Server SSIS / SSRS Developer

Responsibilities:

• Involving withQuery Optimizationto increase the performance of the Report.
• Developing Reports for business end-users usingReport Builderwith updating Statistics.
• Creating charts and pivot tables in Excel.
• Establishing ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Updating functional specifications and technical design documents.
• Developing reports using complex formulas and querying the database to generate different types of ad-hoc reports usingSSRS.
• Analyzing existing ETL jobs and find the gaps
• Creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, views, and SQL joins and statements for applications.
• Designing an OLAP system with the help of ERWIN to visualize data structure.
• Extracting data from heterogeneous sources and transferring it to OLAP using SQL Server Integration Services (SSIS).
• Creating low-level design and ETL design doc according to requirement.
• Creating SSIS Packages to export and import data from CSV files, Text files, and Excel Spreadsheets.
• Designing and developing matrix and tabular reports with drill-down, drill-through, and drop-down menu options using SSRS.
• Creating Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Creating Alerts for successful or unsuccessful completion of scheduled jobs.
• Working as aSQLdeveloperto write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQLcode andSQLjoins for applications.
• Gathering business requirements from users and translating them as technical specs and design docs for development.
• Actively involved in requirements gathering/analysis meetings with Business and describe the analysis and approach.
• Power BIdevelopment and administration.
• Creating and developingSQLserver jobs onSQLServer Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Extensively usedSSISto move data from text files toSQLServer.
• Creating Complex ETL Packages usingSSISto extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Proficient in usage ofSSISControl Flow items (For Loop, execute package/SQLtasks, Script task, send mail task) andSSISData Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
• Create logging for ETL load at package level and task level to log the number of records processed by each package and each task in a package usingSSIS.
• Working with Airport Customer Service built key KPIs including reports used to pay, measure, and provide incentives to our different business partners at the stations. SLA measures those partners against the operational goals set for them in their contracts.
• Working with Scheduling team and Build schedule change proc that is essential to identify passengers that are going to be affected by the schedule change, this help us to notify the passenger with the upcoming change And Build Seating panning report to identify Pax that is going to affect by the schedule change, And Establishing ETL design to identify flights to track flight that have a schedule change
• Working Closely with department across the enterprise as a data liaison to understand their business need and mold out big data platform to meet them
• Day to day guidance and direction of other bi team member post departure for all more senior member
• Migrate reports from the different report server
• Utilize data mining bad data visualization tools such as power BI, SSRS to design report for stakeholders to help drive business decision
• Assisted In the development, roll-out, and maintenance of dashboards and SSRS reports, which focus on contribute improvement in a processing
• Develop metrics to monitor performance such as aircraft maintenance and part procurement on weeks, monthly, and yearly level to detect operational inefficiencies
• Design, Deploy and support business intelligence and data warehouse solution to assist organization program in achieving their goals
• Research and maintain awareness of new technology development, trends and emerging best practice in industry cross-train and share expertise with other members of the development team
• Assess and resolve prove problem affecting data availability and accuracy
• Maintaining daily, weekly, and monthly report subscription to all areas of the business
• Analyses passenger information to predict volumes
• Sourcing data from various types of relational databases, flat files, excel files.
• Developing SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, executeSQLtask, custom script task, data mining task.