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 wif SQL database of customer information.
• Designed, coded, and implemented ad hoc reports using existing report models in SSRS.
• Identified teh Data sources and defined them to build teh Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions, and Functions for teh reports. click-through, and demographic comparisons wif SQL database of customer information.
• Used Crystal Reports tracking successful/unsuccessful sent emails, emails that were read,
• Power BIdevelopment and administration.
• Launching teh report builder for ad-hoc reports.
• Strong Knowledge in Enhancing and Deploying teh 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 teh errors.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation, etc. to migrate teh 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 teh 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 TEMPeffective 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 wif 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 teh 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 wif Power BI and integration wif Power BI Service portal.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Experience in publishing teh 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 teh 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 teh errors.
• Closely worked wif a business in teh design, loading, and tuning of our Data Warehouse, Data Mart, and Data Vault environments
• Assisted in teh definition of teh 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 teh 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 teh 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 teh data into teh Data warehouse.
• Responsible for implementation of data viewers, Logging, error configurations for error handling teh packages. Involved in complete life cycle in creating SSIS packages, building, deploying, and executing teh packages in both teh 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 wifQuery Optimizationto increase teh performance of teh Report.
• Developing Reports for business end-users usingReport Builderwif 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 teh database to generate different types of ad-hoc reports usingSSRS.
• Analyzing existing ETL jobs and find teh gaps
• Creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, views, and SQL joins and statements for applications.
• Designing an OLAP system wif teh halp 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 wif 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 wif Business and describe teh analysis and approach.
• Power BIdevelopment and administration.
• Creating and developingSQLserver jobs onSQLServer Integration Services (SSIS) packages to automate teh execution of teh 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 wif 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 teh number of records processed by each package and each task in a package usingSSIS.
• Working wif Airport Customer Service built key KPIs including reports used to pay, measure, and provide incentives to our different business partners at teh stations. SLA measures those partners against teh operational goals set for them in their contracts.
• Working wif Scheduling team and Build schedule change proc that is essential to identify passengers that are going to be effected by teh schedule change, dis halp us to notify teh passenger wif teh upcoming change And Build Seating panning report to identify Pax that is going to effect by teh schedule change, And Establishing ETL design to identify flights to track flight that has a schedule change
• Working Closely wif department across teh 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 teh different report server
• Utilize data mining bad data visualization tools such as power BI, SSRS to design report for stakeholders to halp drive business decision
• Assisted In teh 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 wif other members of teh development team
• Assess and resolve prove problem effecting data availability and accuracy
• Maintaining daily, weekly, and monthly report subscription to all areas of teh business
• Analyses passenger information to predict volumes
• Sourcing data from various types of relational databases, flat files, excel files.
• Developing SSIS packages wif various tasks like - FTP, file system, for each loop, execute package, data flow task, executeSQLtask, custom script task, data mining task.