SUMMARY

• Over 5 years of IT experience as a Business Analyst/ Data Analyst experienced with data analysis, visualization and reporting. Also experienced with supporting business process analysis and improvement.
• Experience in database design, development and administration with MS SQL Server versions 2012/2008R 2/2008/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in various domains.
• Adept in performing Gap Analysis, Feasibility Analysis and SWOT Analysis to check the compatibility of the existing system infrastructure with new business requirements
• Proficient in creating Business Requirement Documents (BRD), Functional Requirement Specification (FRS) document, User Requirement Specifications (URS) document, Use Case Diagrams, Activity Diagrams,and Sequence Diagrams using MS Visio and Rational Rose
• Strong experience in coordinating Joint Application Development (JAD) sessions and interviews to converge towards a design acceptable to the customer and feasible for the developers
• Deep understanding of Database management system, OLTP, Data warehousing concepts, Business Intelligence technologies and Data mining
• Experience in writing SQL queries and store procedures in SQL and PL/SQL
• Expertise in creating the dimensional models and creating the ETL specifications
• Technical expertise in BI, Data warehousing, ETL(SSIS), Data Modelling, Data profiling, Data Cleansing, Data Scrubbing, Data Integrity, Reference Data for securities and Data Quality Management
• Proficient in creating mapping spreadsheets and Source to Target mapping documents including the transformation rules
• Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web
• Conduct functional walkthrough, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
• Highly motivated team player with excellent communication, presentation and interpersonal skills
• Having Knowledge of Software Development Life Cycle(SDLC), Agile Methodology, RDBMS, Data Warehouse & Data Modeling concepts.
• Experinced in preparing report/dashboards using SSRS, Tableau, Qlik Sense.

TECHNICAL SKILLS

Languages: Java, Python (Pandas, NumPy), R tools (R Shiny, ggplot)

Web Technologies: XML, JavaScript, PHP, Google Analytics (Web Analytics Service)

Tools: / Software: Tableau, Qlik Sense, RapidMiner, ArcGIS, Visio, Microsoft Excel, VBA, Macros MSBI Stack (SSIS, SSAS, SSRS), SPSS, Working knowledge of Hadoop

Version Control: GIT, SourceTree

Database: SQL, PL/SQL, MySQL Server 5.7, MS Access

PROFESSIONAL EXPERIENCE

Confidential, St. Charles, MO

Digital Business Analyst

Responsibilities:

• Analyze current processes and reports to determine future needs for the business
• Determine business reporting needs and data requirements through meetings, consultations and document analysis
• Create reporting mockups and high - level conceptual data mapping
• Articulate user stories for developing and integrating components involved in building a D2C platform for pet food with an existing B2B portal
• Translate business needs/wants into new functional documents
• Actively manage the reporting and analytical roadmap and other reporting applications
• Evaluate the information gathered and distinguish between individual wants and business needs prioritizing accordingly
• Prioritize stories for developers using the Agile methodology
• Created and implemented UAT plan by leading a group of testers.
• Analyze and prioritize future phases of applications for value proposition and enhancement
• Communicate with Senior Management on long term goals and analyze what can be done to provide them what they need from a data and application standpoint
• Identify, create and facilitate process design changes by conducting business and systems process analysis and design at a complex level; focusing on quality improvement and data management; ensuring data is reliable and valid; developing process improvements or re-engineering and recommending elimination; integrating new systems and processes with existing ones; and partnering with internal and external customers to ensure systems provided meet the long-term business strategies
• Create and maintain project schedules by developing project plans and specifications, estimating time and resources, monitoring milestone completion, tracking all phases of the project lifecycle, providing timely reporting of issues that impact project progress, coordinating actions and resolving conflicts.

Environment: MS Excel, MS Visio, MS Office, Agile Methodology, MS Visio, JIRA/ASANA, Microsoft Project, Ms SQL server 2016, SSIS, SSRS, Tableau, Google Analytics

Confidential, NJ

