SUMMARY

• 6+ years of professional IT experience in various data warehouse practices with extensive experience in BI tools and databases, Data warehouse designing and Data modellings.
• Experience in designing, documenting and implementing Data Warehouse - Conceptual, Logical and Physical data models.
• Strong proficiency in the full life cycle of Business solution development with great capabilities in analysis, problem definition and requirements gathering.
• Extensively working on data consolidation from different data sources with the help of ETL tools
• Well-versed in utilizing T-SQL to construct database objects such as Stored Procedures, UDFs, views, Triggers and Indexes.
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models
• Experience in Logging, Error handling, and Custom Logging for SSIS Packages.
• Experience in building report models and creating dashboard using Visual Studio, SSRS, Power BI & Tableau.
• Experience working on Agile projects with multiple sprint cycles using Agile Project management tools like Trello & Slack.
• Conduct training programs and knowledge transfer sessions to junior developers when needed.
• Coordinate with Business Analysts and customers to develop both business requirements and specifications documents in SDLC.
• Determine business intelligence and data warehousing solutions to meet business needs.
• Develop standard reports and functional dashboards.
• Generate and deliver quality reports to customers both internal and external, for business performance monitoring and business decision making.
• Identify and resolve data reporting issues.
• Maintain business intelligence models.
• Manage new report generation and report enhancement based on the change requests.
• Perform data warehouse design and modelling according to established standards.
• Perform quality assurance checks.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure
• Recommend improvements for optimum reporting solutions.
• Stay updated with business operations and intelligence processes.
• Work with Project Manager in developing and executing project plans.

TECHNICAL SKILLS

Technologies: SSIS, SSAS, SSRS, Visual Studio, Data Ware Housing, Power BI, C#, DAX, Python and VB .NET

Languages: PL/SQL, HTML, TSQL, Python, DAX

Operating Systems: Windows Server, AIX

Databases: IBM DB2, MS SQL-Server 2008R2, 2012, 2014,2016,2017, Oracle, Mongo DB.

Methodologies: Agile, waterfall

Communication & Other Tools: Oracle Data Modeler, SQL Developer Data Modeler, Trello, Slack, Asana, Jira, HP ALM, GitHub

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

ETL/Report Developer

Responsibilities:

• Involved in modifying and rebuilding stored procedures and large T-SQL Queries to enhance the performances
• Experience in writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snapshot reports Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS. Maintaining UAT environment and helping for UAT testing
• Embedded the reports on to application using MS Report Viewer in Visual Studio 2016
• Exceptional ability to quickly master new concepts and capable of working in teams as well as independently.
• Developed SSRS reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Responsible for Dimensional modeling, defining relationships between Dimensions and Measure groups.

Confidential, Washington, DC

MS SQL Server /ETL Developer

Responsibilities:

• Working with business Analyst, subject matter experts and business users to gather and refine requirement and perform source system analysis.
• Designing and deploying SSIS packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Derived Column Transformations, Slowly Changing Dimension etc.
• Automating processes trough SSIS Packages using SQL Server Agent job.
• Participate in all phases of the software development life cycle in a team environment
• Building efficient SSIS packages that perform multiple and complex ETL processes to fetch, cleanse transform and validate data coming from various sources such as flat files, online applications, excel and RDBMs tables and migrate/load to destination tables.
• Involved in troubleshooting, implementing error-handling solutions, monitoring, training and 24/7 production support of various SSIS packages in mission critical environments.
• Perform SQL query tuning and performance optimization on complex inefficient queries
• Developing and maintaining Stored procedures, SQL queries using various joins, aggregates, system functions, UDFs, Triggers and views to clean and reconstruct data within the Enterprise DW environment.
• Designing, developing, testing, and deploying various regular and support Ad hoc reports and dashboards utilizing Excel, SSRS and PowerBI visualizations
• Involved in analyzing a huge number of existing reports to understand the logical and interface design changes to be applied accordingly
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Updating and communicating with team and management regarding project status and documenting various processes for future reference.
• Created different reports and dashboards in Power BI desktop and used power BI service to publish the reports
• Able to multi-task and adapt to shifting priorities, meet deadlines set in project planning and Produce quality deliverables upon deployment

Confidential, Denver, CO

Database/Junior BI Developer

Responsibilities:

• Work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW (Reservation, customer service, Ground service, Maintenance & Engineering, corporate, inflight etc.)
• Involved in designing the technical deliverable artifacts such as source-to-target mappings, implementation run books etc. needed for project implementation.
• Conduct ETL, Data Warehouse Modelling, OLAP, processes documentation and BI solution delivery
• Experience in Extract, Transform & load (ETL) data from various sources like Flat File, Excel, XML and RDBM’s using SSIS tools.
• Created various database objects such as Tables, Views, Stored Procedures and Indexes and wrote T-SQL queries to retrieve data from various tables.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Modified the existing SSIS packages to meet the changes specified by the users
• Develop, test and deploy codes (Packages, procedures, functions) in the backend using SQL for any enhancement based on the business requirements for the existing applications.
• Participates in system integration, regression testing and UAT
• Involved in Developing various operational reports such as Sub Reports, Charts, Matrix reports, Drill-through, Drill Down and parameterized reports and Created report models on Ad hoc reports.
• Provide recommendations to improve system functionality and processes within the BI environment

Confidential

Data Specialist

Responsibilities:

• Compile verify accuracy and sort information according to priorities to prepare source data for computer entry.
• Quote preparation, telephone coverage, customer support, maintaining administrative records, and verifying the installation and end-to-end Keeping the information confidential.
• Review data for deficiencies or errors, correct any incompatibilities if possible and check the output.