Business / Data Analyst

Responsibilities:

• Responsible for gathering high level requirements from business and marketing team, developed analytics design and implementation documents.
• Worked on end-to-end google analytics solution design, development, support, testing and data analysis.
• Developed Traffic Reports (Site, Visitor, Segmentation), Path Reports (Page reports, Entries and exits) and Conversion reports (Purchases, Custom events, Campaigns reports etc.) using Report Builder
• Set up and optimizing Google Analytics properties and views in line with current product structure
• Generated Metrics on Bounce Rate, Visit Duration, Click Through Rate (CTR), Average Organic Page Ranking and demonstrated to executive team on opportunities for improvement
• Built executive dashboards for the leadership team with the conversion KPI's & also involved in building/ scheduling of dashboards for the middle-management to provide them a snapshot of the business.
• Measured the effectiveness of digital campaigns by leveraging A/B and/or multivariate testing to refine performance over time
• Worked on data modeling and produced data mapping and data definition and ETL specification documentation
• Designed and implemented SQL queries for testing and report/data validation
• Worked with different groups through all phases of the SDLC using technologies including SQL server, Erwin, SSIS, Data Warehousing
• Developed the test plans and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Conducted UATand developed strategies with Quality Assurance group to implement Test Cases

Environment: MS Excel, MS Visio, MS Office, Agile Methodology, MS Visio, JIRA/ASANA, Microsoft Project, MS SQL 2016, SSIS, SSAS, SSRS, ETL, Google Analytics, Qlik Sense

Confidential, NY

Data Analyst

Responsibilities:

• Calculated metrics and analysis as well as condensed multiple points of interest and large amounts of data into concise targeted information summaries and reports for management
• Leveraged clients existing IT framework/CRM system for better data visibility and system integration.
• Conducted QA of new CRM software, reported bugs and verified features and functionality
• Managed data quality in SFDC be validating sources of truth.
• Filtered and cleaned salesforce data by reviewing workday requirements to locate and correct discrepancies.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Reviewed data issue reports, and escalated data issues to appropriate internal partners.
• Performed checks on datasets to ensure planned consistency in sensitive data.
• Assisted in data migration for importing legacy data into Salesforce.
• Developed tests, reports, and procedures around data quality improvements.
• Designed and developed T-SQL procedures, query performance tunings
• Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Environment: MS SQL 2012, SSIS, MS Excel, MS Visio, MS Office, Agile Methodology, MS Visio, JIRA/ASANA, VBA, .Net, Salesforce, Tableau

Confidential, NJ

Business Analyst

Responsibilities:

• Acquired data from primary or secondary data sources and maintained databases.
• Interpreted data, analysed results using statistical techniques and provided ongoing reports.
• Identified, analysed and interpreted trends or patterns in complex data sets.
• Identified and developed Use Cases from the business and systems requirements.
• Conducted interviews with key business users to collect requirement and business process information.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
• Designed and developed T-SQL procedures, query performance tunings and SSIS packages.
• Developed underlying data models and databases.

Environment: MS SQL 2012, T-SQL, SSIS, SSRS, ETL, MS Excel, MS Visio, MS Office, Agile, VBA, .Net

Confidential

Data Analyst

Responsibilities:

• Designed and developed T-SQL procedures, query performance tunings and SSIS packages.
• Developed underlying data models and databases.
• Performed and executed data extraction, transformation and loading using ETL tools.
• Wrote different complex SQL queries and created database objects likeTables, User Defined Functions, Triggers, Procedures, IndexesandViews as per the team’s request through team tracks.
• Involved in supporting database & BI (ETL, Analytics, and Reporting) activities for various applications and teams across all business units.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Developed reports from these OLAP cubes using SSRS.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Used Analysis Services (SSAS) processing task to update with the current data.
• Involved in datawarehousing and dimensional modeling by Identifying the fact and dimension tables based on the user & reporting requirements.
• Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS), Agile, VBA, .Net